设计依据:docs/SITE_GROUP.md。依赖 M1(site_id 列 + 解析器);建议在 M2(站点管理后台)之后做,以便在后台直接配置各站参数。 目标:让每个站点拥有独立的配置、主题、SEO、搜索与缓存;前台会员支持「共享 / 独立」可切换。
docs/SITE_GROUP.md
settings
members
site_id
settings(key,site_id)
members(site_id,username)
Setting.get/set
GLOBAL_KEYS
redis_*
oss_*
storage_*
api_*
jwt_*
i18n_*
search_*
login_*
upload_*
audit_*
backup_*
member_scope
site_id=0
site_name
seo_*
site_theme
site_status
site_close_reason
footer_copyright
analytics_*
cache_*
form_notify_*
notify_*
(key,0)
_settings_map
_settings_map_{sid}
set()
sid
get_active_theme()
sites.theme
Setting('site_theme')
theme_template()
collect_sitemap_urls
/sitemap.xml
robots.txt
_try_cache
f'site{sid}:<key>'
_incr_view
_flush_view_counts
Setting
cache_ttl_*
shared
isolated
members.site_id
username
(0, username)
current_site_id()
plugins/member/frontend_routes.py
Member.query.filter_by(username=...)
site_id=current_site_id()
shared → isolated
isolated → shared
member_oauths
member_sms_codes
member_id
phone
email
member_only
member_scope=shared
member_scope=isolated
站群模式 M3:站点化子系统(settings/theme/sitemap/search/缓存)+ 会员 member_scope 开关
前置条件
settings/members已有site_id列,settings(key,site_id)/members(site_id,username)复合唯一已建。范围
A. 站点化 settings
Setting.get/set引入全局键集合GLOBAL_KEYS(每实例一份、与站点无关):redis_*、oss_*/storage_*、api_*/jwt_*、i18n_*、search_*、login_*、upload_*(安全策略)、audit_*/backup_*、member_scope。site_id=0(无论当前站点)。site_name/seo_*/site_theme/site_status/site_close_reason/footer_copyright/analytics_*/cache_*/form_notify_*/notify_*等):取当前站点site_id。(key,0)= 迁移后的现有行 → 行为不变。_settings_map键改为_settings_map_{sid};set()按对应sid失效。(key,0)(默认站点值)→ 新站点未配置时沿用默认站点的配置,避免空站。B. 站点主题
get_active_theme():「当前站点sites.theme→ 全局Setting('site_theme')(site_id=0)」fallback。theme_template()随之取站点主题;主题文件仍磁盘共享,仅选择器变化。C. sitemap / robots
collect_sitemap_urls按当前站点生成;各子域/域名各自/sitemap.xml仅含本站栏目/文章。robots.txt同理按站点输出。D. 搜索站点隔离
site_id字段;查询按当前站点过滤:site_id字段过滤;site_id条件。E. 缓存命名空间
_try_cache键加站点前缀f'site{sid}:<key>'。_incr_view/_flush_view_counts)按站点隔离(article id 全局唯一,键天然隔离,但视图计数 flush 需确认不跨站混淆)。Setting请求缓存按sid(见 A.2)。cache_ttl_*。F. 前台会员 member_scope(决策 2:超管可选共享/独立)
member_scope∈shared(默认,向后兼容)/isolated。超管在后台切换(全局键,恒 site_id=0)。members.site_id(M1 已加列):site_id=0;username复合唯一(0, username)= 全局唯一,与现网一致。current_site_id();username各站独立唯一。plugins/member/frontend_routes.py等):Member.query.filter_by(username=...)/ 按 phone / 短信验证码追加site_id=current_site_id();shared → isolated:存量会员保留site_id=0(归默认站点),新注册按当前站落;isolated → shared:可选提供「归一化」脚本把所有site_id置 0(需处理 username 冲突,冲突则报错提示)。member_oauths/member_sms_codes经member_id继承,无需加列;phone/email非唯一索引,独立模式天然可跨站共存。member_only栏目判定、前台会员会话归属按模式追加站点过滤。验收标准
member_scope=isolated:两站可注册同用户名(各自独立);登录/短信按站隔离。不做(留给后续阶段)
关联
docs/SITE_GROUP.md§4.3/§4.4/§9