From 44d00065cfbd0f24d2fac631608a5aeaace648a7 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
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

