85083ab962
完善官网、管理后台与后端的多语言内容编辑和发布流程，调整站点页面及相关接口，并同步数据库脚本。 新增容器部署配置，改用环境变量注入数据库凭据；补充仓库忽略规则，并停止跟踪本地环境文件和 Maven 构建产物。
20 lines
509 B
SQL
20 lines
509 B
SQL
-- Remove admin-side join page menu and its stale references.
|
|
|
|
DELETE FROM `sys_role_menu`
|
|
WHERE `menu_id` IN (2810, 2811, 2812, 2893);
|
|
|
|
DELETE FROM `sys_menu`
|
|
WHERE `menu_id` IN (2810, 2811, 2812, 2893);
|
|
|
|
UPDATE `huayang_site_config`
|
|
SET `config_value` = TRIM(BOTH ',' FROM
|
|
REPLACE(
|
|
REPLACE(
|
|
REPLACE(
|
|
REPLACE(CONCAT(',', COALESCE(`config_value`, ''), ','), ',2810,', ','),
|
|
',2811,', ','),
|
|
',2812,', ','),
|
|
',2893,', ',')
|
|
)
|
|
WHERE `config_key` = 'translation_menu_selected_ids';
|