drop table if exists `t1`; CREATE TABLE `t1` ( `col_0` varchar(11) NOT NULL DEFAULT '', `col_1` varchar(70) NOT NULL, `col_2` int(11) unsigned DEFAULT NULL, `col_3` varchar(75) DEFAULT '', `col_4` varchar(100) NOT NULL DEFAULT '', `col_5` varchar(50) NOT NULL DEFAULT '', `col_6` varchar(200) NOT NULL DEFAULT '', `col_7` varchar(200) NOT NULL DEFAULT '', `col_8` varchar(100) NOT NULL DEFAULT '', `col_9` varchar(100) NOT NULL DEFAULT '', `col_10` varchar(100) NOT NULL DEFAULT '', `col_11` varchar(100) DEFAULT NULL, `col_12` varchar(20) DEFAULT NULL, `col_13` int(7) NOT NULL DEFAULT '0', `col_14` decimal(22,2) NOT NULL, `col_15` decimal(22,2) DEFAULT '0.00', `col_16` varchar(50) DEFAULT NULL, `col_16_` int(10) DEFAULT '0', `col_17` varchar(11) DEFAULT '0', `col_18` decimal(22,2) DEFAULT '0.00', `col_19` decimal(22,2) DEFAULT NULL, `col_20` text, `col_21` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `col_22` varchar(50) NOT NULL DEFAULT '', `col_23` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `col_24` text NOT NULL, `col_25` date NOT NULL, `col_26` varchar(50) NOT NULL, `col_27` varchar(20) NOT NULL DEFAULT '', `col_28` varchar(100) NOT NULL, `col_29` varchar(50) DEFAULT NULL, `col_30` varchar(50) DEFAULT NULL, `col_31` decimal(22,2) DEFAULT '0.00', `col_32` decimal(22,4) NOT NULL, `col_33` decimal(22,4) NOT NULL, `col_34` decimal(22,4) NOT NULL, `col_35` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `col_36` varchar(11) NOT NULL DEFAULT '', `col_37` varchar(11) DEFAULT NULL, `col_38` varchar(11) DEFAULT NULL, `col_39` varchar(11) DEFAULT NULL, `col_40` varchar(11) NOT NULL DEFAULT '', `col_41` varchar(11) NOT NULL DEFAULT '', `col_42` varchar(11) DEFAULT '', `col_43` decimal(22,2) NOT NULL, `col_44` varchar(11) NOT NULL DEFAULT '', `col_45` varchar(11) NOT NULL DEFAULT '', `col_46` enum('Y','N') NOT NULL DEFAULT 'Y', `col_47` varchar(200) DEFAULT NULL, `col_48` text, `col_49` text, `col_50` enum('YES','NO') NOT NULL DEFAULT 'YES', `col_51` enum('1','2','3','4','5') NOT NULL DEFAULT '1', `col_52` decimal(22,2) NOT NULL, `col_53` decimal(22,2) NOT NULL, `col_54` enum('1','2') NOT NULL DEFAULT '1', `col_55` int(11) unsigned NOT NULL DEFAULT '0', `col_56` text NOT NULL, `col_57` text NOT NULL, `col_58` text NOT NULL, `col_59` varchar(200) DEFAULT NULL, `col_60` decimal(22,2) NOT NULL, `col_61` decimal(22,2) NOT NULL, `col_62` varchar(11) NOT NULL DEFAULT '', `col_63` varchar(60) DEFAULT NULL, `col_64` enum('1','3') NOT NULL DEFAULT '1', `col_65` enum('YES','NO') NOT NULL DEFAULT 'NO', `col_66` varchar(50) NOT NULL, `col_67` enum('YES','NO') NOT NULL DEFAULT 'NO', `col_68` int(11) unsigned NOT NULL DEFAULT '0', `col_69` text NOT NULL, `col_70` varchar(50) NOT NULL, `col_71` varchar(50) DEFAULT NULL, `col_72` varchar(50) DEFAULT NULL, `col_73` varchar(50) DEFAULT NULL, `col_74` varchar(50) DEFAULT NULL, `col_75` varchar(50) DEFAULT NULL, `col_76` varchar(50) DEFAULT NULL, `col_77` varchar(50) DEFAULT NULL, `col_78` varchar(50) DEFAULT NULL, `col_79` varchar(50) DEFAULT NULL, `col_80` varchar(50) DEFAULT NULL, `col_81` varchar(50) DEFAULT NULL, `col_82` varchar(50) DEFAULT NULL, `col_83` varchar(50) DEFAULT NULL, `col_84` varchar(50) DEFAULT NULL, `col_85` varchar(50) DEFAULT NULL, `col_86` varchar(50) DEFAULT NULL, `col_87` varchar(50) DEFAULT NULL, `col_88` varchar(50) DEFAULT NULL, `col_89` varchar(50) DEFAULT NULL, `col_90` varchar(50) DEFAULT NULL, `col_91` varchar(50) DEFAULT NULL, `col_92` varchar(50) DEFAULT NULL, `col_93` varchar(50) DEFAULT NULL, `col_94` varchar(50) DEFAULT NULL, `col_95` varchar(50) DEFAULT NULL, `col_96` varchar(50) DEFAULT NULL, `col_97` varchar(50) DEFAULT NULL, `col_98` varchar(50) DEFAULT NULL, `col_99` varchar(50) DEFAULT NULL, `col_100` varchar(100) DEFAULT NULL, `col_101` varchar(50) DEFAULT '', `col_102` varchar(50) DEFAULT NULL, `col_103` varchar(50) DEFAULT NULL, `col_104` varchar(50) DEFAULT NULL, `col_105` varchar(50) DEFAULT NULL, `col_106` varchar(50) DEFAULT NULL, `col_107` varchar(50) DEFAULT NULL, `col_108` text, `col_109` date NOT NULL, `col_110` varchar(50) DEFAULT NULL, `col_111` text NOT NULL, `col_112` varchar(50) NOT NULL, `col_113` datetime NOT NULL, `col_114` enum('Y','N') NOT NULL DEFAULT 'N', `col_115` varchar(20) NOT NULL, `col_116` varchar(19) NOT NULL, `col_117` decimal(22,2) NOT NULL, `col_118` date NOT NULL, `col_119` varchar(50) DEFAULT NULL, `col_120` varchar(50) NOT NULL, `col_121` varchar(50) NOT NULL, `col_122` varchar(50) DEFAULT NULL, `col_123` varchar(50) DEFAULT NULL, `col_124` varchar(100) NOT NULL, `col_125` varchar(100) NOT NULL, `col_126` decimal(22,2) NOT NULL, `col_127` decimal(22,2) NOT NULL, `col_128` decimal(22,2) NOT NULL, `col_129` varchar(50) DEFAULT NULL, `col_130` varchar(50) NOT NULL, `col_131` decimal(22,2) NOT NULL, `col_132` text NOT NULL, `col_133` enum('YES','NO') NOT NULL DEFAULT 'NO', `col_134` decimal(22,0) DEFAULT '0', `col_135` varchar(50) DEFAULT NULL, `col_136` varchar(50) DEFAULT NULL, `col_137` varchar(50) DEFAULT NULL, `col_138` varchar(50) DEFAULT NULL, `col_139` varchar(11) DEFAULT NULL, `col_141` varchar(11) DEFAULT NULL, `col_142` varchar(100) DEFAULT NULL, `col_143` varchar(100) DEFAULT NULL, `col_144` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into t1 values ();