Files
mtusi2026lab4/migrations/004_attachment_integrity.sql

6 lines
354 B
SQL

ALTER TABLE attachments
ADD COLUMN IF NOT EXISTS storage_state text NOT NULL DEFAULT 'ok',
ADD COLUMN IF NOT EXISTS storage_checked_at timestamptz;
ALTER TABLE attachments DROP CONSTRAINT IF EXISTS attachments_storage_state;
ALTER TABLE attachments ADD CONSTRAINT attachments_storage_state CHECK (storage_state IN ('ok', 'missing'));