sqitch/deploy/change_package_descriptions_index.sql


1
2
3
4
5
6
7
8
9
10
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;