selfrelease
8 lines
292 B
SQL
8 lines
292 B
SQL
-- Migration: 014_add_notice_extras
|
|
-- Description: 通知公告增加定时发布和撤回字段
|
|
-- Date: 2026-08-01
|
|
|
|
ALTER TABLE notices ADD COLUMN scheduled_at TEXT;
|
|
ALTER TABLE notices ADD COLUMN withdrawn_at TEXT;
|
|
ALTER TABLE notices ADD COLUMN status TEXT NOT NULL DEFAULT 'published';
|