forked from mtusi2026/mtusi2026lab4
10 lines
282 B
SQL
10 lines
282 B
SQL
ALTER TABLE attachments
|
|
DROP CONSTRAINT attachments_ready_at;
|
|
|
|
ALTER TABLE attachments
|
|
ADD CONSTRAINT attachments_ready_at CHECK (
|
|
(status = 'pending' AND ready_at IS NULL) OR
|
|
(status = 'ready' AND ready_at IS NOT NULL) OR
|
|
status = 'deleting'
|
|
);
|