X-Git-Url: https://plomlompom.com/repos/?a=blobdiff_plain;f=migrations%2F5_create_process_step_suppressions.sql;fp=migrations%2F5_create_process_step_suppressions.sql;h=6ac4ea29acf9d5572ba1125587524ab57ec69f11;hb=8794d9441a50fc76d7746e6a034aff40705894f9;hp=0000000000000000000000000000000000000000;hpb=80e2cf170d408e7d183301ea3fba0df65ec261d5;p=plomtask

diff --git a/migrations/5_create_process_step_suppressions.sql b/migrations/5_create_process_step_suppressions.sql
new file mode 100644
index 0000000..6ac4ea2
--- /dev/null
+++ b/migrations/5_create_process_step_suppressions.sql
@@ -0,0 +1,8 @@
+CREATE TABLE process_step_suppressions (
+    process INTEGER NOT NULL,
+    process_step INTEGER NOT NULL,
+    PRIMARY KEY (process, process_step),
+    FOREIGN KEY (process) REFERENCES processes(id),
+    FOREIGN KEY (process_step) REFERENCES process_steps(id)
+);
+