CREATE TABLE `st_mobile_push_subscribe_day_general` (
  `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',
  `vendor` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `gender` tinyint unsigned NOT NULL DEFAULT 0,
  `age_group` tinyint unsigned NOT NULL DEFAULT 0,
  `is_app_user` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_pay_group` tinyint unsigned NOT NULL DEFAULT 0,
  `mobile_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `count` bigint(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`,`vendor`,`fs_activity_group`,`gender`,`age_group`,`is_app_user`,`fs_pay_group`,`mobile_activity_group`),
  KEY `clean` (`month`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY KEY */ /*!50611 ALGORITHM = 1 */ /*!50100 (`month`)
PARTITIONS 12 */;

CREATE TABLE `st_mobile_push_subscribe_month_general` (
  `field` int(10) unsigned NOT NULL DEFAULT '0',
  `month` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `day` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `vendor` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `gender` tinyint unsigned NOT NULL DEFAULT 0,
  `age_group` tinyint unsigned NOT NULL DEFAULT 0,
  `is_app_user` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_pay_group` tinyint unsigned NOT NULL DEFAULT 0,
  `mobile_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `count` bigint(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`,`vendor`,`fs_activity_group`,`gender`,`age_group`,`is_app_user`,`fs_pay_group`,`mobile_activity_group`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY KEY */ /*!50611 ALGORITHM = 1 */ /*!50100 (`month`)
PARTITIONS 12 */;

CREATE TABLE `st_mobile_push_subscribe_all_general` (
  `field` int(10) unsigned NOT NULL DEFAULT '0',
  `month` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `vendor` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `gender` tinyint unsigned NOT NULL DEFAULT 0,
  `age_group` tinyint unsigned NOT NULL DEFAULT 0,
  `is_app_user` tinyint unsigned NOT NULL DEFAULT 0,
  `fs_pay_group` tinyint unsigned NOT NULL DEFAULT 0,
  `mobile_activity_group` tinyint unsigned NOT NULL DEFAULT 0,
  `count` bigint(10) unsigned NOT NULL DEFAULT '0',
  `unique_month` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`field`,`month`,`vendor`,`fs_activity_group`,`gender`,`age_group`,`is_app_user`,`fs_pay_group`,`mobile_activity_group`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;