drop table if exists g6;
CREATE TABLE `g6` (
  `a6` int(10) unsigned NOT NULL,
  `col21` mediumtext CHARACTER SET armscii8 NOT NULL,
  `col22` varbinary(203) NOT NULL,
  `col23` enum('','yl') CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
  `col55` date NOT NULL,
  `col1353` time NOT NULL,
  `col658` float unsigned DEFAULT NULL,
  `col1555` float unsigned zerofill NOT NULL,
  `col1514` datetime DEFAULT NULL,
  `col746` datetime DEFAULT NULL,
  `col1042` decimal(44,9) unsigned zerofill DEFAULT NULL,
  `col102` blob NOT NULL,
  `col1325` float unsigned zerofill DEFAULT NULL,
  `col1085` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `col411` datetime NOT NULL,
  `col1156` binary(1) NOT NULL,
  `col1721` time NOT NULL,
  `col1451` char(90) CHARACTER SET utf8 NOT NULL,
  `col211` set('npkbtihl','qt','hu') NOT NULL,
  `col1291` date NOT NULL,
  `col1214` varbinary(251) NOT NULL,
  `col1995` text NOT NULL,
  `col1460` char(150) NOT NULL,
  `col625` year(2) NOT NULL,
  `col358` year(4) DEFAULT NULL,
  `col1331` double unsigned DEFAULT NULL,
  `col1880` longblob NOT NULL,
  `col119` tinyint(1) DEFAULT NULL,
  `col1303` time NOT NULL,
  `col1972` blob NOT NULL,
  `col124` decimal(8,4) unsigned zerofill NOT NULL,
  `col1237` tinyint(1) NOT NULL,
  `col799` mediumblob NOT NULL,
  `col461` tinyblob NOT NULL,
  `col1665` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `col226` longblob NOT NULL,
  `col631` blob NOT NULL,
  `col693` double unsigned zerofill NOT NULL,
  `col1789` char(126) NOT NULL,
  `col1861` decimal(36,4) unsigned NOT NULL,
  `col470` time NOT NULL,
  `col870` tinyint(3) unsigned zerofill DEFAULT NULL,
  `col609` datetime NOT NULL,
  `col1804` smallint(5) unsigned zerofill NOT NULL,
  `col1835` date NOT NULL,
  `col1545` mediumtext NOT NULL,
  `col1801` tinytext NOT NULL,
  `col1167` int(11) DEFAULT NULL,
  `col1157` double unsigned NOT NULL,
  `col979` datetime NOT NULL,
  `col1644` decimal(49,15) unsigned zerofill NOT NULL,
  `col759` tinyblob NOT NULL,
  `col86` decimal(32,1) unsigned zerofill DEFAULT NULL,
  `col884` year(4) NOT NULL,
  `col645` char(211) CHARACTER SET utf8 NOT NULL,
  `col1524` date DEFAULT NULL,
  `col591` bit(26) DEFAULT NULL,
  `col1926` varchar(75) CHARACTER SET utf8 NOT NULL,
  `col1459` char(91) CHARACTER SET utf8 NOT NULL,
  `col1503` char(66) NOT NULL,
  `col1367` tinyint(1) NOT NULL,
  `col1877` decimal(51,16) unsigned DEFAULT NULL,
  `col810` text NOT NULL,
  `col934` text NOT NULL,
  `col167` binary(1) NOT NULL,
  `col1366` float unsigned NOT NULL,
  `col772` time DEFAULT NULL,
  `col388` varchar(246) NOT NULL,
  `col1196` tinyblob NOT NULL,
  `col1541` tinytext NOT NULL,
  `col1552` enum('iagvmr','mq','tuoed','uwboyeylgz','jgvmkmj') NOT NULL,
  `col1172` set('poira','flbijoyuk','rwydfzt') NOT NULL,
  `col841` char(111) CHARACTER SET utf8 NOT NULL,
  `col252` year(2) NOT NULL,
  `col1415` datetime DEFAULT NULL,
  `col681` datetime DEFAULT NULL,
  `col186` varbinary(67) NOT NULL,
  `col1140` binary(1) NOT NULL,
  `col700` datetime DEFAULT NULL,
  `col267` year(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 row_format=compressed KEY_BLOCK_SIZE=2;

set sql_mode='';
insert ignore into `g6` set 
`col1214`=repeat('a',219),
`col1880`=repeat('a',190),
`col799`=repeat('a',41),
`col461`=repeat('a',70),
`col226`=repeat('a',97),
`col631`=repeat('a',6),
`col1366`=1,
`col1196`=repeat('a',54),
`col1415`='19600921053612',
`col681`='19000725130636',
`col186`=repeat('a',137),
`col1140`=repeat('a',137),
`col700`='20040717012324'
;