sqitch/deploy/partition_package_derivations_by_guix_revision_range.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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;