变更普通表baby_user_change_log为分区表
一、 表列描述
mysql> desc baby_user_change_log ;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| account_id | int(11) unsigned | NO | MUL | NULL | |
| app_id | int(11) | YES | | NULL | |
| operate | varchar(20) | YES | | NULL | |
| old_data | varchar(2000) | YES | | NULL | |
| new_data | varchar(2000) | YES | | NULL | |
| change_data | varchar(2000) | YES | | NULL | |
| operate_time | int(11) | YES | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
二、 表结构特征
CREATE TABLE `baby_user_change_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自增id‘,
`account_id` int(11) unsigned NOT NULL COMMENT ‘account_id‘,
`app_id` int(11) DEFAULT NULL COMMENT ‘平台ID‘,
`operate` varchar(20) DEFAULT NULL COMMENT ‘操作类型‘,
`old_data` varchar(2000) DEFAULT NULL COMMENT ‘修改之前的数据‘,
`new_data` varchar(2000) DEFAULT NULL COMMENT ‘修改之后的数据‘,
`change_data` varchar(2000) DEFAULT NULL COMMENT ‘被修改的数据‘,
`operate_time` int(11) DEFAULT NULL COMMENT ‘时间‘,
PRIMARY KEY (`id`),
KEY `idx_account_id` (`account_id`)
)ENG