Add a new table to store setup_failures

This is when a build was allocated to an agent, but the agent couldn't setup
the environment for the build. One failure I'm particularly thinking about is
where inputs to the derivation are missing, so add another table to store
them.

1 files changed, 17 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/setup_failures.sql b/sqitch/sqlite/deploy/setup_failures.sql
new file mode 100644
index 0000000..977f103
--- /dev/null
+++ b/sqitch/sqlite/deploy/setup_failures.sql
@@ -0,0 +1,17 @@
+-- Deploy guix-build-coordinator:setup_failures to sqlite
+
+BEGIN;
+
+CREATE TABLE setup_failures (
+       id INTEGER PRIMARY KEY ASC,
+       build_id TEXT NOT NULL REFERENCES builds (uuid),
+       agent_id TEXT NOT NULL REFERENCES agents (id),
+       failure_reason TEXT NOT NULL
+);
+
+CREATE TABLE setup_failure_missing_inputs (
+       setup_failure_id INTEGER NOT NULL REFERENCES setup_failures (id),
+       missing_input_store_path TEXT NOT NULL
+);
+
+COMMIT;