db.sql
3.37 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
CREATE TABLE `bsth_c_sys_op_log` (
`timestamp` bigint(20) NOT NULL ,
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`caller_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`caller_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`client_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`http_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`month` date NOT NULL ,
`path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`server_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`line_number` int(11) NULL DEFAULT NULL
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=DYNAMIC
PARTITION BY RANGE(TO_DAYS (month))
(
PARTITION p201610 VALUES LESS THAN (TO_DAYS('2016-11-01')),
PARTITION p201611 VALUES LESS THAN (TO_DAYS('2016-12-01')),
PARTITION p201612 VALUES LESS THAN (TO_DAYS('2017-01-01')),
PARTITION p201701 VALUES LESS THAN (TO_DAYS('2017-02-01')),
PARTITION p201702 VALUES LESS THAN (TO_DAYS('2017-03-01')),
PARTITION p201703 VALUES LESS THAN (TO_DAYS('2017-04-01')),
PARTITION p201704 VALUES LESS THAN (TO_DAYS('2017-05-01')),
PARTITION p201705 VALUES LESS THAN (TO_DAYS('2017-06-01')),
PARTITION p201706 VALUES LESS THAN (TO_DAYS('2017-07-01')),
PARTITION p201707 VALUES LESS THAN (TO_DAYS('2017-08-01')),
PARTITION p201708 VALUES LESS THAN (TO_DAYS('2017-09-01')),
PARTITION p201709 VALUES LESS THAN (TO_DAYS('2017-10-01')),
PARTITION p201710 VALUES LESS THAN (TO_DAYS('2017-11-01')),
PARTITION p201711 VALUES LESS THAN (TO_DAYS('2017-12-01')),
PARTITION p201712 VALUES LESS THAN (TO_DAYS('2018-01-01')),
PARTITION p201801 VALUES LESS THAN (TO_DAYS('2018-02-01')),
PARTITION p201802 VALUES LESS THAN (TO_DAYS('2018-03-01')),
PARTITION p201803 VALUES LESS THAN (TO_DAYS('2018-04-01')),
PARTITION p201804 VALUES LESS THAN (TO_DAYS('2018-05-01')),
PARTITION p201805 VALUES LESS THAN (TO_DAYS('2018-06-01')),
PARTITION p201806 VALUES LESS THAN (TO_DAYS('2018-07-01')),
PARTITION p201807 VALUES LESS THAN (TO_DAYS('2018-08-01')),
PARTITION p201808 VALUES LESS THAN (TO_DAYS('2018-09-01')),
PARTITION p201809 VALUES LESS THAN (TO_DAYS('2018-10-01')),
PARTITION p201810 VALUES LESS THAN (TO_DAYS('2018-11-01')),
PARTITION p201811 VALUES LESS THAN (TO_DAYS('2018-12-01')),
PARTITION p201812 VALUES LESS THAN (TO_DAYS('2019-01-01')),
PARTITION p201901 VALUES LESS THAN (TO_DAYS('2019-02-01')),
PARTITION p201902 VALUES LESS THAN (TO_DAYS('2019-03-01')),
PARTITION p201903 VALUES LESS THAN (TO_DAYS('2019-04-01')),
PARTITION p201904 VALUES LESS THAN (TO_DAYS('2019-05-01')),
PARTITION p201905 VALUES LESS THAN (TO_DAYS('2019-06-01')),
PARTITION p201906 VALUES LESS THAN (TO_DAYS('2019-07-01')),
PARTITION p201907 VALUES LESS THAN (TO_DAYS('2019-08-01')),
PARTITION p201908 VALUES LESS THAN (TO_DAYS('2019-09-01')),
PARTITION p201909 VALUES LESS THAN (TO_DAYS('2019-10-01')),
PARTITION p201910 VALUES LESS THAN (TO_DAYS('2019-11-01')),
PARTITION p201911 VALUES LESS THAN (TO_DAYS('2019-12-01')),
PARTITION p201912 VALUES LESS THAN (TO_DAYS('2020-01-01'))
);