diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-04-06 19:54:41 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-04-10 20:34:47 +0100 |
| commit | f0524be43ea57996c2c5ddf1b859a30fb887bfe2 (patch) | |
| tree | d34c16445c81e5cffb3a85075e23528118900694 /sqitch/sqlite/deploy | |
| parent | 75290ee2db7452168c966fd9585c4e12f0c2e849 (diff) | |
| download | build-coordinator-f0524be43ea57996c2c5ddf1b859a30fb887bfe2.tar build-coordinator-f0524be43ea57996c2c5ddf1b859a30fb887bfe2.tar.gz | |
Add a migration to create the builds table
Diffstat (limited to 'sqitch/sqlite/deploy')
| -rw-r--r-- | sqitch/sqlite/deploy/create_builds.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/create_builds.sql b/sqitch/sqlite/deploy/create_builds.sql new file mode 100644 index 0000000..18e9dc3 --- /dev/null +++ b/sqitch/sqlite/deploy/create_builds.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:create_builds to sqlite + +BEGIN; + +CREATE TABLE builds ( + uuid TEXT PRIMARY KEY, + derivation_name TEXT NOT NULL REFERENCES derivations (name), + priority INTEGER NOT NULL, + processed BOOLEAN NOT NULL DEFAULT 0 +); + +COMMIT; |