CREATE
DATABASE
`test`;use `test`;
CREATE
TABLE
`log` ( `id`
int
(11) unsigned
NOT
NULL
AUTO_INCREMENT, `content` text
NOT
NULL
COMMENT
'内容'
, `status` tinyint(3) unsigned
NOT
NULL
COMMENT
'记录状态'
, `addtime`
int
(11) unsigned
NOT
NULL
COMMENT
'添加时间'
, `lastmodify`
int
(11) unsigned
NOT
NULL
COMMENT
'最后修改时间'
,
PRIMARY
KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1
DEFAULT
CHARSET=utf8
/*!50100 PARTITION
BY
RANGE (id)
(PARTITION p10w
VALUES
LESS THAN (100000) ENGINE = InnoDB,
PARTITION p20w
VALUES
LESS THAN (200000) ENGINE = InnoDB,
PARTITION p50w
VALUES
LESS THAN (500000) ENGINE = InnoDB,
PARTITION p100w
VALUES
LESS THAN (1000000) ENGINE = InnoDB,
PARTITION pmax
VALUES
LESS THAN MAXVALUE ENGINE = InnoDB) */;
insert
into
`log`(content,status,addtime,lastmodify)
values
(
'content1'
,1, unix_timestamp(
'2018-01-11 00:00:00'
), unix_timestamp(
'2018-01-11 00:00:00'
)),
(
'content2'
,1, unix_timestamp(
'2018-02-22 00:00:00'
), unix_timestamp(
'2018-02-22 00:00:00'
)),
(
'content3'
,1, unix_timestamp(
'2018-03-31 00:00:00'
), unix_timestamp(
'2018-03-31 00:00:00'
));