diff options
author | Christopher Baines <mail@cbaines.net> | 2020-05-31 18:24:18 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-05-31 18:24:18 +0100 |
commit | 2ac09243135c85d54e2ae2740d5c1aabe5c1ef06 (patch) | |
tree | d8a5b9cccbf9f739e454ad146e2dfd538e38c915 /sqitch/sqlite | |
parent | 4ff7ee1dc340cbb8cd1c49fc98619dd72650c5fe (diff) | |
download | build-coordinator-2ac09243135c85d54e2ae2740d5c1aabe5c1ef06.tar build-coordinator-2ac09243135c85d54e2ae2740d5c1aabe5c1ef06.tar.gz |
Support adding tags to builds
Diffstat (limited to 'sqitch/sqlite')
-rw-r--r-- | sqitch/sqlite/deploy/build_tags.sql | 16 | ||||
-rw-r--r-- | sqitch/sqlite/revert/build_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/build_tags.sql | 7 |
3 files changed, 30 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/build_tags.sql b/sqitch/sqlite/deploy/build_tags.sql new file mode 100644 index 0000000..7f2c040 --- /dev/null +++ b/sqitch/sqlite/deploy/build_tags.sql @@ -0,0 +1,16 @@ +-- Deploy guix-build-coordinator:build_tags to sqlite + +BEGIN; + +CREATE TABLE tags ( + id INTEGER PRIMARY KEY ASC, + key TEXT NOT NULL, + value TEXT NOT NULL +); + +CREATE TABLE build_tags ( + build_id TEXT NOT NULL REFERENCES builds (uuid), + tag_id INTEGER NOT NULL REFERENCES tags (id) +); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_tags.sql b/sqitch/sqlite/revert/build_tags.sql new file mode 100644 index 0000000..f6bcef8 --- /dev/null +++ b/sqitch/sqlite/revert/build_tags.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_tags from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_tags.sql b/sqitch/sqlite/verify/build_tags.sql new file mode 100644 index 0000000..5cd681b --- /dev/null +++ b/sqitch/sqlite/verify/build_tags.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_tags on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |