You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
13 lines
743 B
MySQL
13 lines
743 B
MySQL
|
7 years ago
|
CREATE TABLE IF NOT EXISTS `gconfig` (
|
||
|
|
`key` varchar(50) NOT NULL COMMENT '配置名',
|
||
|
|
`value` text NOT NULL COMMENT '配置值',
|
||
|
|
`oldvalue` text NOT NULL COMMENT '之前的配置值',
|
||
|
|
`name` varchar(128) NOT NULL COMMENT '配置名称',
|
||
|
|
`comment` text NOT NULL COMMENT '配置描述',
|
||
|
|
`operator_id` int(11) NOT NULL COMMENT '操作员 ID',
|
||
|
|
`operator_name` varchar(128) NOT NULL COMMENT '操作员名称',
|
||
|
|
`operator_email` varchar(32) NOT NULL COMMENT '操作员邮箱',
|
||
|
|
`last_update` bigint(20) NOT NULL COMMENT '修改时间',
|
||
|
|
PRIMARY KEY (`key`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网站配置';
|