From c2cde5561cc7c4973aa221444e58660b0649713c Mon Sep 17 00:00:00 2001 From: erickson Date: Fri, 4 Sep 2009 17:25:10 +0000 Subject: [PATCH] Loosened constraint on group penalty thresholds. You can now define threholds for the same group as long as they have a different context org unit To Update: ALTER TABLE permission.grp_penalty_threshold DROP CONSTRAINT penalty_grp_once; ALTER TABLE permission.grp_penalty_threshold ADD CONSTRAINT penalty_grp_once UNIQUE (grp,penalty,org_unit); git-svn-id: svn://svn.open-ils.org/ILS/trunk@13961 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/006.schema.permissions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/006.schema.permissions.sql b/Open-ILS/src/sql/Pg/006.schema.permissions.sql index 424bb1d08..66126b04a 100644 --- a/Open-ILS/src/sql/Pg/006.schema.permissions.sql +++ b/Open-ILS/src/sql/Pg/006.schema.permissions.sql @@ -45,7 +45,7 @@ CREATE TABLE permission.grp_penalty_threshold ( org_unit INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, penalty INT NOT NULL REFERENCES config.standing_penalty (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, threshold NUMERIC(8,2) NOT NULL, - CONSTRAINT penalty_grp_once UNIQUE (grp,penalty) + CONSTRAINT penalty_grp_once UNIQUE (grp,penalty,org_unit) ); CREATE TABLE permission.grp_perm_map ( -- 2.11.0