diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-07-11 15:25:12 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-07-11 15:25:12 +0100 |
| commit | 5cefa250d8bd604fc33e6b5e6444f32c94ad9eb1 (patch) | |
| tree | 8232dd95cf78975e98cfc079ba89d16452499121 /sqitch/revert/package_derivations_not_null_hash_index.sql | |
| parent | d1a2a7125cc15d6d1d8d41e2e8394493e963e5fa (diff) | |
| download | data-service-5cefa250d8bd604fc33e6b5e6444f32c94ad9eb1.tar data-service-5cefa250d8bd604fc33e6b5e6444f32c94ad9eb1.tar.gz | |
Add an index on derivation_output_details.id
Where hash is not null, since this helps with the fixed output package
derivations query.
Diffstat (limited to 'sqitch/revert/package_derivations_not_null_hash_index.sql')
| -rw-r--r-- | sqitch/revert/package_derivations_not_null_hash_index.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/package_derivations_not_null_hash_index.sql b/sqitch/revert/package_derivations_not_null_hash_index.sql new file mode 100644 index 0000000..7b40004 --- /dev/null +++ b/sqitch/revert/package_derivations_not_null_hash_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:package_derivations_not_null_hash_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; |