CREATE TABLE gb_dat (
  ID int(10) unsigned NOT NULL AUTO_INCREMENT,
  INTNR varchar(60) CHARACTER SET utf8 COLLATE utf8_bin,
  V1 varchar(50),
  V2 varchar(10),
  V3 varchar(10),
  V4 varchar(4),
  V5 tinyint(1),
  V6 tinyint(1),
  V7 tinyint(1),
  V8 tinyint(1),
  V9 tinyint(1),
  V10 tinyint(1),
  V11 tinyint(1),
  V12 varchar(7),
  V13 tinyint(1),
  V14 varchar(500) CHARACTER SET utf8 COLLATE utf8_bin,
  V15 varchar(6),
  V16 varchar(4),
  V17 varchar(8),
  V18 varchar(9),
  V19 tinyint(1),
  V20 tinyint(1),
  V21 tinyint(1),
  V22 tinyint(1),
  V23 tinyint(1),
  V24 tinyint(1),
  V104 tinyint(6),
  V105 tinyint(1),
  V106 tinyint(1),
  V107 tinyint(1),
  V108 tinyint(2),
  V109 tinyint(1),
  V110 tinyint(1),
  V112 tinyint(2),
  V115 decimal(6,2),
  V116 decimal(6,2),
  V117 decimal(6,2),
  V118 decimal(6,2),
  V119 tinyint(1),
  V120 tinyint(1),
  V121 tinyint(1),
  V122 tinyint(1),
  V123 tinyint(1),
  V124 tinyint(1),
  V201 decimal(6,2),
  V202 tinyint(2),
  V203 decimal(6,2),
  V301 decimal(6,2),
  V302 tinyint(2),
  V303 decimal(6,2),
  V401 decimal(6,2),
  V402 tinyint(2),
  V403 decimal(6,2),
  V111 decimal(6,2),
  V222 tinyint(2),
  V333 decimal(6,2),
  V901 varchar(3) CHARACTER SET utf8 COLLATE utf8_bin,
  V902_1 varchar(2) CHARACTER SET utf8 COLLATE utf8_bin,
  V902_2 varchar(2) CHARACTER SET utf8 COLLATE utf8_bin,
  V903_1 varchar(2) CHARACTER SET utf8 COLLATE utf8_bin,
  V903_2 varchar(2) CHARACTER SET utf8 COLLATE utf8_bin,
  V903_3 varchar(2) CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
