CREATE TABLE `bugtest` (
  `INTERFACE_ID` DOUBLE NOT NULL,
  `test1` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test2` VARCHAR(240) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test3` DOUBLE DEFAULT NULL,
  `test4` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test5` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test6` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test7` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test8` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test9` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test10` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test11` DECIMAL(15,0) DEFAULT NULL,
  `test12` DOUBLE NOT NULL DEFAULT '0',
  `test13` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test14` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test15` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test16` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test17` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test18` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test19` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test20` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test21` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test22` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test23` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test24` DATETIME DEFAULT NULL,
  `test25` DATETIME DEFAULT NULL,
  `test26` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test27` DOUBLE DEFAULT NULL,
  `test28` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test29` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'N',
  `test30` DATETIME DEFAULT NULL,
  `test31` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test32` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test33` DATETIME DEFAULT NULL,
  `test34` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test35` DATETIME DEFAULT NULL,
  `test36` DATETIME DEFAULT NULL,
  `test37` DATETIME DEFAULT NULL ,
  `test38` DATETIME DEFAULT NULL ,
  `test39` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Y/N',
  `test40` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test41` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test42` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test43` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test44` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test45` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test46` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test47` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test48` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `test49` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8;


