Files
FruitServer/sql/patch-2026-11-05-creator-publish-menu.sql

14 lines
970 B
SQL

-- Author: fruit.com.cn
-- 创作者中心「一键发布」隐藏路由(幂等,由发布流程执行)
-- visible=0:只作为路由存在,从「我的作品」页的发布按钮进入,不进侧边栏。
INSERT INTO sys_menu (id, parent_id, title, route_path, route_name, component, redirect, icon,
permission_code, type, always_show, affix, sort, visible) VALUES
(31, 26, '发布作品', 'publish', 'creator-publish', 'views/creator-center/PublishView',
'', '', 'creator-center:upload', 'MENU', 0, 0, 0, 0)
ON CONFLICT (id) DO UPDATE SET parent_id = EXCLUDED.parent_id, title = EXCLUDED.title,
route_path = EXCLUDED.route_path, route_name = EXCLUDED.route_name, component = EXCLUDED.component,
redirect = EXCLUDED.redirect, icon = EXCLUDED.icon, permission_code = EXCLUDED.permission_code,
type = EXCLUDED.type, always_show = EXCLUDED.always_show, affix = EXCLUDED.affix,
sort = EXCLUDED.sort, visible = EXCLUDED.visible;