drop table if exists `table2`;
CREATE TABLE `table2` (`col0` tinyint(1) DEFAULT NULL,
`col1` mediumint(9) DEFAULT NULL,
`col2` varchar(209) DEFAULT NULL,
`col3` mediumblob,
`col4` char(13) DEFAULT NULL,
`col5` double DEFAULT NULL,
`col6` tinytext,
`col7` double DEFAULT NULL,
`col8` smallint(6) DEFAULT NULL,
`col9` blob,
`col10` tinyint(4) DEFAULT NULL,
`col11` decimal(10,0) DEFAULT NULL,
`col12` blob,
`col13` decimal(10,0) DEFAULT NULL,
`col14` longblob,
`col15` smallint(6) DEFAULT NULL,
`col16` longblob,
`col17` tinytext,
`col18` float DEFAULT NULL,
`col19` char(78) DEFAULT NULL,
`col20` mediumtext,
`col21` set('test1','test2','test3') DEFAULT NULL,
`col22` mediumint(9) DEFAULT NULL,
`col23` int(11) DEFAULT NULL,
`col24` mediumblob,
`col25` enum('test1','test2','test3') DEFAULT NULL,
`col26` tinyblob,
`col27` varchar(116) DEFAULT NULL,
`col28` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`col29` blob,
`col30` smallint(6) DEFAULT NULL,
`col31` double DEFAULT NULL,
`col32` decimal(10,0) DEFAULT NULL,
`col33` decimal(10,0) DEFAULT NULL,
`col34` text,
`col35` mediumint(9) DEFAULT NULL,
`col36` mediumint(9) DEFAULT NULL,
`col37` bigint(20) DEFAULT NULL,
`col38` varchar(253) DEFAULT NULL,
`col39` tinyblob,
`col40` mediumblob,
`col41` bigint(20) DEFAULT NULL,
`col42` double DEFAULT NULL,
`col43` text,
`col44` blob,
`col45` time DEFAULT NULL,
`col46` mediumint(9) DEFAULT NULL,
`col47` double DEFAULT NULL,
`col48` set('test1','test2','test3') DEFAULT NULL,
`col49` double DEFAULT NULL,
`col50` varchar(97) DEFAULT NULL,
`col51` text,
`col52` decimal(10,0) DEFAULT NULL,
`col53` enum('test1','test2','test3') DEFAULT NULL,
`col54` mediumtext,
`col55` mediumint(9) DEFAULT NULL,
`col56` datetime DEFAULT NULL,
`col57` datetime DEFAULT NULL,
`col58` mediumtext,
`col59` char(244) DEFAULT NULL,
`col60` longblob,
`col61` mediumblob,
`col62` double DEFAULT NULL,
`col63` smallint(6) DEFAULT NULL,
`col64` tinyint(1) DEFAULT NULL,
`col65` smallint(6) DEFAULT NULL,
`col66` varchar(212) DEFAULT NULL,
`col67` time DEFAULT NULL,
`col68` double DEFAULT NULL,
`col69` tinyint(1) NOT NULL DEFAULT '0',
`col70` bigint(20) DEFAULT NULL,
`col71` date DEFAULT NULL,
`col72` tinyint(4) DEFAULT NULL,
`col73` enum('test1','test2','test3') DEFAULT NULL,
`col74` date DEFAULT NULL,
`col75` time DEFAULT NULL,
`col76` datetime DEFAULT NULL,
`col77` tinyint(1) DEFAULT NULL,
`col78` tinytext,
`col79` mediumint(9) DEFAULT NULL,
`col80` decimal(10,0) DEFAULT NULL,
`col81` longtext,
`col82` set('test1','test2','test3') DEFAULT NULL,
`col83` double DEFAULT NULL,
`col84` decimal(10,0) DEFAULT NULL,
`col85` varchar(184) DEFAULT NULL,
`col86` double DEFAULT NULL,
`col87` mediumtext,
`col88` mediumblob,
`col89` tinyint(1) DEFAULT NULL,
`col90` smallint(6) DEFAULT NULL,
`col91` tinyint(4) DEFAULT NULL,
`col92` enum('test1','test2','test3') DEFAULT NULL,
`col93` tinyint(1) DEFAULT NULL,
`col94` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col95` tinyint(1) DEFAULT NULL,
`col96` mediumtext,
`col97` decimal(10,0) DEFAULT NULL,
`col98` tinyint(1) DEFAULT NULL,
`col99` decimal(10,0) DEFAULT NULL,
`col100` mediumint(9) DEFAULT NULL,
`col101` double DEFAULT NULL,
`col102` tinyint(4) DEFAULT NULL,
`col103` tinyint(1) DEFAULT NULL,
`col104` mediumint(9) DEFAULT NULL,
`col105` decimal(10,0) DEFAULT NULL,
`col106` decimal(10,0) DEFAULT NULL,
`col107` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col108` mediumblob,
`col109` tinyblob,
`col110` set('test1','test2','test3') DEFAULT NULL,
`col111` year(4) DEFAULT NULL,
`col112` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col113` char(201) DEFAULT NULL,
`col114` tinyint(1) DEFAULT NULL,
`col115` tinyint(4) DEFAULT NULL,
`col116` double DEFAULT NULL,
`col117` tinyint(4) DEFAULT NULL,
`col118` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col119` set('test1','test2','test3') DEFAULT NULL,
`col120` smallint(6) DEFAULT NULL,
`col121` tinyblob,
`col122` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col123` blob,
`col124` date DEFAULT NULL,
`col125` smallint(6) DEFAULT NULL,
`col126` enum('test1','test2','test3') DEFAULT NULL,
`col127` mediumblob,
`col128` double DEFAULT NULL,
`col129` double DEFAULT NULL,
`col130` varchar(159) DEFAULT NULL,
`col131` mediumblob,
`col132` bigint(20) DEFAULT NULL,
`col133` int(11) DEFAULT NULL,
`col134` set('test1','test2','test3') DEFAULT NULL,
`col135` char(198) DEFAULT NULL,
`col136` set('test1','test2','test3') DEFAULT NULL,
`col137` mediumtext,
`col138` smallint(6) DEFAULT NULL,
`col139` blob,
`col140` longblob,   PRIMARY KEY (`col69`)  ) engine=maria DEFAULT CHARSET=latin1;

insert ignore into `table2` set `col69`=17342;
insert ignore into `table2` set 

`col22`=if(abs(-6874398)%100<20,null,19561),
`col24`=if(abs(-2089015823)%100<20,null,repeat('effloresces',abs(-112))),
`col25`=abs(-10719) % 2,
`col26`=if(abs(-1946772874)%100<20,null,repeat('Nydia',abs(43))),
`col27`=if(abs(-20592)%100<20,null,'Muhammadanisms'),
`col29`=if(abs(-1787646559)%100<20,null,repeat('Rebba\'s',abs(-22))),
`col30`=if(abs(15779)%100<20,null,26900),
`col31`=if(abs(1166021.8810083317)%100<20,null,-1598),
`col36`=if(abs(5767092)%100<20,null,-8924),
`col37`=if(abs(-1736248897)%100<20,null,-31653),
`col38`=if(abs(-1795)%100<20,null,'litigant\'s'),
`col39`=if(abs(-1886793247)%100<20,null,repeat('seronegative',abs(-94))),
`col40`=if(abs(-2129127577)%100<20,null,repeat('bionomics\'s',abs(55))),
`col41`=if(abs(-1929424498)%100<20,null,2819),
`col42`=if(abs(6178681.2536698505)%100<20,null,-5798),
`col43`=if(abs(-12075)%100<20,null,'Diamante\'s'),
`col44`=if(abs(-2084213737)%100<20,null,repeat('casemaker',abs(38))),
`col46`=if(abs(7942567)%100<20,null,-5924),
`col47`=if(abs(4289641858.3682671000)%100<20,null,-5226),
`col49`=if(abs(4293902134.2735987000)%100<20,null,14849),
`col50`=if(abs(-13329)%100<20,null,'undenominational'),
`col51`=if(abs(-28650)%100<20,null,'Ignaz'),
`col52`=if(abs(4293517328.4543290000)%100<20,null,-3033),
`col53`=abs(-11807) % 2,
`col54`=if(abs(-17453)%100<20,null,'Baillie'),
`col56`='20460118055904',
`col57`='19480707195730',
`col58`=if(abs(1128)%100<20,null,'Penrod'),
`col59`=if(abs(-18591)%100<20,null,'preternaturalness\'s'),
`col61`=if(abs(-2042183757)%100<20,null,repeat('hobbledehoy',abs(-56))),
`col62`=if(abs(4294572163.1192360000)%100<20,null,11263),
`col63`=if(abs(25867)%100<20,null,-16712),
`col64`=if(abs(25)%100<20,null,-1981),
`col66`=if(abs(18592)%100<20,null,'repressiveness\'s'),
`col68`=if(abs(4291866089.7126074000)%100<20,null,-32663),
`col69`=26305,
`col70`=if(abs(-1800247527)%100<20,null,-1178),
`col72`=if(abs(44)%100<20,null,25057),
`col73`=abs(32513) % 2,
`col75`='341850',
`col76`='20000916142124',
`col77`=if(abs(-23)%100<20,null,-6647),
`col78`=if(abs(-18783)%100<20,null,'tormentingly'),
`col79`=if(abs(-6884093)%100<20,null,14326),
`col83`=if(abs(4289701433.3442183000)%100<20,null,-21004),
`col85`=if(abs(8676)%100<20,null,'flirting'),
`col86`=if(abs(5062336.1094698934)%100<20,null,14447),
`col87`=if(abs(-26441)%100<20,null,'homogeneously'),
`col88`=if(abs(-2034504662)%100<20,null,repeat('bolus\'s',abs(-44))),
`col90`=if(abs(-30093)%100<20,null,15564),
`col104`=if(abs(-8180224)%100<20,null,30228),
`col105`=if(abs(140949.1506698813)%100<20,null,32512),
`col108`=if(abs(-1710319923)%100<20,null,repeat('chuckhole\'s',abs(61))),
`col109`=if(abs(-1626857284)%100<20,null,repeat('bastinadoing',abs(69))),
`col111`='1939',
`col116`=if(abs(3540365.1769157993)%100<20,null,-27809),
`col121`=if(abs(-2048098348)%100<20,null,repeat('calcic',abs(123))),
`col123`=if(abs(-2037703889)%100<20,null,repeat('plumbers',abs(-61))),
`col126`=abs(2155) % 2,
`col127`=if(abs(-2083635247)%100<20,null,repeat('Pottawatomie',abs(125))),
`col128`=if(abs(4744537.8902554400)%100<20,null,6139),
`col129`=if(abs(2294162.3178502764)%100<20,null,-6671),
`col140`=if(abs(-1576064925)%100<20,null,repeat('donations',abs(94)))
;