LP#1569884: stamp schema update
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0977.schema.allow_parts_to_be_recreated.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('0977', :eg_version); -- Callender/Dyrcona/gmcharlt
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;