CREATE TABLE `st_analytics_all_test_492` (
  `field` int(10) unsigned NOT NULL DEFAULT '0',
  `month` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_group_492` int(11) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `unique_month` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`field`,`month`,`user_group_492`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
CREATE TABLE `st_analytics_day_test_492` (
  `field` int(10) unsigned NOT NULL DEFAULT '0',
  `month` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `day` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `hour` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_group_492` int(11) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `unique_month` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `unique_day` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `unique_hour` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`field`,`month`,`day`,`hour`,`user_group_492`),
  KEY `Index_2` (`month`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY KEY (`day`)
PARTITIONS 31 */;
CREATE TABLE `st_analytics_month_test_492` (
  `field` int(10) unsigned NOT NULL DEFAULT '0',
  `month` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `day` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `user_group_492` int(11) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `unique_month` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `unique_day` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`field`,`month`,`day`,`user_group_492`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY KEY (`month`)
PARTITIONS 12 */;