diff options
Diffstat (limited to 'sqitch/deploy/change_package_descriptions_index.sql')
| -rw-r--r-- | sqitch/deploy/change_package_descriptions_index.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sqitch/deploy/change_package_descriptions_index.sql b/sqitch/deploy/change_package_descriptions_index.sql new file mode 100644 index 0000000..da6b7f7 --- /dev/null +++ b/sqitch/deploy/change_package_descriptions_index.sql @@ -0,0 +1,11 @@ +-- Deploy guix-data-service:change_package_descriptions_index to pg + +BEGIN; + +ALTER TABLE package_descriptions DROP CONSTRAINT + package_descriptions_locale_description_key; + +CREATE UNIQUE INDEX package_descriptions_locale_description_key + ON package_descriptions USING btree (locale, MD5(description)); + +COMMIT; |