21 lines
964 B
SQL
21 lines
964 B
SQL
-- Banner 位置字典：补「动态页面」= 6（App 动态顶部轮播）
|
|
-- 若库中已有 value=6，执行会因业务唯一性报错时可忽略；或先查：
|
|
-- SELECT * FROM system_dict_data WHERE dict_type='promotion_banner_position' AND value='6';
|
|
|
|
INSERT INTO `system_dict_data` (
|
|
`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`,
|
|
`remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`
|
|
)
|
|
SELECT 0, '动态页面', '6', 'promotion_banner_position', 0, 'primary', '',
|
|
'App 动态页 Banner', '1', NOW(), '1', NOW(), b'0'
|
|
FROM (SELECT 1 AS _) AS t
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM `system_dict_data`
|
|
WHERE `dict_type` = 'promotion_banner_position' AND `value` = '6' AND `deleted` = b'0'
|
|
);
|
|
|
|
-- 确保 Banner 菜单可见：营销中心 → 内容管理 → Banner
|
|
UPDATE `system_menu`
|
|
SET `status` = 0, `visible` = b'1', `deleted` = b'0', `update_time` = NOW()
|
|
WHERE `id` IN (2030, 2387, 2025);
|