forked from mtusi2026/mtusi2026lab4
6 lines
354 B
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')); |