max / makenotwork

380 B · 8 lines History Blame Raw

1	-- Per-item content removal by admin, separate from user unpublish.
2	-- Fulfills the enforcement ladder's "content removal" step (item hidden,
3	-- account stays active, creator notified with reason).
4
5	ALTER TABLE items ADD COLUMN removed_by_admin BOOLEAN NOT NULL DEFAULT false;
6	ALTER TABLE items ADD COLUMN removal_reason TEXT;
7	ALTER TABLE items ADD COLUMN removed_at TIMESTAMPTZ;
8