-- 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';