CMYH-SERVER/src/main/resources/db/migration/V1_2__20230202.sql

update sys_config set config_value = '武侯区华西医美健康城管理系统' where config_key = 'sys.index.title';

delete from cms_category;
insert into cms_category values(1, 0, null, '新闻资讯', 0, null, 1, '超级管理员', now());
insert into cms_category values(2, 0, null, '关于我们', 0, null, 2, '超级管理员', now());
insert into cms_category values(3, 0, null, '水电站简介', 0, null, 3, '超级管理员', now());

insert into cms_category values(4, 1, null, '水利要闻', 0, null, 1, '超级管理员', now());
insert into cms_category values(5, 1, null, '通知公告', 0, null, 2, '超级管理员', now());
insert into cms_category values(6, 1, null, '政策文件', 0, null, 3, '超级管理员', now());

insert into cms_category values(7, 2, null, '单位简介', 1, null, 1, '超级管理员', now());
insert into cms_category values(8, 2, null, '机构设置', 1, null, 2, '超级管理员', now());
insert into cms_category values(9, 2, null, '河湖长简介', 1, null, 3, '超级管理员', now());

insert into cms_category values(10, 3, null, '叶巴滩水电站', 1, null, 1, '超级管理员', now());
insert into cms_category values(11, 3, null, '松雪水电站', 1, null, 2, '超级管理员', now());
insert into cms_category values(12, 3, null, '拉哇水电站', 1, null, 3, '超级管理员', now());

SELECT setval('cms_category_category_id_seq', 100, true);

delete from sys_menu where parent_id = 107 or parent_id = 120 or parent_id = 123;
delete from sys_menu where menu_id = 107 or menu_id = 120 or menu_id = 123;