sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

-- Deploy guix-data-service:guix_revision_package_derivation_distribution_counts to pg

BEGIN;

CREATE TABLE guix_revision_package_derivation_distribution_counts (
  guix_revision_id integer NOT NULL REFERENCES guix_revisions (id),
  system_id integer NOT NULL REFERENCES systems (id),
  target varchar NOT NULL,
  level integer NOT NULL,
  distinct_derivations integer NOT NULL
);

COMMIT;