1-- Revert to the original blockers table without the blocker_id FK.
 2
 3CREATE TABLE blockers_old (
 4    task_id    TEXT,
 5    blocker_id TEXT,
 6    PRIMARY KEY (task_id, blocker_id),
 7    FOREIGN KEY (task_id) REFERENCES tasks(id)
 8);
 9
10INSERT INTO blockers_old (task_id, blocker_id)
11    SELECT task_id, blocker_id FROM blockers;
12
13DROP TABLE blockers;
14
15ALTER TABLE blockers_old RENAME TO blockers;