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)
 );