38 lines
1.8 KiB
SQL
38 lines
1.8 KiB
SQL
-- +goose Up
|
|
|
|
-- 公告中心支持分站自定义：
|
|
-- 1) announcements.distribution_site_id 标记公告归属站点（0 = 主站），前台按站点隔离；
|
|
-- 2) distribution_sites.announcement_mode 决定分站公告中心来源：
|
|
-- inherit（默认）= 主站公告 + 本站公告；own_only = 仅本站公告。
|
|
ALTER TABLE announcements
|
|
ADD COLUMN distribution_site_id BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '归属站点，0=主站' AFTER id,
|
|
ADD KEY idx_announcements_site (distribution_site_id, status, is_pinned, priority, published_at);
|
|
|
|
ALTER TABLE distribution_sites
|
|
ADD COLUMN announcement_mode VARCHAR(16) NOT NULL DEFAULT 'inherit' COMMENT '公告中心来源：inherit=继承主站+本站，own_only=仅本站' AFTER storefront_text_json;
|
|
|
|
-- 站长（ops 角色）自助维护本站公告所需权限；超管与财务同样授予，便于代管。
|
|
INSERT INTO permissions (code, name, resource, action) VALUES
|
|
('distribution:announcement_view', '查看分站公告', 'distribution', 'announcement_view'),
|
|
('distribution:announcement_manage', '管理分站公告', 'distribution', 'announcement_manage')
|
|
ON DUPLICATE KEY UPDATE name = VALUES(name), resource = VALUES(resource), action = VALUES(action);
|
|
|
|
INSERT IGNORE INTO role_permissions (role_id, permission_id)
|
|
SELECT r.id, p.id FROM roles r CROSS JOIN permissions p
|
|
WHERE r.code IN ('super_admin', 'ops', 'finance') AND p.code LIKE 'distribution:announcement%';
|
|
|
|
-- +goose Down
|
|
|
|
DELETE rp FROM role_permissions rp
|
|
JOIN permissions p ON p.id = rp.permission_id
|
|
WHERE p.code LIKE 'distribution:announcement%';
|
|
|
|
DELETE FROM permissions WHERE code LIKE 'distribution:announcement%';
|
|
|
|
ALTER TABLE distribution_sites
|
|
DROP COLUMN announcement_mode;
|
|
|
|
ALTER TABLE announcements
|
|
DROP KEY idx_announcements_site,
|
|
DROP COLUMN distribution_site_id;
|