taskcafe/migrations/0025_add-cascade-delete-to-task-id-fk-on-task_label.up.sql

7 lines
200 B
MySQL
Raw Permalink Normal View History

2020-06-19 01:12:15 +02:00
ALTER TABLE task_label DROP CONSTRAINT task_label_task_id_fkey;
ALTER TABLE task_label
ADD CONSTRAINT task_label_task_id_fkey
FOREIGN KEY (task_id)
REFERENCES task(task_id)
ON DELETE CASCADE;