CREATE DATABASE IF NOT EXISTS `stability_test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `stability_test`;

DROP TABLE IF EXISTS `item`;
CREATE TABLE IF NOT EXISTS `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Item custom name',
  `external_id` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `field1` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field2` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field3` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field4` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field5` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field6` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field7` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field8` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field9` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field10` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `external_id` (`external_id`),
  KEY `count` (`count`),
  UNIQUE KEY `field1` (`field1`),
  UNIQUE KEY `field2` (`field2`),
  UNIQUE KEY `field3` (`field3`),
  UNIQUE KEY `field4` (`field4`),
  UNIQUE KEY `field5` (`field5`),
  UNIQUE KEY `field6` (`field6`),
  UNIQUE KEY `field7` (`field7`),
  UNIQUE KEY `field8` (`field8`),
  UNIQUE KEY `field9` (`field9`),
  UNIQUE KEY `field10` (`field10`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;