85083ab962
完善官网、管理后台与后端的多语言内容编辑和发布流程，调整站点页面及相关接口，并同步数据库脚本。 新增容器部署配置，改用环境变量注入数据库凭据；补充仓库忽略规则，并停止跟踪本地环境文件和 Maven 构建产物。
116 lines
4.5 KiB
SQL
116 lines
4.5 KiB
SQL
-- =====================================================================
|
||
-- 多语言国际化：补充「静态文案」菜单（已有库升级脚本）
|
||
-- 适用场景：侧栏仅显示“语言配置 / 翻译管理”，未显示“静态文案”
|
||
-- 执行环境：MySQL 8+
|
||
-- 幂等：可重复执行
|
||
-- =====================================================================
|
||
|
||
-- 1) 菜单：静态文案（C）
|
||
INSERT INTO `sys_menu` (
|
||
`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
|
||
`query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
|
||
`perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
|
||
)
|
||
SELECT
|
||
2991, '静态文案', 2660, 3, 'staticText', 'huayang/staticText/index',
|
||
'', '', 1, 0, 'C', '0', '0',
|
||
'huayang:translation:list', 'form', 'admin', NOW(), '', NULL, '按 key 维护静态文案'
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2660)
|
||
AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991);
|
||
|
||
-- 2) 按钮权限（F）：查询 / 新增 / 修改 / 删除
|
||
INSERT INTO `sys_menu` (
|
||
`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
|
||
`query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
|
||
`perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
|
||
)
|
||
SELECT
|
||
2992, '静态文案查询', 2991, 1, '', '', '', '', 1, 0, 'F', '0', '0',
|
||
'huayang:translation:query', '#', 'admin', NOW(), '', NULL, ''
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
|
||
AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2992);
|
||
|
||
INSERT INTO `sys_menu` (
|
||
`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
|
||
`query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
|
||
`perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
|
||
)
|
||
SELECT
|
||
2993, '静态文案新增', 2991, 2, '', '', '', '', 1, 0, 'F', '0', '0',
|
||
'huayang:translation:add', '#', 'admin', NOW(), '', NULL, ''
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
|
||
AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2993);
|
||
|
||
INSERT INTO `sys_menu` (
|
||
`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
|
||
`query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
|
||
`perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
|
||
)
|
||
SELECT
|
||
2994, '静态文案修改', 2991, 3, '', '', '', '', 1, 0, 'F', '0', '0',
|
||
'huayang:translation:edit', '#', 'admin', NOW(), '', NULL, ''
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
|
||
AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2994);
|
||
|
||
INSERT INTO `sys_menu` (
|
||
`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`,
|
||
`query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`,
|
||
`perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`
|
||
)
|
||
SELECT
|
||
2995, '静态文案删除', 2991, 4, '', '', '', '', 1, 0, 'F', '0', '0',
|
||
'huayang:translation:remove', '#', 'admin', NOW(), '', NULL, ''
|
||
FROM DUAL
|
||
WHERE EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2991)
|
||
AND NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `menu_id` = 2995);
|
||
|
||
-- 3) 给已有“翻译管理(2662)”权限的角色补“静态文案(2991~2995)”权限
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT rm.`role_id`, 2991
|
||
FROM `sys_role_menu` rm
|
||
WHERE rm.`menu_id` = 2662
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `sys_role_menu` t
|
||
WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2991
|
||
);
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT rm.`role_id`, 2992
|
||
FROM `sys_role_menu` rm
|
||
WHERE rm.`menu_id` = 2662
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `sys_role_menu` t
|
||
WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2992
|
||
);
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT rm.`role_id`, 2993
|
||
FROM `sys_role_menu` rm
|
||
WHERE rm.`menu_id` = 2662
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `sys_role_menu` t
|
||
WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2993
|
||
);
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT rm.`role_id`, 2994
|
||
FROM `sys_role_menu` rm
|
||
WHERE rm.`menu_id` = 2662
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `sys_role_menu` t
|
||
WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2994
|
||
);
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT rm.`role_id`, 2995
|
||
FROM `sys_role_menu` rm
|
||
WHERE rm.`menu_id` = 2662
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM `sys_role_menu` t
|
||
WHERE t.`role_id` = rm.`role_id` AND t.`menu_id` = 2995
|
||
);
|