Files
hfb_jysh/backend/migrations/000076_distribution_site_storefront_text.sql

16 lines
720 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- +goose Up
-- 分站首页文案(站长可在分销后台「品牌装修」自定义)。JSON 字段:
-- tagline 头部品牌区副标题(PC + 移动)
-- hero_badge 首页主视觉徽标(PC Hero + 移动认证卡片)
-- hero_desc 首页主视觉描述(PC)
-- card_sub 移动端认证卡片副标题
-- 空值或空字符串表示沿用前台内置默认文案,因此不影响存量站点。
ALTER TABLE distribution_sites
ADD COLUMN storefront_text_json TEXT NULL COMMENT '分站首页文案 JSON(tagline/hero_badge/hero_desc/card_sub),空字段继承默认' AFTER cooperation_feedback_json;
-- +goose Down
ALTER TABLE distribution_sites
DROP COLUMN storefront_text_json;