CREATE TABLE `group_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_article_type` tinyint(3) unsigned NOT NULL COMMENT ‘1帖子2新闻’,
`group_article_id` int(10) unsigned NOT NULL COMMENT ‘ 帖子、新闻id’,
`pid` int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘论坛,新声对应的 评论id’,
`uid` int(10) unsigned NOT NULL COMMENT ‘用户id’,
`username` varchar(30) NOT NULL COMMENT ‘用户昵称’,
`content` mediumtext,
`dynstr` mediumblob NOT NULL COMMENT ‘虚拟动态列’,
`lights` smallint(5) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘亮’,
`create_at` int(10) unsigned NOT NULL COMMENT ‘回复时间（时间戳）’,
PRIMARY KEY (`id`,`group_article_id`),
KEY `group_article_type` (`group_article_type`,`group_article_id`),
KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT=’回复表（帖子、新闻）’
PARTITION BY RANGE (group_article_id)
(PARTITION p20000 VALUES LESS THAN (20000) ENGINE = InnoDB,
PARTITION p40000 VALUES LESS THAN (40000) ENGINE = InnoDB,
PARTITION p60000 VALUES LESS THAN (60000) ENGINE = InnoDB,
PARTITION p80000 VALUES LESS THAN (80000) ENGINE = InnoDB,
PARTITION p100000 VALUES LESS THAN (100000) ENGINE = InnoDB,
PARTITION p120000 VALUES LESS THAN (120000) ENGINE = InnoDB,
PARTITION p140000 VALUES LESS THAN (140000) ENGINE = InnoDB,
PARTITION p160000 VALUES LESS THAN (160000) ENGINE = InnoDB,
PARTITION p180000 VALUES LESS THAN (180000) ENGINE = InnoDB,
PARTITION p200000 VALUES LESS THAN (200000) ENGINE = InnoDB,
PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
后期的修改maxvalue
ALTER TABLE xxxx REORGANIZE PARTITION pm INTO (
PARTITION s0 VALUES LESS THAN(111) ENGINE = InnoDB,
PARTITION pm VALUES LESS THAN MAXVALUE ENGINE = InnoDB
)
for($i=3020000;$i<5000001;$i=$i+20000){ echo “PARTITION p$i VALUES LESS THAN($i) ENGINE = InnoDB,\n”; } die;