forked from Gitlink/microservices
25 lines
1.5 KiB
SQL
25 lines
1.5 KiB
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
ALTER TABLE `ruoyi-gitlink`.`cms_doc`
|
|
ADD COLUMN `editor_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'markdown_editor' COMMENT '编辑器类型';
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`,
|
|
`update_by`, `update_time`, `remark`)
|
|
VALUES ('文本编辑器类型', 'editor_type', '0', 'admin', '2023-07-05 10:42:31', '', NULL, NULL);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`,
|
|
`list_class`, `is_default`, `status`, `create_by`, `create_time`,
|
|
`update_by`, `update_time`, `remark`)
|
|
VALUES (0, '富文本编辑器', 'rich_editor', 'editor_type', NULL, NULL, 'N', '0', 'admin', '2023-07-05 10:46:11', '', NULL,
|
|
NULL);
|
|
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`,
|
|
`list_class`, `is_default`, `status`, `create_by`, `create_time`,
|
|
`update_by`, `update_time`, `remark`)
|
|
VALUES (0, 'Markdown编辑器', 'markdown_editor', 'editor_type', NULL, NULL, 'N', '0', 'admin', '2023-07-05 10:46:31', '',
|
|
NULL, NULL);
|
|
|
|
update `ruoyi-gitlink`.cms_doc
|
|
set editor_type='markdown_editor'
|
|
where is_dir = 0;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |