From 04cc25a0f250d14f8b54cd4dc521c7a34108d97d Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Wed, 13 Apr 2016 10:19:49 -0400 Subject: [PATCH] LP#1569884 Allow deleted monograph parts to be recreated. Changed the constraint on the biblio.monograph_part table to allow for a monograph part to be created if a duplicate deleted version is found. --- .../sql/Pg/upgrade/XXXX.schema.allow_parts_to_be_recreated.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.allow_parts_to_be_recreated.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.allow_parts_to_be_recreated.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.allow_parts_to_be_recreated.sql new file mode 100644 index 0000000000..960925c601 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.allow_parts_to_be_recreated.sql @@ -0,0 +1,8 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique"; +ALTER TABLE biblio.monograph_part ADD CONSTRAINT record_label_unique UNIQUE (record,label,deleted); + +COMMIT; -- 2.11.0