testing/test-suite/data/db/nasty_tables.sql (2,302 lines of code) (raw):

-- MySQL dump 10.13 Distrib 5.6.10, for Win32 (x86) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.7.2-m12 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `…hñƒ9~[­Žaêr×âþ·mû{ àæctñ·ãð/ãg!þ‚1×ï~ñ¯]ðšpæüð!¾  %•põa` -- DROP TABLE IF EXISTS `…hñƒ9~[­Žaêr×âþ·mû{ àæctñ·ãð/ãg!þ‚1×ï~ñ¯]ðšpæüð!¾  %•põa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `…hñƒ9~[­Žaêr×âþ·mû{ àæctñ·ãð/ãg!þ‚1×ï~ñ¯]ðšpæüð!¾  %•põa` ( `a6` int(11) DEFAULT NULL, `NïߍCO dQ|©îNfF]cÙª‰ÊB6a*ýei4÷(š†9ãd` year(4) NOT NULL DEFAULT '0000', `ïgâÅÈWŽÖ_ÿÝÑH8¿žúÛ ^ìWYiøJšS‚‡èÅâF„µAçG ¡Àœ„ÜVò ¿ßnäX` decimal(64,0) DEFAULT '0', `å –]![¥”ôŠ*[tw²TÔJ”ùÃÜ)~´öڂTØ¡` multipolygon NOT NULL, `S½R¦5êðQå[•¨ÕÝ­R°@oÏX6*G^éØÔ,$ùÐÖmT×3³m+&Ñú6…J»Á;S` polygon NOT NULL, `Ѐ<¹(¨_ûtL“B¹Ò†pE¸šn¯§I1‚Ë‚9£ØiMq]©cðЯ¬"½çƲ>T` binary(1) NOT NULL, `â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/` date NOT NULL DEFAULT '2012-04-18', `f•üE±Eürƒö‡jFø ¸Y¨˜ìë+_±s)&Jª£ ñ!•ÅÚ¤3“A9z.•ã "S` decimal(52,2) NOT NULL DEFAULT '100000.00', `ìkIµã¦Æ¹7'¸š£é­` date NOT NULL DEFAULT '2013-05-22', `‰Ù~Ã` double NOT NULL DEFAULT '-1.389e74', PRIMARY KEY (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx28` (`S½R¦5êðQå[•¨ÕÝ­R°@oÏX6*G^éØÔ,$ùÐÖmT×3³m+&Ñú6…J»Á;S`(224)), KEY `idx30` (`S½R¦5êðQå[•¨ÕÝ­R°@oÏX6*G^éØÔ,$ùÐÖmT×3³m+&Ñú6…J»Á;S`(46)), KEY `idx31` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx33` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx34` (`S½R¦5êðQå[•¨ÕÝ­R°@oÏX6*G^éØÔ,$ùÐÖmT×3³m+&Ñú6…J»Á;S`(8)), KEY `idx35` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx36` (`å –]![¥”ôŠ*[tw²TÔJ”ùÃÜ)~´öڂTØ¡`(147)), KEY `idx37` (`ìkIµã¦Æ¹7'¸š£é­`), KEY `idx38` (`a6`), KEY `idx40` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx41` (`a6`), KEY `idx43` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx45` (`â 81Έèdœä3Ô}IN yþ8Êh pî’žõGó_ýG5/`), KEY `idx46` (`f•üE±Eürƒö‡jFø ¸Y¨˜ìë+_±s)&Jª£ ñ!•ÅÚ¤3“A9z.•ã "S`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `;zèãs휎çñóz–â~fåèè¯íú6wzfcüôøˆj£ˆ‘‹ ¡ñšéæú·'ôbîaráƒè®` -- DROP TABLE IF EXISTS `;zèãs휎çñóz–â~fåèè¯íú6wzfcüôøˆj£ˆ‘‹ ¡ñšéæú·'ôbîaráƒè®`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `;zèãs휎çñóz–â~fåèè¯íú6wzfcüôøˆj£ˆ‘‹ ¡ñšéæú·'ôbîaráƒè®` ( `a1` int(11) DEFAULT NULL, `èFàVŠa²N„0¿ûcDJÿ{£` time DEFAULT '04:46:16', `(ûòRîVDÂfnòT®` point NOT NULL, `7ñv±D"/‹Ý»þÉ@üêáO7’šBïg‰0± ò9ü*xoý¸V©s²*¸&+` int(11) DEFAULT '0', `*` decimal(56,22) NOT NULL DEFAULT '844.0000000000000000000000', `‘º¹ÙÅ@aN}ѽž‰Mó-°/4ýûà¸k<+½I$›¨§©d7I` datetime NOT NULL DEFAULT '2012-08-16 13:21:22', `¡uï[@E9Oí¾«å>^¤róm87vq¥œÕÙÑEÍP‰æÛªê–W¼&ò«±NøØæï<ŸíIH¦` int(10) unsigned NOT NULL DEFAULT '100001', `@”&”` mediumint(8) unsigned zerofill NOT NULL DEFAULT '00000442', `Çɸ°f’jo0¦7—ÚøTq…` point NOT NULL, `YOànfç¶|?ôh¤Š½â9C¿àebT^µj` date NOT NULL DEFAULT '2012-08-09', `ÉÕHuõ»îÕ¯3ÖqÃä/53¥§:¹` geometrycollection NOT NULL, `ÖÑÌÄX` timestamp NOT NULL DEFAULT '2013-04-02 11:48:43', `}kïÿ0¬ðqKa60ç:¾¡;Ta#m´,™¡e 4W¥` int(10) unsigned NOT NULL DEFAULT '100001', `ùºœ¨0%̐Œx sœ]%øÃëÊ?U` double NOT NULL DEFAULT '9.698453e95', `ÔÑeÑL%íô¯×®á²¯ Eà‰3¥”˜h¢aÝ&ɦ<_ØÃôF_†‡BiNþ*dŒ †œh®÷çû•EÛ` time DEFAULT '12:30:22', `k‘à‚0£ð„mš… I÷éC-ôW‰˜Ý˜-ëì,Ä\Æ¢ôñRî¨aÃ~vO` enum('vlpcllxfrk','yuckuq','emilsrwh','oaifgwfdgd','xuivqpnnc','nbmwdxkcc','m','eiwczyju','ffpxxuva','cc','rsileffjb','','ztcirklchd','egcragsl','','','mrrltyukri','lomgafa','haosb','wacroxiihg','b','whfkc','uvztcjsugk','khticyzeb','','xeqw','','mf','lthglquszp','cuhcxwk','','xg','qpu','v','dumjmg','pvtwuqpzny','cj','lqbzrdm','vyjnjchvsm','hp','nbsl','aei','gicdaejjjv','vhzyr','uutrxpfgg','iuhkeawsl','ov','bvfy','mty','hqoypgrgdo','krylhgdu','nniby','f','pfopctgscb','mzw','u','ipw','yhwbvebaxd','ed','rvdljzz') NOT NULL, `¦ ?Jjá¦~.œF’‡‰¨ a£Z^»;ê` timestamp NOT NULL DEFAULT '2012-08-10 09:14:54', `=~0` linestring NOT NULL, `Ä{XPH^€;ÞÛâä|+ßb™Ÿûª%&–«` decimal(20,11) unsigned DEFAULT '1482.99600000000', `ÎY,w¡Z«s>ÿúٛ÷‚éßõ2Êû«3ž´ê8é€'mñ}XRݨ` decimal(63,28) NOT NULL DEFAULT '-99999.0000000000000000000000000000', `±` decimal(56,7) unsigned DEFAULT '0.0000000', `Zcï€Š3÷˳¾aÈ©J` decimal(62,12) NOT NULL DEFAULT '99999.000000000000', `þîRºÚµoe0üRëÔïdŒAKb2C ø<Œ öísS"S ¼@¡]‚Žýc%G` mediumblob NOT NULL, `ô€R*ýÝÏFʅǔg3 ¾\Kg¬p¡p¶ÃÕÑ®ý Ć` varchar(176) CHARACTER SET utf8 NOT NULL DEFAULT 'amuprygbcxgp', `t‘ev+·¿# úPÏ` point NOT NULL, `ýɄ{cm"ðOÅ.֑¨Ç` year(4) DEFAULT '0000', `zpˆÜ”•·©ºˆsúpÜ¿tXœ”þ”¿ e}UqJQ~WèKÃQ*÷Ě»` datetime NOT NULL DEFAULT '2012-05-28 21:02:41', `KÍP_ý)\joڜÒæ2ÿœ(yxˆTȚuÊܳŽ½žVp¤CÙ` decimal(33,28) DEFAULT '0.0000000000000000000000000000', `Ru-Ù? D†?Ì!žÛyVTÌ-ã` datetime NOT NULL DEFAULT '2013-09-09 22:20:10', `o-b…sš–Õ*àË]*œ\7ÿlí!ª²è‚†­y¼en;J'ª‹¨³ˆR1‘“ò6;Éz¢` mediumint(9) NOT NULL DEFAULT '38', `CÈa5SýH'ƒÊ¯ŒC„¤6ˆLeöfŒ=À|.D¥ÜO $ d.6_Çÿ•¤½è\™ ¹Y¿` tinyblob NOT NULL, `)‡ø2۟áD܅aâ8Rè«®L` decimal(36,13) DEFAULT '0.0000000000000', `‚˯XBa°ä‡ñ]$Ô~ßsa4¥úÞۙOA‰«` point DEFAULT NULL, `¯23Åü` binary(1) NOT NULL, `º´®Œæðlƒ€Õ` multilinestring DEFAULT NULL, `Q5öÏÚÙûÑð` geometrycollection DEFAULT NULL, `g^µ <wéHÌó)+<®:áßÕ{…Â--Qp°!â|%ÉǸ-ãu¸8f±•ä^;‰€”ò` int(10) unsigned NOT NULL DEFAULT '100001', `¨™õ^ £@.p“'tñ’sÔÕ)³` time NOT NULL DEFAULT '13:31:31', `P÷w™§ª5[Ãá8ŒŠwJ¼´6WˆÑ¨¶YN‘·^äÀ8>wÈ9‰Ùf• ÆzÇP#éî_‚Š‘˜h` datetime NOT NULL DEFAULT '2012-04-19 11:01:07', `õ֊!>ž` longtext NOT NULL, `õ™Î;¨=Þ1µÝ6ˆ£™ípyoü@ˆÕæu,bãcWg^FJa‰ FŸÐ FA` mediumtext NOT NULL, `Á2í?ǩ@–Y é—ÊüyCæ•tɈX` smallint(5) unsigned zerofill NOT NULL DEFAULT '00000', `“:Ð7ûÛ#Ýx½²±Dli PdñÀ¼3ÈÌݯ` char(249) CHARACTER SET utf8 NOT NULL DEFAULT 'sfmgdvi', `…Ï¥ó$í¤‰žÙíç˜[4x|‰xE7Ÿš|›v͵:6eö%÷ª` multipoint NOT NULL, `%ŽèöE¯,ÜkºÛÓ¨ˆyLIä*ÿ¬y"e]‡p^ýHçPýË}ëa‘–´#ð` decimal(15,1) unsigned zerofill DEFAULT '00000000001323.0', `b*¸ o©A»¦mëæLÇ*©Ì˜›ÂÀ` date DEFAULT '2012-11-26', `ηxçîØ»ÚKtÌï{㿪:Xèd±ÌIF¢aÃÏ-°“îhƇ¢ §–Ÿ` double unsigned DEFAULT '1521.3673', `>3×¾€›” >/úš` enum('jho','g','aosxgis','xh','m','gcqdkj','jjo','zi','xm','z','kp','','','lpabnzuu','vnmsggbr','e','sk','ybuwwnfwkn','pneapvgfz','iq','gwufwqumc','kxgzbsinqm','','rd','ktuqtclslg','f','l','juaspeyxm','jcey','pkldcmnjtn','zjxhsuh','d','sorytcher','rlga','pmj','hozo','x','','xub','lt','moxjfyshw','f','c','aybq','ctjhrk','l','nlkubzme','lqba','tnjwdtmchf','cijigdvs','dtaewounc','bsmfcnr','trm','lfmnuvjp','edcqqnbpy','phck','xwzhhm','ugstv') NOT NULL, ` ³Vpº˜kze‡9Eã2 Pº0Û)kQÉ }ÙócSEÉ»¡åĶv)Ѽó*»‡‡Ï` point DEFAULT NULL, `›í{>4šžþ¯dU0õ°_@ì‹*Ç_Œ` timestamp NOT NULL DEFAULT '2012-12-28 11:58:27', `P^™ñ Ë÷'Û2z<o-®¸ÈÓ5˜Ëä ð1üRûÿ\.c• ûµœùR@âéô` date DEFAULT '2013-10-17', PRIMARY KEY (`Zcï€Š3÷˳¾aÈ©J`,`@”&”`,`¦ ?Jjá¦~.œF’‡‰¨ a£Z^»;ê`), UNIQUE KEY `idx10` (`Q5öÏÚÙûÑð`(45)), KEY `idx0` (`Zcï€Š3÷˳¾aÈ©J`,`@”&”`,`¦ ?Jjá¦~.œF’‡‰¨ a£Z^»;ê`), KEY `idx1` (`ÎY,w¡Z«s>ÿúٛ÷‚éßõ2Êû«3ž´ê8é€'mñ}XRݨ`) USING BTREE, KEY `idx2` (`%ŽèöE¯,ÜkºÛÓ¨ˆyLIä*ÿ¬y"e]‡p^ýHçPýË}ëa‘–´#ð`,`@”&”`,`k‘à‚0£ð„mš… I÷éC-ôW‰˜Ý˜-ëì,Ä\Æ¢ôñRî¨aÃ~vO`,`b*¸ o©A»¦mëæLÇ*©Ì˜›ÂÀ`,`P^™ñ Ë÷'Û2z<o-®¸ÈÓ5˜Ëä ð1üRûÿ\.c• ûµœùR@âéô`), KEY `idx3` (`*`,`‘º¹ÙÅ@aN}ѽž‰Mó-°/4ýûà¸k<+½I$›¨§©d7I`,`(ûòRîVDÂfnòT®`(25),`Çɸ°f’jo0¦7—ÚøTq…`(25)) USING BTREE, KEY `idx4` (`o-b…sš–Õ*àË]*œ\7ÿlí!ª²è‚†­y¼en;J'ª‹¨³ˆR1‘“ò6;Éz¢`,`KÍP_ý)\joڜÒæ2ÿœ(yxˆTȚuÊܳŽ½žVp¤CÙ`) USING HASH, KEY `idx7` (`P÷w™§ª5[Ãá8ŒŠwJ¼´6WˆÑ¨¶YN‘·^äÀ8>wÈ9‰Ùf• ÆzÇP#éî_‚Š‘˜h`,`g^µ <wéHÌó)+<®:áßÕ{…Â--Qp°!â|%ÉǸ-ãu¸8f±•ä^;‰€”ò`,`Q5öÏÚÙûÑð`(21),`ÔÑeÑL%íô¯×®á²¯ Eà‰3¥”˜h¢aÝ&ɦ<_ØÃôF_†‡BiNþ*dŒ †œh®÷çû•EÛ`) USING BTREE, KEY `idx8` (`Çɸ°f’jo0¦7—ÚøTq…`(25),`…Ï¥ó$í¤‰žÙíç˜[4x|‰xE7Ÿš|›v͵:6eö%÷ª`(152),`¨™õ^ £@.p“'tñ’sÔÕ)³`,`%ŽèöE¯,ÜkºÛÓ¨ˆyLIä*ÿ¬y"e]‡p^ýHçPýË}ëa‘–´#ð`) USING HASH, KEY `idx9` (`%ŽèöE¯,ÜkºÛÓ¨ˆyLIä*ÿ¬y"e]‡p^ýHçPýË}ëa‘–´#ð`,`t‘ev+·¿# úPÏ`(25)), KEY `idx12` (`ÔÑeÑL%íô¯×®á²¯ Eà‰3¥”˜h¢aÝ&ɦ<_ØÃôF_†‡BiNþ*dŒ †œh®÷çû•EÛ`,`Çɸ°f’jo0¦7—ÚøTq…`(25),`ÉÕHuõ»îÕ¯3ÖqÃä/53¥§:¹`(59),`>3×¾€›” >/úš`,`èFàVŠa²N„0¿ûcDJÿ{£`,`¡uï[@E9Oí¾«å>^¤róm87vq¥œÕÙÑEÍP‰æÛªê–W¼&ò«±NøØæï<ŸíIH¦`) USING HASH, KEY `idx13` (`>3×¾€›” >/úš`,`=~0`(105)) USING BTREE, KEY `idx15` (`›í{>4šžþ¯dU0õ°_@ì‹*Ç_Œ`,`¯23Åü`,`KÍP_ý)\joڜÒæ2ÿœ(yxˆTȚuÊܳŽ½žVp¤CÙ`,`‘º¹ÙÅ@aN}ѽž‰Mó-°/4ýûà¸k<+½I$›¨§©d7I`), KEY `idx17` (`P÷w™§ª5[Ãá8ŒŠwJ¼´6WˆÑ¨¶YN‘·^äÀ8>wÈ9‰Ùf• ÆzÇP#éî_‚Š‘˜h`,`zpˆÜ”•·©ºˆsúpÜ¿tXœ”þ”¿ e}UqJQ~WèKÃQ*÷Ě»`,`P^™ñ Ë÷'Û2z<o-®¸ÈÓ5˜Ëä ð1üRûÿ\.c• ûµœùR@âéô`,`¨™õ^ £@.p“'tñ’sÔÕ)³`), KEY `idx18` (`›í{>4šžþ¯dU0õ°_@ì‹*Ç_Œ`), KEY `idx19` (`>3×¾€›” >/úš`,`èFàVŠa²N„0¿ûcDJÿ{£`,`ÔÑeÑL%íô¯×®á²¯ Eà‰3¥”˜h¢aÝ&ɦ<_ØÃôF_†‡BiNþ*dŒ †œh®÷çû•EÛ`), KEY `idx20` (`ùºœ¨0%̐Œx sœ]%øÃëÊ?U`,`YOànfç¶|?ôh¤Š½â9C¿àebT^µj`,`‘º¹ÙÅ@aN}ѽž‰Mó-°/4ýûà¸k<+½I$›¨§©d7I`,`)‡ø2۟áD܅aâ8Rè«®L`), KEY `idx21` (`Ä{XPH^€;ÞÛâä|+ßb™Ÿûª%&–«`,`ýɄ{cm"ðOÅ.֑¨Ç`,`}kïÿ0¬ðqKa60ç:¾¡;Ta#m´,™¡e 4W¥`) USING HASH, KEY `idx23` (`P^™ñ Ë÷'Û2z<o-®¸ÈÓ5˜Ëä ð1üRûÿ\.c• ûµœùR@âéô`,`±`), KEY `idx24` (`ÖÑÌÄX`,`¡uï[@E9Oí¾«å>^¤róm87vq¥œÕÙÑEÍP‰æÛªê–W¼&ò«±NøØæï<ŸíIH¦`,`ùºœ¨0%̐Œx sœ]%øÃëÊ?U`,`Ru-Ù? D†?Ì!žÛyVTÌ-ã`,`}kïÿ0¬ðqKa60ç:¾¡;Ta#m´,™¡e 4W¥`,`¨™õ^ £@.p“'tñ’sÔÕ)³`) USING BTREE, KEY `idx26` (`k‘à‚0£ð„mš… I÷éC-ôW‰˜Ý˜-ëì,Ä\Æ¢ôñRî¨aÃ~vO`,`ηxçîØ»ÚKtÌï{㿪:Xèd±ÌIF¢aÃÏ-°“îhƇ¢ §–Ÿ`,`ùºœ¨0%̐Œx sœ]%øÃëÊ?U`,`g^µ <wéHÌó)+<®:áßÕ{…Â--Qp°!â|%ÉǸ-ãu¸8f±•ä^;‰€”ò`,`P÷w™§ª5[Ãá8ŒŠwJ¼´6WˆÑ¨¶YN‘·^äÀ8>wÈ9‰Ùf• ÆzÇP#éî_‚Š‘˜h`), KEY `idx27` (`ùºœ¨0%̐Œx sœ]%øÃëÊ?U`,`ÔÑeÑL%íô¯×®á²¯ Eà‰3¥”˜h¢aÝ&ɦ<_ØÃôF_†‡BiNþ*dŒ †œh®÷çû•EÛ`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hâæøta³ åñãñ •¬’ávƒpöut?íû€h<u´u6üí½¦ˆ ã해9ˆk=ôðê"±ìýx` -- DROP TABLE IF EXISTS `hâæøta³ åñãñ •¬’ávƒpöut?íû€h<u´u6üí½¦ˆ ã해9ˆk=ôðê"±ìýx`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hâæøta³ åñãñ •¬’ávƒpöut?íû€h<u´u6üí½¦ˆ ã해9ˆk=ôðê"±ìýx` ( `a8` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000', `»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú` bit(44) NOT NULL DEFAULT b'11000011010100000', `ÌÚ{Ê’ò{)å ¡Fe똴?ÿÛå¨%νízÅ4ºfˆ±™¾XË;` char(141) CHARACTER SET utf8 NOT NULL, `ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–` smallint(6) DEFAULT '0', `ß` geometry NOT NULL, `Úþ«“(H”¥oO L=î}u{oq³ø§élò` date DEFAULT '2013-05-28', `iFÏ a*¹ý¤’!º+&#¯LÖy [ŠâçnŒ03˜Eðb' ò«.y§:Ð` multipoint NOT NULL, `Aƒ6ºO8­Ô*<` binary(1) NOT NULL, `S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡` geometry NOT NULL, `Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP` varbinary(243) NOT NULL, `âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF` blob NOT NULL, `Cò" e0€6/±ŠÎãADÎz` date NOT NULL DEFAULT '2013-06-12', `=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU` mediumblob NOT NULL, `Œa †ê’•°$9b}¤}ºwlë Ð‹l-ÐðO` timestamp NOT NULL DEFAULT '2013-10-02 14:14:16', `ÊÀÍÙ§úå½ ó†‹nE9]銒föÝh€¿|²™a#[aPaùöœWnØá(’‹ö` bit(43) DEFAULT b'11001100100', `ïÎý¡pÏò9ÙëŒÿ»}Üß^Û[ãv¦ãñoÝØTæcÕYŒãaýLô‡ Ã\( ¿/bîΝ;K[^gR` set('g','bqlxzvaq','jdjqa','','ajuycjms','l','b','tallvpc','aohl','rrkmf','is','cljtffvp','','uj','fhccvion','xjfkelvppf','','eq','','ih','ygtfc','wqcjwqatx','fl','roerworad','ewbcvrgocu','spbnit','xtdhaj','m','ftymwfdp','zroc','pirgtwm','shtlpmjewc','oveweqe','zmsglkeg','zlnzr','blahtwinq','ufctda','fw','fnslcxz','jseho','gfgaecqqj','kjyhq','teic','fplpegtofh','','fu','dbpldcboec','kjlgvk','','yfszfj','fslllhiky','dlrjofzdki','fpmcjj','srjwxrhy','wmgla','mjxysz','zrytmlcs','jqdilnjg') NOT NULL, `íJgìz0ÎÃ` text NOT NULL, `¯&` double DEFAULT '-4.53e47', `_iœÿµ[v^È^གྷ¡<jþ°—”9‚´³FÚ_Ï·l.ßaÂT*5bZÉiä¡ê»â¾R` bigint(20) unsigned NOT NULL DEFAULT '871022800000', `<‰¯X` geometry NOT NULL, `ƒê0ǎGÆÖüúl¦ñF` timestamp NOT NULL DEFAULT '2012-12-17 11:52:42', `¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î` float NOT NULL DEFAULT '100000', `„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.` mediumint(8) unsigned NOT NULL DEFAULT '0', `ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x` binary(1) NOT NULL, PRIMARY KEY (`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`Aƒ6ºO8­Ô*<`,`¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î`,`ÌÚ{Ê’ò{)å ¡Fe똴?ÿÛå¨%νízÅ4ºfˆ±™¾XË;`(99),`a8`), UNIQUE KEY `idx86` (`Œa †ê’•°$9b}¤}ºwlë Ð‹l-ÐðO`,`ïÎý¡pÏò9ÙëŒÿ»}Üß^Û[ãv¦ãñoÝØTæcÕYŒãaýLô‡ Ã\( ¿/bîΝ;K[^gR`,`a8`), UNIQUE KEY `idx55` (`Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP`(223),`ƒê0ǎGÆÖüúl¦ñF`,`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(3)), UNIQUE KEY `idx59` (`Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP`(64)), UNIQUE KEY `idx79` (`ß`(70)) USING HASH, UNIQUE KEY `idx87` (`íJgìz0ÎÃ`(15),`iFÏ a*¹ý¤’!º+&#¯LÖy [ŠâçnŒ03˜Eðb' ò«.y§:Ð`(233),`S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡`(18),`_iœÿµ[v^È^གྷ¡<jþ°—”9‚´³FÚ_Ï·l.ßaÂT*5bZÉiä¡ê»â¾R`) USING BTREE, UNIQUE KEY `idx48` (`¯&`,`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(170),`a8`,`S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡`(119),`Œa †ê’•°$9b}¤}ºwlë Ð‹l-ÐðO`,`ïÎý¡pÏò9ÙëŒÿ»}Üß^Û[ãv¦ãñoÝØTæcÕYŒãaýLô‡ Ã\( ¿/bîΝ;K[^gR`), UNIQUE KEY `idx64` (`ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–`,`ß`(235),`iFÏ a*¹ý¤’!º+&#¯LÖy [ŠâçnŒ03˜Eðb' ò«.y§:Ð`(37),`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`,`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(208)), UNIQUE KEY `idx81` (`iFÏ a*¹ý¤’!º+&#¯LÖy [ŠâçnŒ03˜Eðb' ò«.y§:Ð`(16),`¯&`,`ïÎý¡pÏò9ÙëŒÿ»}Üß^Û[ãv¦ãñoÝØTæcÕYŒãaýLô‡ Ã\( ¿/bîΝ;K[^gR`,`¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î`), UNIQUE KEY `idx83` (`ß`(159),`Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP`(175),`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`,`ƒê0ǎGÆÖüúl¦ñF`,`¯&`,`íJgìz0ÎÃ`(3)), KEY `idx47` (`Úþ«“(H”¥oO L=î}u{oq³ø§élò`,`ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–`), KEY `idx49` (`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`,`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(74)), KEY `idx51` (`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(198),`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`,`Úþ«“(H”¥oO L=î}u{oq³ø§élò`,`S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡`(254)), KEY `idx53` (`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`,`¯&`,`Aƒ6ºO8­Ô*<`,`ƒê0ǎGÆÖüúl¦ñF`,`ÌÚ{Ê’ò{)å ¡Fe똴?ÿÛå¨%νízÅ4ºfˆ±™¾XË;`(6),`_iœÿµ[v^È^གྷ¡<jþ°—”9‚´³FÚ_Ï·l.ßaÂT*5bZÉiä¡ê»â¾R`), KEY `idx56` (`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`Úþ«“(H”¥oO L=î}u{oq³ø§élò`,`¯&`,`ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–`), KEY `idx57` (`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`Aƒ6ºO8­Ô*<`,`¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î`,`ÌÚ{Ê’ò{)å ¡Fe똴?ÿÛå¨%νízÅ4ºfˆ±™¾XË;`(128),`a8`), KEY `idx58` (`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(99)) USING BTREE, KEY `idx60` (`Úþ«“(H”¥oO L=î}u{oq³ø§élò`,`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`), KEY `idx61` (`Aƒ6ºO8­Ô*<`,`<‰¯X`(22),`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(127),`¯&`,`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`), KEY `idx62` (`iFÏ a*¹ý¤’!º+&#¯LÖy [ŠâçnŒ03˜Eðb' ò«.y§:Ð`(227),`ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–`,`ÊÀÍÙ§úå½ ó†‹nE9]銒föÝh€¿|²™a#[aPaùöœWnØá(’‹ö`,`¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î`,`¯&`) USING HASH, KEY `idx63` (`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`ÊÀÍÙ§úå½ ó†‹nE9]銒föÝh€¿|²™a#[aPaùöœWnØá(’‹ö`), KEY `idx66` (`Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP`(92),`Aƒ6ºO8­Ô*<`,`<‰¯X`(226),`ifß±¢{v8+G»cdŸP…DîIø}8¤N£qh ,Æ #ÊÃ3ï…a33-f‹0^!–`) USING BTREE, KEY `idx67` (`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(141),`ÌÚ{Ê’ò{)å ¡Fe똴?ÿÛå¨%νízÅ4ºfˆ±™¾XË;`(69),`¯&`,`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(212),`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`) USING BTREE, KEY `idx68` (`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(82)), KEY `idx69` (`¯&`,`_iœÿµ[v^È^གྷ¡<jþ°—”9‚´³FÚ_Ï·l.ßaÂT*5bZÉiä¡ê»â¾R`,`S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡`(115),`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(130)), KEY `idx70` (`ß`(185),`ƒê0ǎGÆÖüúl¦ñF`,`Aƒ6ºO8­Ô*<`,`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`) USING BTREE, KEY `idx71` (`ÊÀÍÙ§úå½ ó†‹nE9]銒föÝh€¿|²™a#[aPaùöœWnØá(’‹ö`,`a8`), KEY `idx72` (`íJgìz0ÎÃ`(62),`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`,`Aƒ6ºO8­Ô*<`), KEY `idx73` (`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`,`¯&`), KEY `idx74` (`¶à‚ü_Àœ±¨£é—HÅ@jï씔ÏÀ°ôé 4Î`,`ƒê0ǎGÆÖüúl¦ñF`,`Û<3ё©r• {ÕWÂa}8a±ºä_KËØZ‚zÒÖæUmbkŠ fqTéAÁå³ZkaÖÉõP`(176),`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(61),`ß`(215),`S¡èՁ>ÝCQ PÚô#÷2TŽió›!l†´¾äú+daÿ”ØÂAV‡`(112)), KEY `idx75` (`»þ¡Èp Ò2ÉhE‘"œœÆ ´Ú`,`¯&`,`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`,`Aƒ6ºO8­Ô*<`,`<‰¯X`(203),`ïÎý¡pÏò9ÙëŒÿ»}Üß^Û[ãv¦ãñoÝØTæcÕYŒãaýLô‡ Ã\( ¿/bîΝ;K[^gR`), KEY `idx76` (`Aƒ6ºO8­Ô*<`,`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(21),`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(244)) USING BTREE, KEY `idx78` (`a8`,`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`) USING BTREE, KEY `idx80` (`_iœÿµ[v^È^གྷ¡<jþ°—”9‚´³FÚ_Ï·l.ßaÂT*5bZÉiä¡ê»â¾R`), KEY `idx82` (`Úþ«“(H”¥oO L=î}u{oq³ø§élò`), KEY `idx84` (`ÈòšüþªaÀuÁ 'êØ &â¼µ8õ‹fŸ|Ûcôf)íí7x`) USING BTREE, KEY `idx85` (`Œa †ê’•°$9b}¤}ºwlë Ð‹l-ÐðO`,`=‚\H‡a-"âos²û‹Òh8±˜ƒ—ÛaUU`(177),`âA΂íýKb’$Åð%|Ò&!Qàí±ÂžíF`(115),`„2gíèqõh@m¸Ù#0o¢HËىÁõ!½ÀÓK hÎ)‘ZÕbÚÖN®Q._ÀÏÅÅ;Œy¿â.`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=512; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `r1` -- DROP TABLE IF EXISTS `r1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `r1` ( `a` smallint(6) NOT NULL, `b` text, PRIMARY KEY (`a`), KEY `d` (`b`(55)), KEY `f` (`b`(255)), KEY `h` (`b`(30)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0001` -- DROP TABLE IF EXISTS `t0001`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0001` ( `a1` int(11) NOT NULL, `col1` multipolygon NOT NULL, `col3` linestring NOT NULL, `col4` text NOT NULL, `col5` multipoint NOT NULL, `col6` mediumtext NOT NULL, `col7` set('','rnmingnfmm','srfwqmfw','mqhbtf','p','hgysrq','zoejxhs','tjxksgvc','','vr','si','nctllps','qmlgj','wpaefyf','gqrrrkjvj','f','othovcslmk','','','o','wbl','bfgetgmwb','fw','n','pgogdeaeo','aaexktb','euot','d','sltuowyp','fnyhusmvk','ddynt','scsef','','','az','cktb','sh','ts','y','','pwjezukku','e','u','qietew','xyvj','','nmwzufrvqx') NOT NULL, `col8` datetime DEFAULT '2012-11-30 02:11:24', `col9` linestring DEFAULT NULL, `col10` geometrycollection NOT NULL DEFAULT '', `col11` enum('awxqhtxsvw','msyjug','dqynxowc','fgxjzknrdl','ocakyk','mfmr','kde','epe','k','inyyuwv','iuiynemt','bx') NOT NULL, `col12` decimal(47,27) NOT NULL DEFAULT '99999.000000000000000000000000000', `col13` binary(1) NOT NULL, `col14` char(229) CHARACTER SET utf8 NOT NULL, `col15` double unsigned DEFAULT '597.288', `col16` smallint(6) NOT NULL DEFAULT '-198', `col17` geometrycollection DEFAULT NULL, `col18` longblob NOT NULL, `col19` tinyint(1) NOT NULL DEFAULT '0', `col20` mediumblob NOT NULL, `col21` double unsigned DEFAULT '1291.8246', `col22` float unsigned NOT NULL DEFAULT '1105.6', `col23` tinyint(1) NOT NULL DEFAULT '0', `col25` int(11) NOT NULL DEFAULT '0', `col26` timestamp NOT NULL DEFAULT '2013-12-28 15:51:26', `col27` mediumtext NOT NULL, `col28` varchar(126) CHARACTER SET utf8 NOT NULL DEFAULT 'rvdhezyzawiczzqfiocetwiuqybkdrpgdbyklawycjizkkswogtcmaeenrkmatsyhplwwciyjbvuwphpzptmdn', `col29` timestamp NOT NULL DEFAULT '2014-03-11 13:26:54', `col32` date NOT NULL DEFAULT '2012-10-02', `col33` longtext NOT NULL, `col34` geometry NOT NULL, `col35` timestamp NOT NULL DEFAULT '2013-05-02 01:09:57', `col36` bigint(20) DEFAULT '1118', `col38` point DEFAULT NULL, `col39` enum('darc','dilfaqj','c','n','qhxrowflm','xuxrxs','qdhwpf','yj','qpeimahna','mai','fgesjugte','zdocdi','oxhvohg','pwjyre','','kdj','ecblhooeb','ekzij','cd','ig','ojuudqk','alszlckv','ciyfd','ub','yfuqyrz','l','yvi','fnlzyxgj','y','miqovbpq','vikk','cwxqoxssi','nmut','eyzkjk','l','mhplfso','jmjzfbguw') NOT NULL, `col41` decimal(34,19) unsigned zerofill DEFAULT '000000000000700.7444000000000000000', `col43` time NOT NULL DEFAULT '19:28:29', `col46` multipoint DEFAULT NULL, `col47` point DEFAULT NULL, `col49` geometrycollection DEFAULT NULL, `col50` longblob NOT NULL, `col51` text NOT NULL, `col52` geometry NOT NULL, `col53` polygon NOT NULL, `col54` geometry NOT NULL, `col55` blob NOT NULL, `col56` mediumtext NOT NULL, `col57` tinyblob NOT NULL, `col60` int(10) unsigned NOT NULL DEFAULT '876', `col61` year(4) DEFAULT '0000', `col62` tinyint(1) DEFAULT NULL, `col63` bigint(20) unsigned DEFAULT '0', `col64` date DEFAULT '2013-07-25', `col65` multipolygon NOT NULL, `col66` timestamp NOT NULL DEFAULT '2013-01-20 03:35:19', `col67` text NOT NULL, `col68` int(11) NOT NULL DEFAULT '100000', `col69` double unsigned zerofill NOT NULL DEFAULT '0000000000000000000630', `col70` tinyint(3) unsigned DEFAULT '0', `col71` varbinary(239) NOT NULL, `col72` linestring NOT NULL, `col74` text NOT NULL, `col75` decimal(25,17) unsigned NOT NULL DEFAULT '485.00000000000000000', `col78` time DEFAULT '07:43:03', `col79` timestamp NOT NULL DEFAULT '2013-05-14 03:07:28', `col80` geometrycollection DEFAULT NULL, `col82` time NOT NULL DEFAULT '11:51:48', `col83` geometrycollection DEFAULT NULL, `col84` date DEFAULT '2013-10-12', `col86` binary(1) NOT NULL, `col87` datetime NOT NULL DEFAULT '2013-12-13 02:03:21', `col88` datetime NOT NULL DEFAULT '2013-04-08 15:14:18', `col90` timestamp NOT NULL DEFAULT '2012-12-11 01:32:47', `col91` tinytext NOT NULL, `col92` timestamp NOT NULL DEFAULT '2013-08-22 06:36:12', `col93` int(10) unsigned NOT NULL DEFAULT '1399', `col94` multipolygon NOT NULL, PRIMARY KEY (`col72`(173),`col88`,`col19`,`col10`(179),`col91`(169)), UNIQUE KEY `idx14` (`col65`(97),`col16`,`col69`,`col68`,`col18`(174),`col5`(188),`col82`,`col50`(2)) USING BTREE, UNIQUE KEY `idx4` (`col86`,`col46`(201),`col34`(245),`col68`,`col65`(100),`col29`,`col25`), UNIQUE KEY `idx5` (`col25`,`col6`(104),`col20`(99),`col15`), UNIQUE KEY `idx10` (`col84`,`col17`(92),`col64`,`col86`,`col8`,`col14`(79)) USING HASH, UNIQUE KEY `idx12` (`col19`,`col15`,`col53`(17),`col1`(232)) USING HASH, UNIQUE KEY `idx20` (`col67`(216),`col10`(166),`col14`(139),`col60`,`col33`(89),`col92`), UNIQUE KEY `idx43` (`col3`(188),`col63`) USING HASH, KEY `idx0` (`col21`,`col11`,`col79`,`col35`,`col64`,`col68`), KEY `idx1` (`col67`(189),`col71`(183),`col38`(25),`col6`(58)) USING HASH, KEY `idx2` (`col8`), KEY `idx6` (`col12`,`col1`(240),`col90`,`col69`), KEY `idx7` (`col84`,`col55`(77),`col79`,`col47`(25),`col23`,`col1`(42),`col88`) USING BTREE, KEY `idx8` (`col15`,`a1`,`col64`) USING BTREE, KEY `idx9` (`col69`,`col35`,`col23`,`col13`,`col20`(219),`col66`), KEY `idx11` (`col21`,`col84`,`col28`(39),`col1`(73),`col34`(90),`col82`,`col88`) USING HASH, KEY `idx13` (`col82`,`col4`(251),`col32`,`col43`,`col46`(43),`col10`(234),`col22`), KEY `idx15` (`col14`(96),`col12`,`col47`(25),`col88`,`col94`(138)) USING BTREE, KEY `idx17` (`col10`(139),`col36`,`col33`(85),`col49`(235),`col51`(107),`col90`,`col11`,`col6`(134)), KEY `idx19` (`col21`,`col28`(38),`col36`,`col33`(127),`a1`,`col94`(130)), KEY `idx21` (`col72`(96),`col14`(194),`col3`(250),`col36`) USING BTREE, KEY `idx22` (`col19`,`col55`(199),`col93`,`col22`,`col6`(174),`col27`(97)), KEY `idx23` (`col39`), KEY `idx24` (`col64`) USING HASH, KEY `idx25` (`col17`(206)), KEY `idx26` (`col92`,`col55`(77),`col68`,`col57`(236),`col86`,`col50`(33),`col38`(25)) USING HASH, KEY `idx28` (`col56`(217),`col13`,`col7`,`col71`(86)), KEY `idx29` (`col50`(144),`col34`(219),`col43`,`col41`,`col28`(122),`col47`(25),`col93`) USING BTREE, KEY `idx30` (`col1`(198),`col88`,`col64`,`col3`(11),`col12`,`col28`(58)) USING HASH, KEY `idx31` (`col49`(96),`col79`), KEY `idx32` (`col63`,`col41`) USING HASH, KEY `idx35` (`col43`,`col5`(98),`col33`(173),`col15`,`col16`), KEY `idx36` (`col87`,`col75`,`col61`,`col83`(123)), KEY `idx37` (`col72`(58),`col88`,`col19`,`col10`(206),`col91`(106)), KEY `idx38` (`col67`(121),`col14`(5),`col94`(93),`col46`(164),`col26`,`col38`(25)), KEY `idx39` (`col10`(159),`col8`,`col39`,`col79`,`col51`(123),`col17`(108)) USING HASH, KEY `idx40` (`col92`,`col69`,`col9`(229),`col13`), KEY `idx41` (`col94`(134),`col35`,`col28`(24)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4096; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0002` -- DROP TABLE IF EXISTS `t0002`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0002` ( `a2` int(11) DEFAULT NULL, `col97` datetime NOT NULL DEFAULT '2014-04-02 17:19:08', `col99` datetime NOT NULL DEFAULT '2012-12-29 05:44:17', `col100` multipolygon DEFAULT NULL, `col101` binary(1) NOT NULL, `col102` point NOT NULL, `col103` longblob NOT NULL, `col104` multipoint DEFAULT NULL, `col106` bit(30) DEFAULT b'11000011010100001', `col107` text NOT NULL, `col109` timestamp NOT NULL DEFAULT '2014-03-27 09:47:55', `col110` binary(1) NOT NULL, `col111` datetime NOT NULL DEFAULT '2013-08-02 09:23:17', `col112` int(10) unsigned DEFAULT '0', `col113` multilinestring DEFAULT NULL, `col115` longtext NOT NULL, `col116` binary(1) NOT NULL, `col117` tinyint(1) NOT NULL DEFAULT '0', `col119` linestring NOT NULL, `col120` timestamp NOT NULL DEFAULT '2013-05-29 07:34:40', `col121` linestring NOT NULL, `col122` point DEFAULT NULL, `col123` point NOT NULL DEFAULT '', `col124` linestring DEFAULT NULL, `col125` multipolygon NOT NULL, `col126` varchar(191) CHARACTER SET utf8 NOT NULL DEFAULT 'zgpezylvgufytzonmctpelwzgghkxcisqbkwddmeikyghyhukayekbspvjsvzbooqkdituiqbyaonvfuhduujmwfmwzciwnlxongffqpudkvtnjcrzlierqocrlfsiumscinnoqsmpgdrdjarjlcqoueelibaoffmhxjzzjwcbadipu', `col127` double unsigned DEFAULT '1099.668', `col128` date DEFAULT '2012-11-28', `col129` double unsigned DEFAULT NULL, `col130` geometry NOT NULL, `col131` varbinary(206) NOT NULL, `col132` geometrycollection DEFAULT NULL, `col133` mediumblob NOT NULL, `col134` geometry DEFAULT NULL, `col136` multipoint NOT NULL, `col137` multilinestring DEFAULT NULL, `col138` char(204) NOT NULL DEFAULT 'bvvtevltpvhvpfdlivyhlmvpkqiwzthhyjhguysildyhutwgmrqbankejkswcrhgwnzonolvbohdkjx', `col139` time DEFAULT '14:46:46', `col140` set('','sxjxy','anozrcaqj','rguk','anu','nmqc','vzn','izbd','qiohi','qtxz','','gaobrrxcun','soryzmorf','l','p','kncymq','wrzij') NOT NULL, `col141` geometry NOT NULL, `col142` mediumint(8) unsigned NOT NULL DEFAULT '1607', `col143` float unsigned zerofill DEFAULT '00000362.088', `col144` geometry NOT NULL DEFAULT '', `col146` multipolygon DEFAULT NULL, `col147` int(10) unsigned NOT NULL DEFAULT '424', `col149` mediumtext NOT NULL, `col151` enum('o','vpzcqwdxq','','hc','akvp','kbafgfkj','dqdhikvsb','aky','nwvehzz','gzmqlsnkum','','p','ytcla','guxzlqked','shawijt','piftpnul','urerwpfd','m','bgwxt','tpikncxa','z','rjvspxelx','','f','ahznvglzl','') NOT NULL, `col152` double unsigned DEFAULT '1446.4067', `col153` tinyblob NOT NULL, `col154` char(110) CHARACTER SET utf8 NOT NULL, `col155` time DEFAULT '07:26:24', `col156` geometry DEFAULT NULL, `col157` longtext NOT NULL, `col160` decimal(32,8) DEFAULT '-1343.62460000', `col161` mediumint(9) NOT NULL DEFAULT '-1086', `col162` tinyint(1) NOT NULL DEFAULT '0', `col163` date DEFAULT '2012-07-17', `col164` binary(1) NOT NULL, `col165` datetime NOT NULL DEFAULT '2012-12-16 22:12:27', `col166` set('rlk','','yblbvm','esekvir','sgoeki','sp','rsjtocpe','qlcmvhxpl','avvvehbcf','jgun','gpi','ljg','melg','nacde','ytuthg','sfueqfz','wk','iafwrlciw','','gwpsfmjd','','hxdmaaiw','yblakgziz','eaolqzyofq','ivlxjuwc','r','pjokxofdlx','kuhr','','iipbwhem','abxc') NOT NULL, `col169` time DEFAULT '21:26:09', `col171` timestamp NOT NULL DEFAULT '2012-12-07 12:13:56', `col172` point NOT NULL DEFAULT '', `col173` tinyint(3) unsigned NOT NULL DEFAULT '0', `col174` blob NOT NULL, `col175` multipoint DEFAULT NULL, `col176` longblob NOT NULL, `col177` blob NOT NULL, `col179` mediumtext NOT NULL, `col180` float unsigned DEFAULT '70', `col182` varbinary(235) NOT NULL, `col183` multilinestring DEFAULT NULL, `col184` multilinestring DEFAULT NULL, `col185` point NOT NULL, `col186` linestring NOT NULL, `col187` double NOT NULL DEFAULT '-885', `col188` year(4) NOT NULL DEFAULT '0000', `col189` linestring DEFAULT NULL, `col190` decimal(48,9) DEFAULT '1312.997300000', `col192` multilinestring NOT NULL, `col193` date NOT NULL DEFAULT '2012-05-18', `col194` decimal(47,19) NOT NULL DEFAULT '1646.1823000000000000000', `col195` mediumblob NOT NULL, `col196` linestring DEFAULT NULL, `col197` double unsigned NOT NULL DEFAULT '0', `col200` multilinestring NOT NULL, `col201` bigint(20) unsigned NOT NULL DEFAULT '600', `col202` decimal(42,30) unsigned zerofill DEFAULT '000000001698.754700000000000000000000000000', `col203` geometrycollection NOT NULL, PRIMARY KEY (`col144`(5),`col197`,`col161`,`col200`(251),`col119`(145),`col172`(25),`col123`(25)), UNIQUE KEY `idx47` (`col188`,`col171`), UNIQUE KEY `idx50` (`col144`(19),`col197`,`col161`,`col200`(25),`col119`(157),`col172`(25),`col123`(25)), KEY `idx44` (`col104`(50),`col106`,`col138`(27),`col134`(184),`col137`(18),`col154`(26),`col112`), KEY `idx46` (`col190`,`col116`,`col139`,`col171`,`col110`,`col127`), KEY `idx48` (`col180`,`col119`(11),`col184`(186),`col160`,`col117`,`col97`), KEY `idx49` (`col179`(185),`col155`,`col97`,`col146`(228),`col163`,`col115`(69)) USING BTREE, KEY `idx51` (`col101`,`col180`) USING BTREE, KEY `idx52` (`col195`(110),`col177`(14),`col156`(189)), KEY `idx53` (`col130`(20)), KEY `idx54` (`col107`(184),`col134`(68),`col192`(16),`col183`(66),`col156`(33),`col190`,`col196`(222),`col193`,`col120`), KEY `idx56` (`col112`,`col134`(68)), KEY `idx57` (`col101`,`col175`(100),`col195`(238),`col160`,`col143`,`col116`,`col192`(192),`col147`), KEY `idx58` (`col203`(11)) USING BTREE, KEY `idx59` (`col109`,`col138`(117),`col190`,`col100`(167)) USING HASH, KEY `idx61` (`col186`(13),`col128`,`col153`(135),`col142`,`col129`,`col163`,`col177`(255),`col137`(37),`col138`(116)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=16; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0003` -- DROP TABLE IF EXISTS `t0003`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0003` ( `a3` int(10) unsigned DEFAULT NULL, `col204` timestamp NOT NULL DEFAULT '2013-08-07 09:42:06', `col205` char(153) CHARACTER SET utf8 NOT NULL DEFAULT 'zqwqwbhdujzdzwaijrjsxyiagwbxwlttpqna', `col206` geometry NOT NULL, `col207` mediumtext NOT NULL, `col208` datetime DEFAULT '2013-07-23 19:05:28', `col210` timestamp NOT NULL DEFAULT '2013-07-10 18:46:25', `col211` double unsigned NOT NULL DEFAULT '0', `col212` time NOT NULL DEFAULT '06:55:59', `col213` double NOT NULL DEFAULT '99999', `col214` enum('lyih','hqnoxrw','dlhx','tsnxzr','hehc','ecmv','fwwaxpbow','sri','','z','t','vdlyhkbgxa','ydzdk','hzg','uz','lt','vpfqrqiep','jdza','','wwj','kdpxhvu','gwytkl','qnl','ztwrat','qw','cp','gicfzmf','icczfme','c','','avpaosiup','','dbot','w','anhstcod','jhq','tisuhg','deopcxmcae','howdrhqu','','iwjmyui','','kdprmjow','zn','kev','oqefwagb','dexeb','v','stazjvjqoa','','cgmnldedum','','wznxwoju','xn','','ichou') NOT NULL, `col215` polygon DEFAULT NULL, `col216` time DEFAULT '05:19:01', `col217` datetime NOT NULL DEFAULT '2013-04-22 00:02:23', `col218` set('zzwugjrvc','wz','ynayglndzf','enst','','ybkaxpbta','iyzorr','cxeqoqi','','yqqe','kmrrv','','s','kpkftian','','uodsce','lraakxbfge','pvkvnl','ag','mzwyg','gmiynpdiq','xvcgsi','ypxmzn','cotmpiec','olp','bgkq','wzipdok','','yrirjbep','','uichtfojwd','ot','sx','gjhihudair','qnripcwn','jbkpraje','jazgrisv','atdjrli','as','m','rnd','j','quwu','kbkyrzibk','ljxgetradz','dnl','wet','gqkqhbwgsr','ft','bspez','e','euc','c') NOT NULL, `col219` multipolygon DEFAULT NULL, `col220` binary(1) NOT NULL, `col221` date DEFAULT '2013-08-11', `col222` varbinary(49) NOT NULL, `col223` varbinary(32) NOT NULL, `col224` geometry NOT NULL, `col226` set('kgzgb','so','hhmzfasb','byhirdajn','','bmokrsb','vk','eudfup','nonj','a','va','hda','uisppoq','gobu','xkmeet','','bjoqlbaqsf','','rnlytbn','xngtsw','pkak','wfggb','sxx','prsyjub','rxqtuo','tkualuna','','sy','jbrvjdvej','i','acjulfpdrl','yjvitunb','','wtgntqk','','','oeiap','','sudcxcph','ql','cuhxmurmbo','suacmufil','jzcmjoebjs','ppbk') NOT NULL, `col228` mediumtext NOT NULL, `col230` multilinestring NOT NULL, `col232` char(143) CHARACTER SET utf8 NOT NULL, `col233` varbinary(197) NOT NULL, `col234` multilinestring DEFAULT NULL, `col236` tinyblob NOT NULL, `col237` time NOT NULL DEFAULT '06:03:23', `col238` mediumtext NOT NULL, `col239` double unsigned zerofill DEFAULT '00000000000001659.4918', `col240` multilinestring NOT NULL, `col241` longtext NOT NULL, `col242` datetime NOT NULL DEFAULT '2013-10-24 00:37:33', `col243` polygon NOT NULL, `col244` time NOT NULL DEFAULT '00:54:18', `col246` geometrycollection DEFAULT NULL, `col247` binary(1) NOT NULL, `col248` text NOT NULL, `col249` double NOT NULL DEFAULT '5.540531e102', `col251` double DEFAULT '1306.457', `col252` timestamp NOT NULL DEFAULT '2012-08-01 15:22:31', `col253` decimal(47,10) NOT NULL DEFAULT '739539800000000000000000000000000.0000000000', `col254` varbinary(192) NOT NULL, `col255` enum('nf','mpbpeft','yvpawin','vgalhmqsre','','ixaxxjon','','npgkw','vqwfxf','skxlvkcyp','wgftasw','rjdv','grvsoyqmfp','','gws','ztrxo','','vyqxcr','sipbiuwduu','pythfcctf','hrmnloiia','cdmuui','iickz','yanc','iwa','ia','vowcywvztz','p','piw','twf','fqumxspyt','','','nqbmlxndep','jano','ro','mkt','','hhtf','lhhyytuoyx') NOT NULL, `col256` binary(1) NOT NULL, `col257` time NOT NULL DEFAULT '21:59:32', `col258` datetime DEFAULT '2013-01-23 07:33:07', `col262` date NOT NULL DEFAULT '2013-04-29', `col263` multipolygon DEFAULT NULL, `col265` time DEFAULT '23:50:56', `col266` tinytext NOT NULL, `col267` linestring DEFAULT NULL, `col268` int(11) NOT NULL DEFAULT '585', `col269` float unsigned zerofill NOT NULL DEFAULT '001331190000', `col270` time NOT NULL DEFAULT '16:19:18', `col271` float DEFAULT '-7.15616e29', `col272` smallint(6) NOT NULL DEFAULT '887', `col273` longtext NOT NULL, `col274` multilinestring DEFAULT NULL, `col275` point DEFAULT NULL, `col277` char(175) NOT NULL DEFAULT 'yyodkfcyhljhreabatwaqogxmztjvhawzelyossrkwtothzqfoo', `col278` binary(1) NOT NULL, `col279` multipoint DEFAULT NULL, `col280` varchar(183) NOT NULL DEFAULT 'nwtbkkhajevacvuna', `col281` multipoint DEFAULT NULL, `col282` timestamp NOT NULL DEFAULT '2014-01-16 01:48:42', `col283` decimal(12,4) unsigned DEFAULT '527.1641', `col285` datetime NOT NULL DEFAULT '2013-11-24 04:21:27', `col286` datetime NOT NULL DEFAULT '2014-02-10 03:49:36', `col287` multilinestring NOT NULL, `col288` time DEFAULT '02:07:49', `col289` timestamp NOT NULL DEFAULT '2013-08-12 02:58:15', `col290` double unsigned zerofill NOT NULL DEFAULT '000000000.000005354304', `col291` geometrycollection DEFAULT NULL, `col292` time NOT NULL DEFAULT '01:10:15', `col295` tinyblob NOT NULL, `col297` decimal(65,12) unsigned NOT NULL DEFAULT '846.719600000000', `col298` time DEFAULT '06:12:04', `col299` char(243) CHARACTER SET utf8 NOT NULL DEFAULT 'iceuttuazliolcbojcpcvyqsgriftxzhxoxylvrpefouqftmy', `col300` time DEFAULT '04:06:23', `col302` polygon DEFAULT NULL, `col303` longtext NOT NULL, `col304` double unsigned DEFAULT '100001', `col305` linestring DEFAULT NULL, `col306` point NOT NULL, `col307` mediumtext NOT NULL, `col309` point DEFAULT NULL, `col310` longtext NOT NULL, `col312` multipolygon DEFAULT NULL, `col314` enum('ho','egnvstifbf','smiudhky','evgpyybzm','ajbzxlmlk','ptcuyiq','etbv','dxffty','fibbpo','mth','eaunae','ybznv','fdgstt','tq','xli','','','abu','diemqmwjm','kebq','fnxeqzp','ooundl','rgiwinbig','idx','nueyfsk','hjm','brtu','aupgmcrl','cklmbfg','','ndcoygxu','bkmm','drtbw','frxqmqsduj','rlbhlczqzx','tnsl','egkdf','gotgfbpw','vqjsgnz','pakicb','weyjn','hnqirywcf','','yjstdjfd','mbhiebbxsd','irtfqqjqgw','n','rr','d','mvwc','ode','dnvghmffgz','inpegrdbp','d','crasml','lbzm','lq','','lv','vvoeqvl') NOT NULL, `col315` multilinestring NOT NULL, PRIMARY KEY (`col277`(35),`col272`) USING HASH, UNIQUE KEY `idx66` (`col298`,`col291`(106),`col275`(25)) USING BTREE, UNIQUE KEY `idx78` (`col244`,`col216`,`col274`(96)), KEY `idx62` (`col238`(160),`col252`,`col269`), KEY `idx63` (`col232`(100),`col298`,`col247`) USING BTREE, KEY `idx64` (`col273`(83)) USING HASH, KEY `idx65` (`col281`(62),`col302`(190)), KEY `idx67` (`col295`(110)), KEY `idx68` (`col282`), KEY `idx69` (`col280`(167)) USING BTREE, KEY `idx71` (`col215`(28),`col280`(18),`col242`), KEY `idx72` (`col302`(124),`col240`(184)), KEY `idx73` (`col206`(27),`col312`(172)), KEY `idx74` (`col228`(57),`col247`,`col205`(144)), KEY `idx77` (`col312`(231),`col289`,`col290`), KEY `idx80` (`col275`(25),`col309`(25)) USING BTREE, KEY `idx81` (`col257`,`col277`(63),`col271`), KEY `idx82` (`col205`(116),`col279`(80)) USING HASH, KEY `idx83` (`col270`,`col265`,`col258`), KEY `idx84` (`col248`(6),`col206`(250),`col269`) USING BTREE, KEY `idx85` (`col291`(40),`col236`(24),`col275`(25)), KEY `idx86` (`col302`(164),`col271`) USING BTREE, KEY `idx87` (`col270`), KEY `idx88` (`col277`(10),`col272`) USING HASH, KEY `idx89` (`col214`,`col279`(28)), KEY `idx90` (`col216`,`col252`) USING BTREE, KEY `idx91` (`a3`), KEY `idx92` (`col278`), KEY `idx93` (`col205`(83),`col262`,`col216`), KEY `idx94` (`col251`,`col206`(78),`col218`), KEY `idx95` (`col277`(22)) USING HASH, KEY `idx96` (`col246`(8)) USING HASH, KEY `idx97` (`col228`(221),`col239`), KEY `idx98` (`col254`(6)), KEY `idx100` (`col224`(12),`col310`(71),`col215`(255)), KEY `idx102` (`col204`), KEY `idx103` (`col247`,`col272`,`col215`(175)), KEY `idx104` (`col246`(45)), KEY `idx105` (`col314`), KEY `idx106` (`col288`,`col277`(138)) USING HASH, KEY `idx107` (`col275`(25)) USING BTREE, KEY `idx108` (`col242`), KEY `idx109` (`col240`(42),`col208`) USING BTREE, KEY `idx110` (`col244`,`col286`), KEY `idx111` (`col215`(64),`col214`,`col265`), KEY `idx113` (`col214`), KEY `idx114` (`col256`,`col292`,`col236`(177)), KEY `idx115` (`col272`), KEY `idx117` (`col282`), KEY `idx118` (`col263`(228),`col256`,`col206`(176)) USING BTREE, KEY `idx121` (`col268`,`col251`,`col226`) USING BTREE, KEY `idx122` (`col216`,`col289`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=16; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0004` -- DROP TABLE IF EXISTS `t0004`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0004` ( `a4` int(10) unsigned zerofill NOT NULL, `col317` timestamp NOT NULL DEFAULT '2013-05-12 19:24:21', `col318` char(226) CHARACTER SET utf8 NOT NULL DEFAULT 'oeoeoobmzbvoiiyepjkorxpeqlonweivcbyfxarhkqqbgktgnxrrqbxyglmgwdvohexhzpvttvbtgzbvvxogkhpe', `col319` double NOT NULL DEFAULT '1665.8961', `col320` char(98) CHARACTER SET utf8 NOT NULL, `col321` point DEFAULT NULL, `col322` decimal(50,6) DEFAULT '0.000000', `col324` multipolygon NOT NULL, `col325` double DEFAULT '2.59e-28', `col326` text NOT NULL, `col330` mediumtext NOT NULL, `col331` multipolygon NOT NULL, `col332` datetime NOT NULL DEFAULT '2013-07-04 14:18:35', `col333` multipolygon NOT NULL, `col334` enum('','vtxlie','zniclbl','b','dsyvhsr','vovn','dyzult','losawzr','xqc','usl','ujeittkro','jkp','pdibqviuqz','clywjhr','','mayggqf','tppkh','lfeaw','qeg','wit','eavoqagk','ayt','neuvu','uauajvtjqe','ivfrekf','nrhri','aviqjqe','nje','vnczhd','vrbmcmc','aesptxio','w','ckkwz','dadanh','qzlvf','r','bb','vbny') NOT NULL, `col335` time NOT NULL DEFAULT '22:04:03', `col336` time NOT NULL DEFAULT '04:31:30', `col337` longblob NOT NULL, `col338` multilinestring NOT NULL, `col339` date NOT NULL DEFAULT '2013-04-16', `col340` tinytext NOT NULL, `col341` datetime DEFAULT '2013-09-28 10:18:39', `col342` geometry DEFAULT NULL, `col343` multipolygon DEFAULT NULL, `col344` geometrycollection DEFAULT NULL, `col345` point DEFAULT NULL, PRIMARY KEY (`col324`(167),`col333`(36)), UNIQUE KEY `idx133` (`col322`), KEY `idx123` (`col330`(72),`col319`,`col343`(130)), KEY `idx124` (`col332`,`col343`(19)) USING BTREE, KEY `idx125` (`col325`,`col344`(6),`col340`(34),`col336`,`col331`(26)) USING HASH, KEY `idx126` (`col336`,`col320`,`col341`), KEY `idx127` (`col331`(110)) USING BTREE, KEY `idx128` (`col331`(230)), KEY `idx129` (`col326`(67),`col337`(39),`col319`,`col332`) USING HASH, KEY `idx130` (`col322`,`col326`(110),`col321`(25),`col333`(24),`col337`(236)), KEY `idx131` (`col317`,`col338`(145),`col333`(159),`col321`(25),`col334`,`col339`) USING HASH, KEY `idx132` (`col343`(38),`col317`,`col333`(13),`col344`(221),`col341`,`col336`) USING BTREE, KEY `idx135` (`col322`,`col340`(1),`col325`,`col342`(70),`col324`(229)), KEY `idx136` (`col324`(86),`col333`(212)), KEY `idx137` (`col340`(244),`col318`(64),`a4`,`col326`(101),`col317`), KEY `idx138` (`col322`,`col317`), KEY `idx139` (`col320`(25),`col332`,`col322`,`col338`(66),`col335`,`col337`(109)), KEY `idx141` (`col336`,`col331`(63)) USING BTREE, KEY `idx142` (`col333`(137)) USING BTREE, KEY `idx143` (`col317`,`col344`(71),`col331`(212),`a4`,`col324`(252),`col322`), KEY `idx144` (`col335`,`col339`,`col333`(135),`col344`(46),`col324`(79),`col330`(88),`col342`(113)), KEY `idx145` (`col338`(88),`col340`(205),`col325`,`col336`,`col326`(113),`col333`(68)) USING HASH, KEY `idx146` (`a4`,`col330`(173)) USING HASH, KEY `idx147` (`col330`(95),`col318`(132),`col336`) USING BTREE, KEY `idx148` (`col334`,`col319`), KEY `idx150` (`col324`(220),`col341`,`col321`(25),`col344`(140)), KEY `idx151` (`col330`(109)) USING BTREE, KEY `idx152` (`col333`(255),`col342`(242),`col338`(46)), KEY `idx153` (`col330`(30),`col337`(159),`col345`(25),`col324`(164),`col322`,`col335`), KEY `idx154` (`col342`(213),`a4`,`col318`(190)), KEY `idx155` (`col321`(25),`col319`), KEY `idx156` (`col340`(46),`col331`(61),`col330`(164),`col342`(2),`col343`(116),`col332`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4096; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0005` -- DROP TABLE IF EXISTS `t0005`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0005` ( `a5` int(10) unsigned DEFAULT NULL, `col346` int(10) unsigned DEFAULT '22', `col347` linestring NOT NULL, `col348` multipoint DEFAULT NULL, `col349` longtext NOT NULL, `col351` year(4) DEFAULT '0000', `col352` date DEFAULT '2013-02-11', `col353` mediumint(9) DEFAULT '714', `col357` multipoint DEFAULT NULL, `col358` multilinestring DEFAULT NULL, `col360` multipolygon NOT NULL, `col362` set('antxllktf','cvvo','bejyhjb','keytjzqa','ibskjml','gfmgj','nviiu','ptpjurvdom','swuaratpdg','','sgzrex','s','qbaajveu','zybioq','cql','hloeuaywc','','mpwccck','','zkxf','q','','s','tfaxys','','woiif','','fwhgaic','ljvoipqu','kfrqraop') NOT NULL, `col365` varbinary(170) NOT NULL, `col368` datetime DEFAULT '2013-04-21 16:04:59', `col369` char(241) CHARACTER SET utf8 NOT NULL, `col370` int(11) NOT NULL DEFAULT '1295', `col371` geometry DEFAULT NULL, `col372` multilinestring DEFAULT NULL, `col373` longtext NOT NULL, `col374` multipolygon DEFAULT NULL, `col376` point DEFAULT NULL, `col377` point DEFAULT NULL, `col378` varbinary(31) NOT NULL, `col380` binary(1) NOT NULL, `col381` multipolygon NOT NULL, `col384` multipoint NOT NULL, `col387` binary(1) NOT NULL, `col388` longblob NOT NULL, `col389` point DEFAULT NULL, `col390` multilinestring NOT NULL, `col391` time DEFAULT '21:01:45', `col392` mediumtext NOT NULL, `col393` binary(1) NOT NULL, `col394` multipolygon DEFAULT NULL, `col395` datetime DEFAULT '2014-03-23 02:41:02', `col396` bit(26) DEFAULT NULL, `col397` mediumblob NOT NULL, `col398` linestring DEFAULT NULL, `col399` polygon NOT NULL, `col400` time DEFAULT '13:22:36', `col403` int(10) unsigned zerofill NOT NULL DEFAULT '0000000416', `col404` varbinary(222) NOT NULL, `col405` mediumint(8) unsigned NOT NULL DEFAULT '915', `col407` point DEFAULT NULL, `col408` float unsigned zerofill NOT NULL DEFAULT '000001078.96', `col410` polygon DEFAULT NULL, `col412` geometrycollection DEFAULT NULL, `col414` binary(1) NOT NULL, `col415` mediumblob NOT NULL, `col416` double NOT NULL DEFAULT '590', `col417` double unsigned NOT NULL DEFAULT '1084', `col418` year(4) DEFAULT '2059', `col420` multipoint DEFAULT NULL, `col421` year(4) DEFAULT '2058', `col422` date NOT NULL DEFAULT '2014-02-09', `col423` float NOT NULL DEFAULT '99999', `col424` text NOT NULL, PRIMARY KEY (`col378`(25)), UNIQUE KEY `idx168` (`col390`(173),`col348`(169),`col398`(232),`col351`,`col408`,`col353`,`col418`), UNIQUE KEY `idx173` (`col403`,`col398`(9)), KEY `idx157` (`col358`(102)), KEY `idx158` (`col362`,`col370`,`col381`(137),`col349`(64)) USING BTREE, KEY `idx160` (`col398`(74),`col410`(31),`col370`,`col376`(25),`a5`,`col407`(25),`col374`(187)) USING BTREE, KEY `idx161` (`col372`(162),`col387`,`col371`(201),`col351`,`col397`(122),`col352`,`col353`,`col380`), KEY `idx163` (`col365`(102)), KEY `idx164` (`col408`) USING HASH, KEY `idx165` (`col378`(12)), KEY `idx166` (`col416`,`col381`(157),`col377`(25)), KEY `idx167` (`col370`,`col394`(34),`col369`(74),`col397`(98),`col414`,`col405`), KEY `idx169` (`col373`(4),`col389`(25),`col351`), KEY `idx170` (`col422`,`col395`,`col417`), KEY `idx171` (`col373`(171),`col405`) USING HASH, KEY `idx172` (`col374`(168),`col378`(1),`col368`,`col381`(68),`col387`), KEY `idx174` (`col381`(126),`col405`,`col389`(25),`col351`,`col423`,`col397`(199)), KEY `idx175` (`col416`,`col417`,`col371`(168)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0006` -- DROP TABLE IF EXISTS `t0006`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0006` ( `a6` int(11) DEFAULT NULL, `col425` decimal(58,9) unsigned NOT NULL DEFAULT '302.000000000', `col426` decimal(35,19) unsigned NOT NULL DEFAULT '0.0000000000000000000', `col428` multilinestring NOT NULL, `col429` decimal(59,17) DEFAULT '-99999.00000000000000000', `col431` char(246) CHARACTER SET utf8 NOT NULL, `col432` text NOT NULL, `col433` linestring DEFAULT NULL, `col434` text NOT NULL, `col435` binary(1) NOT NULL, `col436` tinyblob NOT NULL, `col437` time NOT NULL DEFAULT '10:30:36', `col438` char(99) CHARACTER SET utf8 NOT NULL, `col439` decimal(57,16) NOT NULL DEFAULT '-38.0000000000000000', `col440` year(4) NOT NULL DEFAULT '0000', `col442` linestring NOT NULL, `col444` decimal(63,9) unsigned zerofill NOT NULL DEFAULT '000000000000000000000000000000000000000000000000001559.000000000', `col445` multilinestring NOT NULL, `col446` multilinestring NOT NULL, `col447` double DEFAULT '100001', `col448` mediumblob NOT NULL, `col450` varbinary(173) NOT NULL, `col452` polygon DEFAULT NULL, `col453` bit(6) DEFAULT b'0', `col454` tinytext NOT NULL, `col455` varbinary(253) NOT NULL, `col456` decimal(43,14) DEFAULT '-8.35910000000000', `col457` timestamp NOT NULL DEFAULT '2013-09-19 08:15:00', `col458` time DEFAULT '00:06:55', `col459` date NOT NULL DEFAULT '2012-07-31', `col460` date NOT NULL DEFAULT '2012-11-26', `col461` decimal(43,3) DEFAULT '1330.000', `col462` point NOT NULL, `col463` int(11) DEFAULT '0', `col465` decimal(64,11) DEFAULT '-1164.85910000000', `col466` tinytext NOT NULL, `col467` geometrycollection NOT NULL, `col468` time DEFAULT '03:12:46', `col469` datetime DEFAULT '2013-09-16 18:51:27', `col470` geometrycollection NOT NULL, `col471` geometrycollection DEFAULT NULL, `col473` multipolygon NOT NULL, `col476` int(10) unsigned zerofill NOT NULL DEFAULT '0000001665', `col477` blob NOT NULL, `col478` decimal(20,14) NOT NULL DEFAULT '100000.00000000000000', `col479` multipolygon NOT NULL, `col480` tinyblob NOT NULL, `col481` multipolygon NOT NULL, `col482` time NOT NULL DEFAULT '09:41:27', `col483` mediumblob NOT NULL, `col484` set('znkpxshcrz','udg','fsyuwbd','pc','ysjwum','yerhzpavox','goue','uyfaqru','pnihegal','','ppkjdewz','tlvzlk','viatbk','bh','blegixph','xfuqujcpg','bz','tno','mr','chqz','byb','lgr','gd','e','oex','dlezrr','sqvok','a','jkbcg','kma','kofyczkpek','g','kdgfnuye') NOT NULL, `col485` mediumblob NOT NULL, `col486` datetime NOT NULL DEFAULT '2013-08-09 08:09:57', `col487` timestamp NOT NULL DEFAULT '2013-06-10 12:53:56', PRIMARY KEY (`col480`(86),`col459`,`col478`,`col446`(190)), KEY `idx176` (`col471`(122),`col425`,`col426`) USING BTREE, KEY `idx177` (`col480`(181),`col456`,`col468`), KEY `idx178` (`col463`,`col484`,`col442`(235),`col437`) USING HASH, KEY `idx180` (`col432`(92),`col447`,`col453`), KEY `idx181` (`col435`,`col480`(230)), KEY `idx182` (`col458`,`col481`(128),`a6`,`col459`), KEY `idx183` (`col458`,`col471`(208),`col453`,`col465`), KEY `idx184` (`col465`), KEY `idx185` (`col428`(64),`col469`,`col460`,`col473`(189),`col448`(227)) USING BTREE, KEY `idx186` (`col432`(214),`col460`,`col453`), KEY `idx188` (`col487`), KEY `idx189` (`col435`), KEY `idx190` (`col485`(41),`col438`(90),`col429`,`col450`(99),`col466`(95)) USING BTREE, KEY `idx191` (`col431`(149),`col450`(126)), KEY `idx192` (`col429`,`col428`(101),`col439`,`col461`) USING BTREE, KEY `idx193` (`col437`,`col456`,`col484`,`col428`(29)), KEY `idx197` (`col446`(120),`col461`,`col485`(163)), KEY `idx198` (`col425`,`col442`(8),`col487`), KEY `idx199` (`col466`(68),`a6`,`col460`), KEY `idx202` (`col436`(59),`col484`) USING HASH, KEY `idx203` (`col445`(188),`col462`(25),`col479`(218),`col452`(201)), KEY `idx205` (`col480`(173),`col459`,`col478`,`col446`(218)), KEY `idx206` (`col426`,`col483`(16),`col468`,`col438`(61)) USING HASH, KEY `idx207` (`col435`,`col460`,`col459`,`col457`,`col484`), KEY `idx209` (`col469`,`col448`(73),`col468`), KEY `idx211` (`col458`,`col445`(171),`col450`(21),`col467`(130)), KEY `idx212` (`col448`(181),`col431`(39)), KEY `idx215` (`col478`), KEY `idx216` (`col459`,`col467`(115),`col444`,`col439`,`col478`), KEY `idx217` (`col446`(62),`col463`,`col432`(27)), KEY `idx218` (`col466`(16),`col477`(110),`col432`(181),`col461`), KEY `idx219` (`col454`(193),`col433`(233),`col484`,`col457`), KEY `idx220` (`col440`,`col450`(172),`col466`(247)) USING BTREE, KEY `idx221` (`col484`,`col440`,`col454`(116),`col442`(9)), KEY `idx222` (`col446`(211),`col480`(6),`col485`(36),`col452`(82)), KEY `idx223` (`col484`), KEY `idx224` (`col470`(40)) USING HASH, KEY `idx225` (`col450`(74),`col485`(235),`col426`,`col432`(203)), KEY `idx227` (`col425`,`col432`(25),`col465`,`col445`(82)), KEY `idx229` (`col428`(129),`col482`) USING HASH, KEY `idx230` (`col483`(57)) USING HASH, KEY `idx231` (`col437`,`col485`(222),`col482`,`col452`(47),`col479`(116)), FULLTEXT KEY `idx201` (`col454`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=512; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0007` -- DROP TABLE IF EXISTS `t0007`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0007` ( `a7` int(11) DEFAULT NULL, `col488` timestamp NOT NULL DEFAULT '2012-06-23 18:46:41', `col489` multipolygon NOT NULL, `col490` datetime NOT NULL DEFAULT '2013-04-17 03:50:54', `col491` time NOT NULL DEFAULT '03:45:37', `col492` geometrycollection DEFAULT NULL, `col493` mediumint(9) NOT NULL DEFAULT '1254', `col494` multipoint NOT NULL, `col495` date NOT NULL DEFAULT '2012-04-24', `col496` geometry NOT NULL, `col497` multipoint NOT NULL, `col499` time DEFAULT '23:45:47', `col500` mediumint(8) unsigned NOT NULL DEFAULT '311', `col501` set('oqhkqqw','lyc','lhc','emwxsk','jwxwh','vvcn') NOT NULL, `col502` longtext NOT NULL, `col505` geometry NOT NULL, `col506` set('dqym','qvxetq','htxlbghf','t') NOT NULL, `col507` multipoint NOT NULL, `col509` time NOT NULL DEFAULT '18:35:55', `col510` multilinestring DEFAULT NULL, `col511` bigint(20) NOT NULL DEFAULT '0', `col512` tinytext NOT NULL, `col513` tinyint(1) NOT NULL DEFAULT '108', `col514` timestamp NOT NULL DEFAULT '2012-11-09 21:31:46', `col515` time NOT NULL DEFAULT '12:58:16', `col516` multilinestring NOT NULL, `col517` decimal(25,22) unsigned zerofill NOT NULL DEFAULT '000.0000000000000000000000', `col518` datetime NOT NULL DEFAULT '2013-02-04 02:12:18', `col519` geometrycollection NOT NULL, PRIMARY KEY (`col490`,`col518`), UNIQUE KEY `idx244` (`col512`(219),`col494`(243),`col501`,`col499`,`col517`,`col514`,`col491`,`col493`,`a7`), UNIQUE KEY `idx251` (`col510`(145),`col516`(70),`col492`(248),`col500`), KEY `idx232` (`col505`(167),`col490`,`col489`(13)), KEY `idx233` (`col490`,`col495`,`col501`,`col494`(167),`col516`(133),`col518`), KEY `idx234` (`col490`,`col488`,`col511`,`col500`,`col499`,`col496`(129),`col515`,`col492`(3)), KEY `idx235` (`col494`(87),`col510`(145),`col499`,`col489`(233),`col505`(80),`col506`,`col515`,`col513`), KEY `idx236` (`col500`,`col514`,`col490`,`col519`(31),`col489`(151),`col513`,`col509`,`col502`(62),`col499`,`col495`), KEY `idx238` (`col495`,`col491`,`col497`(206),`col500`,`col519`(193),`col492`(242),`col490`,`col516`(188),`col494`(119)) USING BTREE, KEY `idx239` (`col513`,`col493`,`col494`(176),`col509`,`col507`(141),`a7`,`col519`(124),`col495`), KEY `idx240` (`col500`,`col512`(246),`col494`(167),`a7`,`col510`(178),`col511`,`col489`(87),`col502`(200),`col499`) USING HASH, KEY `idx241` (`col511`,`col488`,`col505`(103),`col502`(8),`col510`(190),`col509`,`col495`,`col518`), KEY `idx242` (`col505`(29)), KEY `idx243` (`col497`(101),`col505`(144),`col496`(170)), KEY `idx247` (`col510`(194),`col499`) USING HASH, KEY `idx248` (`col501`,`col489`(98),`col493`,`col506`,`col500`,`col519`(138),`col491`,`col495`), KEY `idx249` (`col500`,`col491`,`col513`,`a7`,`col506`,`col518`,`col516`(210),`col488`), KEY `idx250` (`col494`(246),`a7`,`col515`,`col492`(157),`col513`,`col489`(40),`col493`,`col517`), KEY `idx252` (`col490`,`col518`), KEY `idx253` (`col496`(204),`col516`(115),`col500`,`col511`,`col492`(51),`col493`,`col509`,`col501`,`col495`), KEY `idx254` (`col491`,`col496`(31),`col511`,`col506`), KEY `idx255` (`col509`,`col500`,`col502`(138),`col495`), KEY `idx256` (`col491`,`col514`,`col492`(163),`col502`(247),`col496`(115),`col490`,`col511`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0008` -- DROP TABLE IF EXISTS `t0008`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0008` ( `a8` int(10) unsigned DEFAULT NULL, `col520` mediumint(9) DEFAULT '-1427', `col521` polygon NOT NULL, `col523` decimal(26,10) DEFAULT '167.0000000000', `col524` timestamp NOT NULL DEFAULT '2012-10-28 20:56:32', `col525` varbinary(56) NOT NULL, `col527` geometry NOT NULL, `col528` date NOT NULL DEFAULT '2013-06-01', `col529` mediumint(9) DEFAULT '100000', `col530` date NOT NULL DEFAULT '2014-01-14', `col531` char(46) CHARACTER SET utf8 NOT NULL, `col532` linestring NOT NULL, `col533` geometrycollection DEFAULT NULL, `col534` geometrycollection NOT NULL, `col535` set('','hyg','p','opjrplcd','','eudsizofs','dhghca','nmfdnfo','tnhv','jm','tuxahoj','hgsobvud','ddjmt','jscxlvcm','','vsxrfxq','uhpboatz','opcti','jckttdcrrp','ybrpzvoufl','uibcwzkfdx','u','pwhzyp','onf','w','qzcaxhhqm','grjsaqqa','bdje','','qsuyzrez','gtkinzx','oqnn','r','fjq','a','rohilkd','jrll','uggiqlihxw','fyhojz','zeqh','uwau','siuwpjfmu','vtvk','ujex','lykg','xakmc','i','biwgjxithg','edpeddjkz','ugpkhnvznv','r','yvxfezvc','hxme','qnhqazslrn') NOT NULL, `col536` date DEFAULT '2014-03-21', `col537` tinyint(1) DEFAULT '0', `col538` multipoint NOT NULL, `col540` timestamp NOT NULL DEFAULT '2013-06-11 20:14:56', `col541` longtext NOT NULL, `col542` float NOT NULL DEFAULT '-15637.8', `col543` multipolygon DEFAULT NULL, `col544` mediumblob NOT NULL, `col545` binary(1) NOT NULL, `col546` mediumblob NOT NULL, `col547` polygon DEFAULT NULL, `col548` multilinestring NOT NULL, `col549` geometrycollection NOT NULL, PRIMARY KEY (`col542`,`col531`(12),`col525`(31),`col544`(81)), UNIQUE KEY `idx257` (`col534`(166),`col536`,`col546`(205),`col533`(66),`col541`(161)), UNIQUE KEY `idx274` (`col524`,`col520`,`col527`(182),`col549`(118),`col542`,`col547`(19),`col541`(61),`col535`) USING HASH, UNIQUE KEY `idx277` (`col530`,`col548`(188),`col546`(151),`col533`(56),`col531`(11),`col542`,`col528`), UNIQUE KEY `idx278` (`col547`(7),`col541`(214),`col523`,`col533`(255),`col525`(7),`col542`) USING HASH, KEY `idx258` (`col544`(202),`col542`,`col548`(30),`col534`(86),`col530`,`col520`,`col525`(30),`a8`), KEY `idx259` (`col547`(46),`col536`,`col520`,`col534`(60),`col537`,`col527`(132)), KEY `idx260` (`col535`), KEY `idx262` (`col540`), KEY `idx264` (`col546`(12),`col525`(27)), KEY `idx265` (`col543`(147)), KEY `idx266` (`col545`,`col538`(135),`col543`(4),`col529`,`col549`(190)), KEY `idx267` (`col545`,`col535`,`col523`,`col528`,`col544`(101),`col537`,`col525`(17),`col549`(110)) USING HASH, KEY `idx268` (`col534`(171),`col532`(90)), KEY `idx270` (`col521`(191),`col527`(207)) USING BTREE, KEY `idx271` (`col536`,`col540`) USING BTREE, KEY `idx272` (`col521`(206),`col527`(205),`col549`(214),`col530`,`col537`,`col520`), KEY `idx273` (`col532`(93),`col528`,`col530`,`col524`,`col547`(81)), KEY `idx276` (`col536`,`col523`,`col533`(114),`col534`(36),`col524`,`col544`(175)), KEY `idx279` (`col535`,`col538`(152),`a8`,`col541`(192),`col531`(40),`col548`(3)), KEY `idx280` (`col531`(31),`col535`,`col544`(178),`col537`,`col548`(187)), KEY `idx281` (`col541`(109),`col528`,`a8`,`col531`(19),`col535`) USING HASH, KEY `idx282` (`col549`(98),`col523`), KEY `idx283` (`col535`,`a8`,`col533`(224)), KEY `idx284` (`col524`,`col525`(5),`col523`,`col545`,`col538`(249),`col547`(216),`col544`(96)) USING BTREE, KEY `idx285` (`col542`,`col529`,`col534`(244),`col524`,`col543`(219),`col540`,`col541`(33)), KEY `idx286` (`col527`(222),`col544`(128),`col545`,`col549`(3),`col543`(233),`col541`(131)), KEY `idx287` (`col520`,`col538`(184),`col523`,`col535`,`col540`,`col529`,`col531`(13),`col548`(167)), KEY `idx288` (`col529`,`col535`,`col543`(146),`col523`,`col532`(43),`col530`) USING BTREE, KEY `idx289` (`col533`(142),`col537`,`col549`(145),`col540`,`col546`(162),`col521`(120),`col525`(44),`col547`(167)), KEY `idx290` (`col538`(190),`col546`(184),`col548`(125),`col528`,`col524`), KEY `idx291` (`col520`,`col535`,`col545`,`col537`) USING HASH, KEY `idx292` (`a8`,`col543`(116),`col547`(172),`col545`), KEY `idx293` (`col521`(200)), KEY `idx295` (`col527`(208)), KEY `idx296` (`col520`,`col524`,`col542`,`col529`,`col523`), KEY `idx297` (`col532`(133),`col535`,`col529`,`col520`,`col538`(95),`col523`,`col546`(61),`col530`,`col527`(145)) USING HASH, KEY `idx298` (`col546`(164)), KEY `idx299` (`col538`(47),`col533`(19)), KEY `idx300` (`col520`,`col548`(172),`col536`) USING BTREE, KEY `idx301` (`col527`(34),`col544`(50),`col536`), KEY `idx303` (`col538`(16),`a8`,`col548`(214),`col544`(11)) USING BTREE, KEY `idx304` (`col538`(168),`col521`(47),`col547`(233),`col528`,`col543`(109),`col525`(13),`col533`(90)), KEY `idx305` (`col532`(246),`col531`(8),`col536`,`col534`(78)), KEY `idx306` (`col533`(254),`col544`(62),`col548`(56)), KEY `idx308` (`col527`(135),`col540`,`col533`(200),`col538`(26),`col534`(154),`col546`(197)), KEY `idx309` (`a8`,`col547`(137),`col546`(84),`col549`(8),`col534`(206)), KEY `idx310` (`col542`,`col531`(16),`col525`(50),`col544`(188)), KEY `idx311` (`col527`(247),`col544`(113),`col547`(189),`col546`(245),`col532`(67),`col520`), KEY `idx312` (`col529`,`a8`,`col547`(255),`col543`(158),`col528`) USING HASH, KEY `idx313` (`col532`(212),`col540`,`col525`(12)) USING HASH, KEY `idx314` (`col530`,`col546`(208),`col531`(4),`col529`,`col541`(242),`col521`(202),`col548`(147)), KEY `idx317` (`col533`(68),`col536`), KEY `idx318` (`col549`(129),`col523`), KEY `idx319` (`col549`(97),`col523`) USING BTREE, KEY `idx321` (`col543`(200),`col532`(28),`a8`,`col527`(63),`col536`,`col520`,`col528`,`col523`), KEY `idx322` (`col543`(240),`col527`(57),`col521`(255),`a8`,`col548`(237),`col536`,`col544`(202)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0009` -- DROP TABLE IF EXISTS `t0009`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0009` ( `a9` int(10) unsigned DEFAULT NULL, `col550` polygon DEFAULT NULL, `col551` geometry NOT NULL, `col552` mediumblob NOT NULL, `col553` multipolygon NOT NULL, `col554` enum('','xmusrg','pl','wvzr','e','fpoykmzpsl','lfafzodg','awwppl','slnuyzr','pbwaobgjt','xuezhi','bqtnreifmz','q','e','niq','dp','takiecc','xxykugxx','rrscqj','line','','twcyhou') NOT NULL, `col556` decimal(11,0) unsigned DEFAULT '511', `col557` geometrycollection DEFAULT NULL, `col558` multilinestring DEFAULT NULL, `col560` multipolygon NOT NULL, `col561` datetime DEFAULT '2014-02-19 00:13:10', `col563` polygon NOT NULL, `col565` mediumblob NOT NULL, `col567` geometrycollection NOT NULL, `col569` multilinestring DEFAULT NULL, `col570` blob NOT NULL, `col571` mediumtext NOT NULL, `col572` set('sijcrt','x','mbzjfhdv','rgmnm','h','xkplyfcdat','lep','hslcevj','zdpp','cqswfjwnnf','unpwkvcok','tpxiyjwlu','pcsbiveopy','axmjpkg','pug','pfgvtkpwu','cfbkxcehi','vjsmladv','qzhvgqhtps','pwnt','tbdr','z','','','qgrqoqufw','ndh','egkyaboywm','qihmgs','ord','urn','nzttekp','krepbmng','qrm','odca','ls','dqav','jllylqtwno','khzkjq','wnipdx','qwht','tbehvtm','yuygvumyd','hqxoboi') NOT NULL, `col575` point DEFAULT NULL, `col576` timestamp NOT NULL DEFAULT '2012-08-03 08:08:59', `col577` year(4) NOT NULL DEFAULT '2038', `col578` date DEFAULT '2013-10-26', `col579` geometrycollection DEFAULT NULL, `col580` timestamp NOT NULL DEFAULT '2012-05-20 02:19:31', `col582` decimal(33,24) unsigned DEFAULT '1674.000000000000000000000000', `col583` multipolygon NOT NULL, `col584` double DEFAULT '1116.2776', `col585` decimal(65,6) unsigned NOT NULL DEFAULT '1389.000000', `col587` blob NOT NULL, `col588` decimal(16,7) unsigned DEFAULT '0.0000000', `col589` multipoint NOT NULL, `col590` multilinestring DEFAULT NULL, `col591` set('iwupscxl','hhthjrgz','hqgesi','hkzgxry','resfjuxpy','','nanwbesw','a','qwtiviq','jefxlhqhqa','oktluqsana','rtm','x','y','mv','vbqmqo','','rvji','ztaagtz','ckbzruatx','zrn','quqdwjy','dvlqr','g','acwc','tc','yrvkefbs','xrc','bipjybi','seiqsdvw','lzhe','kcu','ukihpwd','ai','nyhwmdf','xslqrwmgo','pcwdfyvf','nijkut','jh','','oasuzfbpc','wzfinplbfn','','xpvrrsi','g','evpq','lcmualgi','dmamola','jdmsx','ilgdlfchig') NOT NULL, `col592` timestamp NOT NULL DEFAULT '2012-10-01 05:25:47', `col593` decimal(62,25) unsigned NOT NULL DEFAULT '0.0000000000000000000000000', `col594` decimal(45,5) NOT NULL DEFAULT '-100001.00000', `col595` datetime NOT NULL DEFAULT '2013-09-10 06:07:10', `col596` timestamp NOT NULL DEFAULT '2012-08-09 21:44:22', `col597` time DEFAULT '14:49:22', `col598` varbinary(127) NOT NULL, `col599` timestamp NOT NULL DEFAULT '2014-01-07 17:00:47', `col601` binary(1) NOT NULL, `col605` multilinestring DEFAULT NULL, `col606` binary(1) NOT NULL, `col607` binary(1) NOT NULL, `col608` char(200) CHARACTER SET utf8 NOT NULL, `col609` tinyint(4) NOT NULL DEFAULT '0', `col610` geometrycollection DEFAULT NULL, `col611` time NOT NULL DEFAULT '05:13:56', `col612` point DEFAULT NULL, `col614` bit(10) NOT NULL DEFAULT b'0', `col616` multipolygon NOT NULL, `col617` date DEFAULT '2013-04-21', `col618` int(10) unsigned NOT NULL DEFAULT '1394', `col619` bigint(20) unsigned DEFAULT '0', `col620` enum('ahhsg','dwav','tnndnbaaoz','h','zmrisyy','gwhevrrqo','wwwswsxb','gxckkp','lohsr','qtctfpbvxr','mbjdtig','yf','nrywdysb','k','lpwqqr','vhvtnef','wrmicm','yvix','mhhmn','','shjywnp','lry','magitxckz','','bwp','','elwlbuev','x','mstkpnayvb','dvoadnenyf','','ro','','iy','c','','sjh','evx','dxifvxaf','fyjyapv','qbhip','yrnquh','t','pucywmgo','koi','a') NOT NULL, `col621` time NOT NULL DEFAULT '14:10:45', `col624` double unsigned zerofill NOT NULL DEFAULT '0000000000000000000649', `col626` binary(1) NOT NULL, `col627` timestamp NOT NULL DEFAULT '2012-05-18 11:48:10', `col628` mediumblob NOT NULL, `col629` point NOT NULL, `col630` varbinary(210) NOT NULL, `col632` decimal(18,10) NOT NULL DEFAULT '220.0000000000', `col634` tinytext NOT NULL, `col635` multilinestring NOT NULL, `col637` float unsigned DEFAULT '0.000000839219', `col639` timestamp NOT NULL DEFAULT '2012-08-23 01:45:54', `col640` int(10) unsigned DEFAULT '100000', `col641` date NOT NULL DEFAULT '2013-11-06', `col642` bigint(20) DEFAULT '1293', `col643` decimal(30,14) unsigned DEFAULT '0.00000000000000', `col644` enum('hkq','etdrie','ut','p','ue','wddohecy','g','porppce','pmzxv','rkwkyitbo','jkyt','krybggdbmu','eazpm','xeqch','rqfxtk','jgubhucvx','rlkjmowh','ya','cdl','owtvw','bm','','vsgkgjyznk','f','','bwogshcyp','uqdiiuxax','ujhydniv','bagohlf','jz','hclmzg','mjd','poobjzj','qfcvsmpmlu','iarxcz','umjnao','nakxxeb','bwje','tl','uqqmk','fb','','ypqdh','stdwym','thgaj','vfzqhh','hfkvlhcj','d','ocvxdmvs') NOT NULL, `col645` varchar(54) NOT NULL DEFAULT 'nfoennwiypblcpxphomdvgylngwbohbjrbiusjbdslho', `col646` time NOT NULL DEFAULT '21:41:30', `col647` geometrycollection NOT NULL, PRIMARY KEY (`col639`,`col585`,`col624`), UNIQUE KEY `idx349` (`a9`), UNIQUE KEY `idx334` (`col594`,`col605`(56),`col560`(7),`col609`,`col567`(133)), UNIQUE KEY `idx343` (`col596`,`col591`,`col611`,`col590`(112),`col594`,`col556`,`col609`) USING BTREE, UNIQUE KEY `idx353` (`col620`,`col599`,`col605`(55),`col629`(25),`a9`), UNIQUE KEY `idx359` (`col557`(246)), UNIQUE KEY `idx368` (`col607`,`col609`,`col558`(113),`col560`(130)) USING HASH, UNIQUE KEY `idx376` (`a9`,`col580`,`col642`,`col584`,`col552`(255),`col632`) USING HASH, KEY `idx323` (`col561`,`col578`,`col560`(48)), KEY `idx324` (`col617`,`col594`), KEY `idx325` (`col589`(55),`col551`(151),`col597`,`col608`(122)) USING BTREE, KEY `idx326` (`col572`,`col607`) USING HASH, KEY `idx328` (`col637`,`col585`,`col640`,`col645`(33),`col618`,`col575`(25)), KEY `idx329` (`col643`,`col553`(43),`col614`), KEY `idx331` (`col582`,`col599`,`col611`), KEY `idx332` (`col558`(88),`col560`(81),`col618`), KEY `idx335` (`col608`(93),`col627`) USING BTREE, KEY `idx337` (`col628`(160),`col645`(2),`col637`,`col569`(169)), KEY `idx338` (`col641`,`a9`,`col557`(121),`col598`(21)), KEY `idx339` (`col637`,`col619`), KEY `idx340` (`col594`) USING BTREE, KEY `idx342` (`col620`,`col626`,`col572`,`col621`), KEY `idx344` (`col597`,`col626`), KEY `idx345` (`col639`,`col585`,`col624`), KEY `idx346` (`col550`(52)), KEY `idx347` (`col642`,`col612`(25),`col576`,`col621`,`col614`) USING HASH, KEY `idx348` (`col624`,`col641`,`col639`) USING BTREE, KEY `idx350` (`col643`,`col628`(189),`col619`,`col569`(66),`col621`,`col585`), KEY `idx351` (`col635`(38)), KEY `idx354` (`col645`(37),`col639`,`col596`,`col585`,`col607`), KEY `idx356` (`col601`,`col646`) USING HASH, KEY `idx357` (`col642`), KEY `idx358` (`col593`,`col583`(239),`col557`(33),`col550`(163),`col554`) USING HASH, KEY `idx360` (`col593`,`col598`(30)), KEY `idx361` (`col606`,`col592`,`col619`,`col550`(230),`col601`,`col641`,`col621`), KEY `idx362` (`col646`,`col582`,`col647`(129),`col610`(184),`col596`,`col557`(220),`col598`(113)), KEY `idx363` (`col639`,`col628`(95),`col569`(63),`col646`,`col601`) USING HASH, KEY `idx364` (`col575`(25),`col646`,`col609`,`col617`), KEY `idx369` (`col575`(25)), KEY `idx370` (`col567`(3)) USING HASH, KEY `idx371` (`col594`,`col558`(182),`col645`(23)), KEY `idx373` (`col628`(30),`col597`,`col645`(44),`col616`(186),`col647`(158),`col627`,`col585`) USING BTREE, KEY `idx375` (`col626`,`col635`(82),`col557`(180),`col556`), KEY `idx377` (`col563`(120),`col620`,`col552`(86),`col644`,`col592`,`col605`(179)), KEY `idx378` (`col611`,`col598`(43)), KEY `idx380` (`col552`(58),`col624`), KEY `idx381` (`col598`(93),`col570`(20),`col556`) USING HASH, KEY `idx382` (`col616`(164)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0010` -- DROP TABLE IF EXISTS `t0010`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0010` ( `a10` int(10) unsigned DEFAULT NULL, `col648` date NOT NULL DEFAULT '2012-10-18', `col649` multipoint DEFAULT NULL, `col650` mediumint(9) DEFAULT '-100001', `col651` mediumint(8) unsigned DEFAULT '100001', `col653` enum('nraycmi','','txceqpto','ogmgu','pztr','wpiildvnqf','jonadwrl','cmykpd','yfycvsgi','af','','myvpq','zrlrzpjrn','','jkqaecfq','ougklvdp','gs','mxi','smltrd','','f','kdieupg','mzqsflkr','','sguwat','','rezupgvic','kktmkmjsx','kloazq','rxnijnlhw','bqchhc','pq','uyuhu','nigbzozb','hdsgyooz','','waquidn','jyvrrfkwm','rdvbmrz','akltmseeem','xltnuvaeq','gjs','','wjgnjtbdhn','hxdoz','z','','xz','uclqsw','','ubenpryeed','lwxekmgob','rbzjcb','rvep','mmnrlvbd','uxutwgoeag','wrecftr','zodjsxi') NOT NULL, `col654` mediumblob NOT NULL, `col656` point DEFAULT NULL, `col657` timestamp NOT NULL DEFAULT '2014-02-10 17:58:03', `col658` int(10) unsigned zerofill DEFAULT '0000001207', `col659` time NOT NULL DEFAULT '03:04:58', `col660` mediumint(8) unsigned NOT NULL DEFAULT '254', `col661` double DEFAULT '1355', `col662` polygon NOT NULL, `col663` tinytext NOT NULL, `col664` int(11) DEFAULT '99999', `col665` char(18) CHARACTER SET utf8 NOT NULL, `col668` datetime NOT NULL DEFAULT '2013-03-11 16:20:01', `col670` polygon DEFAULT NULL, `col671` double unsigned DEFAULT '9.898803e-77', `col672` time NOT NULL DEFAULT '16:45:41', `col673` datetime DEFAULT '2013-03-08 05:24:28', `col674` int(10) unsigned NOT NULL DEFAULT '511', `col675` geometry NOT NULL, `col676` tinyblob NOT NULL, `col677` date DEFAULT '2014-03-02', `col678` linestring NOT NULL, `col679` datetime NOT NULL DEFAULT '2012-05-01 02:08:00', `col680` multipoint NOT NULL, `col681` bit(43) DEFAULT b'11000011010011111', `col682` tinyblob NOT NULL, `col683` multipolygon NOT NULL, `col685` point DEFAULT NULL, PRIMARY KEY (`col676`(238),`col672`,`col653`), UNIQUE KEY `idx388` (`col659`,`col658`,`col660`) USING HASH, UNIQUE KEY `idx432` (`col671`), UNIQUE KEY `idx408` (`col654`(254),`col657`,`col685`(25)), UNIQUE KEY `idx422` (`col676`(202),`col658`,`col648`), UNIQUE KEY `idx428` (`col670`(46),`col649`(121),`a10`) USING HASH, KEY `idx383` (`col651`,`col678`(23),`col653`,`col683`(7)), KEY `idx384` (`col657`,`col685`(25),`col671`,`col654`(144)), KEY `idx385` (`col668`), KEY `idx386` (`col672`,`col675`(176),`col677`,`col656`(25)), KEY `idx387` (`col662`(94),`col677`,`col650`), KEY `idx390` (`col665`(6)) USING BTREE, KEY `idx391` (`col653`,`col649`(16)), KEY `idx392` (`col678`(135),`col663`(90),`col656`(25)) USING BTREE, KEY `idx394` (`col660`) USING BTREE, KEY `idx395` (`col648`,`col683`(243),`col670`(217)), KEY `idx396` (`col676`(196)), KEY `idx397` (`col657`,`col649`(191)), KEY `idx398` (`col679`,`col653`,`col677`,`col675`(167)), KEY `idx399` (`col659`,`col660`,`col674`,`col680`(253)), KEY `idx400` (`col651`,`col680`(74),`col659`,`col650`), KEY `idx401` (`col648`), KEY `idx402` (`col680`(58),`col673`), KEY `idx403` (`col654`(149),`a10`,`col670`(138),`col683`(168)), KEY `idx404` (`col662`(116),`col659`,`col651`), KEY `idx405` (`col648`,`col665`(13)), KEY `idx406` (`col659`) USING BTREE, KEY `idx409` (`col656`(25),`col672`,`col668`,`a10`) USING HASH, KEY `idx410` (`col685`(25),`col676`(169),`col648`,`col663`(55)), KEY `idx411` (`col650`), KEY `idx412` (`col670`(16)) USING HASH, KEY `idx413` (`col665`(6),`col683`(109)), KEY `idx414` (`col662`(206)), KEY `idx415` (`col670`(166),`col662`(86),`col673`) USING BTREE, KEY `idx416` (`col683`(255),`col671`), KEY `idx417` (`col659`), KEY `idx418` (`col650`), KEY `idx419` (`col676`(205),`a10`,`col683`(52),`col654`(24)), KEY `idx420` (`col678`(114),`col681`), KEY `idx421` (`col653`), KEY `idx424` (`col683`(146),`col658`) USING HASH, KEY `idx425` (`col674`,`col677`,`col672`), KEY `idx426` (`col672`,`col680`(109),`col676`(85)), KEY `idx427` (`col685`(25),`col658`) USING BTREE, KEY `idx429` (`col664`) USING BTREE, KEY `idx430` (`col659`,`col682`(37)), KEY `idx431` (`col654`(171),`col675`(73),`col658`), KEY `idx433` (`col658`,`col664`), KEY `idx434` (`col660`,`col656`(25),`col674`,`col650`), KEY `idx435` (`col681`), KEY `idx436` (`col676`(118),`col672`,`col653`), KEY `idx437` (`col660`) USING HASH, KEY `idx438` (`col680`(21),`col653`,`col673`), KEY `idx439` (`col659`), KEY `idx440` (`col677`,`col672`), KEY `idx441` (`col683`(107),`col659`,`col672`,`col653`), KEY `idx442` (`col668`), KEY `idx443` (`col675`(110),`col650`,`col678`(202)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0011` -- DROP TABLE IF EXISTS `t0011`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0011` ( `a11` int(10) unsigned DEFAULT NULL, `col687` enum('eredm','zysccdxbo','kmhwjyhy','ooiohstwcw','wvtwsob','no','ata','mprqtwkuq','owjellsn','njovobce','rw','khqs','','lalx','savtmenah','eitzppjs','','ckjdlq','j','lbkxoqa','bpdi','dscoyacpwa','xcj','yaak','gncjclpwgo','iaakektyr','vutulfsz','alrsw','ptjltr','rjjmkuure','zveof','cbqnk','ez','occ','ab','amdvoldq','q','v','hdqmnx','iwjaazh','sf','kdcqsxx','gtxks','nnvmlffwlx','kwczxo','jlmovfoi','uigvl','j','thfjpmmya','jcx','x','mp','kpe','qcp','u','','b','uyb','d','','avwcml','w','nk','tuu','lejg') NOT NULL, `col688` date NOT NULL DEFAULT '2014-02-24', `col689` decimal(47,20) NOT NULL DEFAULT '473.00000000000000000000', `col690` geometry NOT NULL, `col691` datetime DEFAULT '2012-04-26 01:21:13', `col692` double unsigned NOT NULL DEFAULT '0', `col693` longtext NOT NULL, `col694` int(10) unsigned NOT NULL DEFAULT '350', `col695` enum('lb','ympmqb','ad','ylhhfsd','zyelkfire','bi','e','cihl','zikenyvlyx','hitcrqs','qtemaq','ot','nlzong','wzc','rbhukqzui','xju') NOT NULL, `col696` date DEFAULT '2012-09-03', `col697` multilinestring DEFAULT NULL, `col698` binary(1) NOT NULL, `col700` double DEFAULT '-84.4441', `col701` binary(1) NOT NULL, `col702` bigint(20) NOT NULL DEFAULT '-1664', `col703` time DEFAULT '17:31:12', `col705` longtext NOT NULL, `col706` linestring DEFAULT NULL, `col708` time DEFAULT '17:20:54', `col709` mediumint(8) unsigned DEFAULT '1485', `col710` multipoint NOT NULL, `col715` multipoint DEFAULT NULL, `col717` enum('rhbmxth','jnzxgblza','mlipwrx','xllgxdh') NOT NULL, `col719` timestamp NOT NULL DEFAULT '2013-09-01 18:16:30', `col720` bit(35) NOT NULL DEFAULT b'110010110', `col721` point DEFAULT NULL, `col722` float NOT NULL DEFAULT '-8.34178e-40', `col723` geometry NOT NULL, `col724` point NOT NULL, `col725` datetime DEFAULT '2012-09-17 22:47:55', `col726` linestring DEFAULT NULL, `col728` mediumtext NOT NULL, `col731` mediumtext NOT NULL, `col732` date NOT NULL DEFAULT '2013-08-16', `col733` polygon DEFAULT NULL, `col735` mediumint(8) unsigned DEFAULT '1068', `col736` varchar(225) NOT NULL DEFAULT 'qgibultftfdpflydsxcnbgjh', `col739` binary(1) NOT NULL, `col740` date NOT NULL DEFAULT '2012-08-08', PRIMARY KEY (`col692`) USING BTREE, UNIQUE KEY `idx448` (`col687`), UNIQUE KEY `idx469` (`col693`(109)), KEY `idx444` (`col726`(166)) USING BTREE, KEY `idx445` (`col709`), KEY `idx446` (`col736`(114)), KEY `idx447` (`col687`), KEY `idx449` (`col719`), KEY `idx450` (`col736`(162)), KEY `idx452` (`col708`), KEY `idx453` (`col721`(25)) USING BTREE, KEY `idx454` (`col709`), KEY `idx455` (`col687`), KEY `idx456` (`col693`(75)) USING BTREE, KEY `idx457` (`col732`), KEY `idx458` (`col721`(25)) USING BTREE, KEY `idx460` (`col731`(32)), KEY `idx461` (`col692`) USING BTREE, KEY `idx462` (`col695`), KEY `idx464` (`col717`), KEY `idx465` (`col719`), KEY `idx466` (`col696`), KEY `idx467` (`col700`), KEY `idx468` (`col700`), KEY `idx470` (`col715`(33)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=512; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0012` -- DROP TABLE IF EXISTS `t0012`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0012` ( `a12` int(11) NOT NULL, `col741` date NOT NULL DEFAULT '2013-09-05', `col745` geometrycollection NOT NULL, `col746` time DEFAULT '08:40:10', `col747` point DEFAULT NULL, `col750` multilinestring DEFAULT NULL, `col751` linestring NOT NULL, `col752` linestring NOT NULL, `col753` binary(1) NOT NULL, `col754` int(11) DEFAULT '-874', PRIMARY KEY (`a12`), UNIQUE KEY `idx488` (`col741`), UNIQUE KEY `idx495` (`col741`), UNIQUE KEY `idx529` (`a12`), UNIQUE KEY `idx471` (`col745`(181)) USING BTREE, UNIQUE KEY `idx489` (`col745`(194)) USING HASH, UNIQUE KEY `idx497` (`col752`(36)) USING BTREE, UNIQUE KEY `idx478` (`col746`), UNIQUE KEY `idx512` (`col746`) USING HASH, UNIQUE KEY `idx473` (`col747`(25)) USING HASH, KEY `idx472` (`a12`), KEY `idx474` (`col754`), KEY `idx475` (`a12`), KEY `idx476` (`col741`), KEY `idx477` (`col754`) USING BTREE, KEY `idx479` (`col741`), KEY `idx480` (`col752`(126)), KEY `idx481` (`a12`) USING BTREE, KEY `idx483` (`col753`), KEY `idx485` (`col746`) USING BTREE, KEY `idx486` (`a12`) USING HASH, KEY `idx490` (`col746`), KEY `idx491` (`col753`), KEY `idx493` (`col741`), KEY `idx494` (`col753`) USING HASH, KEY `idx496` (`col746`), KEY `idx498` (`col750`(127)), KEY `idx499` (`col753`), KEY `idx500` (`col746`), KEY `idx501` (`a12`), KEY `idx502` (`col752`(200)) USING HASH, KEY `idx504` (`col746`), KEY `idx505` (`col750`(56)) USING BTREE, KEY `idx506` (`col747`(25)) USING HASH, KEY `idx507` (`col746`), KEY `idx508` (`col752`(227)), KEY `idx510` (`a12`) USING HASH, KEY `idx511` (`col751`(7)), KEY `idx513` (`col754`), KEY `idx514` (`col751`(77)), KEY `idx515` (`col746`), KEY `idx516` (`col753`), KEY `idx517` (`col753`), KEY `idx518` (`col754`), KEY `idx521` (`col751`(63)), KEY `idx523` (`col746`) USING HASH, KEY `idx524` (`col745`(105)), KEY `idx525` (`col741`) USING HASH, KEY `idx526` (`col750`(219)) USING BTREE, KEY `idx527` (`col745`(172)), KEY `idx528` (`col752`(14)), KEY `idx530` (`col745`(247)) USING BTREE, KEY `idx531` (`col746`), KEY `idx532` (`col752`(160)), KEY `idx533` (`col751`(188)), KEY `idx536` (`col745`(199)) USING HASH, KEY `idx537` (`col746`), KEY `idx539` (`col747`(25)), KEY `idx540` (`col741`), KEY `idx541` (`a12`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0013` -- DROP TABLE IF EXISTS `t0013`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0013` ( `a13` int(10) unsigned NOT NULL, `col756` multipoint NOT NULL, `col757` linestring NOT NULL, `col758` multipoint DEFAULT NULL, `col759` geometrycollection NOT NULL, `col760` geometrycollection DEFAULT NULL, `col762` date NOT NULL DEFAULT '2014-04-07', `col763` geometrycollection DEFAULT NULL, `col764` timestamp NOT NULL DEFAULT '2012-09-23 19:20:25', `col765` multipoint DEFAULT NULL, `col766` date DEFAULT '2013-11-07', `col767` polygon NOT NULL, `col768` date DEFAULT '2012-05-21', `col769` double unsigned DEFAULT '1.2118637e86', `col770` mediumblob NOT NULL, `col771` polygon DEFAULT NULL, `col772` polygon DEFAULT NULL, `col773` multilinestring NOT NULL, `col774` decimal(50,24) unsigned DEFAULT '1401.906100000000000000000000', `col775` time NOT NULL DEFAULT '06:02:02', `col776` polygon DEFAULT NULL, `col777` polygon DEFAULT NULL, `col778` mediumblob NOT NULL, `col780` tinyblob NOT NULL, `col781` multilinestring NOT NULL, `col782` geometry NOT NULL, `col783` polygon NOT NULL, `col784` point DEFAULT NULL, `col785` text NOT NULL, `col786` varbinary(103) NOT NULL, `col787` mediumblob NOT NULL, `col788` polygon DEFAULT NULL, `col789` date DEFAULT '2013-02-15', `col790` geometrycollection DEFAULT NULL, `col792` binary(1) NOT NULL, `col793` year(4) DEFAULT '0000', `col794` multipolygon NOT NULL, `col795` point DEFAULT NULL, `col796` multipolygon DEFAULT NULL, `col797` multilinestring DEFAULT NULL, `col798` double NOT NULL DEFAULT '-7.72764e45', `col799` binary(1) NOT NULL, `col801` geometrycollection NOT NULL, `col802` timestamp NOT NULL DEFAULT '2013-10-25 19:28:56', `col803` multipolygon NOT NULL, `col804` datetime NOT NULL DEFAULT '2013-07-01 10:32:08', `col805` date NOT NULL DEFAULT '2014-02-01', `col807` int(11) NOT NULL DEFAULT '-461', `col810` longblob NOT NULL, `col812` timestamp NOT NULL DEFAULT '2013-09-23 14:32:18', `col813` char(176) CHARACTER SET utf8 NOT NULL, `col815` multilinestring DEFAULT NULL, `col816` timestamp NOT NULL DEFAULT '2012-11-09 13:31:44', `col817` varchar(246) CHARACTER SET utf8 NOT NULL DEFAULT 'tyoixxqyblstuashcnrngnpzejabnszbznnblgbey', `col818` point DEFAULT NULL, `col819` varbinary(61) NOT NULL, `col821` multipoint NOT NULL, `col822` geometry DEFAULT NULL, `col823` linestring DEFAULT NULL, `col824` multipoint NOT NULL, `col826` text NOT NULL, `col827` datetime DEFAULT '2012-05-21 20:00:15', `col828` linestring NOT NULL, `col829` point NOT NULL, `col830` longtext NOT NULL, `col831` varchar(212) NOT NULL DEFAULT 'njlxuxwtkoxwdeyvzogriyfavpsbkoizuqfwhrwfocjplmqljqdgaunnycqkucwpahwkabnnqjuvfohwvgjhtnmthwocjnweomjoembotvzpoyxoikvazuhoqrldunerkiticivnzilqjbswrnfkvxvzklyrubeywaamfyqigxvwieltiwcsapvtce', `col832` linestring NOT NULL, `col833` varchar(191) CHARACTER SET utf8 NOT NULL DEFAULT 'kehkgrfdsisnsxiqenjwltmdcchzpflclhkbwkktdokmbswxkarduvtbzjaquqjjxgyxgfjbzvnijttgyzvpkbgkouclikxytrvwzyduzbupiiqpcvbfrdehgvejwsnvdlyqretfrvscaronuirmsigbrovkxjzjcctuvwlhpscaxtaxsjt', `col836` double NOT NULL DEFAULT '54.2142', `col837` decimal(35,15) NOT NULL DEFAULT '704.414400000000000', `col840` timestamp NOT NULL DEFAULT '2012-08-31 22:12:40', `col841` date NOT NULL DEFAULT '2013-10-15', `col842` decimal(39,0) unsigned DEFAULT '100001', `col844` geometrycollection DEFAULT NULL, `col846` text NOT NULL, `col847` datetime DEFAULT '2013-08-16 04:10:12', `col849` datetime DEFAULT '2013-12-08 20:59:35', `col850` mediumblob NOT NULL, `col852` multipoint NOT NULL, `col853` char(79) NOT NULL DEFAULT 'ptkbvncizwwjmdmruqgikpfedieofnfuo', `col854` date NOT NULL DEFAULT '2012-06-05', `col855` timestamp NOT NULL DEFAULT '2013-05-15 20:12:59', `col856` decimal(51,30) NOT NULL DEFAULT '100001.000000000000000000000000000000', `col857` double unsigned DEFAULT '204', `col859` linestring NOT NULL, `col860` timestamp NOT NULL DEFAULT '2013-08-17 10:47:32', `col861` multilinestring NOT NULL, `col862` decimal(50,4) NOT NULL DEFAULT '99999.0000', `col864` decimal(22,22) NOT NULL DEFAULT '0.0000000000000000000000', `col865` decimal(62,25) NOT NULL DEFAULT '0.0000000000000000000000000', `col866` date NOT NULL DEFAULT '2012-08-08', `col867` mediumint(8) unsigned NOT NULL DEFAULT '61', PRIMARY KEY (`col816`,`col801`(86)), UNIQUE KEY `idx545` (`col818`(25),`col798`), UNIQUE KEY `idx551` (`col759`(31),`col837`,`col797`(158)) USING BTREE, UNIQUE KEY `idx554` (`col827`,`col841`,`col788`(89)), UNIQUE KEY `idx556` (`col788`(7),`col831`(1)) USING BTREE, UNIQUE KEY `idx558` (`col788`(41)) USING BTREE, UNIQUE KEY `idx580` (`col818`(25)), UNIQUE KEY `idx585` (`col818`(25),`col840`), UNIQUE KEY `idx600` (`col790`(115)) USING HASH, KEY `idx542` (`col860`,`col774`), KEY `idx543` (`col818`(25),`col803`(81)), KEY `idx544` (`col798`,`col840`,`col764`) USING HASH, KEY `idx546` (`col782`(28)), KEY `idx547` (`col850`(86),`col774`,`col827`), KEY `idx548` (`col849`), KEY `idx552` (`col861`(46)), KEY `idx553` (`col766`) USING HASH, KEY `idx555` (`col764`), KEY `idx559` (`col796`(54),`col866`) USING HASH, KEY `idx560` (`col780`(183),`col804`,`col781`(184)), KEY `idx561` (`col867`,`col842`) USING BTREE, KEY `idx563` (`col837`,`col805`), KEY `idx564` (`col829`(25),`col780`(225),`col795`(25)) USING HASH, KEY `idx565` (`col773`(110)), KEY `idx566` (`col830`(152),`col853`(60),`col832`(20)), KEY `idx567` (`col855`), KEY `idx568` (`col764`,`col831`(14),`col760`(59)), KEY `idx570` (`col785`(223),`col782`(225)), KEY `idx571` (`col771`(147),`col766`), KEY `idx572` (`col816`), KEY `idx574` (`col865`,`col776`(20),`col781`(135)) USING HASH, KEY `idx575` (`col771`(250),`col801`(193)), KEY `idx576` (`col864`), KEY `idx579` (`col816`,`col801`(166)), KEY `idx581` (`col832`(7),`col796`(46)), KEY `idx582` (`col853`(42)), KEY `idx584` (`col770`(83),`col767`(178),`col853`(22)), KEY `idx587` (`col862`,`col854`) USING HASH, KEY `idx588` (`col801`(184)), KEY `idx589` (`col864`), KEY `idx590` (`col778`(254),`col813`(115)), KEY `idx593` (`col784`(25)) USING HASH, KEY `idx594` (`col805`,`col802`,`a13`), KEY `idx596` (`col766`,`col763`(159)), KEY `idx597` (`col846`(105),`col812`,`col859`(65)), KEY `idx598` (`col775`,`col769`,`col840`), KEY `idx599` (`col853`(8),`col803`(147),`col860`), KEY `idx601` (`col832`(143),`col813`(86)), KEY `idx602` (`col781`(70),`col804`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0014` -- DROP TABLE IF EXISTS `t0014`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0014` ( `a14` int(10) unsigned zerofill NOT NULL, `col868` multipolygon DEFAULT NULL, `col869` timestamp NOT NULL DEFAULT '2012-11-23 18:32:24', `col870` tinyint(1) DEFAULT '0', `col871` time DEFAULT '05:59:38', `col872` decimal(55,16) unsigned NOT NULL DEFAULT '788.0069000000000000', `col873` geometry NOT NULL, `col876` text NOT NULL, `col877` multipoint NOT NULL, `col878` multipoint NOT NULL, `col879` varchar(149) CHARACTER SET utf8 NOT NULL DEFAULT 'tzqieyuucanudmggbvlolfmcntqghngsuevrbzbsqavsjnrczesdfcfyvpwrwejwjwigwyjjtkirgmurzboiqmybgndwrxjxxtiybvmamhkhdt', `col880` multilinestring DEFAULT NULL, `col881` polygon DEFAULT NULL, `col882` set('pzgyh','jny','iga','pbmjsbju','rlp','l','jqrmmjm','yihdc','tfjymidbt','lmbyyyqdo','byvu','wfupflxvvc','u','bsocplx','pixh','uk','vqyo','ltnbcft','wpjkd','pmmw','jja','r','gsvc','ukrlzfhy','vva','fwz','j','disicz','iqbnkvl','dn','jfswp','','iswt','davtmti','peszdwedh') NOT NULL, `col883` multipoint DEFAULT NULL, `col885` multilinestring NOT NULL, `col886` decimal(37,18) DEFAULT '0.000000000000000000', `col887` set('','','zf','r','lmzi','cf','gsh','','xyeiywtu','dfady','ihjn','lghz','ww','getkyctxrp','a','umtbgewyke','kdwyoatcq','','qckkgg','ddjeooboqn','ctlj','qwm','','qmizqfg','scuo','yca','wumgefjf','qijyxykju','ed','nxbaseiw','u','d') NOT NULL, `col888` multipoint NOT NULL, `col890` point NOT NULL, `col892` geometry DEFAULT NULL, `col893` multilinestring NOT NULL, `col895` date DEFAULT '2012-05-14', `col896` longblob NOT NULL, `col897` geometrycollection NOT NULL, `col899` varbinary(4) NOT NULL, `col900` year(4) DEFAULT '2037', `col901` varchar(34) CHARACTER SET utf8 NOT NULL DEFAULT 'cmuuvkzlxtaosyfwaqngwishvlvhan', `col903` datetime NOT NULL DEFAULT '2012-07-17 15:29:37', `col904` decimal(31,17) unsigned zerofill NOT NULL DEFAULT '00000000000000.00000000000000000', `col905` point NOT NULL, `col906` linestring NOT NULL, `col907` multipolygon NOT NULL, `col910` enum('aemki','xlkxnve','','','xjwa','vmdxvsv','yndoitoabs','iwednuknpy','','ktgmjs','usaiax','q','edtjbunm','ata','vfs','lepik','qe','vygiwud','mqujmzdfqe','vd','phujb') NOT NULL, `col911` tinyblob NOT NULL, `col912` multipoint DEFAULT NULL, `col913` float NOT NULL DEFAULT '-893.54', `col914` multipolygon NOT NULL, `col915` timestamp NOT NULL DEFAULT '2012-12-09 05:33:08', `col916` date NOT NULL DEFAULT '2013-11-22', `col917` decimal(43,6) NOT NULL DEFAULT '-1516.114100', `col919` timestamp NOT NULL DEFAULT '2012-04-29 11:52:27', `col920` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `col921` geometry DEFAULT NULL, `col922` varchar(202) CHARACTER SET utf8 NOT NULL DEFAULT 'z', `col923` multilinestring DEFAULT NULL, `col924` geometry NOT NULL, `col925` multipolygon DEFAULT NULL, `col926` geometry NOT NULL, `col927` multipoint DEFAULT NULL, `col929` decimal(30,17) DEFAULT '-296.05950000000000000', `col930` int(10) unsigned zerofill NOT NULL DEFAULT '0000000371', `col932` double DEFAULT '-1544.0139', `col933` mediumblob NOT NULL, `col934` multipoint DEFAULT NULL, `col935` longblob NOT NULL, `col936` timestamp NOT NULL DEFAULT '2013-11-28 10:38:29', `col937` decimal(45,15) unsigned DEFAULT NULL, `col938` int(11) DEFAULT '0', `col939` polygon DEFAULT NULL, `col940` longtext NOT NULL, `col941` time NOT NULL DEFAULT '08:08:06', `col942` text NOT NULL, `col943` geometrycollection NOT NULL, `col944` point DEFAULT NULL, `col946` decimal(36,20) unsigned zerofill DEFAULT '0000000000000062.00000000000000000000', `col947` geometrycollection DEFAULT NULL, `col949` linestring NOT NULL, `col950` geometry DEFAULT NULL, `col951` time NOT NULL DEFAULT '14:39:31', `col952` timestamp NOT NULL DEFAULT '2013-08-01 02:47:25', `col953` char(181) CHARACTER SET utf8 NOT NULL DEFAULT 'xvbyfvhnirzxxuuvbkibjylprpyvojevdckgcrwjudwsppyiusrjcukdzgibvqohdxcbvlvyjpuxvoyngelvdfyygiqphkhkokpflrgkguathvtxgvcetrmwmagevxhdnt', `col955` date DEFAULT '2013-11-26', `col956` point DEFAULT NULL, `col957` time DEFAULT '04:49:30', `col958` multilinestring DEFAULT NULL, `col959` int(11) NOT NULL DEFAULT '-99999', `col960` point DEFAULT NULL, `col961` date NOT NULL DEFAULT '2012-07-25', `col962` binary(1) NOT NULL, `col963` time NOT NULL DEFAULT '07:53:54', `col964` multipolygon NOT NULL, `col965` linestring DEFAULT NULL, `col966` datetime DEFAULT '2012-09-12 17:10:26', PRIMARY KEY (`col911`(180)), UNIQUE KEY `idx606` (`col961`), UNIQUE KEY `idx603` (`col949`(229),`col911`(48)) USING BTREE, UNIQUE KEY `idx611` (`col886`), UNIQUE KEY `idx615` (`col892`(17),`col880`(93),`col920`,`col927`(24)) USING BTREE, KEY `idx604` (`col911`(48)), KEY `idx605` (`col932`), KEY `idx607` (`col927`(217),`col919`,`col938`,`col907`(133),`col944`(25)), KEY `idx609` (`col959`), KEY `idx610` (`col953`(170),`col903`,`col912`(60),`col921`(56)), KEY `idx612` (`col926`(65),`col904`), KEY `idx614` (`col879`(140),`col910`,`col923`(32),`col916`), KEY `idx616` (`col900`,`col893`(1),`col901`(33),`col895`), KEY `idx617` (`col958`(71),`col922`(125),`col921`(240)) USING HASH, KEY `idx618` (`col941`,`col916`,`col936`,`col873`(207)), KEY `idx619` (`col953`(84),`col905`(25)) USING HASH, KEY `idx620` (`col964`(71)), KEY `idx621` (`col938`) USING HASH, KEY `idx622` (`col904`,`col886`,`col881`(254),`col957`), KEY `idx623` (`col956`(25),`col937`,`col911`(156)), KEY `idx624` (`col925`(2),`col895`,`col871`,`col926`(234)) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0015` -- DROP TABLE IF EXISTS `t0015`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0015` ( `a15` int(10) unsigned NOT NULL, `col968` multipoint NOT NULL, `col969` double unsigned zerofill NOT NULL DEFAULT '0000000001.0936282e-37', `col970` smallint(5) unsigned DEFAULT '1330', `col971` longtext NOT NULL, `col972` longblob NOT NULL, `col973` decimal(8,6) NOT NULL DEFAULT '0.000000', `col974` timestamp NOT NULL DEFAULT '2013-10-14 00:57:04', `col977` geometrycollection NOT NULL, `col978` datetime NOT NULL DEFAULT '2012-06-07 17:24:55', `col979` mediumblob NOT NULL, `col980` datetime DEFAULT '2012-11-01 04:17:58', `col982` tinyint(4) NOT NULL DEFAULT '0', `col983` longtext NOT NULL, `col984` timestamp NOT NULL DEFAULT '2014-04-01 09:32:14', `col985` geometry NOT NULL, `col986` mediumtext NOT NULL, `col988` datetime NOT NULL DEFAULT '2013-05-27 11:03:54', `col989` multipolygon DEFAULT NULL, `col990` point DEFAULT NULL, `col991` date DEFAULT '2013-09-14', `col992` decimal(60,22) DEFAULT '99999.0000000000000000000000', `col994` point NOT NULL, `col995` int(11) DEFAULT NULL, `col996` linestring NOT NULL, `col999` linestring NOT NULL, `col1000` year(4) NOT NULL DEFAULT '0000', `col1001` multipolygon DEFAULT NULL, `col1003` char(241) CHARACTER SET utf8 NOT NULL DEFAULT 'daecplmeulhcukipaytdmxakydsevqomndsauzupvhzlqdpjrm', `col1004` point NOT NULL, `col1005` datetime NOT NULL DEFAULT '2013-04-26 07:42:37', `col1006` time DEFAULT '04:24:57', `col1008` bigint(20) unsigned zerofill NOT NULL DEFAULT '00000000000000100000', `col1010` time DEFAULT '09:40:32', `col1011` time NOT NULL DEFAULT '11:58:31', `col1012` multipoint DEFAULT NULL, `col1013` geometry NOT NULL, `col1015` multipoint NOT NULL, `col1016` double NOT NULL DEFAULT '1670', `col1018` point DEFAULT NULL, `col1019` binary(1) NOT NULL, `col1020` time DEFAULT '18:25:51', `col1021` time DEFAULT '05:19:46', `col1022` double unsigned DEFAULT '624', `col1023` polygon DEFAULT NULL, `col1024` decimal(48,14) unsigned DEFAULT '1359.24930000000000', `col1026` time DEFAULT '10:46:36', `col1028` char(157) CHARACTER SET utf8 NOT NULL DEFAULT 'okypcqcawwiacioaurokkfwebjoyxsrhdhvxwulkaafsxtgrvpgbvhwjzezjpjoksspkfmtxtjmpwtoujonnwghoqbvclhvutgtbmvchpwmqxirpv', `col1029` decimal(45,2) DEFAULT '-21.00', `col1032` geometry DEFAULT NULL, `col1033` datetime DEFAULT '2013-11-29 17:58:26', `col1034` polygon NOT NULL, `col1035` date NOT NULL DEFAULT '2013-09-05', `col1036` time NOT NULL DEFAULT '23:39:55', `col1037` decimal(48,10) unsigned DEFAULT '1120.3694000000', `col1038` point DEFAULT NULL, `col1039` decimal(59,1) NOT NULL DEFAULT '99999.0', `col1040` geometrycollection NOT NULL, `col1041` double unsigned NOT NULL DEFAULT '814', `col1042` char(109) CHARACTER SET utf8 NOT NULL DEFAULT 'bvjezkzdncjwbgkqrarurhukjpkufpndufglnzoefwlydyuzrrpfcbq', `col1043` datetime DEFAULT '2013-02-02 02:48:51', `col1045` multilinestring NOT NULL, `col1046` multipoint DEFAULT NULL, `col1047` set('qiaa','cjsi','wqybnqaix','g','zywczkbqy','numkcscysn','oreb','inx','bm','i','xdpxhfjcn','ecns','hmosptjdd','czvkvkuk','gk') NOT NULL, `col1048` int(11) NOT NULL DEFAULT '-616', `col1049` date DEFAULT '2012-07-17', `col1050` linestring NOT NULL DEFAULT '', `col1051` multipoint DEFAULT NULL, `col1052` linestring NOT NULL, `col1053` geometrycollection DEFAULT NULL, `col1054` varbinary(221) NOT NULL, `col1055` longblob NOT NULL, `col1056` polygon NOT NULL, `col1057` time DEFAULT '23:25:52', `col1058` polygon NOT NULL, `col1059` set('noogwcj','','cfnekzkrjq','brhpf','hybpsk','m','bafnlyx','','am','nbn','twao','stia','shsjnbiit','mvs','cjna','ilyum','dgajzpx','p','hltj','fioec','nmdtay','p','cerafgwnqb','ssxc','arvugjnhtx','hkdeqjsx','oiepzn','aqptepbd','oso','xavxru','eyk') NOT NULL, PRIMARY KEY (`col1050`(195),`col986`(72),`col1003`(112)) USING BTREE, UNIQUE KEY `idx625` (`col968`(53),`col970`,`col1001`(181),`col1042`(90),`col1006`) USING HASH, UNIQUE KEY `idx645` (`col989`(190),`col986`(9),`col990`(25),`col995`,`col1040`(110),`col1035`,`col1010`), UNIQUE KEY `idx655` (`col968`(197),`col990`(25),`col1022`,`col1033`) USING BTREE, UNIQUE KEY `idx661` (`col988`,`col1032`(29),`col1010`,`col1020`) USING BTREE, KEY `idx626` (`col1036`,`col994`(25),`col970`), KEY `idx627` (`col1049`,`col1032`(174),`col1028`(98),`col1015`(112),`col1011`), KEY `idx628` (`col1016`,`col1046`(238),`col1028`(79),`col979`(139),`col968`(208),`col1056`(166)), KEY `idx630` (`col980`,`col978`,`col1047`,`col1058`(228),`col1048`,`col971`(162)), KEY `idx631` (`col1011`,`col992`,`col1047`) USING HASH, KEY `idx632` (`col1050`(52),`col986`(120),`col1003`(86)) USING BTREE, KEY `idx633` (`col1016`,`col1037`,`col1041`,`col985`(211)) USING BTREE, KEY `idx635` (`col1049`,`col1020`,`col1055`(107),`col977`(249)), KEY `idx636` (`col985`(220)) USING BTREE, KEY `idx638` (`col1058`(101),`col996`(185),`col1001`(97)), KEY `idx640` (`col1048`,`col986`(194)), KEY `idx641` (`col1023`(100),`col1052`(254),`col985`(237)) USING BTREE, KEY `idx642` (`col973`,`col980`,`col1046`(47),`col1026`,`col982`) USING BTREE, KEY `idx644` (`col1018`(25)) USING HASH, KEY `idx646` (`col1034`(30),`col1011`,`col1019`,`col1054`(190),`col968`(98),`col1003`(33),`col996`(85)), KEY `idx647` (`col1006`,`col1021`,`col974`,`col999`(14),`col1003`(188),`col983`(29),`col1019`), KEY `idx648` (`col980`,`col1000`,`col979`(52),`col1049`), KEY `idx649` (`col992`,`col1045`(105),`col1020`,`col1001`(219),`col972`(233)), KEY `idx651` (`col974`,`col1005`,`col968`(26)), KEY `idx652` (`col1020`,`col1056`(209),`col979`(65),`col1005`,`col994`(25),`col1024`,`col1022`), KEY `idx654` (`col1005`), KEY `idx656` (`a15`,`col1013`(221)), KEY `idx658` (`col1059`,`col982`,`col1000`,`col994`(25),`col1049`,`col1036`,`col996`(2)), KEY `idx662` (`col1012`(242),`col977`(133),`col1037`,`col1018`(25)) USING BTREE, KEY `idx664` (`col1046`(82),`col1040`(7),`col1003`(72),`col1049`,`col1028`(91)), KEY `idx665` (`col1047`,`col999`(243),`col1056`(235),`col988`,`col1010`), KEY `idx666` (`col1043`,`col991`,`col1005`,`col1032`(212),`col1021`), KEY `idx667` (`col984`,`col970`,`col1015`(47)), KEY `idx668` (`col1029`), KEY `idx669` (`col978`,`col1024`,`col1052`(206)), KEY `idx675` (`col1052`(246),`col973`,`col1043`,`col1001`(174),`col989`(37),`col1016`,`a15`) USING BTREE, KEY `idx676` (`col1012`(7),`col1032`(44),`col1015`(163),`col1040`(190),`col1051`(10),`col1005`,`col978`) USING HASH, KEY `idx677` (`col1055`(243)) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0016` -- DROP TABLE IF EXISTS `t0016`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0016` ( `a16` int(10) unsigned DEFAULT NULL, `col1063` longtext NOT NULL, `col1066` time DEFAULT '13:25:56', `col1067` linestring NOT NULL, `col1068` int(10) unsigned zerofill DEFAULT '0000000000', `col1070` polygon NOT NULL, `col1072` text NOT NULL, `col1073` varchar(176) NOT NULL DEFAULT 'jfssujwzxnwchxlhjcxhndwvuazzi', `col1074` multilinestring NOT NULL, `col1075` geometrycollection NOT NULL, `col1076` binary(1) NOT NULL, `col1077` mediumint(9) DEFAULT '782', `col1078` multipolygon NOT NULL, `col1080` double unsigned zerofill NOT NULL DEFAULT '0000000000000000000995', `col1081` decimal(14,4) unsigned DEFAULT '100001.0000', `col1083` datetime DEFAULT '2013-07-19 03:16:51', `col1084` date NOT NULL DEFAULT '2013-05-04', `col1085` binary(1) NOT NULL, `col1087` mediumtext NOT NULL, `col1089` multilinestring NOT NULL, `col1093` geometrycollection NOT NULL, `col1094` multipolygon NOT NULL, `col1096` int(10) unsigned NOT NULL DEFAULT '1312', `col1097` enum('zv','hsateueif','vspy','eaeeoyxfwq','sthkaaefr','rmtqryy','gpj','wgmxf','','dxy','w','bdwjuggq','elkfy','ary','herzeoia','hmzck','srm','rvydfkhf','xtwvlxms','udlth','ywhwbxxacq','bnzbquff','','','vwd','yvna','kqdbnkkbr','pfbbooq','reycu','jvgvhg','rztqiojgna','r','f','wgpr','uuwiwej','jify','dzypn','rccvoy','','xstyshh','bee','zcxxwndz','v','jhzn') NOT NULL, `col1098` tinyint(3) unsigned DEFAULT '0', `col1099` tinyint(3) unsigned DEFAULT '0', `col1100` decimal(56,20) unsigned NOT NULL DEFAULT '621.00000000000000000000', `col1101` binary(1) NOT NULL, `col1102` varchar(30) NOT NULL DEFAULT 'ynxdnsh', `col1103` timestamp NOT NULL DEFAULT '2013-08-11 10:17:55', `col1104` datetime DEFAULT '2012-08-30 23:58:53', `col1105` time DEFAULT '00:32:48', `col1106` enum('azc','gbw','erizemkxub','','irqharjs','yatteb','apc','hsaq','yq','yqiasrgl','ugvqdhsrxd','','kqxaywfql','geq','yevqzf','badhobm','zx','sowkzt','','mask','sp','ysone','w','xjyi','b','','zed','uvqb','tbey','','yiqodqshwx','tfqzzuyjl','cdnvrwuh','tjhbnm','ngvxaiq','yghsbmwyw','sffo','od','xmeleeymp','wvqpl','sx','fmtx','','siyuovchtw','cpxzx','vjji') NOT NULL, `col1107` datetime DEFAULT '2012-08-04 20:17:10', `col1108` multilinestring DEFAULT NULL, `col1110` polygon DEFAULT NULL, `col1111` bit(12) DEFAULT b'1000011001', `col1112` char(227) CHARACTER SET utf8 NOT NULL DEFAULT 'dvtqkkqlbotvwkphqecddxgpdamsfcsnylbxyzizrloulhuopcthczniutrxinuzrgsgvimooshhdadermfrmlvuzkjyafayfwyakhoh', `col1113` linestring DEFAULT NULL, `col1116` varbinary(150) NOT NULL, `col1117` timestamp NOT NULL DEFAULT '2012-11-14 16:42:46', `col1118` geometry NOT NULL, `col1119` linestring NOT NULL, `col1120` double unsigned NOT NULL DEFAULT '1557.1214', `col1122` timestamp NOT NULL DEFAULT '2014-01-17 05:44:02', `col1123` multilinestring DEFAULT NULL, `col1124` decimal(58,24) DEFAULT '0.000000000000000000000000', `col1125` float DEFAULT '-6.1078', `col1126` point DEFAULT NULL, `col1128` timestamp NOT NULL DEFAULT '2012-04-12 20:48:26', `col1129` longtext NOT NULL, `col1130` tinytext NOT NULL, `col1132` date DEFAULT '2013-08-29', `col1133` point NOT NULL, `col1135` varbinary(35) NOT NULL, `col1136` geometrycollection DEFAULT NULL, `col1137` multipoint DEFAULT NULL, `col1138` char(151) NOT NULL DEFAULT 'ytvcdfwhhjxftfefycsscoudijjbcbjugmprcmqbriqnsxsucgwsbxhmlayqgv', `col1139` geometrycollection NOT NULL, `col1140` binary(1) NOT NULL, `col1141` enum('','tyxrrexkck','sl','roqczt','mz','cornyz','') NOT NULL, `col1143` text NOT NULL, `col1144` timestamp NOT NULL DEFAULT '2013-11-18 21:49:23', `col1145` binary(1) NOT NULL, `col1146` mediumblob NOT NULL, `col1147` date NOT NULL DEFAULT '2013-01-31', `col1148` geometry NOT NULL, `col1150` date DEFAULT '2012-06-16', `col1151` polygon NOT NULL, `col1152` decimal(57,17) NOT NULL DEFAULT '-250988000000000000000000000000000.00000000000000000', `col1153` date DEFAULT '2013-08-31', `col1154` int(10) unsigned zerofill DEFAULT '0000000112', `col1155` date DEFAULT '2013-05-09', `col1156` polygon NOT NULL, `col1158` longtext NOT NULL, `col1160` varchar(41) CHARACTER SET utf8 NOT NULL DEFAULT 'jiohvsmfvz', `col1161` multipolygon DEFAULT NULL, `col1162` multilinestring NOT NULL, `col1163` time NOT NULL DEFAULT '07:10:49', `col1165` date NOT NULL DEFAULT '2014-02-15', `col1167` mediumblob NOT NULL, `col1168` time DEFAULT '03:09:14', `col1169` decimal(53,30) unsigned zerofill DEFAULT '00000000000000000100000.000000000000000000000000000000', `col1171` multilinestring DEFAULT NULL, `col1172` enum('csrcryw','','ouzkmrkr','','pwb','xuk','rs','woyhbyijlo','fcubwkuqet','xykfryigwb','oyxedo','uutuoa','jpax','h','ynvt','xkovhiiw','wl','vtcpuoe','bjwcvtsnpt','kt','ftyonjs','hfsibxcorg','houdny','fgmvvd','awmn','ehw','gvkw','d','rlga','rccpxa','bljkbqeio','fa','ebjnk','fcmujlyj','xpixyat','qdhpeord','y','mjqjbzmxo','anokxuloq','','','achuhaw','bhghxu','c','jyzi') NOT NULL, `col1173` multipoint NOT NULL, `col1174` enum('jplvfk','jzu','crmmcad','qdzpsygoij') NOT NULL, `col1178` mediumtext NOT NULL, `col1179` char(76) NOT NULL DEFAULT 'kzgsgehrzxehibpertgxscsjkum', `col1180` varbinary(123) NOT NULL, `col1182` linestring DEFAULT NULL, PRIMARY KEY (`col1106`), UNIQUE KEY `idx694` (`col1085`) USING BTREE, UNIQUE KEY `idx689` (`col1182`(220)), KEY `idx678` (`col1168`), KEY `idx679` (`col1098`), KEY `idx681` (`col1165`,`col1182`(48)) USING BTREE, KEY `idx683` (`col1180`(77)) USING HASH, KEY `idx685` (`col1124`) USING HASH, KEY `idx686` (`col1106`), KEY `idx687` (`col1146`(244),`col1118`(30)) USING HASH, KEY `idx688` (`col1169`,`col1078`(134)), KEY `idx690` (`col1084`,`col1122`) USING BTREE, KEY `idx691` (`col1108`(50),`col1099`), KEY `idx692` (`col1126`(25),`col1067`(3)), KEY `idx693` (`col1129`(8),`col1158`(111)) USING BTREE, KEY `idx695` (`col1152`), KEY `idx696` (`col1067`(18)) USING BTREE, KEY `idx697` (`col1132`,`col1171`(208)), KEY `idx698` (`col1141`) USING HASH, KEY `idx699` (`col1098`,`col1143`(19)), KEY `idx701` (`col1104`), KEY `idx702` (`col1101`,`col1076`) USING BTREE, KEY `idx704` (`col1066`,`a16`), KEY `idx705` (`col1150`,`col1110`(244)), KEY `idx706` (`col1146`(230),`col1145`), KEY `idx707` (`col1093`(135),`col1107`) USING HASH, KEY `idx708` (`col1104`,`col1078`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0017` -- DROP TABLE IF EXISTS `t0017`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0017` ( `a17` int(10) unsigned NOT NULL, `col1183` char(75) NOT NULL DEFAULT 'baoxkotgsipncvpipmtutepzzoyqxrixoygkioklqjqvjokbsttgurlhajpjhgixlqmzt', `col1184` date NOT NULL DEFAULT '2014-03-23', `col1185` binary(1) NOT NULL, `col1188` multipoint NOT NULL, `col1189` date NOT NULL DEFAULT '2013-06-07', `col1191` binary(1) NOT NULL, `col1192` mediumblob NOT NULL, `col1193` polygon NOT NULL, `col1194` date DEFAULT '2012-04-28', `col1195` double unsigned NOT NULL DEFAULT '4.854277e81', `col1196` decimal(28,12) NOT NULL DEFAULT '0.000000000000', `col1197` geometry NOT NULL, `col1198` timestamp NOT NULL DEFAULT '2013-05-20 03:24:15', `col1199` char(159) CHARACTER SET utf8 NOT NULL, `col1200` point DEFAULT NULL, `col1201` decimal(64,15) unsigned NOT NULL DEFAULT '0.000000000000000', `col1202` time NOT NULL DEFAULT '17:12:50', `col1203` char(177) NOT NULL DEFAULT 'risfaqkobrmpxlikxekmkpmnc', `col1204` blob NOT NULL, `col1206` char(73) CHARACTER SET utf8 NOT NULL, `col1207` geometrycollection DEFAULT NULL, `col1208` double unsigned NOT NULL DEFAULT '1.811703e-95', `col1209` int(10) unsigned NOT NULL DEFAULT '1210', `col1210` date NOT NULL DEFAULT '2012-07-21', `col1211` enum('num','hkifohq','rkvmjxvrf','qhxu','lpbmgmceph','neidg','ufysduw','qnbkiuq','','jsmfvsw','jytne','zar','viu','i','tqtn','','wsgfu','rint','q','izgsko','ka','ihdrt','g','uyefhmkk','xmprnlott','byf','xuzksjbj','wirwiyb','yvuqfc','','iaupzyzb','ldjmled','hxtsrtzqe','ijulwdhxyh','ilfycvi','ipnv','ygjuswdqg','jd','xojpmzt','qmejp') NOT NULL, `col1212` datetime NOT NULL DEFAULT '2013-12-29 01:30:10', `col1213` multipoint NOT NULL, `col1215` geometry NOT NULL, `col1216` char(100) CHARACTER SET utf8 NOT NULL, `col1218` tinytext NOT NULL, `col1219` mediumblob NOT NULL, `col1220` multilinestring NOT NULL, `col1223` datetime NOT NULL DEFAULT '2012-07-02 02:58:40', `col1224` datetime NOT NULL DEFAULT '2012-06-27 03:48:44', `col1227` multipoint DEFAULT NULL, `col1229` datetime DEFAULT '2012-06-26 09:01:05', `col1231` geometry DEFAULT NULL, `col1233` multipoint DEFAULT NULL, `col1234` timestamp NOT NULL DEFAULT '2014-01-09 18:02:52', `col1235` date NOT NULL DEFAULT '2013-07-07', `col1236` timestamp NOT NULL DEFAULT '2013-04-18 19:24:36', `col1237` polygon DEFAULT NULL, `col1238` char(104) NOT NULL DEFAULT 'phkgiwzbbxa', `col1240` geometrycollection NOT NULL, `col1241` datetime DEFAULT '2012-09-26 17:25:13', `col1242` datetime DEFAULT '2012-12-09 18:18:44', `col1244` date NOT NULL DEFAULT '2012-11-26', `col1245` time DEFAULT '12:16:19', `col1248` mediumblob NOT NULL, `col1249` multipoint DEFAULT NULL, `col1250` linestring DEFAULT NULL, PRIMARY KEY (`a17`,`col1209`,`col1197`(154)), UNIQUE KEY `idx736` (`col1184`), UNIQUE KEY `idx732` (`col1235`,`col1223`,`col1220`(63)), UNIQUE KEY `idx734` (`col1245`,`col1202`,`col1241`), UNIQUE KEY `idx726` (`col1198`,`col1249`(158),`col1220`(59)), UNIQUE KEY `idx739` (`col1215`(5),`col1237`(229),`col1193`(2)), UNIQUE KEY `idx751` (`col1250`(187)) USING HASH, KEY `idx709` (`col1204`(93)), KEY `idx710` (`col1249`(151),`col1201`,`col1241`) USING HASH, KEY `idx711` (`col1213`(44),`col1249`(214),`col1208`), KEY `idx712` (`col1209`), KEY `idx713` (`col1189`,`col1209`), KEY `idx714` (`col1189`,`col1203`(101),`col1204`(45)), KEY `idx715` (`col1220`(146),`col1206`(48),`col1208`), KEY `idx716` (`col1201`,`col1235`), KEY `idx717` (`col1242`,`col1250`(128)), KEY `idx718` (`col1227`(246),`col1240`(251)) USING HASH, KEY `idx720` (`col1202`), KEY `idx721` (`col1213`(183),`col1184`,`col1215`(108)), KEY `idx722` (`col1209`), KEY `idx723` (`col1188`(207),`col1184`), KEY `idx724` (`col1193`(93)), KEY `idx728` (`col1229`,`col1231`(67)), KEY `idx729` (`col1227`(54),`col1218`(234)), KEY `idx730` (`a17`,`col1209`,`col1197`(129)), KEY `idx733` (`col1223`,`col1235`) USING BTREE, KEY `idx737` (`col1193`(7),`col1249`(176),`col1212`) USING BTREE, KEY `idx738` (`col1235`,`col1191`), KEY `idx740` (`col1213`(137),`col1236`), KEY `idx741` (`col1207`(139),`col1234`,`col1200`(25)), KEY `idx743` (`col1213`(135),`col1185`,`col1188`(60)), KEY `idx744` (`col1203`(5),`col1199`(151),`col1197`(229)) USING HASH, KEY `idx745` (`col1233`(225),`col1197`(73),`col1200`(25)) USING BTREE, KEY `idx746` (`col1196`,`col1242`), KEY `idx747` (`col1198`,`col1192`(43),`col1223`), KEY `idx748` (`col1215`(77)), KEY `idx750` (`col1192`(243),`col1184`,`col1211`), KEY `idx752` (`col1249`(149)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0018` -- DROP TABLE IF EXISTS `t0018`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0018` ( `a18` int(10) unsigned zerofill NOT NULL, `col1251` multipolygon NOT NULL, `col1252` time DEFAULT '05:05:08', `col1253` timestamp NOT NULL DEFAULT '2013-10-20 10:24:43', `col1254` time NOT NULL DEFAULT '09:12:31', `col1256` mediumblob NOT NULL, `col1257` tinytext NOT NULL, `col1258` float unsigned zerofill DEFAULT '00000168.297', `col1261` text NOT NULL, `col1262` blob NOT NULL, `col1263` geometry DEFAULT NULL, `col1264` geometry NOT NULL DEFAULT '', `col1265` datetime NOT NULL DEFAULT '2012-07-05 03:01:50', `col1266` multipoint DEFAULT NULL, `col1267` multilinestring NOT NULL, `col1268` timestamp NOT NULL DEFAULT '2014-01-31 16:42:28', `col1271` multipoint DEFAULT NULL, `col1272` bigint(20) unsigned NOT NULL DEFAULT '660', `col1274` mediumblob NOT NULL, `col1275` blob NOT NULL, `col1276` double DEFAULT '-1517', `col1277` geometrycollection DEFAULT NULL, `col1278` linestring DEFAULT NULL, `col1280` multipoint NOT NULL, `col1281` time DEFAULT '00:36:21', `col1282` datetime NOT NULL DEFAULT '2013-07-11 11:51:40', `col1284` decimal(62,23) NOT NULL DEFAULT '111.19190000000000000000000', `col1285` multilinestring DEFAULT NULL, `col1286` polygon DEFAULT NULL, `col1290` int(11) NOT NULL DEFAULT '177', `col1291` mediumblob NOT NULL, `col1292` polygon NOT NULL, `col1293` geometrycollection NOT NULL, `col1295` longtext NOT NULL, `col1296` longblob NOT NULL, `col1300` geometrycollection NOT NULL, `col1301` linestring DEFAULT NULL, `col1302` datetime DEFAULT '2013-12-08 07:35:34', `col1304` multilinestring DEFAULT NULL, `col1305` double unsigned zerofill DEFAULT '00000000000000335.6767', `col1306` longblob NOT NULL, `col1307` blob NOT NULL, `col1309` varbinary(79) NOT NULL, `col1310` tinytext NOT NULL, `col1311` mediumint(9) NOT NULL DEFAULT '-952', `col1313` char(224) CHARACTER SET utf8 NOT NULL DEFAULT 'tobcniglirucygistwldqftcajeygtaiwnlqntknhsywguoeenteaex', `col1314` enum('zttiomwx','ayvts','wq','zrwirwceu','fluvwksxz','ozdbgrbwm','szaz','nboefxltn','bckma','air','kmwkubqnsz','d') NOT NULL, `col1316` geometry NOT NULL, `col1317` binary(1) NOT NULL, `col1319` geometry NOT NULL, `col1320` float unsigned zerofill DEFAULT '000001546.78', `col1321` timestamp NOT NULL DEFAULT '2013-02-27 05:04:16', `col1322` longtext NOT NULL, `col1323` tinyblob NOT NULL, `col1324` date DEFAULT '2014-02-05', PRIMARY KEY (`col1321`,`col1272`,`col1264`(38),`col1316`(66),`col1296`(19)), UNIQUE KEY `idx753` (`col1281`,`col1264`(181),`col1263`(191),`col1251`(177),`col1253`), UNIQUE KEY `idx775` (`col1268`,`col1301`(83),`col1291`(172),`col1314`,`col1271`(66)) USING BTREE, KEY `idx754` (`col1276`), KEY `idx756` (`col1286`(85)), KEY `idx757` (`col1278`(150),`col1300`(37),`col1291`(33),`col1280`(1),`col1253`) USING HASH, KEY `idx759` (`col1305`,`col1282`,`col1253`,`col1258`,`col1317`,`col1267`(64)) USING BTREE, KEY `idx760` (`col1321`,`col1319`(119)), KEY `idx761` (`col1254`,`col1322`(208),`col1282`,`col1256`(98)), KEY `idx764` (`col1271`(162),`col1293`(223)), KEY `idx766` (`col1296`(100),`col1309`(74),`col1307`(176),`col1282`,`col1272`), KEY `idx767` (`col1316`(235)) USING BTREE, KEY `idx768` (`col1317`,`col1262`(209),`col1302`,`col1320`,`col1295`(251)), KEY `idx770` (`col1321`,`col1272`,`col1264`(60),`col1316`(189),`col1296`(225)), KEY `idx772` (`col1309`(5)), KEY `idx773` (`col1290`,`col1323`(166),`col1254`), KEY `idx774` (`col1284`,`col1275`(121)), KEY `idx777` (`col1317`,`col1277`(247)), KEY `idx778` (`col1322`(113),`col1310`(186),`col1313`(45),`col1253`,`col1267`(118)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0019` -- DROP TABLE IF EXISTS `t0019`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0019` ( `col1325` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `col1326` char(245) NOT NULL DEFAULT 'uuawftxbhnxialosrbblxncpnppwdyeywzoqvilgigpadnfbaiwagbbfkymbgzipqtqjqth', `col1327` char(73) CHARACTER SET utf8 NOT NULL, `col1328` time NOT NULL DEFAULT '03:51:00', `col1329` enum('','aeoq','ftohayvpqy','vdcsmsqsb','clcvox','wbegfjmxlb','uponqcql','dzlvheuwfc','cdaifnb','mimadcuuiv','ysnus','','zaaffru','mkhcyu','ylzjlmrgrv','hxwap','sku','sonoirwm','','df','snc','wrdskum','vrsnz','ialaqhb','glloat','itto','fczkd','enkms','xuanbw','oxpwe','ziqmou','fpcuf','yo','w','r','vmfho','oaqchqv','exflmndzrj','xwprjyciz','dbiq','mfa','kqvzotr','lyktyy','cjyquzklbm','rsqmi','','xnnocwkumd','lzcriack','t','','jopa','akmmhr','','jn','jktnno','empdkagqv') NOT NULL, `col1330` time NOT NULL DEFAULT '22:13:05', `col1331` varchar(144) NOT NULL DEFAULT 'ymyevgqqptfjyxwpwjdekmlmusdsrwgzkjxdvcowogqqdauackpubieawwtvfnmfgkbeqchgdthrsdbj', `col1332` mediumtext NOT NULL, `col1333` time DEFAULT '15:59:51', `col1334` linestring NOT NULL, `col1335` mediumblob NOT NULL, `col1336` longblob NOT NULL, `col1337` bit(48) NOT NULL DEFAULT b'10100101000', `col1340` multipoint DEFAULT NULL, `col1341` geometry NOT NULL, `col1343` char(246) CHARACTER SET utf8 NOT NULL, `col1344` longtext NOT NULL, `col1345` multilinestring NOT NULL, PRIMARY KEY (`col1345`(10),`col1334`(97),`col1344`(83)), KEY `idx780` (`col1341`(242)) USING BTREE, KEY `idx781` (`col1329`,`col1345`(224),`col1341`(116),`col1334`(132),`col1325`,`col1331`(14)) USING HASH, KEY `idx782` (`col1331`(65),`col1328`,`col1345`(44),`col1332`(67),`col1340`(159),`col1329`), KEY `idx783` (`col1335`(49),`col1325`,`col1343`(69),`col1330`) USING BTREE, KEY `idx785` (`col1336`(133),`col1327`(8),`col1337`,`col1343`(57),`col1344`(82)), KEY `idx786` (`col1345`(125),`col1334`(208),`col1344`(129)), KEY `idx787` (`col1325`,`col1328`), KEY `idx789` (`col1345`(134),`col1325`,`col1340`(84),`col1331`(118),`col1343`(86)), KEY `idx790` (`col1340`(165),`col1333`,`col1343`(31)), KEY `idx792` (`col1341`(155),`col1340`(115),`col1331`(65)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0020` -- DROP TABLE IF EXISTS `t0020`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0020` ( `a20` int(10) unsigned NOT NULL, `col1346` double NOT NULL DEFAULT '520', `col1347` point NOT NULL, `col1348` tinyint(4) DEFAULT NULL, `col1349` enum('btvfowcq','tcxzwdmafh','ejjgekwgh','yzam','xsnp','mwgddkwu','mingydmmjd','zjvpogvula','sehzcz','lnkg','bf','','p','viwrg','kllnlpu','vypldlaoj','mdczd','','qojntczgru','','jv','kljsias','ipdihdzdc','e','qmya','enxuetlyuz','wcbsezl') NOT NULL, `col1350` multipoint NOT NULL, `col1351` float DEFAULT '15.8017', `col1352` timestamp NOT NULL DEFAULT '2013-09-22 22:55:12', `col1353` tinyint(1) DEFAULT '0', `col1355` text NOT NULL, `col1356` enum('','','wmhvsslkg','izu','','vm','','ehfze','dyw','duxj','rllroknn','aws','npnpqff','jlidfxjp','zhpmrv','tuqwmxkuv','qiy','yxaqltz','pqismxgzv','zanvcxkj','w','','p','rwr') NOT NULL, `col1358` double unsigned zerofill DEFAULT '0000000000000000001341', `col1360` point NOT NULL DEFAULT '', `col1361` double NOT NULL DEFAULT '-1.6438483e38', `col1362` text NOT NULL, `col1363` geometry DEFAULT NULL, `col1364` timestamp NOT NULL DEFAULT '2014-02-11 16:21:38', `col1365` date NOT NULL DEFAULT '2012-11-17', `col1366` longtext NOT NULL, `col1367` datetime NOT NULL DEFAULT '2013-06-22 16:21:21', `col1368` int(10) unsigned zerofill DEFAULT '0000001596', `col1369` decimal(41,1) DEFAULT '-100001.0', `col1370` set('l','houybd','arij','vhqugan','tsgfcehxwd','sjasihoau','vhr','icfx','ig','mygpyjwdi','koycc','tzhx','ovpjw','','','x','tnuhli','fh','jnzswjrgn','r','z','oncciqohop','bnqwplw','','','imgwod','nqvwfzlfs','','vkarg','','hb','ugsenbjtj','qvkyj','injaumm','mpyidcn','qgqjl','kaddp','fzuswxsco') NOT NULL, `col1371` time NOT NULL DEFAULT '19:53:22', `col1372` point NOT NULL DEFAULT '', `col1373` date NOT NULL DEFAULT '2012-11-01', `col1374` geometry NOT NULL DEFAULT '', `col1376` decimal(58,4) NOT NULL DEFAULT '-1156000000000000000000000000000000.0000', `col1377` datetime NOT NULL DEFAULT '2014-03-15 21:28:00', `col1378` point DEFAULT NULL, `col1382` timestamp NOT NULL DEFAULT '2012-09-07 11:14:36', `col1383` timestamp NOT NULL DEFAULT '2012-09-06 23:03:12', `col1384` binary(1) NOT NULL, `col1385` timestamp NOT NULL DEFAULT '2012-06-02 09:06:55', `col1386` polygon NOT NULL, `col1387` time DEFAULT '09:39:53', `col1388` time DEFAULT '07:44:37', `col1389` double unsigned NOT NULL DEFAULT '1090', `col1392` varchar(159) CHARACTER SET utf8 NOT NULL DEFAULT 'nxjibdlqhzjpiymfsqdvqcnrxmkdhjrqsayymddiekubhkxcxeeasixdcq', PRIMARY KEY (`col1372`(25),`col1367`,`col1366`(246),`col1374`(223),`col1384`,`col1360`(25)) USING HASH, UNIQUE KEY `idx800` (`col1383`), UNIQUE KEY `idx804` (`col1353`,`col1389`), UNIQUE KEY `idx808` (`col1387`,`col1367`,`col1350`(16),`col1377`,`col1347`(25),`col1386`(144)) USING HASH, UNIQUE KEY `idx823` (`col1346`,`col1348`,`col1387`,`col1361`,`col1367`,`col1360`(25),`col1389`,`col1388`,`col1366`(173),`col1376`), KEY `idx794` (`col1372`(25),`col1352`,`col1378`(25),`col1383`,`col1382`,`col1367`) USING BTREE, KEY `idx795` (`col1388`), KEY `idx796` (`col1356`,`col1352`,`col1362`(103),`col1377`,`col1385`,`col1353`,`col1384`,`col1363`(222),`col1350`(143)), KEY `idx797` (`a20`,`col1362`(129),`col1347`(25),`col1366`(163)) USING HASH, KEY `idx799` (`col1366`(187),`col1352`,`col1367`,`col1383`,`col1388`,`col1392`(154),`col1389`,`col1356`), KEY `idx801` (`col1369`,`col1371`,`col1392`(37),`col1347`(25),`col1382`,`col1370`,`col1378`(25),`col1351`) USING HASH, KEY `idx802` (`col1377`,`col1348`,`col1370`), KEY `idx803` (`col1372`(25),`col1367`,`col1366`(196),`col1374`(164),`col1384`,`col1360`(25)) USING HASH, KEY `idx805` (`col1365`,`col1349`,`col1366`(65),`col1362`(40),`col1388`,`col1373`,`col1385`), KEY `idx806` (`col1377`,`col1392`(156),`col1367`,`col1364`,`col1371`) USING HASH, KEY `idx807` (`col1347`(25),`col1362`(185),`col1368`,`col1366`(6),`col1376`,`col1387`,`col1358`,`col1377`,`col1386`(146)), KEY `idx809` (`col1348`,`col1347`(25),`col1363`(174),`col1349`,`col1376`,`col1358`,`col1361`), KEY `idx810` (`col1348`,`col1384`,`col1353`,`col1389`,`col1383`,`col1356`,`col1382`,`col1392`(60),`col1352`), KEY `idx811` (`col1370`), KEY `idx813` (`col1349`,`col1385`,`col1355`(152),`col1347`(25)) USING BTREE, KEY `idx814` (`col1369`,`col1364`,`col1358`,`col1388`,`col1356`,`col1374`(18),`col1351`,`col1392`(10)), KEY `idx815` (`col1361`,`col1386`(46)), KEY `idx816` (`col1392`(17),`col1364`,`col1346`,`col1377`,`col1374`(253)), KEY `idx817` (`col1392`(126),`col1358`) USING BTREE, KEY `idx818` (`col1346`,`col1377`,`col1348`,`col1361`,`col1371`,`col1351`,`col1384`) USING HASH, KEY `idx820` (`a20`,`col1363`(168),`col1392`(46),`col1349`,`col1351`), KEY `idx822` (`col1348`,`col1386`(165),`col1370`) USING BTREE, KEY `idx824` (`col1352`), KEY `idx825` (`col1374`(21),`col1388`), KEY `idx826` (`col1392`(94),`col1373`,`col1384`,`col1371`) USING HASH, KEY `idx827` (`col1355`(151),`col1374`(164),`col1347`(25)), KEY `idx828` (`col1347`(25),`col1388`,`col1350`(124),`col1349`,`col1365`) USING BTREE, FULLTEXT KEY `idx793` (`col1366`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0021` -- DROP TABLE IF EXISTS `t0021`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0021` ( `a21` int(11) DEFAULT NULL, `col1393` tinyblob NOT NULL, `col1394` timestamp NOT NULL DEFAULT '2014-02-12 07:35:33', `col1396` text NOT NULL, `col1397` decimal(46,19) unsigned zerofill DEFAULT '000000000000000000000000589.0000000000000000000', `col1398` time NOT NULL DEFAULT '02:39:07', `col1400` timestamp NOT NULL DEFAULT '2012-12-17 06:38:01', `col1401` polygon DEFAULT NULL, `col1402` date DEFAULT '2013-10-13', `col1403` set('bjdlbwvj','x','ndsdy','jqhmdn','n','lglfzz','wigzsqo','btdfoukf','rux','easufkhx','','fewhcgvte','','bdsnzsunfd','wm','dfqgzy') NOT NULL, `col1404` time DEFAULT '05:40:15', `col1405` mediumtext NOT NULL, `col1407` multipolygon NOT NULL, `col1408` decimal(48,18) unsigned zerofill NOT NULL DEFAULT '000000000000000000000000100001.000000000000000000', `col1410` geometry NOT NULL, `col1411` linestring NOT NULL DEFAULT '', `col1412` geometry NOT NULL, `col1413` tinyint(1) NOT NULL DEFAULT '0', `col1414` timestamp NOT NULL DEFAULT '2014-01-22 05:15:40', `col1415` geometry NOT NULL, `col1418` timestamp NOT NULL DEFAULT '2013-06-12 23:11:43', `col1419` point NOT NULL, `col1420` point NOT NULL, `col1421` mediumblob NOT NULL, `col1422` mediumint(9) NOT NULL DEFAULT '671', `col1423` point NOT NULL, `col1424` binary(1) NOT NULL, `col1425` year(4) DEFAULT '0000', `col1426` decimal(25,7) NOT NULL DEFAULT '534.3197000', `col1428` int(11) NOT NULL DEFAULT '-861', `col1429` date DEFAULT '2013-02-16', `col1430` timestamp NOT NULL DEFAULT '2012-09-30 06:27:54', `col1431` multilinestring NOT NULL, `col1432` decimal(25,8) unsigned DEFAULT '279.77160000', `col1433` float NOT NULL DEFAULT '1344.67', `col1435` point NOT NULL, `col1436` mediumtext NOT NULL, `col1437` tinytext NOT NULL, `col1438` mediumtext NOT NULL, `col1439` binary(1) NOT NULL, `col1441` blob NOT NULL, `col1442` date NOT NULL DEFAULT '2012-07-16', `col1443` multipolygon DEFAULT NULL, PRIMARY KEY (`col1411`(211),`col1433`) USING HASH, UNIQUE KEY `idx833` (`col1441`(234)), UNIQUE KEY `idx834` (`col1414`,`col1428`,`col1421`(247),`col1435`(25)) USING HASH, KEY `idx830` (`col1410`(245),`col1441`(65),`col1443`(112)) USING BTREE, KEY `idx831` (`col1411`(224),`col1433`) USING HASH, KEY `idx832` (`col1439`,`col1432`,`col1412`(66),`col1418`), KEY `idx835` (`col1443`(37)), KEY `idx837` (`col1426`,`col1435`(25),`col1404`,`col1442`), KEY `idx839` (`col1421`(5)), KEY `idx840` (`col1422`,`col1408`,`col1415`(67)), KEY `idx842` (`col1405`(3)), KEY `idx844` (`col1419`(25),`col1422`,`col1403`,`col1397`), KEY `idx845` (`col1410`(239)), KEY `idx846` (`col1402`,`col1435`(25),`col1410`(94)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t0022` -- DROP TABLE IF EXISTS `t0022`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0022` ( `a22` int(11) DEFAULT NULL, `col1444` bigint(20) unsigned NOT NULL DEFAULT '897', `col1445` multilinestring NOT NULL, `col1446` double unsigned zerofill NOT NULL DEFAULT '000000000001.481171e56', `col1448` geometry DEFAULT NULL, `col1449` double unsigned DEFAULT '1601.6937', `col1450` blob NOT NULL, `col1451` int(10) unsigned NOT NULL DEFAULT '100001', `col1452` date DEFAULT '2013-05-27', `col1453` decimal(50,1) DEFAULT '-100000.0', `col1455` multipoint NOT NULL, `col1456` multipoint DEFAULT NULL, `col1457` multilinestring NOT NULL, `col1458` int(10) unsigned zerofill DEFAULT '0000000000', `col1459` linestring NOT NULL, `col1460` multilinestring NOT NULL, `col1461` time NOT NULL DEFAULT '03:58:44', `col1462` bigint(20) DEFAULT '524', `col1463` double NOT NULL DEFAULT '-9.31e-79' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=1024; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2013-04-10 13:19:24