A-表分区 //dd_user_log做成分区表 CREATE TABLE `dd_user_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '平台流水单号', `tran_id` varchar(255) DEFAULT NULL, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `card_type` char(5) DEFAULT NULL COMMENT '卡类型', `card_no` varchar(100) DEFAULT NULL COMMENT '卡号', `card_sc` varchar(100) DEFAULT NULL COMMENT '卡密', `card_value` char(5) DEFAULT NULL COMMENT '卡面值', `money` decimal(18,2) DEFAULT NULL COMMENT '真实充值金额', `status` tinyint(1) DEFAULT NULL COMMENT '0-审核状态 1-成功 2-失败', `ctime` int(11) unsigned NOT NULL COMMENT '创建日期', `etime` int(11) unsigned NOT NULL COMMENT '审核日期', `agent_id` tinyint(1) DEFAULT '1', `pay_status` tinyint(1) NOT NULL DEFAULT '0', `cash_id` int(11) DEFAULT NULL, `dz_type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`ctime`), KEY `uid` (`uid`) )ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE(ctime)( PARTITION p0 VALUES LESS THAN (UNIX_TIMESTAMP('2016-06-01 00:00:00')), PARTITION p1 VALUES LESS THAN (UNIX_TIMESTAMP('2016-07-01 00:00:00')), PARTITION p2 VALUES LESS THAN (UNIX_TIMESTAMP('2016-08-01 00:00:00')), PARTITION p3 VALUES LESS THAN (UNIX_TIMESTAMP('2016-09-01 00:00:00')), PARTITION p4 VALUES LESS THAN (UNIX_TIMESTAMP('2016-10-01 00:00:00')), PARTITION p5 VALUES LESS THAN (UNIX_TIMESTAMP('2016-11-01 00:00:00')), PARTITION p6 VALUES LESS THAN (UNIX_TIMESTAMP('2016-12-01 00:00:00')), PARTITION p7 VALUES LESS THAN (UNIX_TIMESTAMP('2017-01-01 00:00:00')), PARTITION p8 VALUES LESS THAN (UNIX_TIMESTAMP('2017-02-01 00:00:00')), PARTITION p9 VALUES LESS THAN (UNIX_TIMESTAMP('2017-03-01 00:00:00')), PARTITION p10 VALUES LESS THAN (UNIX_TIMESTAMP('2017-04-01 00:00:00')), PARTITION p11 VALUES LESS THAN (UNIX_TIMESTAMP('2017-05-01 00:00:00')), PARTITION p12 VALUES LESS THAN (UNIX_TIMESTAMP('2017-06-01 00:00:00')), PARTITION p13 VALUES LESS THAN (UNIX_TIMESTAMP('2017-07-01 00:00:00')), PARTITION p14 VALUES LESS THAN (UNIX_TIMESTAMP('2017-08-01 00:00:00')), PARTITION p15 VALUES LESS THAN (UNIX_TIMESTAMP('2017-09-01 00:00:00')), PARTITION p16 VALUES LESS THAN (UNIX_TIMESTAMP('2017-10-01 00:00:00')), PARTITION p17 VALUES LESS THAN (UNIX_TIMESTAMP('2017-11-01 00:00:00')), PARTITION p18 VALUES LESS THAN (UNIX_TIMESTAMP('2017-12-01 00:00:00')), PARTITION pmax VALUES LESS THAN (maxvalue) ); //dd_notice_log CREATE TABLE `dd_notice_log_p` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `agent_id` int(11) DEFAULT NULL COMMENT '卡回收渠道ID', `sh_id` varchar(50) DEFAULT NULL COMMENT '商户ID', `bill_no` varchar(50) DEFAULT NULL COMMENT '渠道平台订单ID', `sh_no` varchar(50) DEFAULT NULL COMMENT '商户平台订单ID', `pay_type` char(5) DEFAULT NULL COMMENT '支付类型', `pay_message` varchar(255) DEFAULT NULL COMMENT '支付结果信息', `pay_status` char(5) DEFAULT NULL COMMENT '支付状态', `pay_amt` char(5) DEFAULT NULL COMMENT '实际支付金额', `remark` varchar(250) DEFAULT NULL COMMENT '商家数据包原样', `sign` varchar(255) DEFAULT NULL COMMENT 'MD5签名结果', `ctime` int(11) DEFAULT NULL COMMENT '通知创建时间', `card_no` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`,`ctime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE(ctime)( PARTITION p0 VALUES LESS THAN (UNIX_TIMESTAMP('2016-06-01 00:00:00')), PARTITION p1 VALUES LESS THAN (UNIX_TIMESTAMP('2016-07-01 00:00:00')), PARTITION p2 VALUES LESS THAN (UNIX_TIMESTAMP('2016-08-01 00:00:00')), PARTITION p3 VALUES LESS THAN (UNIX_TIMESTAMP('2016-09-01 00:00:00')), PARTITION p4 VALUES LESS THAN (UNIX_TIMESTAMP('2016-10-01 00:00:00')), PARTITION p5 VALUES LESS THAN (UNIX_TIMESTAMP('2016-11-01 00:00:00')), PARTITION p6 VALUES LESS THAN (UNIX_TIMESTAMP('2016-12-01 00:00:00')), PARTITION p7 VALUES LESS THAN (UNIX_TIMESTAMP('2017-01-01 00:00:00')), PARTITION p8 VALUES LESS THAN (UNIX_TIMESTAMP('2017-02-01 00:00:00')), PARTITION p9 VALUES LESS THAN (UNIX_TIMESTAMP('2017-03-01 00:00:00')), PARTITION p10 VALUES LESS THAN (UNIX_TIMESTAMP('2017-04-01 00:00:00')), PARTITION p11 VALUES LESS THAN (UNIX_TIMESTAMP('2017-05-01 00:00:00')), PARTITION p12 VALUES LESS THAN (UNIX_TIMESTAMP('2017-06-01 00:00:00')), PARTITION p13 VALUES LESS THAN (UNIX_TIMESTAMP('2017-07-01 00:00:00')), PARTITION p14 VALUES LESS THAN (UNIX_TIMESTAMP('2017-08-01 00:00:00')), PARTITION p15 VALUES LESS THAN (UNIX_TIMESTAMP('2017-09-01 00:00:00')), PARTITION p16 VALUES LESS THAN (UNIX_TIMESTAMP('2017-10-01 00:00:00')), PARTITION p17 VALUES LESS THAN (UNIX_TIMESTAMP('2017-11-01 00:00:00')), PARTITION p18 VALUES LESS THAN (UNIX_TIMESTAMP('2017-12-01 00:00:00')), PARTITION pmax VALUES LESS THAN (maxvalue) ); //dd_hongbao_log CREATE TABLE `dd_hongbao_log_p` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT NULL COMMENT '用户ID', `oid` int(11) DEFAULT NULL COMMENT '订单ID', `return_code` varchar(20) DEFAULT NULL, `return_msg` varchar(255) DEFAULT NULL, `sign` varchar(255) DEFAULT NULL, `result_code` varchar(20) DEFAULT NULL, `err_code` varchar(20) DEFAULT NULL, `err_code_des` varchar(255) DEFAULT NULL, `mch_billno` varchar(250) DEFAULT NULL, `mch_id` varchar(250) DEFAULT NULL, `wxappid` varchar(20) DEFAULT NULL, `re_openid` varchar(100) DEFAULT NULL, `total_amount` char(10) DEFAULT NULL, `send_time` int(11) DEFAULT NULL, `send_listid` varchar(255) DEFAULT NULL, `ctime` int(11) DEFAULT NULL COMMENT '日志创建时间', `etime` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `remark` varchar(255) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`ctime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE(ctime)( PARTITION p0 VALUES LESS THAN (UNIX_TIMESTAMP('2016-06-01 00:00:00')), PARTITION p1 VALUES LESS THAN (UNIX_TIMESTAMP('2016-07-01 00:00:00')), PARTITION p2 VALUES LESS THAN (UNIX_TIMESTAMP('2016-08-01 00:00:00')), PARTITION p3 VALUES LESS THAN (UNIX_TIMESTAMP('2016-09-01 00:00:00')), PARTITION p4 VALUES LESS THAN (UNIX_TIMESTAMP('2016-10-01 00:00:00')), PARTITION p5 VALUES LESS THAN (UNIX_TIMESTAMP('2016-11-01 00:00:00')), PARTITION p6 VALUES LESS THAN (UNIX_TIMESTAMP('2016-12-01 00:00:00')), PARTITION p7 VALUES LESS THAN (UNIX_TIMESTAMP('2017-01-01 00:00:00')), PARTITION p8 VALUES LESS THAN (UNIX_TIMESTAMP('2017-02-01 00:00:00')), PARTITION p9 VALUES LESS THAN (UNIX_TIMESTAMP('2017-03-01 00:00:00')), PARTITION p10 VALUES LESS THAN (UNIX_TIMESTAMP('2017-04-01 00:00:00')), PARTITION p11 VALUES LESS THAN (UNIX_TIMESTAMP('2017-05-01 00:00:00')), PARTITION p12 VALUES LESS THAN (UNIX_TIMESTAMP('2017-06-01 00:00:00')), PARTITION p13 VALUES LESS THAN (UNIX_TIMESTAMP('2017-07-01 00:00:00')), PARTITION p14 VALUES LESS THAN (UNIX_TIMESTAMP('2017-08-01 00:00:00')), PARTITION p15 VALUES LESS THAN (UNIX_TIMESTAMP('2017-09-01 00:00:00')), PARTITION p16 VALUES LESS THAN (UNIX_TIMESTAMP('2017-10-01 00:00:00')), PARTITION p17 VALUES LESS THAN (UNIX_TIMESTAMP('2017-11-01 00:00:00')), PARTITION p18 VALUES LESS THAN (UNIX_TIMESTAMP('2017-12-01 00:00:00')), PARTITION pmax VALUES LESS THAN (maxvalue) );