X-Git-Url: https://plomlompom.com/repos/?a=blobdiff_plain;f=migrations%2F4_create_Process_blockers_Todo_blockers.sql;fp=migrations%2F4_create_Process_blockers_Todo_blockers.sql;h=8e82ca1fb7f3d8751d1a9fd05a6e15e80ca140c3;hb=eb16b47ddcaefaeab2f616419ea746cc32346893;hp=0000000000000000000000000000000000000000;hpb=31b778276bb7297151f1c90098cc50842c9c138f;p=plomtask

diff --git a/migrations/4_create_Process_blockers_Todo_blockers.sql b/migrations/4_create_Process_blockers_Todo_blockers.sql
new file mode 100644
index 0000000..8e82ca1
--- /dev/null
+++ b/migrations/4_create_Process_blockers_Todo_blockers.sql
@@ -0,0 +1,14 @@
+CREATE TABLE process_blockers (
+    process INTEGER NOT NULL,
+    condition INTEGER NOT NULL,
+    PRIMARY KEY (process, condition),
+    FOREIGN KEY (process) REFERENCES processes(id),
+    FOREIGN KEY (condition) REFERENCES conditions(id)
+);
+CREATE TABLE todo_blockers (
+    todo INTEGER NOT NULL,
+    condition INTEGER NOT NULL,
+    PRIMARY KEY (todo, condition),
+    FOREIGN KEY (todo) REFERENCES todos(id),
+    FOREIGN KEY (condition) REFERENCES conditions(id)
+);