taskcafe/migrations/0017_add-profile-bg-delete-cascade.up.sql

7 lines
194 B
SQL

ALTER TABLE task_assigned
DROP CONSTRAINT task_assigned_task_id_fkey,
ADD CONSTRAINT task_assigned_task_id_fkey
FOREIGN KEY (task_id)
REFERENCES task(task_id)
ON DELETE CASCADE;