diff options
Diffstat (limited to 'sqitch/sqlite')
9 files changed, 69 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql b/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..66d6b45 --- /dev/null +++ b/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:allocated_builds_submit_outputs to sqlite + +BEGIN; + +ALTER TABLE allocated_builds ADD COLUMN submit_outputs BOOLEAN DEFAULT NULL; + +COMMIT; diff --git a/sqitch/sqlite/deploy/background-jobs-queue.sql b/sqitch/sqlite/deploy/background-jobs-queue.sql new file mode 100644 index 0000000..1cb35f0 --- /dev/null +++ b/sqitch/sqlite/deploy/background-jobs-queue.sql @@ -0,0 +1,11 @@ +-- Deploy guix-build-coordinator:background-jobs-queue to sqlite + +BEGIN; + +CREATE TABLE background_jobs_queue ( + id INTEGER PRIMARY KEY, + type TEXT NOT NULL, + args TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..a404f31 --- /dev/null +++ b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql @@ -0,0 +1,9 @@ +-- Deploy guix-build-coordinator:builds_replace_unprocessed_index to sqlite + +BEGIN; + +DROP INDEX builds_unprocessed; + +CREATE INDEX builds_live ON builds (id) WHERE processed = 0 AND canceled = 0; + +COMMIT; diff --git a/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql b/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..240de22 --- /dev/null +++ b/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:allocated_builds_submit_outputs from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/revert/background-jobs-queue.sql b/sqitch/sqlite/revert/background-jobs-queue.sql new file mode 100644 index 0000000..10ef1ff --- /dev/null +++ b/sqitch/sqlite/revert/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:background-jobs-queue from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql b/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..b02dd3c --- /dev/null +++ b/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:builds_replace_unprocessed_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql b/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..0b1331e --- /dev/null +++ b/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:allocated_builds_submit_outputs on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqlite/verify/background-jobs-queue.sql b/sqitch/sqlite/verify/background-jobs-queue.sql new file mode 100644 index 0000000..1cf9965 --- /dev/null +++ b/sqitch/sqlite/verify/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:background-jobs-queue on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql b/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..d0dd086 --- /dev/null +++ b/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:builds_replace_unprocessed_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |