diff options
author | Christopher Baines <mail@cbaines.net> | 2023-08-01 14:12:48 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2023-08-01 14:12:48 +0100 |
commit | 1461aa037fa64b3b4694428a1e00239f3f592ff5 (patch) | |
tree | 38ec3c802e2d15c8f9d18316449fc25ecbe1e622 /sqitch/deploy/nar_indexes.sql | |
parent | 7495085f631a3589ecdf5f282b750a318b422394 (diff) | |
download | data-service-1461aa037fa64b3b4694428a1e00239f3f592ff5.tar data-service-1461aa037fa64b3b4694428a1e00239f3f592ff5.tar.gz |
Make database changes to help with deleting entries in the nars table
Diffstat (limited to 'sqitch/deploy/nar_indexes.sql')
-rw-r--r-- | sqitch/deploy/nar_indexes.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sqitch/deploy/nar_indexes.sql b/sqitch/deploy/nar_indexes.sql new file mode 100644 index 0000000..baaeb00 --- /dev/null +++ b/sqitch/deploy/nar_indexes.sql @@ -0,0 +1,9 @@ +-- Deploy guix-data-service:nar_indexes to pg + +BEGIN; + +CREATE INDEX narinfo_signatures_narinfo_signature_data_id ON narinfo_signatures (narinfo_signature_data_id);;;; + +CREATE INDEX nar_references_nar_id ON nar_references (nar_id); + +COMMIT; |