diff options
author | Christopher Baines <mail@cbaines.net> | 2019-11-09 08:30:02 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2019-11-09 08:30:02 +0000 |
commit | 5bb4dfdabea34af0bfa03d6430935124f7b60a90 (patch) | |
tree | 721c0f53ab02ee73365ae9185ed96da0693ae8a1 /sqitch/deploy/package_derivations_by_guix_revision_range.sql | |
parent | fea4dc9385f6f42e7b89f1fafe1a8189f62af9eb (diff) | |
download | data-service-5bb4dfdabea34af0bfa03d6430935124f7b60a90.tar data-service-5bb4dfdabea34af0bfa03d6430935124f7b60a90.tar.gz |
Diffstat (limited to 'sqitch/deploy/package_derivations_by_guix_revision_range.sql')
-rw-r--r-- | sqitch/deploy/package_derivations_by_guix_revision_range.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sqitch/deploy/package_derivations_by_guix_revision_range.sql b/sqitch/deploy/package_derivations_by_guix_revision_range.sql new file mode 100644 index 0000000..e84c641 --- /dev/null +++ b/sqitch/deploy/package_derivations_by_guix_revision_range.sql @@ -0,0 +1,17 @@ +-- Deploy guix-data-service:package_derivations_by_guix_revision_range to pg + +BEGIN; + +CREATE TABLE package_derivations_by_guix_revision_range ( + git_repository_id integer NOT NULL REFERENCES git_repositories (id), + branch_name varchar NOT NULL, + package_name varchar NOT NULL, + package_version varchar NOT NULL, + derivation_id integer NOT NULL, + system varchar NOT NULL, + target varchar NOT NULL, + first_guix_revision_id integer NOT NULL REFERENCES guix_revisions (id), + last_guix_revision_id integer NOT NULL REFERENCES guix_revisions (id) +); + +COMMIT; |