From b6b618e9433e4c95d403c9128db9b0f8fe832891 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 1 Dec 2008 21:57:38 +0000 Subject: [PATCH] Backport r11373 from trunk to protect against duplicate locations at the same library git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4@11374 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index d6952e8282..098792f03e 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -28,7 +28,8 @@ CREATE TABLE asset.copy_location ( holdable BOOL NOT NULL DEFAULT TRUE, hold_verify BOOL NOT NULL DEFAULT FALSE, opac_visible BOOL NOT NULL DEFAULT TRUE, - circulate BOOL NOT NULL DEFAULT TRUE + circulate BOOL NOT NULL DEFAULT TRUE, + CONSTRAINT acl_name_once_per_lib UNIQUE (name, owning_lib) ); CREATE TABLE asset.copy ( -- 2.11.0