From 8794d9441a50fc76d7746e6a034aff40705894f9 Mon Sep 17 00:00:00 2001 From: Christian Heller Date: Thu, 6 Jun 2024 06:24:45 +0200 Subject: [PATCH] Add previously forgotten migration script. --- migrations/5_create_process_step_suppressions.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 migrations/5_create_process_step_suppressions.sql 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) +); + -- 2.30.2