Files
hfb_jysh/backend/migrations/000073_distribution_site_home_entries.sql

13 lines
522 B
SQL

-- +goose Up
-- 分站首页入口。空字符串表示继承主站 mobile.aw_recycle / mobile.cooperation_feedback。
ALTER TABLE distribution_sites
ADD COLUMN aw_recycle_json TEXT NULL COMMENT '分站 AW炫彩回收 JSON,空则继承主站' AFTER footer_info_json,
ADD COLUMN cooperation_feedback_json TEXT NULL COMMENT '分站合作与反馈 JSON,空则继承主站' AFTER aw_recycle_json;
-- +goose Down
ALTER TABLE distribution_sites
DROP COLUMN cooperation_feedback_json,
DROP COLUMN aw_recycle_json;