From "show create table bench1'
Table Create Table bench1 CREATE TABLE `bench1` ( `field1` INT NOT NULL, `field_search` INT NOT NULL, `field2` INT NOT NULL, `field3` INT NOT NULL, `field4` VARCHAR(16) COLLATE utf8_general_ci NOT NULL, `field5` INT NOT NULL, `field6` DOUBLE NOT NULL, `field7` DOUBLE NOT NULL, `field8` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field9` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field10` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field11` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field12` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field13` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field14` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field15` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, `field16` VARCHAR(6) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`field1`,`field2`,`field3`,`field4`,`field5`,`field6`,`field7`,`field8`,`field9`,`field10`,`field11`,`field12`,`field13`,`field14`,`field15`,`field16`), KEY `index2` (`field_search`), KEY `index3` (`field3`), KEY `index4` (`field4`), KEY `index5` (`field5`), KEY `index6` (`field6`), KEY `index7` (`field7`), KEY `index8` (`field8`), KEY `index9` (`field9`), KEY `index10` (`field10`), KEY `index11` (`field11`), KEY `index12` (`field12`), KEY `index13` (`field13`), KEY `index14` (`field14`), KEY `index15` (`field15`), KEY `index16` (`field16`) ) ENGINE=InnoDB COLLATE = utf8_general_ci
From "show create table bench1'
Table Create Table ,`field2` ,`field3` ,`field4` ,`field5` ,`field6` ,`field7` ,`field8` ,`field9` ,`field10` ,`field11` ,`field12` ,`field13` ,`field14` ,`field15` ,`field16` ),
bench1 CREATE TABLE `bench1` (
`field1` INT NOT NULL,
`field_search` INT NOT NULL,
`field2` INT NOT NULL,
`field3` INT NOT NULL,
`field4` VARCHAR(16) COLLATE utf8_general_ci NOT NULL,
`field5` INT NOT NULL,
`field6` DOUBLE NOT NULL,
`field7` DOUBLE NOT NULL,
`field8` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field9` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field10` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field11` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field12` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field13` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field14` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field15` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
`field16` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`field1`
KEY `index2` (`field_search`),
KEY `index3` (`field3`),
KEY `index4` (`field4`),
KEY `index5` (`field5`),
KEY `index6` (`field6`),
KEY `index7` (`field7`),
KEY `index8` (`field8`),
KEY `index9` (`field9`),
KEY `index10` (`field10`),
KEY `index11` (`field11`),
KEY `index12` (`field12`),
KEY `index13` (`field13`),
KEY `index14` (`field14`),
KEY `index15` (`field15`),
KEY `index16` (`field16`)
) ENGINE=InnoDB COLLATE = utf8_general_ci