DROP TABLE
IF EXISTSet_msg_201703;CREATE TABLE
IF NOT EXISTSet_user_msg_201703 (
`mid`BIGINTauto_increment ,
`send_username`VARCHAR (255) NOT NULL COMMENT '发送消息者',
`receive_username`VARCHAR (255) NOT NULL COMMENT '接受消息者,发送者发送的对象',
`video_source_id`TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '分享视频的来源地址:0,youtube;1,facebook;2,ted',
`video_thumb_url`VARCHAR (255),
`videoId`VARCHAR (255) DEFAULT '' COMMENT '视频的videoId',
`share_url`VARCHAR (255),
`share_title`VARCHAR (255),
`share_text`TEXT,
`share_time`INT (11),
`share_status`TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0,未读;1,已读',
`share_type`TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0,分享类消息;1,聊天类消息',KEY(send_username),PRIMARY key(mid,share_time),KEY(receive_username),KEY(
send_username,
receive_username,
share_status
)
) ENGINE= INNODB charset = utf8 PARTITION BYRANGE (share_time)(
PARTITION p1VALUESLESS THAN (1488322800),
PARTITION p2VALUESLESS THAN (1488409200),
PARTITION p3VALUESLESS THAN (1488495600),
PARTITION p4VALUESLESS THAN (1488582000),
PARTITION p5VALUESLESS THAN (1488668400),
PARTITION p6VALUESLESS THAN (1488754800),
PARTITION p7VALUESLESS THAN (1488841200),
PARTITION p8VALUESLESS THAN (1488927600),
PARTITION p9VALUESLESS THAN (1489014000),
PARTITION p10VALUESLESS THAN (1489100400),
PARTITION p11VALUESLESS THAN (1489186800),
PARTITION p12VALUESLESS THAN (1489273200),
PARTITION p13VALUESLESS THAN (1489359600),
PARTITION p14VALUESLESS THAN (1489446000),
PARTITION p15VALUESLESS THAN (1489532400),
PARTITION p16VALUESLESS THAN (1489618800),
PARTITION p17VALUESLESS THAN (1489705200),
PARTITION p18VALUESLESS THAN (1489791600),
PARTITION p19VALUESLESS THAN (1489878000),
PARTITION p20VALUESLESS THAN (1489964400),
PARTITION p21VALUESLESS THAN (1490050800),
PARTITION p22VALUESLESS THAN (1490137200),
PARTITION p23VALUESLESS THAN (1490223600),
PARTITION p24VALUESLESS THAN (1490310000),
PARTITION p25VALUESLESS THAN (1490396400),
PARTITION p26VALUESLESS THAN (1490482800),
PARTITION p27VALUESLESS THAN (1490565600),
PARTITION p28VALUESLESS THAN (1490652000),
PARTITION p29VALUESLESS THAN (1490738400),
PARTITION p30VALUESLESS THAN (1490824800),
PARTITION p31VALUESLESS THAN (1490911200)
);