diff options
Diffstat (limited to 'sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql')
-rw-r--r-- | sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql b/sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql new file mode 100644 index 0000000..88611f6 --- /dev/null +++ b/sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql @@ -0,0 +1,18 @@ +-- Deploy guix-data-service:partition_package_derivations_by_guix_revision_range to pg + +BEGIN; + +DROP TABLE package_derivations_by_guix_revision_range; + +CREATE TABLE package_derivations_by_guix_revision_range ( + git_branch_id integer NOT NULL REFERENCES git_branches (id), + 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) +) PARTITION BY LIST (git_branch_id); + +COMMIT; |