# Generating 10 tables
# Creating a table with 94 columns and 24 indexes
DROP TABLE IF EXISTS `table0`;
CREATE TABLE IF NOT EXISTS `table0`
(`col0` BOOL,
`col1` BOOL,
`col2` TINYINT,
`col3` DATE,
`col4` TIME,
`col5` SET ('test1','test2','test3'),
`col6` TIME,
`col7` TEXT,
`col8` DECIMAL,
`col9` SET ('test1','test2','test3'),
`col10` FLOAT,
`col11` DOUBLE PRECISION,
`col12` ENUM ('test1','test2','test3'),
`col13` TINYBLOB,
`col14` YEAR,
`col15` SET ('test1','test2','test3'),
`col16` NUMERIC,
`col17` NUMERIC,
`col18` BLOB,
`col19` DATETIME,
`col20` DOUBLE PRECISION,
`col21` DECIMAL,
`col22` DATETIME,
`col23` NUMERIC,
`col24` NUMERIC,
`col25` LONGTEXT,
`col26` TINYBLOB,
`col27` TIME,
`col28` TINYBLOB,
`col29` ENUM ('test1','test2','test3'),
`col30` SMALLINT,
`col31` REAL,
`col32` FLOAT,
`col33` CHAR (175),
`col34` TINYTEXT,
`col35` TINYTEXT,
`col36` TINYBLOB,
`col37` TINYBLOB,
`col38` TINYTEXT,
`col39` MEDIUMBLOB,
`col40` TIMESTAMP,
`col41` DOUBLE,
`col42` SMALLINT,
`col43` LONGBLOB,
`col44` VARCHAR (80),
`col45` MEDIUMTEXT,
`col46` NUMERIC,
`col47` BIGINT,
`col48` DATE,
`col49` TINYBLOB,
`col50` DATE,
`col51` BOOL,
`col52` MEDIUMINT,
`col53` FLOAT,
`col54` TINYBLOB,
`col55` LONGTEXT,
`col56` SMALLINT,
`col57` ENUM ('test1','test2','test3'),
`col58` DATETIME,
`col59` MEDIUMTEXT,
`col60` VARCHAR (232),
`col61` NUMERIC,
`col62` YEAR,
`col63` SMALLINT,
`col64` TIMESTAMP,
`col65` BLOB,
`col66` LONGBLOB,
`col67` INT,
`col68` LONGTEXT,
`col69` ENUM ('test1','test2','test3'),
`col70` INT,
`col71` TIME,
`col72` TIMESTAMP,
`col73` TIMESTAMP,
`col74` VARCHAR (170),
`col75` SET ('test1','test2','test3'),
`col76` TINYBLOB,
`col77` BIGINT,
`col78` NUMERIC,
`col79` DATETIME,
`col80` YEAR,
`col81` NUMERIC,
`col82` LONGBLOB,
`col83` TEXT,
`col84` CHAR (83),
`col85` DECIMAL,
`col86` FLOAT,
`col87` INT,
`col88` VARCHAR (145),
`col89` DATE,
`col90` DECIMAL,
`col91` DECIMAL,
`col92` MEDIUMBLOB,
`col93` TIME,
KEY `idx0` (`col69`,`col90`,`col8`),
KEY `idx1` (`col60`),
KEY `idx2` (`col60`,`col70`,`col74`),
KEY `idx3` (`col22`,`col32`,`col72`,`col30`),
KEY `idx4` (`col29`),
KEY `idx5` (`col19`,`col45`(143)),
KEY `idx6` (`col46`,`col48`,`col5`,`col39`(118)),
KEY `idx7` (`col48`,`col61`),
KEY `idx8` (`col93`),
KEY `idx9` (`col31`),
KEY `idx10` (`col30`,`col21`),
KEY `idx11` (`col67`),
KEY `idx12` (`col44`,`col6`,`col8`,`col38`(226)),
KEY `idx13` (`col71`,`col41`,`col15`,`col49`(88)),
KEY `idx14` (`col78`),
KEY `idx15` (`col63`,`col67`,`col64`),
KEY `idx16` (`col17`,`col86`),
KEY `idx17` (`col77`,`col56`,`col10`,`col55`(24)),
KEY `idx18` (`col62`),
KEY `idx19` (`col31`,`col57`,`col56`,`col53`),
KEY `idx20` (`col46`),
KEY `idx21` (`col83`(54)),
KEY `idx22` (`col51`,`col7`(120)),
KEY `idx23` (`col7`(163),`col31`,`col71`,`col14`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 10 columns and 32 indexes
DROP TABLE IF EXISTS `table1`;
CREATE TABLE IF NOT EXISTS `table1`
(`col0` CHAR (113),
`col1` FLOAT,
`col2` BIGINT,
`col3` DECIMAL,
`col4` BLOB,
`col5` LONGTEXT,
`col6` SET ('test1','test2','test3'),
`col7` BIGINT,
`col8` BIGINT,
`col9` TINYBLOB,
KEY `idx0` (`col5`(101),`col7`,`col8`),
KEY `idx1` (`col8`),
KEY `idx2` (`col4`(177),`col9`(126),`col6`,`col3`),
KEY `idx3` (`col5`(160)),
KEY `idx4` (`col9`(242)),
KEY `idx5` (`col4`(139),`col2`,`col3`),
KEY `idx6` (`col7`),
KEY `idx7` (`col6`,`col2`,`col0`,`col3`),
KEY `idx8` (`col9`(66)),
KEY `idx9` (`col5`(253)),
KEY `idx10` (`col1`,`col7`,`col2`),
KEY `idx11` (`col9`(242),`col0`,`col8`,`col5`(163)),
KEY `idx12` (`col8`),
KEY `idx13` (`col0`,`col9`(37)),
KEY `idx14` (`col0`),
KEY `idx15` (`col5`(111)),
KEY `idx16` (`col8`,`col0`,`col5`(13)),
KEY `idx17` (`col4`(139)),
KEY `idx18` (`col5`(189),`col2`,`col3`,`col9`(136)),
KEY `idx19` (`col0`,`col3`,`col1`,`col8`),
KEY `idx20` (`col8`),
KEY `idx21` (`col0`,`col7`,`col9`(227),`col3`),
KEY `idx22` (`col0`),
KEY `idx23` (`col2`),
KEY `idx24` (`col3`),
KEY `idx25` (`col2`,`col3`),
KEY `idx26` (`col0`),
KEY `idx27` (`col5`(254)),
KEY `idx28` (`col3`),
KEY `idx29` (`col3`),
KEY `idx30` (`col7`,`col3`,`col0`,`col4`(220)),
KEY `idx31` (`col4`(1),`col0`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 141 columns and 18 indexes
DROP TABLE IF EXISTS `table2`;
CREATE TABLE IF NOT EXISTS `table2`
(`col0` BOOL,
`col1` MEDIUMINT,
`col2` VARCHAR (209),
`col3` MEDIUMBLOB,
`col4` CHAR (13),
`col5` DOUBLE,
`col6` TINYTEXT,
`col7` REAL,
`col8` SMALLINT,
`col9` BLOB,
`col10` TINYINT,
`col11` DECIMAL,
`col12` BLOB,
`col13` DECIMAL,
`col14` LONGBLOB,
`col15` SMALLINT,
`col16` LONGBLOB,
`col17` TINYTEXT,
`col18` FLOAT,
`col19` CHAR (78),
`col20` MEDIUMTEXT,
`col21` SET ('test1','test2','test3'),
`col22` MEDIUMINT,
`col23` INT,
`col24` MEDIUMBLOB,
`col25` ENUM ('test1','test2','test3'),
`col26` TINYBLOB,
`col27` VARCHAR (116),
`col28` TIMESTAMP,
`col29` BLOB,
`col30` SMALLINT,
`col31` DOUBLE PRECISION,
`col32` DECIMAL,
`col33` DECIMAL,
`col34` TEXT,
`col35` MEDIUMINT,
`col36` MEDIUMINT,
`col37` BIGINT,
`col38` VARCHAR (253),
`col39` TINYBLOB,
`col40` MEDIUMBLOB,
`col41` BIGINT,
`col42` DOUBLE,
`col43` TEXT,
`col44` BLOB,
`col45` TIME,
`col46` MEDIUMINT,
`col47` DOUBLE PRECISION,
`col48` SET ('test1','test2','test3'),
`col49` DOUBLE PRECISION,
`col50` VARCHAR (97),
`col51` TEXT,
`col52` NUMERIC,
`col53` ENUM ('test1','test2','test3'),
`col54` MEDIUMTEXT,
`col55` MEDIUMINT,
`col56` DATETIME,
`col57` DATETIME,
`col58` MEDIUMTEXT,
`col59` CHAR (244),
`col60` LONGBLOB,
`col61` MEDIUMBLOB,
`col62` DOUBLE,
`col63` SMALLINT,
`col64` BOOL,
`col65` SMALLINT,
`col66` VARCHAR (212),
`col67` TIME,
`col68` REAL,
`col69` BOOL,
`col70` BIGINT,
`col71` DATE,
`col72` TINYINT,
`col73` ENUM ('test1','test2','test3'),
`col74` DATE,
`col75` TIME,
`col76` DATETIME,
`col77` BOOL,
`col78` TINYTEXT,
`col79` MEDIUMINT,
`col80` NUMERIC,
`col81` LONGTEXT,
`col82` SET ('test1','test2','test3'),
`col83` DOUBLE PRECISION,
`col84` NUMERIC,
`col85` VARCHAR (184),
`col86` DOUBLE PRECISION,
`col87` MEDIUMTEXT,
`col88` MEDIUMBLOB,
`col89` BOOL,
`col90` SMALLINT,
`col91` TINYINT,
`col92` ENUM ('test1','test2','test3'),
`col93` BOOL,
`col94` TIMESTAMP,
`col95` BOOL,
`col96` MEDIUMTEXT,
`col97` DECIMAL,
`col98` BOOL,
`col99` DECIMAL,
`col100` MEDIUMINT,
`col101` DOUBLE PRECISION,
`col102` TINYINT,
`col103` BOOL,
`col104` MEDIUMINT,
`col105` DECIMAL,
`col106` NUMERIC,
`col107` TIMESTAMP,
`col108` MEDIUMBLOB,
`col109` TINYBLOB,
`col110` SET ('test1','test2','test3'),
`col111` YEAR,
`col112` TIMESTAMP,
`col113` CHAR (201),
`col114` BOOL,
`col115` TINYINT,
`col116` DOUBLE,
`col117` TINYINT,
`col118` TIMESTAMP,
`col119` SET ('test1','test2','test3'),
`col120` SMALLINT,
`col121` TINYBLOB,
`col122` TIMESTAMP,
`col123` BLOB,
`col124` DATE,
`col125` SMALLINT,
`col126` ENUM ('test1','test2','test3'),
`col127` MEDIUMBLOB,
`col128` DOUBLE PRECISION,
`col129` REAL,
`col130` VARCHAR (159),
`col131` MEDIUMBLOB,
`col132` BIGINT,
`col133` INT,
`col134` SET ('test1','test2','test3'),
`col135` CHAR (198),
`col136` SET ('test1','test2','test3'),
`col137` MEDIUMTEXT,
`col138` SMALLINT,
`col139` BLOB,
`col140` LONGBLOB,
KEY `idx0` (`col14`(139),`col24`(208),`col38`,`col35`),
KEY `idx1` (`col48`,`col118`,`col29`(131),`col100`),
KEY `idx2` (`col86`,`col67`,`col43`(175)),
KEY `idx3` (`col19`),
KEY `idx4` (`col40`(220),`col67`),
KEY `idx5` (`col99`,`col56`),
KEY `idx6` (`col68`,`col28`,`col137`(157)),
KEY `idx7` (`col51`(160),`col99`,`col45`,`col39`(9)),
KEY `idx8` (`col15`,`col52`,`col90`,`col94`),
KEY `idx9` (`col24`(3),`col139`(248),`col108`(118),`col41`),
KEY `idx10` (`col36`,`col92`,`col114`),
KEY `idx11` (`col115`,`col9`(116)),
KEY `idx12` (`col130`,`col93`,`col134`),
KEY `idx13` (`col123`(65)),
KEY `idx14` (`col44`(90),`col86`,`col119`),
KEY `idx15` (`col69`),
KEY `idx16` (`col132`,`col81`(118),`col18`),
KEY `idx17` (`col24`(250),`col7`,`col92`,`col45`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 199 columns and 1 indexes
DROP TABLE IF EXISTS `table3`;
CREATE TABLE IF NOT EXISTS `table3`
(`col0` SMALLINT,
`col1` SET ('test1','test2','test3'),
`col2` TINYTEXT,
`col3` DOUBLE,
`col4` NUMERIC,
`col5` DATE,
`col6` BIGINT,
`col7` DOUBLE,
`col8` TEXT,
`col9` INT,
`col10` REAL,
`col11` TINYINT,
`col12` NUMERIC,
`col13` NUMERIC,
`col14` TIME,
`col15` DOUBLE,
`col16` REAL,
`col17` MEDIUMBLOB,
`col18` YEAR,
`col19` TINYTEXT,
`col20` YEAR,
`col21` CHAR (250),
`col22` TINYINT,
`col23` TINYINT,
`col24` SMALLINT,
`col25` DATETIME,
`col26` MEDIUMINT,
`col27` LONGBLOB,
`col28` VARCHAR (106),
`col29` FLOAT,
`col30` MEDIUMTEXT,
`col31` TINYBLOB,
`col32` BIGINT,
`col33` YEAR,
`col34` REAL,
`col35` MEDIUMBLOB,
`col36` LONGTEXT,
`col37` LONGBLOB,
`col38` BIGINT,
`col39` FLOAT,
`col40` TIME,
`col41` DATETIME,
`col42` BOOL,
`col43` BIGINT,
`col44` SMALLINT,
`col45` TIME,
`col46` DOUBLE PRECISION,
`col47` TIME,
`col48` TINYTEXT,
`col49` DOUBLE PRECISION,
`col50` BIGINT,
`col51` NUMERIC,
`col52` TINYBLOB,
`col53` DATE,
`col54` DECIMAL,
`col55` SMALLINT,
`col56` TINYTEXT,
`col57` ENUM ('test1','test2','test3'),
`col58` YEAR,
`col59` TIME,
`col60` TINYINT,
`col61` DECIMAL,
`col62` DOUBLE,
`col63` DATE,
`col64` LONGTEXT,
`col65` DOUBLE,
`col66` VARCHAR (88),
`col67` MEDIUMTEXT,
`col68` DATE,
`col69` MEDIUMINT,
`col70` DECIMAL,
`col71` MEDIUMTEXT,
`col72` LONGTEXT,
`col73` REAL,
`col74` DOUBLE,
`col75` TIME,
`col76` DATE,
`col77` DECIMAL,
`col78` MEDIUMBLOB,
`col79` NUMERIC,
`col80` BIGINT,
`col81` YEAR,
`col82` SMALLINT,
`col83` MEDIUMINT,
`col84` TINYINT,
`col85` MEDIUMBLOB,
`col86` TIME,
`col87` MEDIUMBLOB,
`col88` LONGTEXT,
`col89` BOOL,
`col90` BLOB,
`col91` LONGBLOB,
`col92` YEAR,
`col93` BLOB,
`col94` INT,
`col95` TINYTEXT,
`col96` TINYINT,
`col97` DECIMAL,
`col98` ENUM ('test1','test2','test3'),
`col99` MEDIUMINT,
`col100` TINYINT,
`col101` MEDIUMBLOB,
`col102` TINYINT,
`col103` SET ('test1','test2','test3'),
`col104` TIMESTAMP,
`col105` TEXT,
`col106` DATETIME,
`col107` MEDIUMTEXT,
`col108` CHAR (220),
`col109` TIME,
`col110` VARCHAR (131),
`col111` DECIMAL,
`col112` FLOAT,
`col113` SMALLINT,
`col114` BIGINT,
`col115` LONGBLOB,
`col116` SET ('test1','test2','test3'),
`col117` ENUM ('test1','test2','test3'),
`col118` BLOB,
`col119` MEDIUMTEXT,
`col120` SET ('test1','test2','test3'),
`col121` DATETIME,
`col122` FLOAT,
`col123` VARCHAR (242),
`col124` YEAR,
`col125` MEDIUMBLOB,
`col126` TIME,
`col127` BOOL,
`col128` TINYBLOB,
`col129` DOUBLE,
`col130` TINYINT,
`col131` BIGINT,
`col132` SMALLINT,
`col133` INT,
`col134` DOUBLE PRECISION,
`col135` MEDIUMBLOB,
`col136` SET ('test1','test2','test3'),
`col137` TINYTEXT,
`col138` DOUBLE PRECISION,
`col139` NUMERIC,
`col140` BLOB,
`col141` SET ('test1','test2','test3'),
`col142` INT,
`col143` VARCHAR (26),
`col144` BLOB,
`col145` REAL,
`col146` SET ('test1','test2','test3'),
`col147` LONGBLOB,
`col148` TEXT,
`col149` BLOB,
`col150` CHAR (189),
`col151` LONGTEXT,
`col152` INT,
`col153` FLOAT,
`col154` LONGTEXT,
`col155` DATE,
`col156` LONGBLOB,
`col157` TINYBLOB,
`col158` REAL,
`col159` DATE,
`col160` TIME,
`col161` YEAR,
`col162` DOUBLE,
`col163` VARCHAR (90),
`col164` FLOAT,
`col165` NUMERIC,
`col166` ENUM ('test1','test2','test3'),
`col167` DOUBLE PRECISION,
`col168` DOUBLE PRECISION,
`col169` TINYBLOB,
`col170` TIME,
`col171` SMALLINT,
`col172` TINYTEXT,
`col173` SMALLINT,
`col174` DOUBLE,
`col175` VARCHAR (14),
`col176` VARCHAR (90),
`col177` REAL,
`col178` MEDIUMINT,
`col179` TINYBLOB,
`col180` FLOAT,
`col181` TIMESTAMP,
`col182` REAL,
`col183` DOUBLE PRECISION,
`col184` BIGINT,
`col185` INT,
`col186` MEDIUMTEXT,
`col187` TIME,
`col188` FLOAT,
`col189` TIME,
`col190` INT,
`col191` FLOAT,
`col192` MEDIUMINT,
`col193` TINYINT,
`col194` MEDIUMTEXT,
`col195` DATE,
`col196` TIME,
`col197` YEAR,
`col198` CHAR (206),
KEY `idx0` (`col39`,`col23`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 133 columns and 16 indexes
DROP TABLE IF EXISTS `table4`;
CREATE TABLE IF NOT EXISTS `table4`
(`col0` VARCHAR (60),
`col1` NUMERIC,
`col2` LONGTEXT,
`col3` MEDIUMTEXT,
`col4` LONGTEXT,
`col5` LONGBLOB,
`col6` LONGBLOB,
`col7` DATETIME,
`col8` TINYTEXT,
`col9` BLOB,
`col10` BOOL,
`col11` BIGINT,
`col12` TEXT,
`col13` VARCHAR (213),
`col14` TINYBLOB,
`col15` BOOL,
`col16` MEDIUMTEXT,
`col17` DOUBLE,
`col18` TEXT,
`col19` BLOB,
`col20` SET ('test1','test2','test3'),
`col21` TINYINT,
`col22` DATETIME,
`col23` TINYINT,
`col24` ENUM ('test1','test2','test3'),
`col25` REAL,
`col26` BOOL,
`col27` FLOAT,
`col28` LONGBLOB,
`col29` DATETIME,
`col30` FLOAT,
`col31` SET ('test1','test2','test3'),
`col32` LONGBLOB,
`col33` NUMERIC,
`col34` YEAR,
`col35` VARCHAR (146),
`col36` BIGINT,
`col37` DATETIME,
`col38` DATE,
`col39` SET ('test1','test2','test3'),
`col40` CHAR (112),
`col41` FLOAT,
`col42` YEAR,
`col43` TIME,
`col44` DOUBLE,
`col45` NUMERIC,
`col46` FLOAT,
`col47` DECIMAL,
`col48` BIGINT,
`col49` DECIMAL,
`col50` YEAR,
`col51` MEDIUMTEXT,
`col52` LONGBLOB,
`col53` SET ('test1','test2','test3'),
`col54` BLOB,
`col55` FLOAT,
`col56` REAL,
`col57` REAL,
`col58` TEXT,
`col59` MEDIUMBLOB,
`col60` INT,
`col61` INT,
`col62` DATE,
`col63` TEXT,
`col64` DATE,
`col65` ENUM ('test1','test2','test3'),
`col66` DOUBLE PRECISION,
`col67` TINYTEXT,
`col68` TINYBLOB,
`col69` FLOAT,
`col70` BLOB,
`col71` DATETIME,
`col72` DOUBLE,
`col73` LONGTEXT,
`col74` TIME,
`col75` DATETIME,
`col76` VARCHAR (122),
`col77` MEDIUMTEXT,
`col78` MEDIUMTEXT,
`col79` BOOL,
`col80` LONGTEXT,
`col81` TINYTEXT,
`col82` NUMERIC,
`col83` DOUBLE PRECISION,
`col84` DATE,
`col85` YEAR,
`col86` BLOB,
`col87` TINYTEXT,
`col88` DOUBLE PRECISION,
`col89` MEDIUMINT,
`col90` MEDIUMTEXT,
`col91` NUMERIC,
`col92` DATETIME,
`col93` NUMERIC,
`col94` SET ('test1','test2','test3'),
`col95` TINYTEXT,
`col96` SET ('test1','test2','test3'),
`col97` YEAR,
`col98` MEDIUMINT,
`col99` TEXT,
`col100` TEXT,
`col101` TIME,
`col102` VARCHAR (225),
`col103` TINYTEXT,
`col104` TEXT,
`col105` MEDIUMTEXT,
`col106` TINYINT,
`col107` TEXT,
`col108` LONGBLOB,
`col109` LONGTEXT,
`col110` TINYTEXT,
`col111` CHAR (56),
`col112` YEAR,
`col113` ENUM ('test1','test2','test3'),
`col114` TINYBLOB,
`col115` DATETIME,
`col116` DATE,
`col117` TIME,
`col118` MEDIUMTEXT,
`col119` DOUBLE PRECISION,
`col120` FLOAT,
`col121` TIMESTAMP,
`col122` MEDIUMINT,
`col123` YEAR,
`col124` DATE,
`col125` TEXT,
`col126` FLOAT,
`col127` TINYTEXT,
`col128` BOOL,
`col129` NUMERIC,
`col130` TIMESTAMP,
`col131` INT,
`col132` MEDIUMBLOB,
KEY `idx0` (`col130`),
KEY `idx1` (`col30`,`col55`,`col19`(31)),
KEY `idx2` (`col104`(186)),
KEY `idx3` (`col131`),
KEY `idx4` (`col64`,`col93`,`col2`(11)),
KEY `idx5` (`col34`,`col121`,`col22`),
KEY `idx6` (`col33`,`col55`,`col83`),
KEY `idx7` (`col17`,`col87`(245),`col99`(17)),
KEY `idx8` (`col65`,`col120`),
KEY `idx9` (`col82`),
KEY `idx10` (`col9`(72)),
KEY `idx11` (`col88`),
KEY `idx12` (`col128`,`col9`(200),`col71`,`col66`),
KEY `idx13` (`col77`(126)),
KEY `idx14` (`col105`(26),`col13`,`col117`),
KEY `idx15` (`col4`(246),`col130`,`col115`,`col3`(141))
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 176 columns and 13 indexes
DROP TABLE IF EXISTS `table5`;
CREATE TABLE IF NOT EXISTS `table5`
(`col0` MEDIUMTEXT,
`col1` VARCHAR (90),
`col2` TINYTEXT,
`col3` TIME,
`col4` BOOL,
`col5` TINYTEXT,
`col6` BOOL,
`col7` TIMESTAMP,
`col8` TINYBLOB,
`col9` TINYINT,
`col10` YEAR,
`col11` SET ('test1','test2','test3'),
`col12` TEXT,
`col13` CHAR (248),
`col14` BIGINT,
`col15` TEXT,
`col16` TINYINT,
`col17` NUMERIC,
`col18` SET ('test1','test2','test3'),
`col19` LONGBLOB,
`col20` FLOAT,
`col21` INT,
`col22` TEXT,
`col23` BOOL,
`col24` DECIMAL,
`col25` DOUBLE PRECISION,
`col26` FLOAT,
`col27` TINYBLOB,
`col28` NUMERIC,
`col29` MEDIUMBLOB,
`col30` DATE,
`col31` LONGTEXT,
`col32` DATE,
`col33` FLOAT,
`col34` BIGINT,
`col35` TINYTEXT,
`col36` MEDIUMTEXT,
`col37` TIME,
`col38` INT,
`col39` TINYINT,
`col40` SET ('test1','test2','test3'),
`col41` CHAR (130),
`col42` SMALLINT,
`col43` INT,
`col44` MEDIUMTEXT,
`col45` VARCHAR (126),
`col46` INT,
`col47` DOUBLE PRECISION,
`col48` BIGINT,
`col49` MEDIUMTEXT,
`col50` TINYBLOB,
`col51` MEDIUMINT,
`col52` TEXT,
`col53` VARCHAR (208),
`col54` VARCHAR (207),
`col55` NUMERIC,
`col56` DATETIME,
`col57` ENUM ('test1','test2','test3'),
`col58` NUMERIC,
`col59` TINYBLOB,
`col60` VARCHAR (73),
`col61` MEDIUMTEXT,
`col62` TINYBLOB,
`col63` DATETIME,
`col64` NUMERIC,
`col65` MEDIUMINT,
`col66` DATETIME,
`col67` NUMERIC,
`col68` TINYINT,
`col69` VARCHAR (58),
`col70` DECIMAL,
`col71` MEDIUMTEXT,
`col72` DATE,
`col73` TIME,
`col74` DOUBLE PRECISION,
`col75` DECIMAL,
`col76` MEDIUMBLOB,
`col77` REAL,
`col78` YEAR,
`col79` YEAR,
`col80` LONGBLOB,
`col81` BLOB,
`col82` BIGINT,
`col83` ENUM ('test1','test2','test3'),
`col84` NUMERIC,
`col85` SET ('test1','test2','test3'),
`col86` MEDIUMTEXT,
`col87` LONGBLOB,
`col88` TIME,
`col89` ENUM ('test1','test2','test3'),
`col90` DECIMAL,
`col91` FLOAT,
`col92` DATETIME,
`col93` TINYTEXT,
`col94` TIMESTAMP,
`col95` TIMESTAMP,
`col96` TEXT,
`col97` REAL,
`col98` VARCHAR (198),
`col99` TIME,
`col100` TINYINT,
`col101` BIGINT,
`col102` LONGBLOB,
`col103` LONGBLOB,
`col104` MEDIUMINT,
`col105` MEDIUMTEXT,
`col106` TIMESTAMP,
`col107` SMALLINT,
`col108` NUMERIC,
`col109` DECIMAL,
`col110` FLOAT,
`col111` DECIMAL,
`col112` REAL,
`col113` TINYTEXT,
`col114` FLOAT,
`col115` VARCHAR (7),
`col116` LONGTEXT,
`col117` DATE,
`col118` BIGINT,
`col119` TEXT,
`col120` BIGINT,
`col121` BLOB,
`col122` CHAR (110),
`col123` NUMERIC,
`col124` MEDIUMBLOB,
`col125` NUMERIC,
`col126` NUMERIC,
`col127` BOOL,
`col128` TIME,
`col129` TINYBLOB,
`col130` TINYBLOB,
`col131` DATE,
`col132` INT,
`col133` VARCHAR (123),
`col134` CHAR (238),
`col135` VARCHAR (225),
`col136` LONGTEXT,
`col137` LONGBLOB,
`col138` REAL,
`col139` TINYBLOB,
`col140` DATETIME,
`col141` TINYTEXT,
`col142` LONGBLOB,
`col143` BIGINT,
`col144` VARCHAR (236),
`col145` TEXT,
`col146` YEAR,
`col147` DECIMAL,
`col148` TEXT,
`col149` MEDIUMBLOB,
`col150` TINYINT,
`col151` BOOL,
`col152` VARCHAR (72),
`col153` INT,
`col154` VARCHAR (165),
`col155` TINYINT,
`col156` MEDIUMTEXT,
`col157` DOUBLE PRECISION,
`col158` TIME,
`col159` MEDIUMBLOB,
`col160` LONGBLOB,
`col161` DATETIME,
`col162` DOUBLE PRECISION,
`col163` BLOB,
`col164` ENUM ('test1','test2','test3'),
`col165` TIMESTAMP,
`col166` DATE,
`col167` TINYBLOB,
`col168` TINYBLOB,
`col169` LONGBLOB,
`col170` DATETIME,
`col171` BIGINT,
`col172` VARCHAR (30),
`col173` LONGTEXT,
`col174` TIME,
`col175` FLOAT,
KEY `idx0` (`col16`,`col156`(139),`col97`,`col120`),
KEY `idx1` (`col24`,`col0`(108)),
KEY `idx2` (`col117`,`col173`(34),`col132`,`col82`),
KEY `idx3` (`col2`(86)),
KEY `idx4` (`col2`(43)),
KEY `idx5` (`col83`,`col35`(87),`col111`),
KEY `idx6` (`col6`,`col134`,`col92`),
KEY `idx7` (`col56`),
KEY `idx8` (`col30`,`col53`,`col129`(66)),
KEY `idx9` (`col53`,`col113`(211),`col32`,`col15`(75)),
KEY `idx10` (`col34`),
KEY `idx11` (`col126`),
KEY `idx12` (`col24`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 179 columns and 46 indexes
DROP TABLE IF EXISTS `table6`;
CREATE TABLE IF NOT EXISTS `table6`
(`col0` ENUM ('test1','test2','test3'),
`col1` MEDIUMBLOB,
`col2` MEDIUMBLOB,
`col3` DATETIME,
`col4` DATE,
`col5` YEAR,
`col6` REAL,
`col7` NUMERIC,
`col8` MEDIUMBLOB,
`col9` TEXT,
`col10` TIMESTAMP,
`col11` DOUBLE,
`col12` DOUBLE,
`col13` SMALLINT,
`col14` TIMESTAMP,
`col15` DECIMAL,
`col16` DATE,
`col17` TEXT,
`col18` LONGBLOB,
`col19` BIGINT,
`col20` FLOAT,
`col21` DATETIME,
`col22` TINYINT,
`col23` MEDIUMBLOB,
`col24` SET ('test1','test2','test3'),
`col25` TIME,
`col26` TEXT,
`col27` LONGTEXT,
`col28` BIGINT,
`col29` REAL,
`col30` YEAR,
`col31` MEDIUMBLOB,
`col32` MEDIUMINT,
`col33` FLOAT,
`col34` TEXT,
`col35` DATE,
`col36` TIMESTAMP,
`col37` REAL,
`col38` BLOB,
`col39` BLOB,
`col40` BLOB,
`col41` TINYBLOB,
`col42` INT,
`col43` TINYINT,
`col44` REAL,
`col45` BIGINT,
`col46` TIMESTAMP,
`col47` BLOB,
`col48` ENUM ('test1','test2','test3'),
`col49` BOOL,
`col50` CHAR (109),
`col51` DOUBLE,
`col52` DOUBLE PRECISION,
`col53` ENUM ('test1','test2','test3'),
`col54` FLOAT,
`col55` DOUBLE PRECISION,
`col56` CHAR (166),
`col57` TEXT,
`col58` TIME,
`col59` DECIMAL,
`col60` TEXT,
`col61` ENUM ('test1','test2','test3'),
`col62` LONGTEXT,
`col63` YEAR,
`col64` DOUBLE,
`col65` CHAR (87),
`col66` DATE,
`col67` BOOL,
`col68` MEDIUMBLOB,
`col69` DATETIME,
`col70` DECIMAL,
`col71` TIME,
`col72` REAL,
`col73` LONGTEXT,
`col74` BLOB,
`col75` REAL,
`col76` INT,
`col77` INT,
`col78` FLOAT,
`col79` DOUBLE,
`col80` MEDIUMINT,
`col81` ENUM ('test1','test2','test3'),
`col82` VARCHAR (221),
`col83` BIGINT,
`col84` TINYINT,
`col85` BIGINT,
`col86` FLOAT,
`col87` MEDIUMBLOB,
`col88` CHAR (126),
`col89` MEDIUMBLOB,
`col90` DATETIME,
`col91` TINYINT,
`col92` DOUBLE,
`col93` NUMERIC,
`col94` DATE,
`col95` BLOB,
`col96` DATETIME,
`col97` TIME,
`col98` LONGBLOB,
`col99` INT,
`col100` SET ('test1','test2','test3'),
`col101` TINYBLOB,
`col102` INT,
`col103` MEDIUMBLOB,
`col104` MEDIUMTEXT,
`col105` FLOAT,
`col106` TINYBLOB,
`col107` VARCHAR (26),
`col108` TINYINT,
`col109` TIME,
`col110` TINYBLOB,
`col111` LONGBLOB,
`col112` TINYTEXT,
`col113` FLOAT,
`col114` TINYINT,
`col115` NUMERIC,
`col116` TIME,
`col117` SET ('test1','test2','test3'),
`col118` DATE,
`col119` SMALLINT,
`col120` BLOB,
`col121` TINYTEXT,
`col122` REAL,
`col123` YEAR,
`col124` REAL,
`col125` BOOL,
`col126` BLOB,
`col127` REAL,
`col128` MEDIUMBLOB,
`col129` TIMESTAMP,
`col130` LONGBLOB,
`col131` MEDIUMBLOB,
`col132` YEAR,
`col133` YEAR,
`col134` INT,
`col135` MEDIUMINT,
`col136` MEDIUMINT,
`col137` TINYTEXT,
`col138` TINYBLOB,
`col139` BLOB,
`col140` SET ('test1','test2','test3'),
`col141` ENUM ('test1','test2','test3'),
`col142` ENUM ('test1','test2','test3'),
`col143` TINYTEXT,
`col144` DATETIME,
`col145` TEXT,
`col146` DOUBLE PRECISION,
`col147` DECIMAL,
`col148` MEDIUMTEXT,
`col149` TINYTEXT,
`col150` SET ('test1','test2','test3'),
`col151` MEDIUMTEXT,
`col152` CHAR (126),
`col153` DOUBLE,
`col154` CHAR (243),
`col155` SET ('test1','test2','test3'),
`col156` SET ('test1','test2','test3'),
`col157` DATETIME,
`col158` DOUBLE,
`col159` NUMERIC,
`col160` DECIMAL,
`col161` FLOAT,
`col162` LONGBLOB,
`col163` LONGTEXT,
`col164` INT,
`col165` TIME,
`col166` CHAR (27),
`col167` VARCHAR (63),
`col168` TEXT,
`col169` TINYBLOB,
`col170` TINYBLOB,
`col171` ENUM ('test1','test2','test3'),
`col172` INT,
`col173` TIME,
`col174` DECIMAL,
`col175` DOUBLE,
`col176` MEDIUMBLOB,
`col177` LONGBLOB,
`col178` CHAR (43),
KEY `idx0` (`col131`(219)),
KEY `idx1` (`col67`,`col122`,`col59`,`col87`(33)),
KEY `idx2` (`col83`,`col42`,`col57`(152)),
KEY `idx3` (`col106`(124)),
KEY `idx4` (`col173`,`col80`,`col165`,`col89`(78)),
KEY `idx5` (`col174`,`col145`(108),`col23`(228),`col141`),
KEY `idx6` (`col157`,`col140`),
KEY `idx7` (`col130`(188),`col15`),
KEY `idx8` (`col52`),
KEY `idx9` (`col144`),
KEY `idx10` (`col155`),
KEY `idx11` (`col62`(230),`col1`(109)),
KEY `idx12` (`col151`(24),`col95`(85)),
KEY `idx13` (`col114`),
KEY `idx14` (`col42`,`col98`(56),`col146`),
KEY `idx15` (`col147`,`col39`(254),`col35`),
KEY `idx16` (`col79`),
KEY `idx17` (`col65`),
KEY `idx18` (`col149`(165),`col168`(119),`col32`,`col117`),
KEY `idx19` (`col64`),
KEY `idx20` (`col93`),
KEY `idx21` (`col64`,`col113`,`col104`(182)),
KEY `idx22` (`col52`,`col111`(189)),
KEY `idx23` (`col45`),
KEY `idx24` (`col154`,`col107`,`col110`(159)),
KEY `idx25` (`col149`(1),`col87`(131)),
KEY `idx26` (`col58`,`col115`,`col63`),
KEY `idx27` (`col95`(9),`col0`,`col87`(113)),
KEY `idx28` (`col92`,`col130`(1)),
KEY `idx29` (`col151`(129),`col137`(254),`col13`),
KEY `idx30` (`col49`),
KEY `idx31` (`col28`),
KEY `idx32` (`col83`,`col146`),
KEY `idx33` (`col155`,`col90`,`col17`(245)),
KEY `idx34` (`col174`,`col169`(44),`col107`),
KEY `idx35` (`col113`),
KEY `idx36` (`col52`),
KEY `idx37` (`col16`,`col120`(190)),
KEY `idx38` (`col28`),
KEY `idx39` (`col131`(165)),
KEY `idx40` (`col135`,`col26`(86)),
KEY `idx41` (`col69`,`col94`),
KEY `idx42` (`col105`,`col151`(38),`col97`),
KEY `idx43` (`col88`),
KEY `idx44` (`col176`(100),`col42`,`col73`(189),`col94`),
KEY `idx45` (`col2`(27),`col27`(116))
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 122 columns and 27 indexes
DROP TABLE IF EXISTS `table7`;
CREATE TABLE IF NOT EXISTS `table7`
(`col0` INT,
`col1` SET ('test1','test2','test3'),
`col2` REAL,
`col3` SET ('test1','test2','test3'),
`col4` TINYINT,
`col5` DOUBLE,
`col6` MEDIUMBLOB,
`col7` TEXT,
`col8` VARCHAR (42),
`col9` YEAR,
`col10` MEDIUMBLOB,
`col11` DOUBLE PRECISION,
`col12` TINYINT,
`col13` MEDIUMTEXT,
`col14` BOOL,
`col15` TIMESTAMP,
`col16` TINYBLOB,
`col17` TINYTEXT,
`col18` REAL,
`col19` NUMERIC,
`col20` LONGBLOB,
`col21` DOUBLE PRECISION,
`col22` SMALLINT,
`col23` VARCHAR (42),
`col24` NUMERIC,
`col25` BOOL,
`col26` DOUBLE,
`col27` REAL,
`col28` INT,
`col29` TINYINT,
`col30` BIGINT,
`col31` LONGTEXT,
`col32` SET ('test1','test2','test3'),
`col33` VARCHAR (62),
`col34` LONGTEXT,
`col35` BIGINT,
`col36` NUMERIC,
`col37` LONGTEXT,
`col38` REAL,
`col39` BOOL,
`col40` BIGINT,
`col41` LONGBLOB,
`col42` TIME,
`col43` CHAR (246),
`col44` MEDIUMBLOB,
`col45` ENUM ('test1','test2','test3'),
`col46` MEDIUMINT,
`col47` BLOB,
`col48` VARCHAR (68),
`col49` TINYTEXT,
`col50` BLOB,
`col51` YEAR,
`col52` SET ('test1','test2','test3'),
`col53` LONGTEXT,
`col54` TINYBLOB,
`col55` BLOB,
`col56` REAL,
`col57` SMALLINT,
`col58` DOUBLE PRECISION,
`col59` DOUBLE,
`col60` BOOL,
`col61` TEXT,
`col62` SMALLINT,
`col63` NUMERIC,
`col64` TINYBLOB,
`col65` SET ('test1','test2','test3'),
`col66` SET ('test1','test2','test3'),
`col67` YEAR,
`col68` ENUM ('test1','test2','test3'),
`col69` LONGBLOB,
`col70` MEDIUMTEXT,
`col71` DATE,
`col72` TINYINT,
`col73` SMALLINT,
`col74` CHAR (104),
`col75` SMALLINT,
`col76` MEDIUMBLOB,
`col77` BOOL,
`col78` TINYBLOB,
`col79` REAL,
`col80` CHAR (32),
`col81` SET ('test1','test2','test3'),
`col82` TINYINT,
`col83` TINYTEXT,
`col84` LONGBLOB,
`col85` BLOB,
`col86` TINYBLOB,
`col87` MEDIUMBLOB,
`col88` MEDIUMINT,
`col89` REAL,
`col90` LONGTEXT,
`col91` BIGINT,
`col92` FLOAT,
`col93` NUMERIC,
`col94` TINYBLOB,
`col95` INT,
`col96` MEDIUMBLOB,
`col97` TIME,
`col98` TINYBLOB,
`col99` CHAR (240),
`col100` TIME,
`col101` TIME,
`col102` TEXT,
`col103` TIMESTAMP,
`col104` YEAR,
`col105` FLOAT,
`col106` BLOB,
`col107` DECIMAL,
`col108` YEAR,
`col109` YEAR,
`col110` TINYINT,
`col111` DOUBLE,
`col112` BLOB,
`col113` VARCHAR (136),
`col114` TINYTEXT,
`col115` YEAR,
`col116` YEAR,
`col117` INT,
`col118` SMALLINT,
`col119` LONGBLOB,
`col120` INT,
`col121` VARCHAR (78),
KEY `idx0` (`col34`(172),`col14`),
KEY `idx1` (`col66`,`col32`),
KEY `idx2` (`col26`),
KEY `idx3` (`col87`(91)),
KEY `idx4` (`col34`(180)),
KEY `idx5` (`col43`,`col5`,`col74`),
KEY `idx6` (`col91`,`col51`),
KEY `idx7` (`col34`(194)),
KEY `idx8` (`col23`,`col77`),
KEY `idx9` (`col102`(225),`col66`,`col100`,`col3`),
KEY `idx10` (`col73`,`col70`(246)),
KEY `idx11` (`col3`,`col26`,`col63`,`col101`),
KEY `idx12` (`col76`(22),`col4`),
KEY `idx13` (`col51`,`col121`,`col19`),
KEY `idx14` (`col31`(15),`col99`),
KEY `idx15` (`col0`),
KEY `idx16` (`col71`,`col73`,`col72`),
KEY `idx17` (`col84`(255)),
KEY `idx18` (`col64`(28),`col3`),
KEY `idx19` (`col104`,`col97`),
KEY `idx20` (`col83`(93),`col37`(72)),
KEY `idx21` (`col9`),
KEY `idx22` (`col14`),
KEY `idx23` (`col29`,`col2`,`col26`),
KEY `idx24` (`col19`,`col13`(209),`col76`(158),`col15`),
KEY `idx25` (`col107`,`col52`),
KEY `idx26` (`col98`(202),`col108`,`col33`,`col78`(241))
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 197 columns and 7 indexes
DROP TABLE IF EXISTS `table8`;
CREATE TABLE IF NOT EXISTS `table8`
(`col0` YEAR,
`col1` DECIMAL,
`col2` DOUBLE,
`col3` TIME,
`col4` TIMESTAMP,
`col5` BLOB,
`col6` LONGTEXT,
`col7` TINYTEXT,
`col8` TINYBLOB,
`col9` TEXT,
`col10` MEDIUMTEXT,
`col11` DECIMAL,
`col12` BOOL,
`col13` VARCHAR (111),
`col14` LONGBLOB,
`col15` TINYINT,
`col16` DATETIME,
`col17` MEDIUMTEXT,
`col18` DECIMAL,
`col19` SET ('test1','test2','test3'),
`col20` LONGBLOB,
`col21` TINYBLOB,
`col22` NUMERIC,
`col23` NUMERIC,
`col24` TIME,
`col25` YEAR,
`col26` SET ('test1','test2','test3'),
`col27` DATETIME,
`col28` NUMERIC,
`col29` TINYBLOB,
`col30` LONGBLOB,
`col31` MEDIUMINT,
`col32` TIME,
`col33` REAL,
`col34` LONGTEXT,
`col35` LONGBLOB,
`col36` FLOAT,
`col37` DOUBLE PRECISION,
`col38` CHAR (251),
`col39` YEAR,
`col40` ENUM ('test1','test2','test3'),
`col41` SET ('test1','test2','test3'),
`col42` TIMESTAMP,
`col43` MEDIUMTEXT,
`col44` MEDIUMBLOB,
`col45` REAL,
`col46` DECIMAL,
`col47` MEDIUMBLOB,
`col48` LONGTEXT,
`col49` TIME,
`col50` DECIMAL,
`col51` BOOL,
`col52` LONGTEXT,
`col53` TINYTEXT,
`col54` DATETIME,
`col55` BLOB,
`col56` FLOAT,
`col57` BLOB,
`col58` DOUBLE PRECISION,
`col59` TINYINT,
`col60` TEXT,
`col61` FLOAT,
`col62` LONGTEXT,
`col63` NUMERIC,
`col64` TIME,
`col65` VARCHAR (253),
`col66` SMALLINT,
`col67` TIME,
`col68` INT,
`col69` DATETIME,
`col70` LONGBLOB,
`col71` TINYINT,
`col72` SET ('test1','test2','test3'),
`col73` BLOB,
`col74` MEDIUMINT,
`col75` TIMESTAMP,
`col76` TEXT,
`col77` INT,
`col78` ENUM ('test1','test2','test3'),
`col79` YEAR,
`col80` LONGBLOB,
`col81` BLOB,
`col82` TINYBLOB,
`col83` MEDIUMBLOB,
`col84` DECIMAL,
`col85` DOUBLE PRECISION,
`col86` FLOAT,
`col87` LONGTEXT,
`col88` FLOAT,
`col89` VARCHAR (2),
`col90` CHAR (46),
`col91` TINYBLOB,
`col92` NUMERIC,
`col93` DATETIME,
`col94` MEDIUMBLOB,
`col95` ENUM ('test1','test2','test3'),
`col96` MEDIUMINT,
`col97` DOUBLE,
`col98` DOUBLE,
`col99` ENUM ('test1','test2','test3'),
`col100` DATE,
`col101` ENUM ('test1','test2','test3'),
`col102` TINYINT,
`col103` MEDIUMBLOB,
`col104` MEDIUMTEXT,
`col105` BIGINT,
`col106` INT,
`col107` TINYTEXT,
`col108` DECIMAL,
`col109` CHAR (29),
`col110` CHAR (177),
`col111` BIGINT,
`col112` SMALLINT,
`col113` DATETIME,
`col114` DOUBLE,
`col115` NUMERIC,
`col116` TINYBLOB,
`col117` TIMESTAMP,
`col118` DOUBLE PRECISION,
`col119` YEAR,
`col120` REAL,
`col121` NUMERIC,
`col122` LONGBLOB,
`col123` DECIMAL,
`col124` DOUBLE PRECISION,
`col125` DOUBLE PRECISION,
`col126` LONGBLOB,
`col127` LONGTEXT,
`col128` TINYINT,
`col129` BIGINT,
`col130` BLOB,
`col131` LONGTEXT,
`col132` MEDIUMTEXT,
`col133` LONGBLOB,
`col134` BOOL,
`col135` DATE,
`col136` TIMESTAMP,
`col137` TEXT,
`col138` FLOAT,
`col139` DATETIME,
`col140` REAL,
`col141` BOOL,
`col142` CHAR (77),
`col143` DOUBLE,
`col144` TIMESTAMP,
`col145` LONGBLOB,
`col146` LONGTEXT,
`col147` TINYTEXT,
`col148` DOUBLE,
`col149` REAL,
`col150` TEXT,
`col151` TINYBLOB,
`col152` BOOL,
`col153` BOOL,
`col154` REAL,
`col155` NUMERIC,
`col156` SET ('test1','test2','test3'),
`col157` DATE,
`col158` BOOL,
`col159` ENUM ('test1','test2','test3'),
`col160` MEDIUMBLOB,
`col161` SET ('test1','test2','test3'),
`col162` MEDIUMINT,
`col163` LONGBLOB,
`col164` DOUBLE,
`col165` VARCHAR (134),
`col166` LONGBLOB,
`col167` DECIMAL,
`col168` LONGBLOB,
`col169` LONGTEXT,
`col170` TINYINT,
`col171` LONGBLOB,
`col172` SET ('test1','test2','test3'),
`col173` DOUBLE PRECISION,
`col174` TINYINT,
`col175` VARCHAR (13),
`col176` TINYTEXT,
`col177` DOUBLE PRECISION,
`col178` TINYTEXT,
`col179` ENUM ('test1','test2','test3'),
`col180` YEAR,
`col181` FLOAT,
`col182` DATETIME,
`col183` TIME,
`col184` TINYINT,
`col185` DOUBLE,
`col186` ENUM ('test1','test2','test3'),
`col187` DATE,
`col188` ENUM ('test1','test2','test3'),
`col189` MEDIUMBLOB,
`col190` LONGBLOB,
`col191` MEDIUMTEXT,
`col192` BOOL,
`col193` BOOL,
`col194` MEDIUMBLOB,
`col195` SMALLINT,
`col196` SMALLINT,
KEY `idx0` (`col46`,`col1`,`col10`(3),`col81`(115)),
KEY `idx1` (`col167`),
KEY `idx2` (`col175`,`col27`,`col192`),
KEY `idx3` (`col24`,`col55`(150)),
KEY `idx4` (`col81`(21),`col59`),
KEY `idx5` (`col138`,`col93`,`col174`),
KEY `idx6` (`col56`,`col22`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

# Creating a table with 103 columns and 24 indexes
DROP TABLE IF EXISTS `table9`;
CREATE TABLE IF NOT EXISTS `table9`
(`col0` CHAR (80),
`col1` DATETIME,
`col2` LONGBLOB,
`col3` TINYBLOB,
`col4` DOUBLE PRECISION,
`col5` CHAR (50),
`col6` REAL,
`col7` BLOB,
`col8` MEDIUMTEXT,
`col9` DOUBLE,
`col10` MEDIUMBLOB,
`col11` TIME,
`col12` BOOL,
`col13` BOOL,
`col14` BLOB,
`col15` SMALLINT,
`col16` SET ('test1','test2','test3'),
`col17` TEXT,
`col18` LONGBLOB,
`col19` YEAR,
`col20` LONGBLOB,
`col21` TEXT,
`col22` REAL,
`col23` TINYBLOB,
`col24` BLOB,
`col25` INT,
`col26` DECIMAL,
`col27` ENUM ('test1','test2','test3'),
`col28` BOOL,
`col29` BOOL,
`col30` YEAR,
`col31` REAL,
`col32` SET ('test1','test2','test3'),
`col33` TIME,
`col34` VARCHAR (216),
`col35` TINYBLOB,
`col36` YEAR,
`col37` VARCHAR (111),
`col38` SMALLINT,
`col39` SMALLINT,
`col40` YEAR,
`col41` MEDIUMINT,
`col42` DOUBLE PRECISION,
`col43` ENUM ('test1','test2','test3'),
`col44` SMALLINT,
`col45` TIME,
`col46` SET ('test1','test2','test3'),
`col47` NUMERIC,
`col48` TEXT,
`col49` TIME,
`col50` BOOL,
`col51` BIGINT,
`col52` DATETIME,
`col53` TINYBLOB,
`col54` SET ('test1','test2','test3'),
`col55` CHAR (3),
`col56` TINYTEXT,
`col57` TIME,
`col58` BLOB,
`col59` TEXT,
`col60` LONGBLOB,
`col61` DECIMAL,
`col62` SET ('test1','test2','test3'),
`col63` DECIMAL,
`col64` TIME,
`col65` BOOL,
`col66` TIMESTAMP,
`col67` ENUM ('test1','test2','test3'),
`col68` FLOAT,
`col69` VARCHAR (190),
`col70` DECIMAL,
`col71` TINYBLOB,
`col72` BIGINT,
`col73` DECIMAL,
`col74` LONGTEXT,
`col75` BIGINT,
`col76` NUMERIC,
`col77` REAL,
`col78` FLOAT,
`col79` DOUBLE PRECISION,
`col80` REAL,
`col81` BIGINT,
`col82` DOUBLE,
`col83` VARCHAR (174),
`col84` MEDIUMINT,
`col85` SET ('test1','test2','test3'),
`col86` TINYINT,
`col87` SET ('test1','test2','test3'),
`col88` TINYBLOB,
`col89` INT,
`col90` SMALLINT,
`col91` DOUBLE PRECISION,
`col92` CHAR (207),
`col93` MEDIUMTEXT,
`col94` NUMERIC,
`col95` SET ('test1','test2','test3'),
`col96` TEXT,
`col97` TEXT,
`col98` CHAR (17),
`col99` DATETIME,
`col100` INT,
`col101` FLOAT,
`col102` SET ('test1','test2','test3'),
KEY `idx0` (`col77`),
KEY `idx1` (`col15`,`col2`(201),`col59`(13),`col10`(140)),
KEY `idx2` (`col41`),
KEY `idx3` (`col100`,`col62`),
KEY `idx4` (`col28`),
KEY `idx5` (`col34`,`col99`,`col40`,`col86`),
KEY `idx6` (`col80`,`col21`(199)),
KEY `idx7` (`col51`,`col21`(222),`col60`(70)),
KEY `idx8` (`col72`,`col14`(70),`col24`(24),`col57`),
KEY `idx9` (`col73`),
KEY `idx10` (`col87`,`col72`,`col89`),
KEY `idx11` (`col53`(46),`col6`),
KEY `idx12` (`col1`),
KEY `idx13` (`col63`,`col7`(201),`col47`),
KEY `idx14` (`col84`,`col80`,`col79`,`col66`),
KEY `idx15` (`col35`(20),`col6`),
KEY `idx16` (`col31`,`col94`,`col47`),
KEY `idx17` (`col51`,`col97`(72),`col95`,`col52`),
KEY `idx18` (`col34`,`col24`(19),`col82`,`col39`),
KEY `idx19` (`col8`(158),`col84`,`col22`),
KEY `idx20` (`col2`(82)),
KEY `idx21` (`col61`),
KEY `idx22` (`col20`(213)),
KEY `idx23` (`col61`)
)engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;