max / makenotwork

268 B · 5 lines History Blame Raw

1	-- Add scan_status to media_files so list queries can filter without a JOIN.
2	-- Existing rows default to 'clean' (they passed scanning at confirm time or
3	-- were uploaded by trusted users).
4	ALTER TABLE media_files ADD COLUMN scan_status TEXT NOT NULL DEFAULT 'clean';
5