Commits

György Kohut committed 980c49a

add indexes

Comments (2)

  1. siko siko

    [URL="http://j99j.blogspot.com/"]العاب كابتن ماما[/URL] [URL="http://j99j.blogspot.com/2014/03/blog-post_4103.html"]العاب تنانين فرسان قريه بيرك[/URL] [URL="http://j99j.blogspot.com/search/label/%D8%A7%D9%84%D8%B9%D8%A7%D8%A8%20%D9%85%D8%B2%D8%A7%D8%B1%D8%B9"]العاب مزارع[/URL] [URL="http://j99j.blogspot.com/2014/02/blog-post_3529.html"]حديقه الحروف[/URL] [URL="http://j99j.blogspot.com/search/label/%D8%A7%D9%84%D8%B9%D8%A7%D8%A8%20%D8%AA%D8%B9%D9%84%D9%8A%D9%85%D9%8A%D9%87"]العاب تعليميه[/URL] [URL="http://j99j.blogspot.com/2014/01/blog-post_5426.html"]لعبه يحي انجلو[/URL] [URL="http://j99j.blogspot.com/2013/09/blog-post_2667.html"]لعبه جاتا[/URL] [URL="http://j99j.blogspot.com/search/label/%D8%A7%D9%84%D8%B9%D8%A7%D8%A8%20%D8%A8%D9%86%D8%A7%D8%AA"]العاب بنات[/URL] [URL="http://j99j.blogspot.com/search/label/%D8%A7%D9%84%D8%B9%D8%A7%D8%A8%20%D8%AA%D9%84%D8%A8%D9%8A%D8%B3"]العاب تلبيس[/URL] http://j99j.blogspot.com/2014/01/blog-post_1917.html لعبه تلبيس سنفوره http://j99j.blogspot.com/2014/04/blog-post_6903.html العاب منصور

Files changed (2)

 	<category_index>0</category_index>
 	<zoom>1.0</zoom>
 	<x>277</x>
-	<y>55</y>
+	<y>0</y>
 	<default_color>
 		<r>128</r>
 		<g>128</g>
 			</connections>
 			<display>false</display>
 			<creation_date>2011-06-10 22:42:09</creation_date>
-			<updated_date>2012-08-08 14:47:41</updated_date>
+			<updated_date>2012-08-08 15:21:58</updated_date>
 			<model_property>
 				<name>Project Name</name>
 				<value></value>
 				</normal_column>
 			</columns>
 			<indexes>
+				<inidex>
+					<full_text>false</full_text>
+					<non_unique>true</non_unique>
+					<name>virustotal_reports_binary_id_idx</name>
+					<type></type>
+					<description></description>
+					<columns>
+						<column>
+							<id>37</id>
+							<desc>true</desc>
+						</column>
+					</columns>
+				</inidex>
 			</indexes>
 			<complex_unique_key_list>
 			</complex_unique_key_list>
 				</normal_column>
 			</columns>
 			<indexes>
+				<inidex>
+					<full_text>false</full_text>
+					<non_unique>true</non_unique>
+					<name>asn_shadowserver_ip_idx</name>
+					<type></type>
+					<description></description>
+					<columns>
+						<column>
+							<id>44</id>
+							<desc>true</desc>
+						</column>
+					</columns>
+				</inidex>
 			</indexes>
 			<complex_unique_key_list>
 			</complex_unique_key_list>
 			<width>248</width>
 				<font_name>Lucida Grande</font_name>
 				<font_size>9</font_size>
-			<x>1033</x>
-			<y>264</y>
+			<x>1032</x>
+			<y>266</y>
 			<color>
 				<r>128</r>
 				<g>128</g>
 				</normal_column>
 			</columns>
 			<indexes>
+				<inidex>
+					<full_text>false</full_text>
+					<non_unique>true</non_unique>
+					<name>geoip_shadowserver_ip_idx</name>
+					<type></type>
+					<description></description>
+					<columns>
+						<column>
+							<id>53</id>
+							<desc>true</desc>
+						</column>
+					</columns>
+				</inidex>
 			</indexes>
 			<complex_unique_key_list>
 			</complex_unique_key_list>
 
+/* Drop Indexes */
+
+DROP INDEX IF EXISTS ASN_SHADOWSERVER_IP_IDX;
+DROP INDEX IF EXISTS GEOIP_SHADOWSERVER_IP_IDX;
+DROP INDEX IF EXISTS VIRUSTOTAL_REPORTS_BINARY_ID_IDX;
+
+
+
 /* Drop Tables */
 
 DROP TABLE IF EXISTS ASN_SHADOWSERVER;
 ;
 
 
+
+/* Create Indexes */
+
+CREATE INDEX ASN_SHADOWSERVER_IP_IDX ON ASN_SHADOWSERVER (IP);
+CREATE INDEX GEOIP_SHADOWSERVER_IP_IDX ON GEOIP_SHADOWSERVER (IP);
+CREATE INDEX VIRUSTOTAL_REPORTS_BINARY_ID_IDX ON VIRUSTOTAL_REPORTS (BINARY_ID);
+
+