From 44d00065cfbd0f24d2fac631608a5aeaace648a7 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 8 Apr 2021 20:34:11 +0100 Subject: Fix the foreign key constraint on setup_failure_missing_inputs It was broken in a previous migration. --- sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql (limited to 'sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql') diff --git a/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..4997bde --- /dev/null +++ b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,14 @@ +-- Deploy guix-build-coordinator:fix_setup_failure_missing_inputs to sqlite + +BEGIN; + +DELETE FROM setup_failures WHERE failure_reason = 'setup_failure'; + +DROP TABLE setup_failure_missing_inputs; + +CREATE TABLE setup_failure_missing_inputs ( + setup_failure_id INTEGER NOT NULL REFERENCES setup_failures (id), + missing_input_store_path TEXT NOT NULL +); + +COMMIT; -- cgit v1.2.3