CREATE TABLE `a` (
|
`a` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
`b` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_general_cs DEFAULT NULL,
|
`c` varchar(128) DEFAULT NULL,
|
`d` varchar(255) DEFAULT NULL,
|
`e` varchar(128) DEFAULT NULL,
|
`f` varchar(128) DEFAULT NULL,
|
`g` varchar(255) DEFAULT NULL,
|
`h` smallint(1) unsigned NOT NULL DEFAULT 0,
|
`i` date DEFAULT NULL,
|
`j` tinyint(4) unsigned DEFAULT NULL,
|
`k` tinyint(4) unsigned DEFAULT NULL,
|
`l` tinyint(4) unsigned DEFAULT NULL,
|
`m` tinyint(4) unsigned DEFAULT NULL,
|
`n` tinyint(4) unsigned DEFAULT NULL,
|
`o` tinyint(4) unsigned DEFAULT NULL,
|
`p` tinyint(4) unsigned DEFAULT NULL,
|
`q` tinyint(4) unsigned DEFAULT NULL,
|
`r` tinyint(4) unsigned DEFAULT NULL,
|
`s` tinyint(4) unsigned DEFAULT NULL,
|
`t` tinyint(4) unsigned DEFAULT NULL,
|
`u` tinyint(4) unsigned DEFAULT NULL,
|
`v` tinyint(4) unsigned DEFAULT NULL,
|
`w` tinyint(4) unsigned DEFAULT NULL,
|
`x` tinyint(4) unsigned DEFAULT NULL,
|
`y` timestamp NULL DEFAULT NULL,
|
`z` varchar(50) DEFAULT NULL,
|
`aa` tinyint(1) NOT NULL DEFAULT 0,
|
`ab` timestamp NULL DEFAULT '0000-00-00 00:00:00',
|
`ac` timestamp NULL DEFAULT '0000-00-00 00:00:00',
|
`ad` varchar(20) DEFAULT NULL,
|
`ae` varchar(11) DEFAULT NULL,
|
`af` int(11) DEFAULT 0,
|
`ag` tinyint(3) unsigned DEFAULT 0,
|
`ah` char(1) NOT NULL DEFAULT 'A',
|
`ai` tinyint(1) NOT NULL DEFAULT 0,
|
`aj` tinyint(1) DEFAULT 0,
|
`ak` tinyint(1) unsigned NOT NULL DEFAULT 0,
|
`al` tinyint(1) NOT NULL DEFAULT 0,
|
`am` timestamp NULL DEFAULT NULL,
|
`an` timestamp NULL DEFAULT NULL,
|
`ao` varchar(255) DEFAULT NULL,
|
`ap` varchar(255) DEFAULT NULL,
|
`aq` varchar(255) DEFAULT NULL,
|
`ar` varchar(255) DEFAULT NULL,
|
`as` tinyint(1) DEFAULT 0,
|
`at` tinyint(1) DEFAULT 0,
|
`au` tinyint(1) DEFAULT 1,
|
`av` varchar(100) DEFAULT 'undefined',
|
`aw` tinyint(1) unsigned DEFAULT 1,
|
`ax` tinyint(1) unsigned DEFAULT 0,
|
`ay` tinyint(1) unsigned DEFAULT 0,
|
`az` tinyint(1) unsigned DEFAULT 0,
|
`ba` timestamp NULL DEFAULT NULL,
|
`bb` timestamp NULL DEFAULT NULL,
|
`bc` tinyint(3) unsigned DEFAULT 0,
|
`bd` varchar(255) DEFAULT NULL,
|
`be` tinyint(3) unsigned DEFAULT 0,
|
`bf` varchar(255) NOT NULL DEFAULT '',
|
`bg` varchar(32) DEFAULT NULL,
|
`bh` timestamp NULL DEFAULT NULL,
|
`bi` tinyint(4) unsigned DEFAULT 0,
|
`bj` tinyint(4) unsigned DEFAULT 0,
|
`bk` tinyint(3) unsigned DEFAULT 0,
|
`bl` tinyint(3) unsigned DEFAULT 0,
|
`bm` tinyint(3) unsigned DEFAULT 0,
|
`bn` tinyint(3) unsigned DEFAULT 0,
|
`bo` tinyint(3) unsigned DEFAULT 0,
|
`bp` text CHARACTER SET cp1251 COLLATE cp1251_general_cs DEFAULT NULL,
|
PRIMARY KEY (`a`,`aa`),
|
KEY `idx_ae` (`ae`) KEY_BLOCK_SIZE=8192,
|
KEY `idx_ab` (`ab`) KEY_BLOCK_SIZE=8192,
|
KEY `av` (`av`) KEY_BLOCK_SIZE=8192,
|
KEY `am` (`am`) KEY_BLOCK_SIZE=8192,
|
KEY `an` (`an`) KEY_BLOCK_SIZE=8192,
|
KEY `ac` (`ac`),
|
KEY `bn` (`bn`),
|
KEY `bo` (`bo`)
|
) ENGINE=InnoDB AUTO_INCREMENT=43300 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci ROW_FORMAT=DYNAMIC `page_compressed`=0
|
PARTITION BY LIST (`aa`)
|
(PARTITION `a0` VALUES IN (0) ENGINE = InnoDB,
|
PARTITION `a1` VALUES IN (1) ENGINE = InnoDB)
|