-
Notifications
You must be signed in to change notification settings - Fork 11
/
v2_to_v3.sql
127 lines (110 loc) · 8.22 KB
/
v2_to_v3.sql
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
/*
v2_to_v3.sql
Date: 20/08/2022 12:00:00
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for melog_special
-- ----------------------------
DROP TABLE IF EXISTS `melog_special`;
CREATE TABLE `melog_special` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '专题ID',
`title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`short_title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '短标题',
`seo_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'SEO标题',
`click` int(255) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点击',
`keywords` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '简介',
`thumb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '缩略图',
`special_dir` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '目录地址（标识）',
`aside` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '侧边栏',
`page_width` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '页面宽度',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`flag` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '标识（0默认，1banner展示）',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for melog_special_item
-- ----------------------------
DROP TABLE IF EXISTS `melog_special_item`;
CREATE TABLE `melog_special_item` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '模块ID',
`special_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '专题ID',
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块类型',
`data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块数据',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`enable` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '启用',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table alter for melog_article
-- ----------------------------
ALTER TABLE `melog_article` CHANGE COLUMN `comment_total` `comment_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论总数';
ALTER TABLE `melog_article` CHANGE COLUMN `is_comment` `comment_set` int(10) NOT NULL DEFAULT 0 COMMENT '评论设置（0跟随系统，1强制开启，-1强制关闭）';
ALTER TABLE `melog_article` MODIFY COLUMN `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容' AFTER `description`;
-- ----------------------------
-- Table alter for melog_cate
-- ----------------------------
ALTER TABLE `melog_cate` ADD COLUMN `seo_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'SEO标题' AFTER `cate_dir`;
ALTER TABLE `melog_cate` MODIFY COLUMN `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '栏目简介' AFTER `keywords`;
-- ----------------------------
-- Table alter for melog_link
-- ----------------------------
ALTER TABLE `melog_link` CHANGE COLUMN `lname` `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题' AFTER `pid`;
-- ----------------------------
-- Table alter for melog_site
-- ----------------------------
ALTER TABLE `melog_site` CHANGE COLUMN `kname` `key` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数key';
ALTER TABLE `melog_site` CHANGE COLUMN `intro` `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数名字';
ALTER TABLE `melog_site` MODIFY COLUMN `group` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分组' AFTER `id`;
ALTER TABLE `melog_site` MODIFY COLUMN `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数值' AFTER `title`;
ALTER TABLE `melog_site` ADD COLUMN `options` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'radio、select选项值' AFTER `value`;
ALTER TABLE `melog_site` ADD COLUMN `tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段提示语' AFTER `options`;
ALTER TABLE `melog_site` ADD COLUMN `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' AFTER `tips`;
-- ----------------------------
-- Table alter for melog_user
-- ----------------------------
ALTER TABLE `melog_user` CHANGE COLUMN `tname` `true_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真实名字';
-- ----------------------------
-- Table data for melog_site
-- ----------------------------
INSERT INTO `melog_site`(`group`, `type`, `key`, `title`, `value`, `options`, `tips`, `sort`) VALUES ('web', 'input', 'seo_title', '主页SEO标题', '', '', '', 2);
INSERT INTO `melog_site`(`group`, `type`, `key`, `title`, `value`, `options`, `tips`, `sort`) VALUES ('web', 'radio', 'style', '网站导航风格', 'cms', 'cms|cms||blog|blog', '', 7);
INSERT INTO `melog_site`(`group`, `type`, `key`, `title`, `value`, `options`, `tips`, `sort`) VALUES ('web', 'input', 'nav_id', 'blog导航ID', 6, '', '即顶级链接ID', 8);
INSERT INTO `melog_site`(`group`, `type`, `key`, `title`, `value`, `options`, `tips`, `sort`) VALUES ('web', 'input', 'theme', '网站模板主题', '', '', '即模板目录名，为空时默认为\"view\"', 9);
INSERT INTO `melog_site`(`group`, `type`, `key`, `title`, `value`, `options`, `tips`, `sort`) VALUES ('other', 'input', 'map_ak', '百度地图ak', '465c0734722cfde06f7d7eac68559354', '', '', 2);
UPDATE `melog_site` SET `tips` = '需要带http或https，结尾不要带斜杠', `sort` = 0 WHERE `key` = 'basehost';
UPDATE `melog_site` SET `tips` = '用来隐藏后台地址，设置后，只能通过此地址进入后台', `sort` = 6 WHERE `key` = 'admin_alias';
UPDATE `melog_site` SET `sort` = 1 WHERE `key` = 'webname';
UPDATE `melog_site` SET `tips` = '目录前需带斜杠，默认为\"/upload\"', `sort` = 0 WHERE `key` = 'upload';
UPDATE `melog_site` SET `title` = '网站关键词', `sort` = 3 WHERE `key` = 'keywords';
UPDATE `melog_site` SET `sort` = 4 WHERE `key` = 'description';
UPDATE `melog_site` SET `tips` = '支持html、javascript代码', `sort` = 5 WHERE `key` = 'beian';
UPDATE `melog_site` SET `sort` = 1 WHERE `key` = 'img_width';
UPDATE `melog_site` SET `sort` = 2 WHERE `key` = 'img_height';
UPDATE `melog_site` SET `type` = 'radio', `title` = '开启评论', `options` = '开启|1||关闭|0', `sort` = 1 WHERE `key` = 'is_comment';
UPDATE `melog_site` SET `sort` = 3 WHERE `key` = 'thumb_width';
UPDATE `melog_site` SET `sort` = 4 WHERE `key` = 'thumb_height';
UPDATE `melog_site` SET `type` = 'radio', `title` = '保留原始图片', `options` = '保留|1||不保留|0', `sort` = 5 WHERE `key` = 'img_origin';
-- ----------------------------
-- Table data for melog_link
-- ----------------------------
DROP PROCEDURE IF EXISTS melog;
DELIMITER //
CREATE PROCEDURE melog()
BEGIN
DECLARE num int(10) default 0;
INSERT INTO `melog_link` (`pid`, `title`, `icon`, `url`, `sort`) VALUES (0, '顶部导航', '', '', 0);
SELECT id INTO num FROM `melog_link` WHERE `title` LIKE '顶部导航';
INSERT INTO `melog_link` (`pid`, `title`, `icon`, `url`, `sort`) VALUES (num, '首页', '', '/', 1);
INSERT INTO `melog_link` (`pid`, `title`, `icon`, `url`, `sort`) VALUES (num, '留言', '', '/article/2.html', 2);
INSERT INTO `melog_link` (`pid`, `title`, `icon`, `url`, `sort`) VALUES (num, '关于', '', '/article/1.html', 3);
UPDATE `melog_site` SET `value` = num WHERE `key` = 'nav_id';
END //
DELIMITER ;
CALL melog();
DROP PROCEDURE melog;
SET FOREIGN_KEY_CHECKS = 1;