Fix the foreign key constraint on setup_failure_missing_inputs

It was broken in a previous migration.

1 files changed, 14 insertions, 0 deletions

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;