LuoQianhong
9ae88e3381
公开笔记本站点新增长文导航、正文检索、逐站点排除和站点配置，保留实时分享以及原有 Token、密码和解锁 Cookie。收录只对无密码的别名页生效，Token 页保持完整 noindex。 迁移 0072 为 notebook_shares 增加站点列，并新增排除关系表。先执行迁移再部署。 Closes #591
13 lines
698 B
SQL
13 lines
698 B
SQL
ALTER TABLE notebook_shares ADD COLUMN site_slug TEXT;
|
|
ALTER TABLE notebook_shares ADD COLUMN site_settings_json TEXT NOT NULL DEFAULT '{}'
|
|
CHECK (json_valid(site_settings_json) AND json_type(site_settings_json) = 'object');
|
|
CREATE UNIQUE INDEX idx_notebook_shares_site_slug
|
|
ON notebook_shares(lower(site_slug)) WHERE site_slug IS NOT NULL;
|
|
|
|
CREATE TABLE notebook_share_excluded_memos (
|
|
share_id TEXT NOT NULL REFERENCES notebook_shares(id) ON UPDATE CASCADE ON DELETE CASCADE,
|
|
memo_id TEXT NOT NULL REFERENCES memos(id) ON UPDATE CASCADE ON DELETE CASCADE,
|
|
PRIMARY KEY (share_id, memo_id)
|
|
);
|
|
CREATE INDEX idx_notebook_share_excluded_memos_memo ON notebook_share_excluded_memos(memo_id);
|