-- MySQL dump 10.13 Distrib 5.1.53, for Win64 (unknown) -- -- Host: 192.168.1.105 Database: test -- ------------------------------------------------------ -- Server version 5.5.9-valgrind-max-debug /*!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 `a` -- DROP TABLE IF EXISTS `a`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `a` ( `pk` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `c` -- DROP TABLE IF EXISTS `c`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `c` ( `a` time DEFAULT NULL, `b` char(8) CHARACTER SET utf8 DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `d` -- DROP TABLE IF EXISTS `d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `d` ( `pk` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, KEY `pk` (`pk`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `g1` -- DROP TABLE IF EXISTS `g1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `g1` ( `a1` int(10) unsigned zerofill NOT NULL, `col0` longblob, `col1` tinytext, `col2` smallint(5) unsigned zerofill DEFAULT '01646', `col4` date DEFAULT '2010-07-03', `col5` varchar(217) DEFAULT 'rjclrzptwfqcfjpbzhcvluriggstgzygvjchhjzugrhtxdacakkovwfeyyhefgvdmvznufejxchzyvdzkhmjzfwpyxnzoymlemablzcqysnhavafydsdyhhhscwhqpgjb', `col6` enum('uyjjdoup') DEFAULT NULL, `col9` timestamp NOT NULL DEFAULT '2011-09-14 19:34:10', `col12` char(86) CHARACTER SET utf8 DEFAULT NULL, `col13` mediumint(8) unsigned zerofill DEFAULT '00090697', `col14` char(156) CHARACTER SET utf8 DEFAULT 'hkwgqojirxwxrfdffpxecuiremagtnqhoivmygaegiatrtvajsequkrdzksuneudhlxwdohxwrymycbvevqaxpzyrhziuvemkorrtvtgsnbctdobvdjsiijxuxnygairhhddy', `col15` char(156) CHARACTER SET utf8 DEFAULT 'ykezbiyovhahoonmdmzywxwqpqhwxebvdldd' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `g32` -- DROP TABLE IF EXISTS `g32`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `g32` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `idx` (`a`,`c`,`b`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `g7` -- DROP TABLE IF EXISTS `g7`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `g7` ( `col196` mediumint(9) DEFAULT NULL, `b` blob ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t1` -- DROP TABLE IF EXISTS `t1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t1` ( `a1` int(10) unsigned zerofill NOT NULL, `col0` longblob, `col1` tinytext, `col2` smallint(5) unsigned zerofill DEFAULT '01646', `col4` date DEFAULT '2010-07-03', `col5` varchar(217) DEFAULT 'rjclrzptwfqcfjpbzhcvluriggstgzygvjchhjzugrhtxdacakkovwfeyyhefgvdmvznufejxchzyvdzkhmjzfwpyxnzoymlemablzcqysnhavafydsdyhhhscwhqpgjb', `col6` enum('uyjjdoup') DEFAULT NULL, `col9` timestamp NOT NULL DEFAULT '2011-09-14 19:34:10', `col12` char(86) CHARACTER SET utf8 DEFAULT NULL, `col13` mediumint(8) unsigned zerofill DEFAULT '00090697', `col14` char(156) CHARACTER SET utf8 DEFAULT 'hkwgqojirxwxrfdffpxecuiremagtnqhoivmygaegiatrtvajsequkrdzksuneudhlxwdohxwrymycbvevqaxpzyrhziuvemkorrtvtgsnbctdobvdjsiijxuxnygairhhddy', `col15` char(156) CHARACTER SET utf8 DEFAULT 'ykezbiyovhahoonmdmzywxwqpqhwxebvdldd' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=8305345 MAX_ROWS=7283849 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t10` -- DROP TABLE IF EXISTS `t10`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t10` ( `a10` int(10) unsigned zerofill NOT NULL, `col260` date DEFAULT '2010-02-08', `col261` char(105) DEFAULT 'xwoldwgsjpcvrwmzledy', `col262` longblob, `col263` double unsigned zerofill DEFAULT '0000000000000000072680', `col265` int(10) unsigned zerofill NOT NULL DEFAULT '0000001589', `col266` double unsigned DEFAULT '63930.5954', `col267` mediumtext, `col268` binary(1) DEFAULT NULL, `col271` tinyblob, `col272` mediumtext NOT NULL, `col273` bigint(20) NOT NULL DEFAULT '42679', `col274` decimal(58,30) unsigned zerofill DEFAULT '0000000000000000000000038594.000000000000000000000000000000', `col275` float DEFAULT '-89113', `col276` time DEFAULT '07:02:15', `col277` datetime DEFAULT '2010-10-27 08:22:07', `col278` longtext, `col280` decimal(54,23) unsigned DEFAULT '96749.34390000000000000000000', `col281` bit(40) DEFAULT b'1111000101011111', `col282` timestamp NOT NULL DEFAULT '2010-10-27 11:59:03', `col283` mediumblob, `col284` blob, `col285` timestamp NOT NULL DEFAULT '2011-11-20 19:38:30', `col286` time DEFAULT '11:27:40', `col287` char(40) CHARACTER SET utf8 NOT NULL DEFAULT '', `col288` date DEFAULT '2011-05-01', `col289` decimal(17,5) DEFAULT '-99304.40160', `col290` timestamp NOT NULL DEFAULT '2010-12-08 09:36:04', `col291` date DEFAULT '2011-10-30', `col293` timestamp NOT NULL DEFAULT '2010-04-10 11:58:58', `col294` blob, `col297` varbinary(55) DEFAULT NULL, `col304` enum('d','ufyyy','pubvmg','bupvzek','xygmlz','ghrnebmry','rakmbtz') NOT NULL DEFAULT 'd', `col306` timestamp NOT NULL DEFAULT '2011-10-20 04:05:48', `col307` binary(1) NOT NULL DEFAULT '\0', `col308` float DEFAULT '-4026.96', `col310` binary(1) DEFAULT NULL, `col314` binary(1) DEFAULT NULL, `col315` varchar(203) CHARACTER SET utf8 NOT NULL DEFAULT 'tgknpiyfknounuiqnnncuswjgqqrjcmkorodkoufdtcnuvkuptowmrnbpddabpssbkvemxtmmqnqrhipzqci', `col317` enum('buim','','gjgqjj','svakpvtvg','xywahcdy','ocfv','gonmls','rk','qknvd','') DEFAULT NULL, PRIMARY KEY (`col304`,`col272`(57),`col287`(7),`col315`(31),`col307`,`col273`,`col265`) USING HASH KEY_BLOCK_SIZE=23748, UNIQUE KEY `idx308` (`col260`,`col266`,`col272`(65),`col294`(20),`col315`(151),`col304`,`a10`,`col281`,`col282`,`col267`(136)), UNIQUE KEY `idx316` (`col272`(166),`col291`,`col290`,`col276`,`col294`(106)) USING HASH, UNIQUE KEY `idx322` (`col267`(130)), UNIQUE KEY `idx331` (`col289`,`col284`(38),`col268`,`col283`(84)), UNIQUE KEY `idx332` (`col261`(21),`col304`,`col282`,`col294`(202),`col276`), KEY `idx307` (`col290`,`col284`(117),`col294`(202),`col267`(116),`col263`) USING BTREE, KEY `idx315` (`col293`,`col267`(101)) USING HASH, KEY `idx324` (`col268`,`col282`,`col293`) USING BTREE, KEY `idx333` (`col281`,`col263`,`col282`,`a10`,`col276`), KEY `idx336` (`col304`,`col272`(200),`col287`(1),`col315`(68),`col307`,`col273`,`col265`) USING HASH, KEY `idx341` (`col308`,`col267`(117),`col286`,`col284`(228),`col274`) USING BTREE, KEY `idx343` (`col284`(39),`col273`,`col268`) USING BTREE, KEY `idx345` (`col267`(8)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=6277555 MAX_ROWS=1774687 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t11` -- DROP TABLE IF EXISTS `t11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t11` ( `a11` int(10) unsigned NOT NULL, `col320` time NOT NULL DEFAULT '13:10:17', `col324` longblob, `col325` double DEFAULT '-74639.056', `col327` datetime DEFAULT '2011-03-15 10:06:18', `col328` longblob, `col329` double unsigned NOT NULL DEFAULT '43041.1261', `col331` text NOT NULL, `col333` time NOT NULL DEFAULT '06:48:49', `col335` longtext NOT NULL, `col339` timestamp NOT NULL DEFAULT '2011-11-30 05:41:41', `col340` double unsigned zerofill NOT NULL DEFAULT '00000000000079155.4375', `col341` time DEFAULT '04:12:49', `col342` double unsigned zerofill DEFAULT '000000000000063938.507', `col343` varbinary(172) NOT NULL DEFAULT '', `col344` mediumint(8) unsigned DEFAULT NULL, `col345` mediumblob, `col346` bigint(20) NOT NULL DEFAULT '-71009', PRIMARY KEY (`col320`,`col339`,`col329`,`col340`,`col346`,`col343`(52),`col335`(150),`col333`,`col331`(238)) USING HASH KEY_BLOCK_SIZE=618, UNIQUE KEY `idx354` (`col333`,`col327`,`col340`) USING HASH, UNIQUE KEY `idx350` (`col325`,`col335`(115),`col346`,`col333`,`col320`,`col331`(155),`col342`,`col327`,`col328`(9),`col329`) USING BTREE, UNIQUE KEY `idx351` (`col320`,`col333`,`col343`(23)) USING BTREE, UNIQUE KEY `idx352` (`col345`(167)) USING BTREE, UNIQUE KEY `idx355` (`col346`,`a11`,`col345`(207),`col340`,`col325`,`col341`,`col339`,`col324`(36)), UNIQUE KEY `idx361` (`col329`,`col342`,`col345`(228),`col346`,`col344`), UNIQUE KEY `idx373` (`col325`,`col324`(60)) USING BTREE, UNIQUE KEY `idx379` (`col343`(33),`col328`(125),`col324`(89),`col342`,`col320`,`col325`,`a11`,`col345`(182)) USING BTREE, UNIQUE KEY `idx383` (`col328`(205),`col329`,`col333`,`col324`(211),`col345`(189),`col341`,`col342`,`col325`,`col344`,`col339`), UNIQUE KEY `idx387` (`col320`,`col339`,`col329`,`col340`,`col346`,`col343`(104),`col335`(159),`col333`,`col331`(57)) USING HASH, KEY `idx348` (`col341`,`col335`(253),`col342`,`col340`,`col333`,`col324`(82),`col339`,`col345`(149),`col344`,`col331`(144)), KEY `idx366` (`col325`,`col329`,`col331`(125),`col342`) USING BTREE, KEY `idx367` (`col341`,`col340`,`col335`(65),`col320`,`col345`(200),`col325`,`col331`(166),`col346`), KEY `idx370` (`col324`(179),`a11`) USING BTREE, KEY `idx374` (`col340`,`col329`) USING HASH, KEY `idx377` (`col344`,`col342`,`col331`(129)) USING BTREE, KEY `idx380` (`col345`(62)) USING BTREE, KEY `idx382` (`col320`,`col344`,`col345`(236),`col328`(193)) USING HASH, KEY `idx386` (`col324`(218),`col340`,`col333`,`col341`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=906380 MAX_ROWS=249638 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t12` -- DROP TABLE IF EXISTS `t12`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t12` ( `a12` int(10) unsigned zerofill NOT NULL, `col348` set('bokj','c','yedjo','dmsw','mds','tderfccdw','jbjlluwcug','ccbyk','blpqnqdaao','wib') DEFAULT NULL, `col349` varbinary(215) DEFAULT NULL, `col354` time DEFAULT '23:41:13', `col356` mediumblob, `col357` date DEFAULT '2011-10-06', `col358` bit(41) NOT NULL DEFAULT b'10010100110110110', `col361` timestamp NOT NULL DEFAULT '2011-10-17 09:04:39', `col362` time DEFAULT '06:34:05', `col363` longtext, `col364` char(159) CHARACTER SET utf8 DEFAULT NULL, `col366` date DEFAULT '2011-09-08', `col369` text, `col370` text, `col371` date DEFAULT '2010-11-15', `col372` date DEFAULT '2011-02-03', `col374` datetime DEFAULT '2011-04-04 09:47:30', `col376` set('ih') NOT NULL DEFAULT '', `col377` time DEFAULT NULL, `col378` timestamp NOT NULL DEFAULT '2010-03-05 05:18:29', `col379` tinytext, `col385` blob, `col386` datetime DEFAULT '2009-12-26 12:33:12', `col387` date DEFAULT '2010-05-17', `col388` binary(1) DEFAULT NULL, PRIMARY KEY (`col378`,`col358`,`col376`) USING HASH KEY_BLOCK_SIZE=12096, UNIQUE KEY `idx393` (`col371`) USING BTREE, UNIQUE KEY `idx406` (`col378`,`col358`,`col376`) USING HASH, UNIQUE KEY `idx423` (`col388`,`col387`,`col372`,`col377`), UNIQUE KEY `idx438` (`col387`,`col354`,`col371`,`col376`,`col378`), UNIQUE KEY `idx402` (`col364`(52),`col386`,`col385`(163),`col348`,`a12`,`col357`,`col356`(138)), UNIQUE KEY `idx404` (`col369`(209),`col364`(1),`col363`(99),`col370`(188),`col377`,`col387`) USING HASH, UNIQUE KEY `idx411` (`col363`(248),`col357`,`col386`,`col374`,`col348`,`col362`) USING HASH, UNIQUE KEY `idx417` (`col354`,`col385`(230),`col370`(37)), UNIQUE KEY `idx422` (`col362`,`col357`,`col388`,`col348`,`col386`,`col370`(208)) USING BTREE, UNIQUE KEY `idx424` (`col349`(70)) USING BTREE, UNIQUE KEY `idx431` (`col374`,`col356`(240),`col371`,`col358`,`col372`) USING HASH, UNIQUE KEY `idx433` (`col349`(97),`col376`,`col358`,`col377`,`col354`,`col356`(28),`col372`,`col348`,`col386`), UNIQUE KEY `idx441` (`col362`,`col376`,`col366`,`col349`(81),`col378`,`col357`,`col348`,`col388`,`col354`) USING HASH, UNIQUE KEY `idx442` (`col385`(230),`col362`,`col358`,`col371`,`col364`(131),`col349`(15),`col376`) USING HASH, KEY `idx394` (`col370`(252),`col388`,`col369`(51),`col349`(129),`col364`(92)), KEY `idx395` (`col372`,`col361`,`col376`,`col363`(69)) USING BTREE, KEY `idx397` (`col374`,`col369`(26),`col388`,`col371`,`col364`(141),`col387`,`col363`(224),`col358`) USING HASH, KEY `idx401` (`col366`,`col386`,`col378`,`col379`(218),`col349`(131),`col371`,`col354`,`col372`) USING BTREE, KEY `idx408` (`col361`,`col379`(36)) USING BTREE, KEY `idx413` (`col372`,`col376`,`col358`,`col379`(184)) USING HASH, KEY `idx415` (`col372`,`col357`,`col361`,`a12`,`col354`,`col364`(82),`col358`) USING HASH, KEY `idx419` (`col369`(161),`col386`,`col379`(133),`col348`), KEY `idx421` (`col349`(42),`col361`,`col370`(251),`col366`,`col354`), KEY `idx425` (`col386`,`col388`,`col387`) USING HASH, KEY `idx426` (`col348`), KEY `idx432` (`col364`(5),`col387`,`col379`(21),`col348`,`col371`), KEY `idx435` (`col378`,`col371`,`col364`(62),`col379`(243),`col388`,`col363`(113),`col356`(63),`col354`,`col358`) USING HASH, KEY `idx437` (`col357`,`col349`(109),`col374`,`col376`,`col354`,`col388`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9523483 MAX_ROWS=2317689 PACK_KEYS=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t13` -- DROP TABLE IF EXISTS `t13`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t13` ( `a13` int(11) NOT NULL, `col392` datetime DEFAULT '2010-03-07 03:49:00', `col393` timestamp NOT NULL DEFAULT '2011-09-20 18:13:41', `col394` datetime DEFAULT '2011-05-22 07:03:44', `col395` time DEFAULT '17:57:56', `col397` double unsigned zerofill DEFAULT '0000000000000000010870', `col398` char(244) CHARACTER SET utf8 NOT NULL DEFAULT 'ypzaswoqrcwitbcfjpzkrtsxambcvvrzvlaqahclevorntbjclitcetmeasqtizkcvhpyqbqywnznnwlpgwrkjtuxetteetqefvizrkyuticfzpgsqlfjnsjsfkblojojqzxtvlaqbkpeovwjasvnddcyduwpiihvweqriwlerpebeunibxrhccqgkscjhpcpsvnsjyyrabnp', `col399` mediumint(9) DEFAULT '-15153', `col402` datetime DEFAULT '2011-08-17 18:39:02', `col403` decimal(56,25) DEFAULT '100000.0000000000000000000000000', `col404` mediumint(8) unsigned DEFAULT '62199', `col405` varchar(222) CHARACTER SET utf8 DEFAULT 'mazjwzwpgepbuhbfgxnkvfjnswndgzdbkcnrhtpoofyevawahfxrya', `col408` date DEFAULT '2010-10-16', `col410` int(10) unsigned zerofill DEFAULT '0000057267', `col411` varbinary(110) DEFAULT NULL, `col412` tinyblob, `col413` decimal(44,28) unsigned DEFAULT '99871.6939000000000000000000000000', `col415` timestamp NOT NULL DEFAULT '2011-11-17 12:43:11', `col416` decimal(54,17) DEFAULT '63946.28920000000000000', `col417` binary(1) DEFAULT NULL, `col419` mediumint(8) unsigned zerofill DEFAULT '00081252', `col421` enum('nu','vgbssraa','','lt','','bql','an') DEFAULT NULL, PRIMARY KEY (`col398`(215)) USING HASH KEY_BLOCK_SIZE=14965, UNIQUE KEY `idx456` (`col410`) USING HASH, UNIQUE KEY `idx462` (`col419`), UNIQUE KEY `idx463` (`col416`) USING BTREE, UNIQUE KEY `idx460` (`col398`(68)) USING HASH, KEY `idx448` (`col392`), KEY `idx453` (`col415`), KEY `idx461` (`col417`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=479673 MAX_ROWS=639382 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t14` -- DROP TABLE IF EXISTS `t14`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t14` ( `a14` int(10) unsigned zerofill NOT NULL, `col422` double unsigned zerofill DEFAULT '0000000000000000065193', `col425` int(10) unsigned NOT NULL DEFAULT '40575', `col427` smallint(5) unsigned DEFAULT '35555', `col428` tinytext, `col429` timestamp NOT NULL DEFAULT '2011-03-27 13:20:18', `col430` timestamp NOT NULL DEFAULT '2010-11-15 22:41:38', `col431` timestamp NOT NULL DEFAULT '2009-12-31 00:44:57', `col432` double unsigned DEFAULT '96873.2589', `col433` mediumtext, `col435` char(239) CHARACTER SET utf8 DEFAULT 'xddrrwxfhyshgpwxszbhwvfbkizeezdjvfbphouuffvisllkfzncfswseijnburnitcarmom', `col436` time NOT NULL DEFAULT '05:12:18', `col438` tinyblob NOT NULL, `col439` date DEFAULT '2010-03-09', `col441` date NOT NULL DEFAULT '2011-06-08', `col442` timestamp NOT NULL DEFAULT '2009-12-04 14:22:21', `col443` double unsigned DEFAULT '96372', `col448` time NOT NULL DEFAULT '19:02:40', `col450` timestamp NOT NULL DEFAULT '2011-07-01 03:44:01', `col452` mediumtext, `col453` timestamp NOT NULL DEFAULT '2011-08-12 23:52:37', `col457` tinyblob, `col459` datetime DEFAULT '2010-12-23 23:20:48', `col460` double unsigned zerofill DEFAULT '00000000000082735.5371', PRIMARY KEY (`col425`,`col438`(240),`col436`,`col441`,`col448`,`col429`,`col453`) USING BTREE KEY_BLOCK_SIZE=29727, UNIQUE KEY `idx464` (`col425`), UNIQUE KEY `idx466` (`col448`,`a14`,`col460`,`col428`(211),`col433`(133),`col425`) USING HASH, UNIQUE KEY `idx473` (`col457`(11),`a14`,`col438`(176),`col429`,`col425`,`col422`,`col433`(208),`col435`(114)), UNIQUE KEY `idx477` (`col431`,`col438`(114),`col430`,`col427`) USING HASH, UNIQUE KEY `idx482` (`col436`,`col429`,`col438`(65),`col459`), UNIQUE KEY `idx490` (`col448`,`col436`,`col439`,`col457`(186),`col443`,`col460`), UNIQUE KEY `idx495` (`col428`(15),`col427`,`col433`(249),`col443`), UNIQUE KEY `idx506` (`col425`,`col433`(13),`col453`,`col442`,`col450`,`col439`), KEY `idx468` (`col425`,`col438`(39),`col436`,`col441`,`col448`,`col429`,`col453`) USING BTREE, KEY `idx474` (`col425`,`col431`,`col429`,`col459`,`col428`(109)) USING HASH, KEY `idx483` (`col428`(48),`col443`,`col431`,`col441`,`col442`) USING BTREE, KEY `idx489` (`col422`,`col452`(64),`col427`) USING HASH, KEY `idx496` (`col427`,`col452`(133),`col430`,`col442`) USING BTREE, KEY `idx497` (`col436`), KEY `idx503` (`col438`(210),`col460`,`col430`,`col448`,`col436`,`col431`), KEY `idx504` (`col457`(161)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=1769901 MAX_ROWS=7292714 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t15` -- DROP TABLE IF EXISTS `t15`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t15` ( `a15` int(10) unsigned NOT NULL, `col462` datetime DEFAULT '2011-01-12 15:52:54', `col463` varchar(242) CHARACTER SET utf8 NOT NULL DEFAULT 'jwltczemhxjayuonykqxqtugtdwhnloabpdkjogohiogjukmedhcutkkrhdhylbzgtuipjnlgkavfirbryrfugquepuqtddxczxjsaduqjlpsbewuvucrcejodpydwfbcbkftcfbnhehiswfngdieyyfrtvpwkgeclojymoanessmckmycevqbvllpwbokuofuylrbbuwkpvydcapaxknrjuzhg', `col464` timestamp NOT NULL DEFAULT '2010-05-30 06:15:37', `col465` date DEFAULT '2011-03-20', `col466` date DEFAULT '2011-01-25', `col467` time DEFAULT '15:18:47', `col468` enum('p') DEFAULT NULL, `col469` time DEFAULT '19:37:51', `col470` mediumtext, `col471` longblob, `col472` date DEFAULT '2010-01-15', `col473` set('h','cbytijjo','rsvyonxy','','','gfqasfo','jpcet','mdxouvee','rwoeomnget','jzmbdptcck') DEFAULT NULL, `col474` double DEFAULT '26756.0411', `col475` mediumblob NOT NULL, `col476` date DEFAULT '2011-04-07', `col477` timestamp NOT NULL DEFAULT '2011-08-13 03:31:06', `col478` tinytext, `col479` set('nxncu','x') DEFAULT NULL, `col481` timestamp NOT NULL DEFAULT '2011-05-08 10:58:48', `col484` datetime DEFAULT '2011-02-04 13:13:49', `col485` timestamp NOT NULL DEFAULT '2011-03-06 02:38:32', `col486` char(210) CHARACTER SET utf8 DEFAULT 'dmlrczrnyjiczacmkxzfqhjdhltvwdiaqwvcavunpzwkdisnosyrlxuufuddypkbwntaccrqwuvmkjiwdaxsrxvyjysslmsaueyeoqr', `col487` longblob, `col488` varchar(223) CHARACTER SET utf8 DEFAULT 'csojmldzctgxfjwdhldh', `col490` timestamp NOT NULL DEFAULT '2011-07-28 12:20:32', `col491` tinytext, `col492` text, `col496` varbinary(54) DEFAULT NULL, `col497` binary(1) NOT NULL DEFAULT '\0', `col499` double DEFAULT '-9255', PRIMARY KEY (`col497`,`col463`(235),`col475`(2)) USING BTREE KEY_BLOCK_SIZE=14760, UNIQUE KEY `idx528` (`col464`) USING BTREE, UNIQUE KEY `idx547` (`col477`,`col499`,`col473`,`col472`) USING BTREE, UNIQUE KEY `idx517` (`col490`,`col487`(136)) USING BTREE, UNIQUE KEY `idx537` (`col490`,`col492`(91)), UNIQUE KEY `idx540` (`col497`,`col463`(33),`col475`(223)) USING BTREE, UNIQUE KEY `idx542` (`col491`(141),`col464`,`col469`), UNIQUE KEY `idx543` (`col478`(155),`col474`,`col481`,`col492`(137)) USING BTREE, UNIQUE KEY `idx545` (`a15`,`col474`,`col496`(33),`col465`,`col467`,`col471`(38)), KEY `idx507` (`col469`,`col487`(183),`col491`(25),`col486`(168)), KEY `idx510` (`col488`(160),`col470`(176),`col475`(79)) USING BTREE, KEY `idx511` (`col478`(207),`col464`,`a15`,`col487`(159),`col481`), KEY `idx518` (`col462`) USING BTREE, KEY `idx520` (`col468`,`col479`) USING BTREE, KEY `idx523` (`col475`(183),`col486`(148)) USING HASH, KEY `idx529` (`col485`) USING BTREE, KEY `idx535` (`col474`,`col484`,`col475`(201),`col466`,`col471`(99),`col490`) USING BTREE, KEY `idx541` (`col478`(206),`col488`(89),`col466`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=6599567 MAX_ROWS=7689899 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t16` -- DROP TABLE IF EXISTS `t16`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t16` ( `a16` int(11) NOT NULL, `col501` char(179) CHARACTER SET utf8 DEFAULT 'fhxdeilsjklnhwpwmktzywpbgzzzlmwkhbrkpwpnkvotuawidlsuhusgonxgtgfxnroaxokqdzeoccpubqszjtx', `col503` bigint(20) unsigned NOT NULL DEFAULT '12146', `col504` time DEFAULT '17:52:20', `col505` tinyblob NOT NULL, `col506` decimal(60,0) unsigned DEFAULT '14741', `col507` decimal(24,7) unsigned DEFAULT '35917.9539000', `col512` timestamp NOT NULL DEFAULT '2011-02-11 11:05:38', `col514` longtext, `col515` int(11) DEFAULT '-74786', `col516` varbinary(141) DEFAULT NULL, `col517` date DEFAULT '2011-06-12', `col519` date DEFAULT '2011-03-26', `col520` tinytext NOT NULL, `col521` timestamp NOT NULL DEFAULT '2011-08-24 16:53:19', `col522` varchar(194) DEFAULT 'tes', `col523` float DEFAULT '58764', `col524` float unsigned zerofill DEFAULT '000000100000', `col525` set('brwrpfmh','cieebwl','gnvffx') DEFAULT NULL, `col526` int(10) unsigned zerofill DEFAULT '0000043623', `col527` mediumtext, `col528` double unsigned DEFAULT '90351.7459', `col530` double DEFAULT '-94010', `col531` char(199) CHARACTER SET utf8 DEFAULT NULL, `col532` varbinary(142) DEFAULT NULL, `col534` binary(1) DEFAULT NULL, `col535` text NOT NULL, `col536` set('ahuvxhrilb','dchcrzluoz','ixhvc','vjh','','','eyxbgull','bvcuxohypj','igqg','uvquoiwt') DEFAULT NULL, `col537` timestamp NOT NULL DEFAULT '2010-11-22 07:53:26', PRIMARY KEY (`col503`,`col505`(183),`col535`(79),`col520`(232)) USING HASH KEY_BLOCK_SIZE=27968, UNIQUE KEY `idx572` (`col532`(27),`col503`), KEY `idx551` (`col503`,`col505`(59),`col535`(51),`col520`(246)) USING HASH, KEY `idx558` (`col506`,`a16`,`col534`,`col535`(245),`col503`), KEY `idx562` (`col504`) USING HASH, KEY `idx566` (`col532`(56),`col521`,`col536`,`col523`,`col520`(134),`col503`,`col517`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4033326 MAX_ROWS=9463306 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t17` -- DROP TABLE IF EXISTS `t17`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t17` ( `a17` int(10) unsigned zerofill NOT NULL, `col539` blob, `col540` mediumblob, `col541` bit(52) DEFAULT b'10001110100000011', `col542` double DEFAULT '-43581.574', `col543` binary(1) NOT NULL DEFAULT '\0', `col544` timestamp NOT NULL DEFAULT '2011-11-30 06:18:03', `col546` time NOT NULL DEFAULT '14:20:21', `col547` mediumblob, `col548` double unsigned zerofill DEFAULT '00000000000090843.4867', `col549` binary(1) DEFAULT NULL, `col550` binary(1) DEFAULT NULL, `col551` int(10) unsigned zerofill DEFAULT '0000037434', `col552` mediumblob, `col554` datetime DEFAULT '2010-09-23 02:04:12', `col558` date DEFAULT NULL, `col559` timestamp NOT NULL DEFAULT '2011-06-07 01:10:26', PRIMARY KEY (`col546`,`a17`,`col543`) USING HASH KEY_BLOCK_SIZE=18072, UNIQUE KEY `idx583` (`col546`,`a17`,`col543`) USING HASH, UNIQUE KEY `idx574` (`col539`(31)) USING HASH, UNIQUE KEY `idx581` (`col550`,`col559`,`col544`,`col552`(122),`col549`) USING HASH, UNIQUE KEY `idx582` (`col554`,`col552`(120),`col559`), KEY `idx578` (`col549`,`col558`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=6025568 MAX_ROWS=146731 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t18` -- DROP TABLE IF EXISTS `t18`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t18` ( `a18` int(10) unsigned NOT NULL, `col560` binary(1) DEFAULT NULL, `col561` date DEFAULT '2010-12-20', `col564` binary(1) NOT NULL DEFAULT '\0', `col566` mediumint(8) unsigned DEFAULT '8416', `col567` tinyblob, `col569` double unsigned NOT NULL DEFAULT '57089', `col571` double unsigned zerofill DEFAULT '00000000000020790.5667', `col572` binary(1) DEFAULT NULL, `col573` varbinary(31) DEFAULT NULL, `col575` tinyblob NOT NULL, `col576` year(4) DEFAULT '0000', `col577` mediumtext, `col579` blob, `col580` datetime DEFAULT '2011-08-15 06:21:55', `col581` varchar(247) NOT NULL DEFAULT 'mglrxhfpaaysapxljmdxygkhfvsmfncnggspyjgsxnuhjfnokfgxkqbeotspqyonvrmeqfgpejyhlrihkccxnxswkpgslassditqfinqyvarsexpbxulmkkfdqhhpficqyocdxlxgakkrqsqehqybydntjxsvziefiruuhgafiruicxkhlorpvqfmqoleqxmbttzshppfkckl', `col582` decimal(9,1) unsigned zerofill DEFAULT '00016996.9', `col583` enum('pvrdtxwmwr','yk','wna','pzuwek','nyjx','qyaadqmdo') DEFAULT NULL, `col584` int(10) unsigned DEFAULT '54224', `col585` tinyblob, `col586` timestamp NOT NULL DEFAULT '2010-07-23 06:20:08', `col591` datetime DEFAULT '2011-08-22 21:18:48', `col592` timestamp NOT NULL DEFAULT '2011-06-01 23:18:36', `col593` mediumtext, `col594` set('vphh','ufyqiodbj','asgbujqxw') DEFAULT NULL, `col595` blob, `col597` date DEFAULT '2011-04-24', `col598` blob, `col600` timestamp NOT NULL DEFAULT '2010-07-26 22:06:43', `col601` double DEFAULT '-91010', `col602` set('','bgjgohebot','h','qpnsill','zrn','','rkdrfg','dvekhpjrmx','xytwqgsy') DEFAULT NULL, `col604` float unsigned zerofill DEFAULT '000000012923', `col606` decimal(49,27) unsigned zerofill DEFAULT '0000000000000000056886.408400000000000000000000000', `col607` longblob, `col608` varbinary(22) DEFAULT NULL, `col609` int(11) DEFAULT '-76795', `col611` timestamp NOT NULL DEFAULT '2010-03-29 18:04:26', PRIMARY KEY (`col564`,`col581`(161),`col569`,`col575`(130)) USING BTREE KEY_BLOCK_SIZE=4126, UNIQUE KEY `idx595` (`col586`,`col571`,`col604`,`col582`) USING HASH, UNIQUE KEY `idx598` (`col609`) USING BTREE, UNIQUE KEY `idx606` (`col566`), UNIQUE KEY `idx620` (`col560`,`col583`,`col572`,`col576`), UNIQUE KEY `idx628` (`col584`) USING HASH, UNIQUE KEY `idx607` (`col582`,`col581`(10),`col561`,`col585`(108),`col569`) USING HASH, UNIQUE KEY `idx610` (`col581`(78),`col608`(1),`col576`,`col611`,`col585`(46)) USING HASH, KEY `idx584` (`col583`) USING BTREE, KEY `idx587` (`col564`,`col581`(67),`col569`,`col575`(115)) USING BTREE, KEY `idx588` (`col561`) USING HASH, KEY `idx611` (`col577`(216),`col601`,`col586`) USING BTREE, KEY `idx616` (`col560`,`col579`(38),`col591`,`col575`(182)) USING BTREE, KEY `idx622` (`col600`,`col581`(98),`col592`), KEY `idx629` (`col566`,`col608`(18),`col597`,`col564`,`col601`) USING HASH, KEY `idx633` (`col577`(145),`col564`,`col593`(30),`col567`(102)) USING HASH, KEY `idx638` (`col593`(3),`col576`,`col566`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9097738 MAX_ROWS=9072137 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t19` -- DROP TABLE IF EXISTS `t19`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t19` ( `a19` int(10) unsigned NOT NULL, `col612` bigint(20) unsigned DEFAULT '8279', `col615` decimal(33,21) unsigned zerofill DEFAULT '000000061981.000000000000000000000', `col617` datetime DEFAULT '2011-04-04 01:00:24', `col619` timestamp NOT NULL DEFAULT '2010-08-28 03:16:40', `col621` text NOT NULL, `col622` time DEFAULT '05:57:08', `col623` tinytext, `col625` date DEFAULT '2010-01-22', `col626` float unsigned DEFAULT '68341', `col627` timestamp NOT NULL DEFAULT '2010-05-22 13:44:59', `col628` text, PRIMARY KEY (`col621`(33)) USING BTREE KEY_BLOCK_SIZE=20954, UNIQUE KEY `idx639` (`col621`(61)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9557641 MAX_ROWS=1592749 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t2` -- DROP TABLE IF EXISTS `t2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t2` ( `a2` int(10) unsigned zerofill NOT NULL, `col6` time DEFAULT '13:07:52', `col7` char(54) CHARACTER SET utf8 DEFAULT 'outzuvxystozaheygoifwksijrhbox', `col8` float unsigned DEFAULT '99999', `col9` bigint(20) NOT NULL DEFAULT '99999', `col10` time DEFAULT '20:50:58', `col11` date DEFAULT '2010-05-10', `col13` date DEFAULT '2010-10-17', `col14` tinyblob NOT NULL, `col15` varbinary(40) NOT NULL DEFAULT '', `col16` datetime DEFAULT '2010-01-07 22:45:35', `col17` time DEFAULT '11:31:29', `col18` blob NOT NULL, `col20` varbinary(10) DEFAULT NULL, `col22` double unsigned zerofill DEFAULT '00000000000001734.3043', `col28` time DEFAULT '05:45:02', PRIMARY KEY (`col15`(8),`col14`(155),`col18`(43),`col9`) USING BTREE KEY_BLOCK_SIZE=18880, UNIQUE KEY `idx25` (`col14`(61),`col15`(18),`col16`,`col6`) USING BTREE, UNIQUE KEY `idx30` (`col9`,`col7`(28),`col18`(179),`col16`), UNIQUE KEY `idx33` (`col10`,`col8`,`col15`(14),`col16`,`col20`(1),`col11`,`col7`(18)), UNIQUE KEY `idx39` (`col7`(16),`col18`(18)) USING HASH, UNIQUE KEY `idx47` (`col16`,`col28`,`col15`(38),`col18`(134)), UNIQUE KEY `idx52` (`col20`(9),`col9`) USING BTREE, UNIQUE KEY `idx56` (`col28`,`col10`,`col8`,`col13`,`col20`(6)), UNIQUE KEY `idx57` (`col15`(29),`col14`(214),`col18`(7),`col9`) USING BTREE, UNIQUE KEY `idx59` (`a2`,`col7`(29)) USING HASH, UNIQUE KEY `idx64` (`col14`(242),`col11`) USING BTREE, KEY `idx32` (`col22`,`col15`(33),`col10`,`col11`,`col6`,`col17`,`col8`) USING BTREE, KEY `idx35` (`col14`(162),`a2`) USING BTREE, KEY `idx44` (`col18`(141),`col7`(48),`col8`,`col9`,`col6`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=7116662 MAX_ROWS=5843247 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t20` -- DROP TABLE IF EXISTS `t20`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t20` ( `a20` int(10) unsigned NOT NULL, `col629` blob NOT NULL, `col630` bigint(20) unsigned zerofill DEFAULT '00000000000000086545', `col631` double unsigned zerofill DEFAULT '00000000000041904.6041', `col632` double DEFAULT '69618.1072', `col633` double unsigned DEFAULT '52241', `col635` date NOT NULL DEFAULT '2010-01-29', `col637` binary(1) NOT NULL DEFAULT '\0', `col638` time DEFAULT '08:04:48', `col639` float unsigned zerofill DEFAULT '000000030040', `col641` longblob NOT NULL, `col642` timestamp NOT NULL DEFAULT '2010-07-07 19:49:04', `col643` decimal(48,21) unsigned DEFAULT '98105.779400000000000000000', `col645` char(167) CHARACTER SET utf8 DEFAULT NULL, `col646` datetime NOT NULL DEFAULT '2011-03-26 02:10:36', `col648` blob, `col651` decimal(24,0) unsigned NOT NULL DEFAULT '56571', PRIMARY KEY (`col637`,`col641`(57),`col629`(252),`col651`,`col646`,`col635`) USING HASH KEY_BLOCK_SIZE=20435, UNIQUE KEY `idx650` (`a20`) USING HASH, UNIQUE KEY `idx651` (`col631`,`col632`,`col637`,`col635`,`col639`,`col651`) USING HASH, UNIQUE KEY `idx669` (`col643`,`col638`,`col642`,`col630`,`col632`,`col651`,`col631`) USING HASH, UNIQUE KEY `idx670` (`col633`,`col635`,`col638`) USING BTREE, UNIQUE KEY `idx647` (`col637`,`col641`(214),`col629`(185),`col651`,`col646`,`col635`) USING HASH, UNIQUE KEY `idx656` (`col630`,`col645`(44),`col648`(242),`col638`,`col632`,`col643`,`col635`) USING HASH, UNIQUE KEY `idx663` (`col630`,`col629`(169),`col645`(9),`a20`,`col651`), UNIQUE KEY `idx665` (`col632`,`col639`,`col638`,`col629`(210)) USING HASH, UNIQUE KEY `idx671` (`col629`(144),`col641`(248),`col637`) USING BTREE, UNIQUE KEY `idx674` (`col639`,`col635`,`col629`(35),`col651`) USING HASH, KEY `idx648` (`col637`,`col630`,`col631`,`col642`) USING HASH, KEY `idx654` (`col646`,`col641`(83),`col651`,`col633`,`col639`), KEY `idx657` (`col646`,`col631`,`a20`,`col643`,`col633`) USING HASH, KEY `idx664` (`col635`,`col630`,`col643`,`col642`,`col638`,`col633`), KEY `idx666` (`col648`(243),`col637`,`col633`), KEY `idx667` (`col629`(97),`col642`,`col646`,`col632`,`col630`) USING BTREE, KEY `idx668` (`col648`(172),`a20`,`col637`,`col641`(200)) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5782109 MAX_ROWS=7927584 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t21` -- DROP TABLE IF EXISTS `t21`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t21` ( `a21` int(10) unsigned NOT NULL, `col652` tinytext, `col653` blob, PRIMARY KEY (`a21`) KEY_BLOCK_SIZE=11316, UNIQUE KEY `idx691` (`a21`), UNIQUE KEY `idx686` (`col653`(103)), UNIQUE KEY `idx689` (`col653`(92),`col652`(58)) USING BTREE, UNIQUE KEY `idx690` (`col653`(172)), UNIQUE KEY `idx701` (`col652`(234),`a21`) USING HASH, KEY `idx692` (`col653`(178),`col652`(139)), KEY `idx696` (`col652`(16),`col653`(239)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=1970834 MAX_ROWS=1368776 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t22` -- DROP TABLE IF EXISTS `t22`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t22` ( `a22` int(10) unsigned zerofill NOT NULL, `col659` time DEFAULT '02:43:43', `col660` float unsigned zerofill DEFAULT '000008155.34', `col661` mediumblob, `col662` mediumblob, `col663` set('taojai','kmkmasfud') DEFAULT NULL, `col664` tinytext, `col665` time NOT NULL DEFAULT '23:57:52', `col666` decimal(60,11) DEFAULT '100000.00000000000', `col667` decimal(36,18) unsigned DEFAULT '39086.546600000000000000', `col670` mediumint(9) DEFAULT '48985', `col671` binary(1) DEFAULT NULL, `col672` varchar(130) NOT NULL DEFAULT 'n', `col674` datetime DEFAULT '2011-07-18 19:08:45', `col675` int(10) unsigned zerofill DEFAULT '0000019219', `col676` date DEFAULT '2010-05-15', `col677` date DEFAULT '2011-02-05', `col678` time DEFAULT '14:45:17', `col679` double unsigned zerofill NOT NULL DEFAULT '0000000000000000100000', `col681` binary(1) NOT NULL DEFAULT '\0', `col682` tinytext, `col683` binary(1) NOT NULL DEFAULT '\0', `col684` datetime DEFAULT '2010-06-13 06:43:55', `col685` mediumtext, `col686` datetime DEFAULT '2011-02-25 05:53:24', `col687` mediumtext, `col688` date DEFAULT '2010-12-04', `col689` timestamp NOT NULL DEFAULT '2010-04-03 00:25:14', `col690` blob, `col691` date DEFAULT '2010-11-16', `col693` timestamp NOT NULL DEFAULT '2011-02-10 13:29:23', `col694` datetime DEFAULT '2010-04-25 13:55:57', `col695` datetime DEFAULT '2010-05-11 02:10:14', `col697` double unsigned zerofill DEFAULT '0000000000000000068107', `col698` enum('ebqwzyuv','wqrh','qmuxxlpzd','gmly','ogyajiybhv','mdyoh','zyewpad','vwcvc','dj') NOT NULL DEFAULT 'ebqwzyuv', `col699` timestamp NOT NULL DEFAULT '2010-06-29 00:15:51', `col700` blob, `col701` timestamp NOT NULL DEFAULT '2011-09-16 22:55:50', PRIMARY KEY (`col683`,`col679`,`col672`(49),`col698`,`col665`,`col681`,`col689`) USING HASH KEY_BLOCK_SIZE=26194, UNIQUE KEY `idx711` (`col693`,`col666`,`col681`,`col691`,`col697`,`col659`,`col698`,`col660`) USING BTREE, UNIQUE KEY `idx704` (`a22`,`col659`,`col663`,`col672`(66),`col671`,`col666`,`col684`,`col677`,`col667`,`col687`(176)), UNIQUE KEY `idx707` (`col681`,`col665`,`col691`,`col688`,`col689`,`col685`(24),`col671`,`col697`,`col690`(42),`col667`,`col666`,`col661`(190)) USING HASH, UNIQUE KEY `idx712` (`col678`,`col693`,`col695`,`col689`,`col687`(107),`col667`,`col674`,`col671`,`col672`(31),`a22`,`col676`) USING BTREE, UNIQUE KEY `idx713` (`a22`,`col681`,`col688`,`col689`,`col660`,`col678`,`col666`,`col659`,`col687`(95),`col667`,`col665`), UNIQUE KEY `idx716` (`col687`(54)) USING BTREE, KEY `idx714` (`col683`,`col679`,`col672`(29),`col698`,`col665`,`col681`,`col689`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5527497 MAX_ROWS=4856630 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t23` -- DROP TABLE IF EXISTS `t23`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t23` ( `a23` int(10) unsigned NOT NULL, `col704` varchar(160) DEFAULT 'kkjhvutjsbikjpyowgfshanguexjnuutgdzzxubtunrcby', `col705` double unsigned zerofill DEFAULT '00000000000072149.9758', `col706` char(255) CHARACTER SET utf8 DEFAULT NULL, `col708` time NOT NULL DEFAULT '12:53:54', `col709` double unsigned DEFAULT '85014', `col710` timestamp NOT NULL DEFAULT '2011-12-02 07:13:56', `col711` char(141) CHARACTER SET utf8 DEFAULT NULL, `col714` time DEFAULT '20:44:30', `col715` time DEFAULT '12:49:24', `col717` varbinary(24) DEFAULT NULL, `col718` varchar(235) CHARACTER SET utf8 DEFAULT 'fuehdqgawrryncsqligfagarwizhnccbdgslpjpiucvgkhkqfdidftlwxhqbbvuhkszmiptipnws', `col720` decimal(58,6) unsigned zerofill DEFAULT '0000000000000000000000000000000000000000000000006187.127300', `col721` date NOT NULL DEFAULT '2011-05-27', `col722` timestamp NOT NULL DEFAULT '2011-04-17 22:05:01', `col723` bigint(20) DEFAULT '91952', `col724` enum('j','fyeevv','omyezcnsh','powhfgnolq','wevgtubc','','zyeb','') DEFAULT NULL, `col726` double unsigned zerofill DEFAULT '00000000000056966.8553', `col728` char(218) CHARACTER SET utf8 DEFAULT 'ipuehvpwoeuhlrllococvezctzjvyuwxhyinwlaktkggtaocxekspqobsnooahufslakhsrgistnprgwwupirhkwrltkddaoqrwplefordwxkikipvtfcssabuogaitfhnpmsqdelpoeyjkvjkftlggzmsvp', `col729` time NOT NULL DEFAULT '14:51:18', `col730` datetime DEFAULT '2011-01-10 16:08:56', `col732` datetime DEFAULT '2011-09-22 17:00:18', `col733` double unsigned DEFAULT '15425', `col734` longtext, `col735` mediumtext, `col736` tinytext, `col737` binary(1) DEFAULT NULL, PRIMARY KEY (`col721`,`col729`,`col708`) USING BTREE KEY_BLOCK_SIZE=29090, UNIQUE KEY `idx726` (`col737`,`col723`,`col720`) USING BTREE, UNIQUE KEY `idx730` (`col721`,`col724`,`a23`,`col730`,`col726`,`col737`) USING BTREE, UNIQUE KEY `idx735` (`col709`,`col726`,`col710`,`col705`,`col721`), UNIQUE KEY `idx733` (`col723`,`col715`,`col704`(116),`col720`), UNIQUE KEY `idx734` (`col734`(74),`col729`,`col737`,`col720`), UNIQUE KEY `idx739` (`col717`(13),`col714`,`col723`,`col735`(79),`col737`) USING HASH, UNIQUE KEY `idx747` (`col715`,`col723`,`a23`,`col732`,`col734`(61)) USING HASH, UNIQUE KEY `idx753` (`col734`(43),`col706`(1),`col718`(49),`col721`,`col724`) USING BTREE, UNIQUE KEY `idx777` (`col724`,`col715`,`col708`,`col736`(40),`col728`(204)), UNIQUE KEY `idx779` (`col722`,`col735`(15)) USING BTREE, UNIQUE KEY `idx780` (`col729`,`col718`(169),`col708`,`col711`(93),`col709`,`col704`(59)), KEY `idx729` (`col715`,`col733`) USING BTREE, KEY `idx731` (`col706`(2),`col728`(165)), KEY `idx738` (`col734`(165),`col735`(43),`col708`,`col710`,`col717`(17),`col726`), KEY `idx742` (`col735`(153),`a23`) USING BTREE, KEY `idx751` (`col734`(85),`a23`,`col724`,`col722`,`col729`) USING HASH, KEY `idx760` (`col721`,`col729`,`col708`) USING BTREE, KEY `idx762` (`col706`(2)) USING HASH, KEY `idx766` (`col720`,`col737`,`col711`(27),`col721`) USING BTREE, KEY `idx768` (`col715`,`col714`,`col718`(80)), KEY `idx770` (`col724`,`col733`,`col705`,`col732`,`col709`) USING HASH, KEY `idx771` (`col710`,`col723`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9188403 MAX_ROWS=8280950 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t24` -- DROP TABLE IF EXISTS `t24`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t24` ( `a24` int(10) unsigned NOT NULL, `col739` datetime DEFAULT '2010-10-22 18:49:08', `col740` tinytext NOT NULL, `col741` float unsigned DEFAULT '46483.8', `col743` text, `col744` binary(1) DEFAULT NULL, `col746` longblob, `col747` timestamp NOT NULL DEFAULT '2011-02-01 06:26:04', `col748` double unsigned DEFAULT '54421.7922', `col749` decimal(65,1) DEFAULT '7929.9', `col750` date NOT NULL DEFAULT '2010-05-23', `col751` mediumint(8) unsigned zerofill DEFAULT '00091362', `col752` float unsigned zerofill DEFAULT '000000023204', `col753` float unsigned DEFAULT '15830', `col754` date DEFAULT '2011-03-22', `col755` binary(1) DEFAULT NULL, `col759` datetime DEFAULT '2010-08-09 17:08:52', `col760` date NOT NULL DEFAULT '2010-09-01', PRIMARY KEY (`a24`,`col760`,`col750`,`col747`,`col740`(104)) USING BTREE KEY_BLOCK_SIZE=10514, UNIQUE KEY `idx791` (`col759`,`col741`,`col752`,`col760`) USING BTREE, UNIQUE KEY `idx795` (`col754`,`col751`) USING HASH, UNIQUE KEY `idx820` (`col744`,`col760`,`col754`,`col751`) USING BTREE, UNIQUE KEY `idx825` (`col753`,`col749`), UNIQUE KEY `idx827` (`a24`,`col751`,`col747`) USING HASH, UNIQUE KEY `idx789` (`a24`,`col760`,`col750`,`col747`,`col740`(163)) USING BTREE, UNIQUE KEY `idx803` (`col751`,`col760`,`col743`(48),`col755`,`col746`(75),`col749`), UNIQUE KEY `idx809` (`col743`(71),`col740`(55)) USING BTREE, UNIQUE KEY `idx814` (`col743`(217),`col748`), UNIQUE KEY `idx828` (`col747`,`col743`(30),`col752`,`col749`,`a24`,`col754`) USING BTREE, KEY `idx783` (`col759`,`col752`,`col747`,`col741`,`col755`) USING BTREE, KEY `idx785` (`col744`,`col759`) USING BTREE, KEY `idx786` (`col740`(15)) USING BTREE, KEY `idx787` (`col759`,`col752`,`col743`(146),`col744`,`col748`,`col750`), KEY `idx792` (`col741`) USING BTREE, KEY `idx793` (`col753`,`col740`(178)) USING HASH, KEY `idx794` (`col740`(82),`col754`,`col749`), KEY `idx800` (`col749`,`col747`,`col753`), KEY `idx804` (`col749`,`col754`,`col751`,`col739`,`col744`,`col746`(204),`col741`) USING BTREE, KEY `idx808` (`col744`), KEY `idx810` (`col747`,`col751`,`col750`,`col754`,`a24`,`col743`(103)) USING HASH, KEY `idx813` (`col744`,`col739`,`col755`,`col747`,`col748`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9697233 MAX_ROWS=3556108 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t25` -- DROP TABLE IF EXISTS `t25`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t25` ( `a25` int(11) NOT NULL, `col762` double unsigned zerofill DEFAULT '00000000000050529.5244', `col763` date NOT NULL DEFAULT '2010-07-25', `col764` double unsigned zerofill NOT NULL DEFAULT '0000000000000000032928', `col765` timestamp NOT NULL DEFAULT '2009-12-19 23:36:18', `col766` set('utwldk','nhwsvscuqb','yitzhmwgch','svwrm','kzvvoe','spitkq') DEFAULT NULL, `col767` datetime NOT NULL DEFAULT '2011-11-08 18:36:56', `col768` mediumtext NOT NULL, `col770` datetime DEFAULT '2010-12-25 22:02:36', `col772` longblob, `col775` varbinary(29) DEFAULT NULL, `col777` double unsigned DEFAULT '39841.2366', `col779` datetime DEFAULT '2011-03-18 10:57:40', PRIMARY KEY (`col763`,`col764`,`col768`(37),`col767`) USING HASH KEY_BLOCK_SIZE=11952, UNIQUE KEY `idx839` (`col779`,`col762`) USING HASH, UNIQUE KEY `idx843` (`col777`), UNIQUE KEY `idx860` (`col770`), UNIQUE KEY `idx864` (`col779`,`col764`), UNIQUE KEY `idx892` (`col766`), UNIQUE KEY `idx837` (`col765`,`col768`(74)), UNIQUE KEY `idx841` (`a25`,`col768`(202),`col770`), UNIQUE KEY `idx849` (`col767`,`a25`,`col768`(243),`col777`) USING HASH, UNIQUE KEY `idx854` (`col772`(40)) USING HASH, UNIQUE KEY `idx856` (`col775`(15),`col770`,`col762`,`col779`) USING BTREE, UNIQUE KEY `idx881` (`col772`(93),`col765`,`a25`) USING BTREE, KEY `idx833` (`col770`,`col775`(14)), KEY `idx840` (`col770`,`col765`), KEY `idx852` (`col767`,`a25`,`col775`(4)) USING HASH, KEY `idx858` (`col777`,`col772`(142)), KEY `idx861` (`col764`,`col763`) USING BTREE, KEY `idx863` (`col766`,`col777`), KEY `idx865` (`col763`,`col764`,`col768`(215),`col767`) USING HASH, KEY `idx870` (`col770`,`col779`) USING BTREE, KEY `idx872` (`col770`,`col768`(183),`col777`) USING HASH, KEY `idx873` (`col766`,`col765`,`col770`,`col777`) USING HASH, KEY `idx875` (`col772`(139)), KEY `idx877` (`col764`,`col772`(238),`col766`,`col770`), KEY `idx879` (`col767`,`a25`) USING HASH, KEY `idx891` (`col772`(213)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9835209 MAX_ROWS=5532840 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t26` -- DROP TABLE IF EXISTS `t26`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t26` ( `a26` int(11) NOT NULL, `col780` binary(1) NOT NULL DEFAULT '\0', `col784` varbinary(116) DEFAULT NULL, `col785` timestamp NOT NULL DEFAULT '2011-06-30 19:43:14', `col786` longtext NOT NULL, `col787` enum('riubgcp','v','yqt','cqemb','qcdpobozhz','fny','axq','jvp','qtznxjxdmk') NOT NULL DEFAULT 'riubgcp', `col788` float DEFAULT '8760', `col791` mediumtext, PRIMARY KEY (`col786`(167),`col787`,`col785`,`col780`) USING HASH KEY_BLOCK_SIZE=22842, UNIQUE KEY `idx905` (`a26`,`col788`,`col780`,`col785`) USING HASH, UNIQUE KEY `idx903` (`col784`(63)), UNIQUE KEY `idx911` (`col791`(159),`col788`,`col785`,`col784`(42),`col786`(43)) USING HASH, UNIQUE KEY `idx915` (`col780`,`col791`(51),`a26`,`col784`(64),`col787`,`col788`,`col785`) USING BTREE, UNIQUE KEY `idx919` (`col780`,`col784`(50),`col788`,`col785`,`col787`,`a26`,`col786`(19)) USING BTREE, UNIQUE KEY `idx924` (`col785`,`col787`,`col791`(113),`col786`(155)) USING BTREE, UNIQUE KEY `idx928` (`col786`(4),`col788`) USING HASH, KEY `idx901` (`col791`(72),`col780`,`col785`,`col784`(101),`col786`(68)) USING BTREE, KEY `idx907` (`col787`,`col786`(133),`col785`,`col791`(160),`col780`,`a26`), KEY `idx908` (`col786`(146),`col787`,`col785`,`col780`) USING HASH, KEY `idx927` (`col787`,`col784`(102),`col788`,`col785`,`col780`,`col791`(113),`col786`(7)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3933977 MAX_ROWS=2171451 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t27` -- DROP TABLE IF EXISTS `t27`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t27` ( `a27` int(11) NOT NULL, `col793` tinyblob NOT NULL, `col794` enum('bkywfmoes','vbz','bhoqdjsjpe','tafwp','hhqqkpeiw','p','','blcxczyn') NOT NULL DEFAULT 'bkywfmoes', `col795` set('uyusruvz','qzoln','u','','wgto','kbgkduom','ezti','t','','vaxifm') DEFAULT NULL, `col796` double unsigned zerofill DEFAULT '0000000000000000007254', `col797` char(90) CHARACTER SET utf8 NOT NULL DEFAULT 'jmmjjgkkapwxokcl', `col799` datetime DEFAULT '2011-04-06 03:37:22', `col800` timestamp NOT NULL DEFAULT '2011-10-29 10:28:08', `col801` enum('','e','qretan','iivncau','vcngfxr','','gdswm','dnguolf') NOT NULL DEFAULT '', `col803` double unsigned zerofill NOT NULL DEFAULT '00000000000063056.8042', `col804` varbinary(95) DEFAULT NULL, `col805` varbinary(24) NOT NULL DEFAULT '', `col806` mediumtext, `col807` time DEFAULT '07:22:22', `col808` tinyint(1) DEFAULT NULL, `col810` binary(1) DEFAULT NULL, `col812` timestamp NOT NULL DEFAULT '2010-01-16 17:16:32', `col813` binary(1) NOT NULL DEFAULT '\0', `col814` timestamp NOT NULL DEFAULT '2011-08-12 11:22:14', `col815` varbinary(89) NOT NULL DEFAULT '', `col816` timestamp NOT NULL DEFAULT '2009-12-28 18:44:00', `col817` longtext, `col820` datetime DEFAULT '2011-05-13 02:40:30', `col821` int(10) unsigned zerofill DEFAULT '0000034385', `col822` set('ombvnu','txmrgvtxyy','') DEFAULT NULL, `col823` timestamp NOT NULL DEFAULT '2011-03-26 12:38:21', `col824` enum('hrhq','rg','wgxex','iogtrd','qvokyx','tnulytrz','y','nj','phbfkyt','dhuspkpg') DEFAULT NULL, `col825` bigint(20) unsigned zerofill DEFAULT '00000000000000019280', `col826` tinyblob, `col834` binary(1) DEFAULT NULL, `col835` int(10) unsigned zerofill DEFAULT '0000096531', `col836` double unsigned zerofill DEFAULT '00000000000044813.9755', `col837` time DEFAULT '04:43:58', `col839` datetime DEFAULT '2011-08-05 08:08:16', `col840` binary(1) NOT NULL DEFAULT '\0', `col841` set('rbktmz','ncpxethn','rfzmwryskh','yv','lfjc','nqdqjm','upiayertl') DEFAULT NULL, `col842` datetime DEFAULT '2010-07-30 06:49:21', `col844` datetime NOT NULL DEFAULT '2010-07-23 20:42:05', `col845` binary(1) DEFAULT NULL, `col846` bigint(20) unsigned zerofill NOT NULL DEFAULT '00000000000000046689', `col849` timestamp NOT NULL DEFAULT '2010-09-01 10:47:56', `col850` date DEFAULT '2010-02-01', PRIMARY KEY (`col805`(23),`col840`,`col844`,`col813`,`col797`(71),`col815`(50),`col803`,`col801`,`col793`(95),`col846`,`col823`,`col794`) USING BTREE KEY_BLOCK_SIZE=12402, UNIQUE KEY `idx931` (`col807`,`col812`,`col842`,`col800`,`col795`,`col804`(26),`col813`,`col840`) USING BTREE, UNIQUE KEY `idx938` (`col826`(214),`col820`,`col806`(68),`col834`,`col813`) USING HASH, UNIQUE KEY `idx944` (`col834`,`col805`(1),`col826`(177),`col814`,`col842`,`col808`,`col825`,`col845`,`col839`) USING HASH, UNIQUE KEY `idx945` (`col835`,`col826`(102),`col839`,`col840`,`col797`(36),`col813`,`col822`,`col794`,`col801`,`col800`) USING HASH, UNIQUE KEY `idx950` (`col805`(9),`col840`,`col844`,`col813`,`col797`(88),`col815`(24),`col803`,`col801`,`col793`(51),`col846`,`col823`,`col794`) USING BTREE, UNIQUE KEY `idx957` (`col804`(34),`col810`,`col799`,`col849`) USING HASH, UNIQUE KEY `idx961` (`col834`,`a27`,`col795`,`col839`,`col804`(1),`col810`,`col814`,`col800`,`col799`) USING HASH, UNIQUE KEY `idx963` (`col824`,`col835`,`col806`(217)) USING BTREE, KEY `idx934` (`col810`,`col814`,`col840`,`col822`,`col805`(1)) USING HASH, KEY `idx941` (`col797`(13),`col796`,`col799`,`col817`(139),`col800`,`col823`,`col810`,`col795`,`col805`(2)) USING HASH, KEY `idx942` (`col800`,`col820`,`col850`,`col826`(167),`a27`,`col813`), KEY `idx943` (`col837`,`col849`,`col821`,`a27`,`col806`(173),`col794`,`col846`,`col795`,`col836`,`col835`,`col815`(48),`col820`) USING HASH, KEY `idx947` (`col825`,`col817`(210),`col810`,`col824`,`col845`,`col794`,`col801`,`col806`(207),`col841`,`col814`), KEY `idx949` (`col834`,`col840`,`col815`(88),`col839`,`col807`,`col825`,`col835`) USING BTREE, KEY `idx953` (`col836`,`col840`,`a27`) USING BTREE, KEY `idx954` (`col794`,`col835`,`col812`,`col821`,`col804`(87),`col841`,`col834`,`col815`(70),`col849`,`col846`), KEY `idx968` (`col840`,`col816`,`col810`,`col820`,`col846`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5107717 MAX_ROWS=6282042 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t28` -- DROP TABLE IF EXISTS `t28`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t28` ( `a28` int(10) unsigned zerofill NOT NULL, `col851` datetime NOT NULL DEFAULT '2011-11-05 21:06:51', `col852` binary(1) NOT NULL DEFAULT '\0', `col853` set('ykopszr','g','djgivfl','b') DEFAULT NULL, `col854` mediumtext, `col855` enum('mwjxwahd','') DEFAULT NULL, `col856` time NOT NULL DEFAULT '06:11:00', `col857` bigint(20) DEFAULT '83581', `col860` time DEFAULT '21:14:25', `col861` date DEFAULT '2010-03-24', `col862` double unsigned zerofill NOT NULL DEFAULT '0000000000000000063001', `col864` timestamp NOT NULL DEFAULT '2011-01-28 22:06:20', `col868` time DEFAULT '02:31:31', `col869` varbinary(24) DEFAULT NULL, `col870` decimal(10,2) unsigned DEFAULT '23167.06', `col871` tinytext, `col873` time DEFAULT '01:11:18', `col876` decimal(58,29) DEFAULT '7097.21780000000000000000000000000', `col877` date NOT NULL DEFAULT '2011-06-08', `col880` binary(1) NOT NULL DEFAULT '\0', `col881` varbinary(239) DEFAULT NULL, `col882` set('zzwuf','mkmfci','qcqbhjo','sek','kwq') DEFAULT NULL, `col883` timestamp NOT NULL DEFAULT '2010-11-12 13:22:25', `col884` blob, `col885` double unsigned zerofill NOT NULL DEFAULT '0000000000000000063328', `col886` datetime DEFAULT '2011-07-01 03:00:00', `col887` varbinary(208) NOT NULL DEFAULT '', `col888` blob, `col889` double unsigned zerofill NOT NULL DEFAULT '0000000000000000043375', `col890` text NOT NULL, `col891` timestamp NOT NULL DEFAULT '2010-01-03 06:43:37', `col893` timestamp NOT NULL DEFAULT '2010-03-29 08:06:13', `col894` time DEFAULT '06:36:34', `col895` mediumtext NOT NULL, `col897` binary(1) DEFAULT NULL, PRIMARY KEY (`col887`(104),`col856`,`col895`(207),`col883`,`col851`,`col877`,`col885`,`col852`,`col890`(150),`col893`,`col880`,`col862`,`col889`) USING HASH KEY_BLOCK_SIZE=985, UNIQUE KEY `idx1000` (`col882`,`col880`,`col873`) USING BTREE, UNIQUE KEY `idx973` (`col895`(119),`col897`,`col861`,`col853`,`col854`(181),`col870`), UNIQUE KEY `idx978` (`col862`,`col897`,`col886`,`col895`(161),`col890`(116),`col893`) USING BTREE, UNIQUE KEY `idx985` (`col870`,`col857`,`col854`(24),`col880`,`col881`(154),`col877`,`col873`,`a28`,`col886`,`col853`,`col856`) USING HASH, UNIQUE KEY `idx987` (`col891`,`col894`,`col869`(1),`col884`(40),`col882`) USING HASH, UNIQUE KEY `idx988` (`col894`,`col855`,`col891`,`col890`(240),`col856`) USING BTREE, UNIQUE KEY `idx989` (`col877`,`col861`,`col881`(206)) USING BTREE, UNIQUE KEY `idx998` (`col876`,`col857`,`col895`(8),`col864`,`col894`,`col856`,`col855`,`col887`(180),`col853`,`col861`,`col869`(1),`a28`) USING BTREE, UNIQUE KEY `idx1001` (`col852`,`col864`,`col871`(179),`col880`,`col893`,`col897`,`col895`(41),`col854`(255),`col868`,`col861`) USING BTREE, UNIQUE KEY `idx1002` (`col884`(54),`col888`(200),`col889`,`col883`,`col887`(11),`col881`(66),`col860`,`col864`) USING HASH, UNIQUE KEY `idx1004` (`col861`,`col873`,`col885`,`a28`,`col894`,`col869`(12),`col881`(3)) USING HASH, UNIQUE KEY `idx1005` (`col868`,`col890`(110),`col888`(211),`a28`,`col886`,`col854`(25),`col882`,`col897`,`col873`,`col857`,`col894`), UNIQUE KEY `idx1009` (`col886`,`col851`,`col854`(83),`col862`,`col883`,`a28`,`col861`,`col853`,`col890`(18),`col882`,`col891`,`col871`(44)) USING HASH, UNIQUE KEY `idx1018` (`col853`,`col861`,`col871`(125)), UNIQUE KEY `idx1020` (`col852`,`col889`,`col876`,`a28`,`col882`,`col853`,`col861`,`col895`(54),`col856`,`col870`,`col877`,`col885`) USING HASH, UNIQUE KEY `idx1022` (`col882`,`col881`(28),`col890`(8)) USING BTREE, KEY `idx972` (`col887`(101),`col856`,`col895`(102),`col883`,`col851`,`col877`,`col885`,`col852`,`col890`(255),`col893`,`col880`,`col862`,`col889`) USING HASH, KEY `idx975` (`col881`(58),`col882`,`col871`(131),`col851`,`col868`,`col853`,`col876`,`col869`(9),`col888`(6),`col857`,`col886`) USING BTREE, KEY `idx976` (`col851`,`col881`(168),`col876`,`col886`,`col854`(243),`col885`,`col852`,`col882`,`col868`), KEY `idx984` (`col889`,`col864`,`col880`,`col897`,`col856`,`col854`(19),`col884`(78),`col888`(107),`a28`,`col895`(193)) USING HASH, KEY `idx986` (`col861`,`col895`(17),`col882`,`col857`,`col884`(203),`col877`,`col854`(84),`col876`,`col890`(1),`col887`(137),`col894`,`col891`) USING BTREE, KEY `idx995` (`col856`,`col883`,`col871`(63),`col876`,`col886`,`col895`(62),`col884`(95)), KEY `idx1007` (`col880`,`col870`,`col890`(85),`col885`,`col852`,`col861`,`col855`,`col887`(194),`col886`,`col868`,`col877`), KEY `idx1010` (`col861`,`col880`,`col851`,`col888`(83),`col884`(131),`col860`,`col886`,`col885`,`col873`,`col877`), KEY `idx1011` (`col871`(145),`col890`(149),`col862`,`col869`(14),`col881`(142),`col854`(153),`col877`,`col851`), KEY `idx1014` (`col860`,`col891`,`col889`,`col897`,`a28`,`col881`(111),`col855`,`col876`,`col883`,`col869`(19),`col862`,`col853`,`col885`,`col887`(62)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=2842084 MAX_ROWS=3035943 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t29` -- DROP TABLE IF EXISTS `t29`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t29` ( `a29` int(10) unsigned zerofill NOT NULL, `col899` time DEFAULT '06:45:32', `col900` double unsigned zerofill DEFAULT '0000000000000000051148', `col903` time DEFAULT '06:27:26', `col904` double unsigned zerofill DEFAULT NULL, `col905` time DEFAULT '00:33:00', `col909` timestamp NOT NULL DEFAULT '2011-03-28 08:49:27', `col910` timestamp NOT NULL DEFAULT '2010-04-19 08:23:45', `col911` longtext, `col912` set('ru','h','zzuqzrpmqv','copop') DEFAULT NULL, `col913` enum('mdsf','','uopkacjvka','h') DEFAULT NULL, `col914` mediumtext NOT NULL, `col915` blob, `col916` timestamp NOT NULL DEFAULT '2010-12-21 01:50:17', `col917` binary(1) DEFAULT NULL, `col918` longblob, `col919` date DEFAULT '2010-05-16', `col921` mediumtext, `col923` datetime DEFAULT '2010-02-11 11:33:15', `col924` text, `col925` time DEFAULT '04:54:26', `col926` datetime DEFAULT '2010-11-18 11:25:02', `col927` varbinary(83) DEFAULT NULL, `col928` date DEFAULT '2011-08-06', `col930` datetime DEFAULT '2010-11-07 13:42:54', `col932` time DEFAULT '15:23:13', `col933` binary(1) DEFAULT NULL, `col934` double unsigned zerofill DEFAULT '0000000000000000030538', `col936` datetime DEFAULT '2010-07-05 11:05:46', `col937` tinyint(1) DEFAULT NULL, `col938` decimal(19,1) DEFAULT '36254.3', `col939` tinytext, `col940` time DEFAULT '23:38:36', PRIMARY KEY (`col909`,`col914`(49)) USING BTREE KEY_BLOCK_SIZE=3003, UNIQUE KEY `idx1082` (`a29`) USING BTREE, UNIQUE KEY `idx1036` (`col937`,`col903`,`col928`,`col930`,`col923`), UNIQUE KEY `idx1076` (`col904`,`col934`) USING BTREE, UNIQUE KEY `idx1027` (`col939`(137),`col905`,`col924`(77),`col909`,`col925`,`col904`) USING BTREE, UNIQUE KEY `idx1041` (`col927`(80),`col916`,`col915`(198),`col925`,`col909`,`col937`) USING HASH, UNIQUE KEY `idx1042` (`col913`,`col927`(65),`col914`(55),`col910`,`col911`(102),`col903`,`col919`,`col938`), UNIQUE KEY `idx1045` (`col938`,`col905`,`col939`(241),`col925`,`col910`,`col921`(243),`col899`,`col933`,`col923`), UNIQUE KEY `idx1046` (`col924`(237),`col911`(214)), UNIQUE KEY `idx1053` (`col934`,`col913`,`col925`,`col939`(128),`col918`(253),`a29`,`col940`,`col915`(176),`col911`(234)) USING HASH, UNIQUE KEY `idx1057` (`col903`,`col913`,`col930`,`col910`,`col936`,`col924`(103),`col934`,`col938`,`col923`,`col914`(167),`col933`) USING BTREE, UNIQUE KEY `idx1060` (`col917`,`col912`,`col903`,`col940`,`col900`,`col939`(254),`col904`,`col921`(4),`col918`(246)), UNIQUE KEY `idx1063` (`col939`(66),`col926`,`col912`,`col910`) USING HASH, UNIQUE KEY `idx1069` (`col913`,`col911`(23),`col918`(39),`col900`,`col917`,`col914`(52)), UNIQUE KEY `idx1080` (`col936`,`col928`,`col916`,`col937`,`col921`(40),`col939`(195),`col930`) USING HASH, UNIQUE KEY `idx1086` (`col904`,`col899`,`col936`,`col927`(47),`col924`(124),`col903`,`col910`,`col940`,`col918`(154)) USING HASH, KEY `idx1029` (`col936`,`col921`(156),`col918`(23),`col926`,`a29`,`col934`,`col913`,`col912`), KEY `idx1034` (`col919`,`col925`,`col932`,`col939`(139),`col928`,`col933`,`col940`) USING HASH, KEY `idx1049` (`col939`(12),`col940`,`col905`,`col938`,`col904`,`col911`(107),`col909`,`col921`(185)), KEY `idx1056` (`col923`,`col930`) USING BTREE, KEY `idx1064` (`col925`) USING BTREE, KEY `idx1077` (`col934`) USING HASH, KEY `idx1084` (`col917`,`col904`), KEY `idx1087` (`col909`,`col914`(98)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3369114 MAX_ROWS=5417670 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t3` -- DROP TABLE IF EXISTS `t3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t3` ( `a3` int(10) unsigned zerofill NOT NULL, `col31` float unsigned zerofill DEFAULT '000000052014', `col32` longblob, `col33` timestamp NOT NULL DEFAULT '2010-02-10 07:26:52', `col36` double unsigned zerofill DEFAULT '0000000000000000083945', `col37` datetime DEFAULT '2011-01-13 04:24:55', `col39` float unsigned zerofill DEFAULT '000000005041', `col40` date DEFAULT '2011-10-13', `col42` longblob, `col43` date DEFAULT '2010-05-02', `col44` float unsigned zerofill DEFAULT '000000063600', `col45` mediumint(8) unsigned zerofill DEFAULT '00065273', `col46` date DEFAULT '2010-03-27', `col47` datetime DEFAULT '2011-10-03 15:02:56', `col48` int(11) DEFAULT '-8129', `col49` longtext, `col50` double unsigned DEFAULT '91617', `col51` date DEFAULT '2010-09-24', `col55` blob, `col56` datetime DEFAULT '2009-12-06 01:23:03', `col57` tinytext, `col58` int(10) unsigned zerofill DEFAULT '0000094831', `col59` time DEFAULT '07:23:46', `col62` blob, `col63` decimal(47,5) unsigned zerofill DEFAULT '000000000000000000000000000000000000100000.00000', `col65` double DEFAULT '-41406', `col66` enum('zmopdibtq','nawky','cxrr','rrkixb','cnyhqn','zsn','blmtwief','cjmcohgx','ulrvpz','ykgrgjobwt') DEFAULT NULL, `col67` tinyblob, `col68` date DEFAULT '2011-04-30', `col69` text, `col72` date DEFAULT '2011-06-19', `col73` datetime DEFAULT '2011-06-14 16:52:01', `col74` year(2) DEFAULT '00', `col75` date DEFAULT '2011-07-07', PRIMARY KEY (`a3`) USING HASH KEY_BLOCK_SIZE=15898, UNIQUE KEY `idx92` (`a3`) USING HASH, UNIQUE KEY `idx78` (`col31`,`col74`,`col47`,`col57`(240),`col68`,`col32`(37),`col56`,`col65`,`col48`,`col37`,`col67`(96),`col50`,`col73`,`col51`), KEY `idx74` (`col55`(153),`col56`,`col46`,`col40`,`col62`(244),`col31`,`col59`,`col58`), KEY `idx76` (`col44`,`col48`,`col32`(189),`col62`(215),`col56`,`col46`,`col73`), KEY `idx85` (`col31`,`col73`,`col42`(8)), KEY `idx86` (`col66`,`col59`,`col73`,`col46`,`col36`,`col47`,`col48`,`col63`,`col51`,`col56`,`col39`), KEY `idx87` (`col63`,`col40`,`col46`,`col68`,`col58`,`col56`,`col55`(223),`col74`,`col39`,`col69`(44),`col75`,`a3`,`col59`) USING BTREE, KEY `idx91` (`col47`) USING HASH, KEY `idx99` (`col51`,`col46`,`col58`,`col39`,`col65`,`col67`(199),`a3`,`col66`) USING BTREE, KEY `idx102` (`col42`(128),`col45`,`col33`,`col62`(32),`col59`,`col66`,`col75`,`col47`,`col36`,`col72`,`col44`,`col73`,`col49`(135)), KEY `idx105` (`col37`,`col39`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=7966612 MAX_ROWS=3783712 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t30` -- DROP TABLE IF EXISTS `t30`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t30` ( `a30` int(10) unsigned zerofill NOT NULL, `col941` datetime DEFAULT '2011-08-18 03:42:47', `col942` float unsigned zerofill DEFAULT '000000015829', `col943` binary(1) DEFAULT NULL, `col944` mediumtext, `col945` datetime DEFAULT '2010-01-19 06:59:16', `col946` date DEFAULT '2011-09-23', `col947` datetime DEFAULT '2011-09-01 10:30:52', `col948` tinyblob, `col949` char(84) CHARACTER SET utf8 DEFAULT NULL, `col950` date DEFAULT '2010-12-23', `col951` binary(1) DEFAULT NULL, `col952` decimal(34,22) unsigned zerofill DEFAULT '000000042019.5560000000000000000000', `col953` set('jnhdsmjfup','','lstjoaw','rglpmq','r','ggt','bmhxbqn','vxreid') DEFAULT NULL, `col955` time DEFAULT '12:29:54', `col956` datetime DEFAULT '2011-03-08 00:26:06', `col957` datetime DEFAULT '2010-06-05 04:14:47', `col958` decimal(8,3) unsigned zerofill DEFAULT '61328.771', `col959` char(209) DEFAULT 'eizshuoxgrafzeetlimwuqpdwxkvmukxeopbxvysxguxphobzmxuwjvneqifkyghdneivydhqalrcbkafkphpxtailpmxhtgeiaubnvnaixwqdogpheqeckegkzrxplnmnfmdqbuxhkzfhonuzvjj', `col962` date DEFAULT '2010-04-27', `col963` date DEFAULT '2010-01-18', `col964` char(202) CHARACTER SET utf8 DEFAULT 'xkaxcpucjmkdtigkbptkoui', `col965` date DEFAULT '2011-10-14', `col967` int(11) DEFAULT '27907', `col968` blob, `col970` time DEFAULT '08:49:30', `col971` enum('sykmhlptj','fsjrcxndiu','tveao','kudjuw','z','uvif','jpidun','fdcsugeczh') DEFAULT NULL, `col972` tinyblob, `col973` varchar(171) CHARACTER SET utf8 DEFAULT 'yzogddipnttdtjnhfviqwpktgyvybldrzzufxdhcaqlxguquuxkdqdgiamsmcxltrsthlclsajgmzdbnmwmiddanuxlihleqrekjig', `col974` binary(1) DEFAULT NULL, `col976` char(214) DEFAULT 'pllrhreythfrzikxlkrssbsgcxcxusnpsyujzutzvzjgqtdlwghzfvlioekaqsteyfaoeicocyysi', `col977` tinytext, `col978` varchar(154) DEFAULT 'rjvhfddwksekwyvwchgihmptjavpivlwoskjbwcnbdcgjcdfdlnmsdhfyomxbehqwtpllibamajqslgwdugpnzwvpbmyzydczcbgovpludctnnmxwcaivfcxokeglkbhv', `col980` float unsigned zerofill DEFAULT '000000098447', `col981` decimal(31,25) unsigned zerofill DEFAULT '100001.0000000000000000000000000', `col982` blob, `col983` decimal(61,19) unsigned zerofill DEFAULT '000000000000000000000000000000000000005039.0000000000000000000', `col986` tinyblob, `col988` datetime NOT NULL DEFAULT '2011-08-17 23:14:50', `col989` float unsigned DEFAULT '98449.4', `col991` longblob, PRIMARY KEY (`col988`,`a30`) USING HASH KEY_BLOCK_SIZE=20229, UNIQUE KEY `idx1098` (`col988`,`a30`) USING HASH, UNIQUE KEY `idx1093` (`col959`(92)) USING BTREE, UNIQUE KEY `idx1102` (`col962`,`col980`,`col957`,`col978`(153),`col982`(37)) USING HASH, KEY `idx1099` (`col991`(66),`col957`,`col989`,`a30`) USING HASH, KEY `idx1101` (`col959`(156)) USING HASH, KEY `idx1104` (`col952`,`a30`,`col981`,`col988`,`col971`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9393448 MAX_ROWS=9124475 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t31` -- DROP TABLE IF EXISTS `t31`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t31` ( `a31` int(10) unsigned zerofill NOT NULL, `col993` datetime DEFAULT '2011-02-03 02:04:13', `col996` timestamp NOT NULL DEFAULT '2011-11-09 12:51:28', `col997` time DEFAULT '19:13:27', `col998` float unsigned zerofill DEFAULT '0000057135.4', `col999` time NOT NULL DEFAULT '22:33:09', `col1000` char(147) CHARACTER SET utf8 DEFAULT NULL, `col1001` datetime DEFAULT '2010-10-15 05:33:47', `col1003` datetime DEFAULT '2011-11-27 07:24:56', `col1004` double unsigned zerofill DEFAULT '0000000000000000025650', PRIMARY KEY (`col999`) USING HASH KEY_BLOCK_SIZE=10452, UNIQUE KEY `idx1110` (`col999`), UNIQUE KEY `idx1129` (`col1004`,`col993`,`col1003`) USING HASH, UNIQUE KEY `idx1118` (`col996`,`col1000`(56),`col993`) USING BTREE, UNIQUE KEY `idx1121` (`a31`,`col997`,`col1000`(79)), UNIQUE KEY `idx1122` (`col1003`,`col1000`(89),`col998`) USING HASH, UNIQUE KEY `idx1123` (`col1001`,`col996`,`col1003`,`col997`,`col999`,`col1000`(26),`a31`,`col993`) USING HASH, UNIQUE KEY `idx1132` (`col1000`(18),`col996`,`col993`,`col997`,`col1004`,`a31`) USING BTREE, UNIQUE KEY `idx1134` (`col997`,`col996`,`col998`,`col1004`,`col1000`(51),`col1001`,`a31`,`col993`) USING BTREE, KEY `idx1113` (`col999`) USING HASH, KEY `idx1115` (`col1003`,`col1004`,`col999`,`col997`,`col996`) USING BTREE, KEY `idx1119` (`col1004`,`col1003`,`col993`,`col997`,`col1001`,`col1000`(84)) USING BTREE, KEY `idx1124` (`col996`,`col997`,`col1004`,`col1001`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3198164 MAX_ROWS=9138891 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t32` -- DROP TABLE IF EXISTS `t32`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t32` ( `a32` int(10) unsigned zerofill NOT NULL, `col1006` time NOT NULL DEFAULT '06:05:25', `col1010` date NOT NULL DEFAULT '0000-00-00', `col1011` float unsigned NOT NULL DEFAULT '86749', `col1012` decimal(44,9) unsigned zerofill NOT NULL DEFAULT '00000000000000000000000000000094162.000000000', `col1013` time DEFAULT '18:46:44', PRIMARY KEY (`col1012`,`col1010`,`col1006`,`col1011`) KEY_BLOCK_SIZE=20096, UNIQUE KEY `idx1143` (`col1012`,`a32`,`col1010`,`col1013`) USING HASH, UNIQUE KEY `idx1150` (`col1011`,`col1010`,`col1012`,`col1006`,`col1013`), UNIQUE KEY `idx1157` (`col1012`,`col1006`,`col1011`,`col1013`), UNIQUE KEY `idx1169` (`a32`,`col1012`,`col1013`,`col1006`,`col1010`), UNIQUE KEY `idx1175` (`col1013`,`a32`) USING HASH, UNIQUE KEY `idx1179` (`col1011`,`col1006`), UNIQUE KEY `idx1182` (`col1010`,`col1012`,`col1013`) USING BTREE, UNIQUE KEY `idx1197` (`col1010`,`col1006`,`a32`) USING HASH, KEY `idx1142` (`col1012`,`col1010`,`col1006`,`col1011`), KEY `idx1144` (`col1012`,`col1010`,`a32`,`col1013`) USING BTREE, KEY `idx1145` (`col1006`,`col1013`,`col1011`) USING BTREE, KEY `idx1152` (`a32`,`col1010`,`col1012`,`col1006`), KEY `idx1153` (`a32`,`col1012`,`col1010`), KEY `idx1154` (`col1011`,`a32`,`col1013`,`col1006`), KEY `idx1158` (`col1011`) USING HASH, KEY `idx1160` (`a32`,`col1011`,`col1012`,`col1013`,`col1010`,`col1006`) USING BTREE, KEY `idx1161` (`col1010`,`a32`,`col1006`,`col1013`,`col1012`) USING BTREE, KEY `idx1163` (`col1010`,`col1011`,`col1012`,`col1013`,`a32`), KEY `idx1177` (`col1011`,`col1013`,`col1012`,`a32`) USING BTREE, KEY `idx1178` (`col1012`,`col1010`,`col1013`) USING HASH, KEY `idx1183` (`col1010`,`col1013`,`col1012`,`col1011`,`col1006`), KEY `idx1184` (`col1011`,`col1012`,`col1013`,`col1010`,`a32`,`col1006`) USING BTREE, KEY `idx1191` (`a32`,`col1010`,`col1006`) USING BTREE, KEY `idx1193` (`col1013`,`col1006`,`col1010`,`col1011`), KEY `idx1198` (`a32`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9170348 MAX_ROWS=5904856 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t33` -- DROP TABLE IF EXISTS `t33`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t33` ( `a33` int(11) NOT NULL, `col1014` datetime NOT NULL DEFAULT '2010-08-28 01:08:04', PRIMARY KEY (`a33`,`col1014`) KEY_BLOCK_SIZE=8553, UNIQUE KEY `idx1236` (`a33`), UNIQUE KEY `idx1242` (`a33`) USING BTREE, UNIQUE KEY `idx1209` (`a33`,`col1014`) USING HASH, UNIQUE KEY `idx1211` (`col1014`,`a33`) USING HASH, UNIQUE KEY `idx1216` (`a33`,`col1014`) USING BTREE, UNIQUE KEY `idx1238` (`col1014`), UNIQUE KEY `idx1239` (`col1014`) USING BTREE, KEY `idx1203` (`col1014`) USING HASH, KEY `idx1207` (`col1014`) USING BTREE, KEY `idx1217` (`a33`,`col1014`) USING BTREE, KEY `idx1218` (`col1014`) USING HASH, KEY `idx1228` (`a33`) USING HASH, KEY `idx1229` (`a33`,`col1014`), KEY `idx1231` (`col1014`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5952907 MAX_ROWS=9426263 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t34` -- DROP TABLE IF EXISTS `t34`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t34` ( `a34` int(10) unsigned NOT NULL, `col1015` decimal(46,14) unsigned zerofill NOT NULL DEFAULT '00000000000000000000000000084918.00000000000000', `col1016` float unsigned zerofill DEFAULT '000000100000', `col1017` date DEFAULT '2010-05-01', `col1018` datetime DEFAULT '2010-05-11 13:03:21', `col1019` varbinary(130) NOT NULL DEFAULT '', `col1020` binary(1) DEFAULT NULL, `col1021` mediumtext, `col1022` double unsigned zerofill NOT NULL DEFAULT '0000000000000000092356', `col1025` decimal(37,11) unsigned DEFAULT '40441.97570000000', `col1027` time DEFAULT '19:53:42', `col1028` float unsigned zerofill DEFAULT '000000011274', `col1029` date DEFAULT '2011-01-24', `col1031` decimal(27,19) unsigned DEFAULT '74712.0000000000000000000', `col1033` timestamp NOT NULL DEFAULT '2011-08-17 10:09:45', `col1034` time NOT NULL DEFAULT '20:16:38', `col1037` time NOT NULL DEFAULT '18:53:19', `col1039` char(35) CHARACTER SET utf8 NOT NULL DEFAULT '', `col1040` longtext, PRIMARY KEY (`col1039`(31),`col1019`(7),`col1015`,`col1033`,`col1022`,`col1037`,`col1034`) KEY_BLOCK_SIZE=5188, UNIQUE KEY `idx1253` (`col1020`,`col1015`,`col1017`,`col1034`) USING HASH, UNIQUE KEY `idx1255` (`col1039`,`col1017`,`col1037`,`col1033`), UNIQUE KEY `idx1247` (`col1039`(7),`col1019`(96),`col1015`,`col1033`,`col1022`,`col1037`,`col1034`), UNIQUE KEY `idx1249` (`col1039`(32),`col1027`,`col1019`(14)) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5501622 MAX_ROWS=5902637 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t35` -- DROP TABLE IF EXISTS `t35`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t35` ( `a35` int(10) unsigned NOT NULL, `col1041` date DEFAULT '2010-12-05', `col1047` float unsigned zerofill DEFAULT '000000008698', `col1048` date DEFAULT '2010-02-24', `col1049` tinytext, `col1050` char(23) CHARACTER SET utf8 NOT NULL DEFAULT '', `col1051` time DEFAULT '23:54:26', `col1052` varchar(219) CHARACTER SET utf8 DEFAULT 'avntvvlvobodvmfmqcyawnmpvoxkmtafpijscueyvntldazvfcsgyzhanfapcmjefzwqkwvcyzxxhdadvlsnaufthkzcbpwlrqnvftkpivsdxroccyntkeiunyocmzsvtshxmqlrfjtezpzknfsffrbgislzpxtbffemwtnbnghbajsuhwfqrqxpuyywqhkfgntwknymgfwoelysylckfvbfqp', `col1056` longblob, PRIMARY KEY (`col1050`(11)) KEY_BLOCK_SIZE=14429, UNIQUE KEY `idx1264` (`a35`), UNIQUE KEY `idx1261` (`col1041`) USING BTREE, UNIQUE KEY `idx1272` (`col1047`) USING HASH, KEY `idx1267` (`col1050`(15)), KEY `idx1274` (`col1056`(159)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3832179 MAX_ROWS=9221309 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t36` -- DROP TABLE IF EXISTS `t36`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t36` ( `a36` int(10) unsigned NOT NULL, `col1057` timestamp NOT NULL DEFAULT '2011-07-12 10:26:45', `col1058` mediumblob NOT NULL, `col1059` blob, `col1060` char(181) DEFAULT 'rtvnxdkhnowhnipusnkepfxxzzwhkcakjxfmpyvtonkyusvrpyqbihngqpauonjgtcxfnovuqubvl', `col1061` float unsigned zerofill DEFAULT '000000085171', `col1062` time NOT NULL DEFAULT '07:23:34', `col1063` datetime NOT NULL DEFAULT '2010-06-17 07:41:37', PRIMARY KEY (`col1058`(49),`col1062`,`col1063`,`a36`) KEY_BLOCK_SIZE=13533, UNIQUE KEY `idx1281` (`col1058`(174),`col1062`,`col1063`,`a36`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=2481905 MAX_ROWS=8501630 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t37` -- DROP TABLE IF EXISTS `t37`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t37` ( `a37` int(10) unsigned zerofill NOT NULL, `col1066` timestamp NOT NULL DEFAULT '2010-05-04 06:55:14', `col1067` bigint(20) unsigned DEFAULT '86159', `col1068` time DEFAULT '21:07:44', `col1071` date DEFAULT '2011-11-01', `col1072` timestamp NOT NULL DEFAULT '2011-08-16 07:42:20', `col1075` enum('mjjghry','ksaftxt','tvdvjaif','w','ih','','f','vsgdjax','rrugozzxs','cargwhag') DEFAULT NULL, `col1076` tinyblob, `col1077` datetime DEFAULT '2011-07-03 22:15:19', `col1079` timestamp NOT NULL DEFAULT '2010-10-29 05:28:10', `col1080` blob, `col1084` datetime DEFAULT '2011-04-03 13:06:03', `col1085` time DEFAULT '13:35:05', `col1088` set('xhapnrp','ddjs','oerlyixjf','njwae','eyaykdzl','fukhmxz','crkfu','pk') DEFAULT NULL, `col1089` double DEFAULT '-25754.3311', `col1091` date DEFAULT '2010-06-18', `col1093` time DEFAULT '08:25:48', `col1097` double DEFAULT '61248.7663', `col1099` float unsigned zerofill DEFAULT '0000038543.7', `col1101` datetime NOT NULL DEFAULT '2011-03-20 23:43:13', `col1102` tinyblob, `col1103` datetime NOT NULL DEFAULT '2011-08-09 02:45:26', `col1105` date DEFAULT '2011-09-18', PRIMARY KEY (`col1101`,`col1103`) USING HASH KEY_BLOCK_SIZE=9418, KEY `idx1286` (`col1101`,`col1103`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=1573302 MAX_ROWS=1029612 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t38` -- DROP TABLE IF EXISTS `t38`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t38` ( `a38` int(11) NOT NULL, `col1106` time DEFAULT '04:29:57', `col1107` date DEFAULT '2010-08-31', `col1109` mediumtext, `col1110` varbinary(32) NOT NULL DEFAULT '', `col1112` int(10) unsigned DEFAULT '0', `col1113` datetime DEFAULT '2010-05-22 20:56:12', `col1115` set('lgfqaue','','aeianjio','','xbp','','qczyvxvdt','','xx','s') DEFAULT NULL, `col1116` int(10) unsigned zerofill DEFAULT '0000030507', `col1117` blob, `col1118` longtext, `col1119` enum('gp') DEFAULT NULL, `col1120` time DEFAULT '18:27:48', `col1122` datetime DEFAULT '2010-11-22 12:22:11', `col1124` varchar(90) DEFAULT 'fqdvrlmhflwzowsxnaxwyjdp', `col1126` timestamp NOT NULL DEFAULT '2009-12-20 13:03:49', `col1127` time DEFAULT '19:38:54', `col1128` double unsigned zerofill NOT NULL DEFAULT '0000000000000000069465', `col1131` double DEFAULT '47353', `col1132` time DEFAULT '09:25:40', `col1133` datetime DEFAULT '2011-09-22 13:54:07', `col1136` bigint(20) DEFAULT '51561', `col1137` varchar(248) CHARACTER SET utf8 DEFAULT 'jeixztgqzlrpjzqnglpusvrvryvwbxxurpfyhktynrsaouxmdsoztgayjbfnvekspevxbhiuycdlrwajkxblelvygbpttvjxlwnjgkwbfchowrodhrjniybihogxmxfimghupzugwzyiorwgbkdzfmvnlocixcpo', `col1138` set('vm','qtwqggm','v','qmpkrtnma','tjfsk','cwwkw') DEFAULT NULL, PRIMARY KEY (`col1110`(31),`col1128`) KEY_BLOCK_SIZE=17257, UNIQUE KEY `idx1289` (`col1122`) USING HASH, UNIQUE KEY `idx1293` (`col1116`,`col1112`) USING HASH, UNIQUE KEY `idx1296` (`col1116`,`col1132`) USING BTREE, UNIQUE KEY `idx1323` (`col1132`,`col1128`) USING HASH, UNIQUE KEY `idx1329` (`col1132`,`a38`) USING BTREE, UNIQUE KEY `idx1337` (`col1131`) USING BTREE, UNIQUE KEY `idx1290` (`col1113`,`col1117`(197)) USING BTREE, UNIQUE KEY `idx1292` (`col1110`(30),`col1128`), UNIQUE KEY `idx1294` (`col1109`(71)) USING BTREE, UNIQUE KEY `idx1301` (`col1124`(83),`col1118`(41)) USING BTREE, UNIQUE KEY `idx1308` (`col1124`(1),`col1126`) USING BTREE, UNIQUE KEY `idx1314` (`col1137`(129),`col1119`) USING BTREE, KEY `idx1288` (`col1109`(224),`col1133`) USING HASH, KEY `idx1295` (`col1112`,`col1132`), KEY `idx1300` (`col1122`,`col1133`), KEY `idx1302` (`col1118`(24)) USING HASH, KEY `idx1306` (`col1110`(28),`col1116`) USING HASH, KEY `idx1313` (`col1110`(21)) USING HASH, KEY `idx1319` (`col1109`(178),`a38`), KEY `idx1327` (`col1116`), KEY `idx1330` (`col1106`), KEY `idx1331` (`col1127`) USING BTREE, KEY `idx1332` (`col1133`,`col1127`) USING HASH, KEY `idx1333` (`col1118`(43),`col1116`) USING HASH, KEY `idx1335` (`col1132`) USING BTREE, KEY `idx1340` (`a38`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9133166 MAX_ROWS=6250149 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t39` -- DROP TABLE IF EXISTS `t39`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t39` ( `a39` int(10) unsigned zerofill NOT NULL, `col1139` date DEFAULT '2011-01-18', `col1140` datetime DEFAULT '2010-12-16 05:13:17', `col1141` text, `col1142` double unsigned zerofill NOT NULL DEFAULT '00000000000057899.7929', `col1143` varchar(66) CHARACTER SET utf8 DEFAULT 'ivdjroaxcyptvdvtglaokwvwworgxppctkeppwzjtqmuspwkewpc', `col1144` set('cufowabk') DEFAULT NULL, `col1145` longblob, `col1146` date DEFAULT '2011-04-03', `col1147` enum('vi','q') DEFAULT NULL, `col1148` longtext NOT NULL, `col1149` double unsigned zerofill DEFAULT '00000000000031934.9623', `col1153` longtext, `col1155` time DEFAULT '02:26:47', `col1158` set('dkktei','fupiy','qopm','zutmg','jjqomxhl','ssofbr','','gsowm','hfcxj','') DEFAULT NULL, `col1160` blob, `col1161` float unsigned zerofill DEFAULT '0000040246.8', `col1162` timestamp NOT NULL DEFAULT '2010-08-27 22:26:12', `col1165` datetime DEFAULT '2011-05-07 13:43:08', `col1167` date DEFAULT '2011-06-19', `col1168` bit(18) DEFAULT b'11000011010100001', `col1169` timestamp NOT NULL DEFAULT '2010-05-08 19:26:05', `col1170` decimal(15,9) unsigned DEFAULT NULL, `col1172` datetime DEFAULT '2011-02-28 03:57:24', PRIMARY KEY (`col1148`(10),`col1142`) USING HASH KEY_BLOCK_SIZE=4265, UNIQUE KEY `idx1345` (`col1168`,`col1147`,`col1144`) USING HASH, UNIQUE KEY `idx1346` (`col1144`) USING BTREE, UNIQUE KEY `idx1347` (`col1170`,`col1149`), UNIQUE KEY `idx1354` (`col1146`,`col1140`,`col1170`), UNIQUE KEY `idx1361` (`col1169`,`col1149`,`col1140`) USING HASH, UNIQUE KEY `idx1369` (`col1142`) USING BTREE, UNIQUE KEY `idx1373` (`col1147`) USING HASH, UNIQUE KEY `idx1348` (`col1165`,`col1160`(228)), UNIQUE KEY `idx1379` (`col1168`,`col1148`(208),`col1169`) USING HASH, UNIQUE KEY `idx1387` (`col1160`(68),`col1149`) USING HASH, UNIQUE KEY `idx1391` (`col1145`(171)), UNIQUE KEY `idx1400` (`col1143`(4),`col1169`,`col1172`), KEY `idx1352` (`col1155`,`col1141`(160),`col1161`) USING BTREE, KEY `idx1353` (`col1165`,`col1167`,`col1160`(15)) USING HASH, KEY `idx1363` (`col1168`,`col1144`) USING BTREE, KEY `idx1372` (`col1165`,`col1146`) USING BTREE, KEY `idx1374` (`col1141`(179),`col1146`) USING BTREE, KEY `idx1380` (`col1148`(160),`col1142`) USING HASH, KEY `idx1383` (`col1161`,`col1148`(16),`col1165`) USING HASH, KEY `idx1388` (`col1149`,`col1155`,`col1170`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=553239 MAX_ROWS=5903098 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t4` -- DROP TABLE IF EXISTS `t4`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t4` ( `a4` int(10) unsigned NOT NULL, `col76` int(10) unsigned DEFAULT '98507', `col77` int(10) unsigned zerofill NOT NULL DEFAULT '0000039159', `col81` char(129) CHARACTER SET utf8 DEFAULT NULL, `col82` enum('qilupcybdt','mylkcuqy','smdhqvpqg','dzfzrlyb','zjryq') DEFAULT NULL, `col83` decimal(10,0) unsigned DEFAULT '63328', `col85` timestamp NOT NULL DEFAULT '2011-07-01 13:27:33', `col86` varbinary(153) NOT NULL DEFAULT '', `col87` time DEFAULT '05:14:35', `col88` longblob, `col93` mediumtext, `col94` text, `col95` char(224) DEFAULT 'dmuuqoonwgxnkctlcdsr', `col96` timestamp NOT NULL DEFAULT '2010-10-04 23:05:33', `col98` timestamp NOT NULL DEFAULT '2010-12-26 00:18:51', `col99` mediumtext, `col100` text, `col101` decimal(15,10) DEFAULT '-74359.0000000000', `col102` datetime DEFAULT '2011-03-23 12:21:28', `col103` timestamp NOT NULL DEFAULT '2011-04-17 06:05:32', `col104` tinyblob, `col105` date NOT NULL DEFAULT '2009-12-13', `col106` varchar(228) DEFAULT 'djgeefnflewweijbqpmuczlfbijojeevjlvdvfhemfxelpjxqnctycbqlwvonjjkvgnlydezremzdfamnvzkxlpivrefgpheibln', `col107` decimal(55,26) DEFAULT '11070.45290000000000000000000000', `col110` mediumblob, PRIMARY KEY (`col105`,`col86`(53),`col77`) KEY_BLOCK_SIZE=6435, UNIQUE KEY `idx106` (`col87`) USING BTREE, UNIQUE KEY `idx109` (`col76`) USING HASH, UNIQUE KEY `idx117` (`a4`,`col82`) USING HASH, UNIQUE KEY `idx123` (`col87`), UNIQUE KEY `idx112` (`col85`,`col107`,`col106`(168),`col82`), UNIQUE KEY `idx113` (`col107`,`col94`(206),`col83`,`col102`), UNIQUE KEY `idx119` (`col104`(173)), UNIQUE KEY `idx122` (`col88`(45)) USING HASH, UNIQUE KEY `idx139` (`col110`(59)) USING HASH, UNIQUE KEY `idx140` (`col101`,`col93`(27)) USING BTREE, UNIQUE KEY `idx143` (`col102`,`col81`(58)) USING HASH, UNIQUE KEY `idx147` (`col100`(53),`col81`(16),`col88`(181),`a4`), KEY `idx107` (`col106`(192),`col98`,`col100`(52),`col102`), KEY `idx110` (`col107`,`col100`(110),`col103`,`col81`(84)) USING BTREE, KEY `idx120` (`col101`,`col107`,`col86`(102)) USING BTREE, KEY `idx126` (`col83`,`col106`(15),`col103`,`col87`) USING HASH, KEY `idx128` (`col107`) USING HASH, KEY `idx129` (`col102`,`col103`,`a4`) USING BTREE, KEY `idx130` (`col82`,`col101`,`col99`(132)) USING HASH, KEY `idx135` (`col105`,`col86`(10),`col77`), KEY `idx154` (`col96`,`col105`) USING BTREE, KEY `idx156` (`col98`,`col101`,`col100`(73)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=6538214 MAX_ROWS=9663810 PACK_KEYS=1 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t40` -- DROP TABLE IF EXISTS `t40`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t40` ( `a40` int(11) NOT NULL, `col1173` date NOT NULL DEFAULT '2011-03-01', `col1175` mediumtext, `col1177` blob, `col1178` int(10) unsigned DEFAULT '40050', `col1179` varchar(104) CHARACTER SET utf8 DEFAULT 'weogupoppwwxixmox', `col1181` time DEFAULT '17:57:05', `col1182` datetime NOT NULL DEFAULT '2011-11-15 18:47:50', `col1185` date DEFAULT '2010-06-13', `col1188` float DEFAULT '-23755', `col1189` mediumtext, `col1191` date DEFAULT '2011-11-28', `col1193` mediumblob, `col1195` binary(1) DEFAULT NULL, `col1196` datetime DEFAULT '2011-04-14 19:12:45', `col1197` datetime NOT NULL DEFAULT '2011-02-09 06:49:20', `col1199` decimal(52,20) unsigned zerofill DEFAULT '00000000000000000000000000081853.82180000000000000000', `col1200` datetime NOT NULL DEFAULT '2011-06-14 17:25:36', `col1201` longblob, `col1202` mediumblob, `col1204` double unsigned DEFAULT '9999.2305', `col1206` datetime DEFAULT '2010-11-10 22:29:44', `col1207` varchar(236) DEFAULT 'mzqbshvglefhpmfakqxgitxyxzgjohbveusmxjpmylyjfnamdhvyvyhmuashocphwcirmkfhdvpiqoxggvhropbpdqxutarrkhytrdjncrtuyifpsqkorzyroovbfkshhanjqrzxfskjkvuyvheqangmubhkkdmugbnikhrmaudprjmeqggpfbntjicfbqjhxcvwm', `col1208` datetime DEFAULT '2011-11-04 17:53:12', `col1209` mediumtext, `col1210` smallint(5) unsigned zerofill DEFAULT '49081', `col1211` tinytext, `col1212` time DEFAULT '05:17:27', PRIMARY KEY (`col1173`,`col1200`,`col1197`,`col1182`) USING BTREE KEY_BLOCK_SIZE=3578, UNIQUE KEY `idx1403` (`col1209`(229),`col1210`,`col1212`,`col1196`,`col1178`), UNIQUE KEY `idx1405` (`col1178`,`col1204`,`col1201`(145),`col1179`(73),`col1181`), UNIQUE KEY `idx1408` (`col1193`(170),`col1210`,`col1209`(156),`col1185`,`col1208`,`col1191`), KEY `idx1402` (`col1173`,`col1200`,`col1197`,`col1182`) USING BTREE, KEY `idx1407` (`col1177`(160),`col1173`,`col1188`,`col1189`(196),`col1207`(143),`col1178`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=545113 MAX_ROWS=8544797 PACK_KEYS=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t41` -- DROP TABLE IF EXISTS `t41`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t41` ( `a41` int(10) unsigned NOT NULL, `col1213` text NOT NULL, `col1214` longblob NOT NULL, `col1216` int(10) unsigned zerofill DEFAULT '0000074307', `col1217` enum('fhtgvdv','','odkwonqa','xigyvawk','jpwthip','uujzwfmy','zndmu','hchlr','bowv') DEFAULT NULL, `col1218` datetime DEFAULT '2011-09-23 06:10:33', `col1219` decimal(27,13) DEFAULT '-20959.4340000000000', `col1220` longblob, `col1221` timestamp NOT NULL DEFAULT '2009-12-05 21:47:19', `col1222` time DEFAULT '15:36:45', `col1223` decimal(65,27) unsigned zerofill NOT NULL DEFAULT '00000000000000000000000000000000018871.000000000000000000000000000', `col1224` decimal(25,2) NOT NULL DEFAULT '68165.00', `col1225` time NOT NULL DEFAULT '17:55:17', `col1226` varbinary(133) DEFAULT NULL, `col1227` tinyblob NOT NULL, `col1228` binary(1) DEFAULT NULL, `col1229` time DEFAULT '00:16:00', `col1231` time NOT NULL DEFAULT '08:55:18', `col1233` char(57) DEFAULT 'lsmtejbbwplmzqlargxllnlrhrlxiswqnoic', `col1235` tinyblob, `col1236` date DEFAULT '2010-10-04', `col1237` longblob, `col1238` int(11) NOT NULL DEFAULT '59997', `col1239` decimal(33,20) DEFAULT '99999.00000000000000000000', `col1242` char(217) DEFAULT 'dydzaqghbfbuiirlxjyinyjaplacwwrlfxmdlhpxoeierkaazpskpiytgpnibiltstfrgmnyhofbleowwxslacjkdcwtaynsrifespdepphtqgrqbvxszjwzeogxmqrgvmdfijalltkrvtbhswkjfyfikmb', `col1243` tinytext, `col1244` mediumtext NOT NULL, `col1246` tinytext, `col1247` float unsigned zerofill DEFAULT '000000099999', `col1250` double unsigned DEFAULT '99655', `col1251` blob, `col1253` mediumblob, `col1254` timestamp NOT NULL DEFAULT '2011-10-30 22:49:29', `col1255` binary(1) DEFAULT NULL, `col1256` datetime NOT NULL DEFAULT '2010-04-09 07:49:01', `col1257` int(10) unsigned zerofill DEFAULT '0000026339', `col1258` double unsigned zerofill DEFAULT '0000000000000000065760', PRIMARY KEY (`col1238`,`col1224`,`col1227`(8),`col1221`,`col1256`,`col1214`(176),`col1213`(174),`a41`,`col1225`,`col1223`,`col1231`,`col1244`(222)) USING BTREE KEY_BLOCK_SIZE=26763, UNIQUE KEY `idx1411` (`col1246`(1),`col1228`,`col1225`,`col1258`,`col1250`,`col1220`(45),`col1217`) USING BTREE, UNIQUE KEY `idx1417` (`col1214`(19),`col1229`,`col1243`(166),`col1217`,`col1221`) USING HASH, UNIQUE KEY `idx1421` (`col1233`(7),`col1242`(104),`col1235`(120),`col1246`(205),`col1237`(11),`col1218`,`col1214`(30),`col1251`(108),`col1224`,`col1257`,`col1247`,`col1244`(239)) USING HASH, UNIQUE KEY `idx1426` (`col1242`(131),`col1224`,`col1254`,`col1228`,`col1238`,`col1225`,`col1229`) USING BTREE, UNIQUE KEY `idx1434` (`col1242`(59),`col1244`(113),`col1238`) USING BTREE, UNIQUE KEY `idx1441` (`col1231`,`col1251`(39),`col1257`,`col1235`(144),`col1226`(107),`col1221`,`col1233`(5)) USING BTREE, UNIQUE KEY `idx1444` (`col1250`,`col1219`,`col1253`(128),`col1218`,`col1227`(132),`col1255`,`col1229`,`col1231`,`col1216`,`col1233`(38),`col1236`,`col1258`), UNIQUE KEY `idx1449` (`col1217`,`col1216`,`col1221`,`col1226`(31),`col1243`(174),`col1237`(203),`col1224`), UNIQUE KEY `idx1455` (`col1224`,`col1235`(179),`col1250`,`col1228`,`col1227`(124),`col1231`,`col1218`,`col1236`,`col1242`(124),`col1246`(44),`col1254`) USING HASH, KEY `idx1413` (`col1214`(59),`col1246`(116),`col1233`(14),`col1244`(252),`col1237`(209),`col1226`(117),`col1256`,`col1223`,`col1257`,`col1229`,`col1258`,`col1255`,`col1253`(71)) USING HASH, KEY `idx1414` (`col1235`(154),`col1247`,`col1219`,`col1246`(115),`col1236`,`col1220`(149),`col1243`(89),`col1214`(228),`col1222`,`col1244`(113)) USING HASH, KEY `idx1415` (`col1229`,`col1255`,`col1257`,`col1222`,`col1233`(33),`col1236`,`col1256`,`col1217`,`col1213`(16),`col1246`(91),`col1239`,`col1235`(165),`col1218`,`col1251`(68)) USING BTREE, KEY `idx1419` (`col1235`(141),`col1244`(20),`col1227`(3),`col1256`,`col1224`,`col1214`(247),`col1258`,`col1236`,`col1233`(47),`col1213`(79),`col1221`), KEY `idx1420` (`col1236`,`col1219`,`col1217`,`col1216`) USING HASH, KEY `idx1424` (`col1221`,`col1231`,`a41`) USING BTREE, KEY `idx1427` (`col1220`(161),`col1217`,`col1239`,`col1224`,`col1222`,`col1218`,`a41`,`col1226`(120),`col1251`(149),`col1247`,`col1235`(191),`col1214`(76)), KEY `idx1432` (`col1220`(51),`col1237`(184),`col1235`(190),`col1213`(127),`col1222`,`col1251`(21),`col1246`(226),`col1223`), KEY `idx1437` (`col1219`,`col1251`(183),`col1253`(19),`col1226`) USING HASH, KEY `idx1446` (`col1258`,`col1217`) USING BTREE, KEY `idx1450` (`col1218`,`col1221`,`col1228`,`col1237`(1),`col1238`,`col1246`(253),`col1229`), KEY `idx1451` (`col1231`,`col1256`,`col1254`) USING BTREE, KEY `idx1453` (`col1239`,`col1255`,`col1214`(201),`col1229`) USING BTREE, KEY `idx1459` (`col1238`,`col1224`,`col1227`(196),`col1221`,`col1256`,`col1214`(120),`col1213`(142),`a41`,`col1225`,`col1223`,`col1231`,`col1244`(43)) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=2122021 MAX_ROWS=9652372 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t42` -- DROP TABLE IF EXISTS `t42`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t42` ( `a42` int(10) unsigned zerofill NOT NULL, `col1259` time NOT NULL DEFAULT '04:22:28', `col1260` enum('ekxgcu','ojcgyyqeu','d','aelvdd','y','unhfwyl','cjqx','tdc','sgcmppr') DEFAULT NULL, PRIMARY KEY (`col1259`,`a42`) KEY_BLOCK_SIZE=562, UNIQUE KEY `idx1483` (`a42`) USING BTREE, UNIQUE KEY `idx1465` (`col1260`) USING BTREE, UNIQUE KEY `idx1479` (`col1259`), UNIQUE KEY `idx1481` (`col1260`) USING HASH, KEY `idx1466` (`col1260`,`col1259`) USING BTREE, KEY `idx1467` (`col1260`), KEY `idx1472` (`col1259`,`a42`,`col1260`) USING HASH, KEY `idx1475` (`col1259`,`col1260`) USING BTREE, KEY `idx1476` (`a42`,`col1260`), KEY `idx1480` (`col1260`,`col1259`,`a42`) USING HASH, KEY `idx1486` (`col1259`,`a42`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3574612 MAX_ROWS=7305103 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t43` -- DROP TABLE IF EXISTS `t43`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t43` ( `a43` int(10) unsigned zerofill NOT NULL, `col1264` char(253) CHARACTER SET utf8 DEFAULT 'grionodwhrdzediivtc', `col1266` double unsigned zerofill NOT NULL DEFAULT '0000000000000000012225', `col1267` datetime NOT NULL DEFAULT '2010-11-16 02:10:27', `col1268` datetime DEFAULT '2011-08-12 12:31:11', `col1269` char(170) CHARACTER SET utf8 DEFAULT NULL, `col1271` date DEFAULT '2011-08-01', `col1273` float unsigned NOT NULL DEFAULT '85686', `col1274` timestamp NOT NULL DEFAULT '2010-04-03 13:33:38', `col1276` timestamp NOT NULL DEFAULT '2011-03-11 14:38:57', `col1277` datetime NOT NULL DEFAULT '2010-08-01 08:23:50', `col1279` varchar(241) CHARACTER SET utf8 DEFAULT 'qfzokfjbjzdcrroglcneyfbxsivclqyxadzrsthtrqsghnohmmsribu', `col1280` int(11) DEFAULT '-83205', `col1283` timestamp NOT NULL DEFAULT '2010-11-28 06:08:13', `col1284` timestamp NOT NULL DEFAULT '2011-01-06 09:32:48', `col1285` datetime DEFAULT '2010-08-19 01:44:38', `col1286` enum('fl','la','mvszlm','zdvfsgn') DEFAULT NULL, `col1287` tinytext NOT NULL, `col1288` decimal(58,11) DEFAULT '-44544.31500000000', `col1290` datetime DEFAULT '2011-02-08 12:11:47', `col1291` text, `col1292` varbinary(93) DEFAULT NULL, `col1293` char(120) CHARACTER SET utf8 DEFAULT NULL, `col1295` timestamp NOT NULL DEFAULT '2011-07-03 02:45:48', `col1296` time NOT NULL DEFAULT '03:35:19', `col1297` smallint(5) unsigned zerofill DEFAULT '21430', `col1299` timestamp NOT NULL DEFAULT '2011-06-29 15:20:57', `col1300` timestamp NOT NULL DEFAULT '2011-07-02 20:57:55', `col1302` varchar(246) DEFAULT 'qxsytgnfeidwtrcfjnsiwiumoloxgkqaaldlnjautxbejjhkinnkieriehldatnzstascbreeprsmwumjzoleuijssqhstydlcjctlgwhdfvazefllmexm', `col1303` tinyblob, `col1304` text, `col1306` char(252) CHARACTER SET utf8 DEFAULT 'wudzqslmafbkvczhgtzohwpuiumkqarwusxabqovggzruzzigbynjrtkkipbcqkxyfsruquuxwvpoduwvxlrredvuihsksblmkqjmjsjfolqudpydnvgrxbmfhawxycqsizlwxljhkknhkpxvesmlvknjuvoiksvurjbcbuvlncpoibhddtodyibhzcduoqvapifmbjefvsgggddvretdyuckhevxupjlluogpftelhovgrfe', `col1307` set('xxskuibz','hdr') DEFAULT NULL, `col1308` timestamp NOT NULL DEFAULT '2010-04-19 04:58:49', PRIMARY KEY (`col1273`,`col1274`,`col1266`,`col1300`,`col1277`,`col1296`,`col1287`(137),`col1267`) USING BTREE KEY_BLOCK_SIZE=25971, UNIQUE KEY `idx1509` (`col1273`) USING BTREE, UNIQUE KEY `idx1490` (`col1266`,`col1280`,`col1306`(158),`col1287`(32),`col1308`,`col1279`(33),`col1302`(190),`col1291`(191),`col1277`) USING HASH, UNIQUE KEY `idx1495` (`col1307`,`col1306`(11),`a43`,`col1268`,`col1267`,`col1266`,`col1279`(239)) USING HASH, UNIQUE KEY `idx1497` (`col1296`,`col1284`,`col1274`,`col1295`,`col1303`(52),`col1299`,`col1266`,`col1306`(211),`col1287`(74),`col1291`(234)), UNIQUE KEY `idx1499` (`col1290`,`col1293`(77),`col1274`,`col1304`(57),`col1285`) USING BTREE, KEY `idx1487` (`col1283`,`col1280`,`col1276`,`col1267`,`col1274`,`col1266`,`col1293`(3),`col1304`(180),`col1306`(44),`col1303`(236),`col1307`,`col1302`(105),`col1295`) USING BTREE, KEY `idx1496` (`col1273`,`col1274`,`col1266`,`col1300`,`col1277`,`col1296`,`col1287`(93),`col1267`) USING BTREE, KEY `idx1503` (`col1293`(3),`col1267`,`col1287`(19),`col1296`,`col1300`,`col1274`) USING BTREE, KEY `idx1511` (`col1296`,`col1290`,`col1286`,`col1283`,`col1308`,`a43`,`col1302`(166),`col1303`(158),`col1291`(36),`col1297`,`col1285`,`col1267`,`col1300`,`col1306`(199),`col1264`(234)) USING HASH, KEY `idx1513` (`col1284`,`col1274`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4720110 MAX_ROWS=2742099 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t44` -- DROP TABLE IF EXISTS `t44`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t44` ( `a44` int(10) unsigned NOT NULL, `col1310` decimal(45,25) unsigned zerofill DEFAULT '00000000000000046586.0000000000000000000000000', `col1311` varchar(116) DEFAULT 'pohncgejtdbxdpweiqihsgaufzywpnsxaxqptkmhowgaqocjobtinsopmtjzblofjcapcboggr', `col1313` timestamp NOT NULL DEFAULT '2010-01-27 10:27:27', `col1314` time DEFAULT '09:02:28', `col1315` datetime DEFAULT '2010-04-20 23:26:47', `col1317` char(244) CHARACTER SET utf8 DEFAULT NULL, `col1318` decimal(49,2) unsigned zerofill DEFAULT '00000000000000000000000000000000000000000024422.00', `col1319` longtext, `col1321` time DEFAULT '00:25:18', `col1322` date DEFAULT '2011-07-11', `col1323` blob, `col1326` float unsigned zerofill DEFAULT '000000032960', `col1327` smallint(5) unsigned zerofill DEFAULT '56155', `col1328` blob, `col1329` timestamp NOT NULL DEFAULT '2010-09-17 20:41:17', `col1330` tinyblob, `col1332` float unsigned zerofill DEFAULT '0000024601.2' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=6316613 MAX_ROWS=7499142 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t5` -- DROP TABLE IF EXISTS `t5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t5` ( `a5` int(11) NOT NULL, `col111` char(168) CHARACTER SET utf8 NOT NULL DEFAULT 'qozkaqzqbbejcrajuggryxgcdplwidqvzqtypmydqqfwjqsvtjesjzsaaefejzsuczfrc', `col112` timestamp NOT NULL DEFAULT '2011-08-16 19:59:28', `col113` date NOT NULL DEFAULT '2010-11-12', PRIMARY KEY (`a5`,`col111`(100),`col113`) KEY_BLOCK_SIZE=21156, UNIQUE KEY `idx159` (`col112`) USING HASH, UNIQUE KEY `idx162` (`col112`) USING HASH, UNIQUE KEY `idx184` (`a5`,`col112`) USING HASH, UNIQUE KEY `idx163` (`col113`,`col112`) USING BTREE, UNIQUE KEY `idx160` (`col111`(105)), UNIQUE KEY `idx180` (`a5`,`col113`,`col111`(91)), UNIQUE KEY `idx181` (`col111`(11)) USING BTREE, UNIQUE KEY `idx182` (`col113`,`col111`(150)), UNIQUE KEY `idx188` (`a5`,`col111`(108),`col113`), UNIQUE KEY `idx190` (`a5`,`col111`(137)), KEY `idx158` (`col113`) USING BTREE, KEY `idx177` (`a5`,`col112`) USING HASH, KEY `idx178` (`col111`(22)) USING HASH, KEY `idx186` (`col112`,`col113`,`col111`(160)), KEY `idx197` (`a5`,`col113`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=9381669 MAX_ROWS=6331357 PACK_KEYS=0 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t6` -- DROP TABLE IF EXISTS `t6`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t6` ( `a6` int(11) NOT NULL, `col114` timestamp NOT NULL DEFAULT '2009-12-14 21:01:39', `col115` time DEFAULT '02:22:02', `col116` bigint(20) DEFAULT '99999', `col117` longtext, `col118` binary(1) DEFAULT NULL, `col120` decimal(30,18) unsigned DEFAULT '74815.088400000000000000', `col121` time DEFAULT '14:09:45', `col122` date DEFAULT '2010-08-23', `col123` mediumblob, `col124` date NOT NULL DEFAULT '2011-03-20', `col125` timestamp NOT NULL DEFAULT '2010-08-02 00:58:35', `col126` date DEFAULT '2011-11-16', `col127` char(136) DEFAULT 'afuwmstooiipksahdseyhamvezrfgazukwexsyhmbvmuwn', `col128` decimal(62,5) DEFAULT '-22487.37010', `col131` float NOT NULL DEFAULT '1075.59', `col132` varchar(112) CHARACTER SET utf8 DEFAULT 'hrdijgynhturxuwzrrifjinsrpnjepxobdecxoprqhtwrzr', `col133` char(18) CHARACTER SET utf8 NOT NULL DEFAULT 'vf', `col134` mediumint(9) DEFAULT '-34527', `col135` timestamp NOT NULL DEFAULT '2010-12-24 10:14:28', `col136` bigint(20) unsigned zerofill DEFAULT '00000000000000049355', PRIMARY KEY (`col133`(7),`col124`,`col131`) KEY_BLOCK_SIZE=28552, UNIQUE KEY `idx222` (`col115`,`col135`) USING BTREE, UNIQUE KEY `idx227` (`col131`,`col134`,`col125`,`col122`) USING BTREE, UNIQUE KEY `idx200` (`col114`,`col124`,`col117`(100),`col122`) USING BTREE, UNIQUE KEY `idx203` (`col114`,`col115`,`col132`(58),`col128`,`col123`(82)) USING BTREE, UNIQUE KEY `idx208` (`col117`(95)) USING BTREE, UNIQUE KEY `idx211` (`col132`(75),`col114`,`col126`,`col118`,`col123`(69),`col127`(75),`col131`) USING HASH, UNIQUE KEY `idx212` (`a6`,`col123`(96),`col120`,`col133`(1),`col128`,`col132`(49),`col131`,`col127`(31)) USING BTREE, UNIQUE KEY `idx219` (`col125`,`col124`,`col117`(107),`col118`) USING HASH, UNIQUE KEY `idx228` (`col123`(75),`col133`(1),`col116`) USING HASH, KEY `idx202` (`col133`(6),`col124`,`col131`), KEY `idx209` (`col131`,`col132`(25),`col135`,`col114`,`col123`(95)) USING BTREE, KEY `idx210` (`col118`,`col128`) USING HASH, KEY `idx214` (`col126`), KEY `idx221` (`col135`,`col125`,`col127`(30),`col136`,`col122`,`col117`(150)) USING BTREE, KEY `idx224` (`col127`(17),`col115`,`col131`,`col117`(91)) USING BTREE, KEY `idx225` (`col132`(16),`col136`,`col116`) USING HASH, KEY `idx229` (`col136`,`col118`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3895029 MAX_ROWS=4660636 PACK_KEYS=0 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t7` -- DROP TABLE IF EXISTS `t7`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t7` ( `a7` int(10) unsigned zerofill NOT NULL, `col137` timestamp NOT NULL DEFAULT '2011-10-07 19:13:21', `col138` datetime DEFAULT '2009-12-17 15:55:52', `col139` time DEFAULT '09:37:53', `col141` char(192) DEFAULT 'nsm', `col143` tinyblob, `col144` binary(1) DEFAULT NULL, `col146` date DEFAULT '2011-10-14', `col147` datetime DEFAULT '2010-06-07 19:30:21', `col149` longblob, `col150` float unsigned zerofill DEFAULT '000000084652', `col151` binary(1) DEFAULT NULL, `col152` enum('hmyj','tsbclkwhnd') NOT NULL DEFAULT 'hmyj', `col153` binary(1) DEFAULT NULL, `col154` double unsigned zerofill NOT NULL DEFAULT '0000000000000000083453', `col155` datetime DEFAULT '2011-01-05 10:33:31', `col158` date NOT NULL DEFAULT '2010-08-08', `col159` float DEFAULT '-74918.8', `col162` char(171) CHARACTER SET utf8 DEFAULT NULL, `col163` timestamp NOT NULL DEFAULT '2011-05-14 20:00:31', `col164` decimal(38,19) unsigned DEFAULT '36288.2109000000000000000', `col165` longblob, `col166` enum('yijbl','nzujp','bbkm','ybbgd','trqgsx','axindyqlp','qexhbkgbde') DEFAULT NULL, `col168` tinyblob, `col169` tinytext, `col171` decimal(51,9) DEFAULT '86702.920500000', `col174` longtext, `col178` float unsigned zerofill NOT NULL DEFAULT '000000056746', `col179` time DEFAULT '15:12:26', `col180` double unsigned zerofill DEFAULT '0000000000000000064910', `col181` mediumblob, `col182` enum('nsnfpicik','toag','ztgj','ntbk','zxpkkkuvcm','zqwyrw','','t') DEFAULT NULL, `col184` varchar(172) CHARACTER SET utf8 NOT NULL DEFAULT 'byarvfaadirumpqiarodaopwknvepzmaixmmhreghqoxgcuuiypgmfygznkevlgmyrqsenjprlqwlbaundccfbybtbftwrlidbwvzrrmtpjlvlkliiqpdbmwx', `col185` date DEFAULT '2010-08-27', `col187` varbinary(243) DEFAULT NULL, `col188` mediumint(8) unsigned zerofill NOT NULL DEFAULT '00000873', `col189` double unsigned NOT NULL DEFAULT '100000', `col193` tinytext, `col194` binary(1) NOT NULL DEFAULT '\0', `col195` decimal(46,8) NOT NULL DEFAULT '84826.00000000', `col196` mediumint(9) DEFAULT '-10394', PRIMARY KEY (`col152`,`col178`,`col154`,`col184`(153),`col158`,`col195`,`col188`,`col194`,`col189`) USING BTREE KEY_BLOCK_SIZE=12865, UNIQUE KEY `idx232` (`col152`,`col178`,`col154`,`col184`(35),`col158`,`col195`,`col188`,`col194`,`col189`) USING BTREE, UNIQUE KEY `idx241` (`col163`,`col174`(214),`col187`(149),`col153`,`col195`,`col171`,`col152`,`col179`,`col137`) USING BTREE, KEY `idx236` (`col138`,`col180`,`col141`(113),`col149`(29),`col189`,`col194`,`col196`,`col182`,`col139`,`col144`) USING BTREE, KEY `idx239` (`col164`,`col193`(110),`col147`,`col143`(196),`col174`(29),`col141`(77),`col171`,`col137`) USING HASH, KEY `idx242` (`col143`(254),`col178`,`col155`,`col150`,`col165`(75),`a7`,`col152`,`col196`,`col189`,`col188`) USING HASH, KEY `idx243` (`col185`,`col159`,`col196`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=5501151 MAX_ROWS=281121 PACK_KEYS=0 CHECKSUM=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t8` -- DROP TABLE IF EXISTS `t8`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t8` ( `a8` int(10) unsigned NOT NULL, `col199` time DEFAULT '00:17:28', `col200` varchar(117) CHARACTER SET utf8 DEFAULT 'vwzjdmcglgwzhfmpptfjgcinwcghezuewobwwjiwxyjasztttwbaeurggzrpoer', `col201` double unsigned zerofill DEFAULT '00000000000048459.1542', `col202` datetime DEFAULT '2010-08-28 23:00:10', `col203` datetime DEFAULT '2010-02-13 11:26:06', `col205` char(151) CHARACTER SET utf8 DEFAULT 'vgoiqnhlchxafniurcbashvutcktwgsdfnqvbdcjxiwsvaaeobvuaplqfhgaqegfcvuugzzxx', `col207` tinyblob, `col208` date DEFAULT '2010-06-30', `col210` timestamp NOT NULL DEFAULT '2010-05-10 15:18:36', `col213` blob NOT NULL, `col216` binary(1) DEFAULT NULL, `col217` double unsigned zerofill NOT NULL DEFAULT '000000000000017389.961', `col218` varchar(155) DEFAULT 'xezytdrshmxtdwycqwrsmnfwipisgpcorifofyllysiekwrcmnadsqjmuywefcehvaxpujt', `col219` tinyblob, `col220` char(32) CHARACTER SET utf8 DEFAULT NULL, `col223` mediumtext, `col225` enum('neevjuqcp','ldgrhveqty','jvef','ru','d','') DEFAULT NULL, `col226` time DEFAULT '01:42:43', `col227` binary(1) DEFAULT NULL, `col228` time DEFAULT '23:58:27', `col229` decimal(29,23) DEFAULT '-91543.67780000000000000000000', `col230` datetime DEFAULT '2011-07-04 04:54:07', PRIMARY KEY (`col213`(233),`col217`) KEY_BLOCK_SIZE=31790, UNIQUE KEY `idx273` (`col210`) USING HASH, UNIQUE KEY `idx266` (`col226`,`col217`,`col229`) USING HASH, UNIQUE KEY `idx244` (`col230`,`col228`,`col207`(6),`col202`,`col210`), UNIQUE KEY `idx252` (`col213`(37),`col217`), UNIQUE KEY `idx253` (`col223`(100),`col229`,`col210`,`col207`(222),`col225`) USING BTREE, KEY `idx254` (`col229`,`col230`) USING BTREE, KEY `idx255` (`col216`,`col199`,`col225`), KEY `idx256` (`col220`(13),`col226`), KEY `idx261` (`col200`(22),`col227`) USING HASH, KEY `idx264` (`col217`,`col223`(237),`col200`(12),`col229`,`col220`(28)), KEY `idx265` (`col228`,`col201`,`col229`), KEY `idx269` (`col226`), KEY `idx270` (`col223`(32),`col202`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=2654088 MAX_ROWS=584831 PACK_KEYS=0 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `t9` -- DROP TABLE IF EXISTS `t9`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t9` ( `a9` int(10) unsigned zerofill NOT NULL, `col234` timestamp NOT NULL DEFAULT '2010-01-19 12:38:40', `col238` date DEFAULT '2011-01-20', `col239` longblob NOT NULL, `col240` datetime DEFAULT '2010-02-12 17:59:42', `col243` binary(1) DEFAULT NULL, `col244` double unsigned zerofill DEFAULT '0000000000000000049526', `col245` timestamp NOT NULL DEFAULT '2010-12-29 19:44:24', `col246` timestamp NOT NULL DEFAULT '2010-09-11 06:56:09', `col247` double DEFAULT '-40245.6755', `col248` datetime DEFAULT '2010-04-11 06:20:24', `col249` longblob, `col250` mediumint(8) unsigned zerofill NOT NULL DEFAULT '00088872', `col251` text NOT NULL, `col255` blob NOT NULL, `col256` timestamp NOT NULL DEFAULT '2011-03-02 06:01:35', `col257` mediumtext, `col258` timestamp NOT NULL DEFAULT '2011-09-14 04:00:00', `col259` int(10) unsigned zerofill NOT NULL DEFAULT '0000027435', PRIMARY KEY (`col250`,`col246`,`col245`,`col255`(169),`col251`(9),`col234`,`col259`,`col239`(197)) KEY_BLOCK_SIZE=1204, UNIQUE KEY `idx297` (`col250`) USING BTREE, UNIQUE KEY `idx278` (`col250`,`col246`,`col245`,`col255`(136),`col251`(117),`col234`,`col259`,`col239`(35)), UNIQUE KEY `idx287` (`col243`,`col240`,`col250`,`col245`,`col234`) USING HASH, UNIQUE KEY `idx282` (`col246`,`col243`,`col250`,`col259`,`col244`,`col257`(21),`col258`) USING BTREE, UNIQUE KEY `idx289` (`col246`,`col249`(156),`col243`,`col238`,`col259`,`col245`,`col240`,`col250`,`col256`,`col234`) USING HASH, UNIQUE KEY `idx290` (`col243`,`col239`(95),`col244`,`col258`,`col240`,`a9`,`col259`,`col250`) USING HASH, UNIQUE KEY `idx296` (`a9`,`col239`(177),`col240`), UNIQUE KEY `idx301` (`col255`(55),`col244`,`col256`,`col247`) USING BTREE, KEY `idx291` (`col245`,`col258`,`col249`(191),`col256`,`col259`), KEY `idx300` (`col244`,`col239`(210),`col250`,`col243`,`col234`,`a9`,`col246`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=3660718 MAX_ROWS=4027666 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; /*!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 2010-12-05 8:15:18 explain partitions select 1 from `t1` as `t1_0` straight_join `t13` as `t13_1` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t28` as `t28_1` on 1 <> ( select 1 from `t1` as `t1_0` right outer join `t8` as `t8_1` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) left join `t4` as `t4_2` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) right join `t4` as `t4_3` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) natural left join `t12` as `t12_4` limit 1 ) natural right join `t1` as `t1_2` left join `t26` as `t26_3` on 1 limit 1 ) natural left join `t25` as `t25_2` straight_join `t42` as `t42_3` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t28` as `t28_1` on 1 <> ( select 1 from `t1` as `t1_0` right outer join `t8` as `t8_1` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) left join `t4` as `t4_2` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) right join `t4` as `t4_3` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) natural left join `t12` as `t12_4` limit 1 ) natural right join `t1` as `t1_2` left join `t26` as `t26_3` on 1 limit 1 ) natural join `t10` as `t10_4` union select 1 from `t1` as `t1_0` straight_join `t13` as `t13_1` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t28` as `t28_1` on 1 <> ( select 1 from `t1` as `t1_0` right outer join `t8` as `t8_1` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) left join `t4` as `t4_2` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) right join `t4` as `t4_3` on 1 <> ( select 1 from `t1` as `t1_0` cross join `t19` as `t19_1` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) right join `t18` as `t18_2` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) natural right join `t9` as `t9_3` cross join `t44` as `t44_4` on 1 <> ( select 1 from `t1` as `t1_0` left outer join `t41` as `t41_1` on 1 natural right outer join `t41` as `t41_2` join `t35` as `t35_3` straight_join `t12` as `t12_4` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t12` as `t12_1` left join `t25` as `t25_2` on 1 <> ( select 1 from `t1` as `t1_0` natural join `t23` as `t23_1` right outer join `t37` as `t37_2` on 1 limit 1 ) natural left outer join `t27` as `t27_3` limit 1 ) limit 1 ) limit 1 ) natural left join `t12` as `t12_4` limit 1 ) natural right join `t1` as `t1_2` left join `t26` as `t26_3` on 1 limit 1 ) natural left join `t25` as `t25_2` straight_join `t42` as `t42_3` on 1 natural join `t10` as `t10_4` ;