drop table if exists `table0000`;
create table `table0000`
(
`col00` float,
`col01` char (246),
`col02` tinyint,
`col03` longtext,
`col04` year,
`col05` char (203),
`col06` int,
key `idx00` (`col04`),
key `idx01` (`col00`),
key `idx02` (`col06`,`col04`,`col05`),
key `idx03` (`col05`,`col06`,`col02`,`col03`(106)),
key `idx04` (`col04`,`col02`),
key `idx05` (`col04`),
key `idx06` (`col01`,`col06`,`col05`),
key `idx07` (`col06`),
key `idx08` (`col03`(74)),
key `idx09` (`col01`,`col04`,`col03`(62)),
key `idx10` (`col00`),
key `idx11` (`col00`),
key `idx12` (`col02`,`col05`,`col01`),
key `idx13` (`col01`,`col05`,`col02`),
key `idx14` (`col03`(185)),
key `idx15` (`col01`,`col02`,`col04`),
key `idx16` (`col01`),
key `idx17` (`col05`,`col00`,`col01`),
key `idx18` (`col02`),
key `idx19` (`col02`),
key `idx20` (`col03`(254),`col06`,`col05`),
key `idx21` (`col04`),
key `idx22` (`col01`),
key `idx23` (`col03`(74),`col04`,`col06`),
key `idx24` (`col06`,`col01`,`col00`,`col02`),
key `idx25` (`col01`,`col03`(227),`col05`,`col06`),
key `idx26` (`col01`,`col05`,`col03`(80)),
key `idx27` (`col00`),
key `idx28` (`col01`,`col06`,`col04`,`col02`),
key `idx29` (`col05`),
key `idx30` (`col01`),
key `idx31` (`col03`(84),`col00`,`col06`),
key `idx32` (`col06`),
key `idx33` (`col06`),
key `idx34` (`col03`(129)),
key `idx35` (`col02`),
key `idx36` (`col01`),
key `idx37` (`col05`),
key `idx38` (`col06`,`col03`(22),`col05`,`col01`),
key `idx39` (`col03`(58)),
key `idx40` (`col00`,`col06`,`col03`(188)),
key `idx41` (`col03`(92),`col05`,`col04`,`col01`),
key `idx42` (`col05`,`col02`,`col06`),
key `idx43` (`col05`),
key `idx44` (`col00`),
key `idx45` (`col03`(178),`col04`,`col02`),
key `idx46` (`col03`(32),`col06`,`col00`,`col01`),
key `idx47` (`col00`,`col04`,`col05`),
key `idx48` (`col00`,`col06`,`col04`),
key `idx49` (`col03`(239)),
key `idx50` (`col06`,`col00`,`col01`,`col02`),
key `idx51` (`col03`(211),`col05`,`col01`,`col04`),
key `idx52` (`col02`,`col05`,`col03`(22)),
key `idx53` (`col05`,`col03`(252)),
key `idx54` (`col06`),
key `idx55` (`col02`),
key `idx56` (`col05`,`col06`,`col03`(148))
)ENGINE=innodb COMMENT='generated';

# Creating a table with 64 columns and 55 indexes
drop table if exists `table0001`;
create table `table0001`
(
`col00` tinyint,
`col01` real,
`col02` varchar (195),
`col03` year,
`col04` mediumint,
`col05` mediumtext,
`col06` mediumtext,
`col07` real,
`col08` tinyint,
`col09` date,
`col10` varchar (28),
`col11` double,
`col12` datetime,
`col13` datetime,
`col14` time,
`col15` datetime,
`col16` time,
`col17` blob,
`col18` datetime,
`col19` mediumtext,
`col20` mediumtext,
`col21` longblob,
`col22` mediumtext,
`col23` tinytext,
`col24` tinyint,
`col25` mediumtext,
`col26` double precision,
`col27` double precision,
`col28` varchar (20),
`col29` mediumtext,
`col30` text,
`col31` char (146),
`col32` float,
`col33` date,
`col34` real,
`col35` mediumblob,
`col36` double precision,
`col37` DECIMAL,
`col38` DECIMAL,
`col39` tinyint,
`col40` mediumint,
`col41` DECIMAL,
`col42` year,
`col43` varchar (174),
`col44` int,
`col45` longblob,
`col46` datetime,
`col47` bigint,
`col48` real,
`col49` bigint,
`col50` tinyblob,
`col51` numeric,
`col52` DECIMAL,
`col53` timestamp,
`col54` longtext,
`col55` int,
`col56` bool,
`col57` longblob,
`col58` datetime,
`col59` date,
`col60` char (13),
`col61` longtext,
`col62` longtext,
`col63` int,
key `idx00` (`col08`),
key `idx01` (`col29`(111)),
key `idx02` (`col20`(4),`col63`),
key `idx03` (`col63`,`col16`,`col52`),
key `idx04` (`col28`,`col26`),
key `idx05` (`col52`,`col04`,`col41`,`col45`(161)),
key `idx06` (`col38`),
key `idx07` (`col29`(25)),
key `idx08` (`col61`(112),`col29`(68)),
key `idx09` (`col47`,`col16`,`col19`(66),`col60`),
key `idx10` (`col45`(164)),
key `idx11` (`col03`,`col32`),
key `idx12` (`col10`),
key `idx13` (`col39`,`col58`,`col60`),
key `idx14` (`col10`),
key `idx15` (`col11`),
key `idx16` (`col22`(147)),
key `idx17` (`col55`),
key `idx18` (`col28`,`col52`,`col51`),
key `idx19` (`col07`,`col34`,`col29`(184),`col39`),
key `idx20` (`col25`(53)),
key `idx21` (`col33`,`col35`(218),`col36`,`col20`(34)),
key `idx22` (`col63`),
key `idx23` (`col41`,`col39`,`col09`,`col63`),
key `idx24` (`col32`),
key `idx25` (`col34`,`col30`(87),`col03`,`col07`),
key `idx26` (`col10`,`col11`,`col59`),
key `idx27` (`col31`,`col33`),
key `idx28` (`col02`,`col28`),
key `idx29` (`col42`,`col35`(138),`col59`),
key `idx30` (`col55`),
key `idx31` (`col50`(63)),
key `idx32` (`col57`(8)),
key `idx33` (`col26`),
key `idx34` (`col34`,`col01`),
key `idx35` (`col39`,`col21`(107),`col62`(134)),
key `idx36` (`col60`),
key `idx37` (`col11`),
key `idx38` (`col46`,`col10`,`col30`(162),`col52`),
key `idx39` (`col01`),
key `idx40` (`col47`,`col57`(235),`col19`(100),`col09`),
key `idx41` (`col33`,`col27`),
key `idx42` (`col28`),
key `idx43` (`col43`,`col41`,`col47`),
key `idx44` (`col19`(250),`col48`),
key `idx45` (`col52`,`col40`,`col34`),
key `idx46` (`col23`(98),`col62`(230)),
key `idx47` (`col21`(106),`col44`),
key `idx48` (`col50`(108),`col19`(42),`col30`(200),`col40`),
key `idx49` (`col37`),
key `idx50` (`col53`,`col06`(5),`col27`,`col45`(145)),
key `idx51` (`col54`(170),`col28`),
key `idx52` (`col44`,`col55`,`col51`),
key `idx53` (`col32`,`col25`(117),`col12`),
key `idx54` (`col42`,`col45`(222),`col01`,`col62`(229))
)ENGINE=innodb COMMENT='generated';