aboutsummaryrefslogtreecommitdiff
path: root/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql')
-rw-r--r--sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql14
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;