c403a5d27d8ac47fdf89af3efc25821dde35cb71
[Evergreen.git] / Open-ILS / src / sql / XXXX.schema.allow_parts_to_be_recreated.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique";
6 CREATE UNIQUE INDEX record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE;
7
8 COMMIT;