diff options
Diffstat (limited to 'sqitch')
4 files changed, 28 insertions, 0 deletions
diff --git a/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql b/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql new file mode 100644 index 0000000..58829c5 --- /dev/null +++ b/sqitch/deploy/guix_revision_package_derivation_distribution_counts.sql @@ -0,0 +1,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; diff --git a/sqitch/revert/guix_revision_package_derivation_distribution_counts.sql b/sqitch/revert/guix_revision_package_derivation_distribution_counts.sql new file mode 100644 index 0000000..7956b30 --- /dev/null +++ b/sqitch/revert/guix_revision_package_derivation_distribution_counts.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:guix_revision_package_derivation_distribution_counts from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 64b2189..caab662 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -93,3 +93,4 @@ blocked_builds 2022-11-07T11:27:28Z Chris <chris@felis> # Add blocked_builds package_derivations_extended_statistics 2022-11-12T10:40:18Z Chris <chris@felis> # Add extended statistics on package_derivations derivation_outputs_id_and_derivation_id_idx 2022-11-12T10:41:42Z Chris <chris@felis> # Add index on derivation_outputs id and derivation_id blocked_builds_blocked_builds_blocked_derivation_output_details_set_id_2 2023-03-05T10:19:53Z Chris <chris@felis> # Add index on blocked_builds_blocked_derivation_output_details_set_id +guix_revision_package_derivation_distribution_counts 2023-03-08T16:53:44Z Chris <chris@felis> # Add guix_revision_package_derivation_distribution_counts table diff --git a/sqitch/verify/guix_revision_package_derivation_distribution_counts.sql b/sqitch/verify/guix_revision_package_derivation_distribution_counts.sql new file mode 100644 index 0000000..1f7edd2 --- /dev/null +++ b/sqitch/verify/guix_revision_package_derivation_distribution_counts.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:guix_revision_package_derivation_distribution_counts on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |