From 340ede45651caf84c5469abef4cdf7bfe1297991 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 26 Jul 2005 17:25:50 +0000 Subject: [PATCH] Fixing dup constraint bug git-svn-id: svn://svn.open-ils.org/ILS/trunk@1495 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 0d5d1496d4..6eccb97b23 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -138,7 +138,7 @@ CREATE TABLE actor.usr_setting ( usr INT NOT NULL REFERENCES actor.usr ON DELETE CASCADE, name TEXT NOT NULL, value TEXT NOT NULL, - CONSTRAINT name_once_per_value UNIQUE (usr,name) + CONSTRAINT usr_once_per_key UNIQUE (usr,name) ); COMMENT ON TABLE actor.usr_setting IS $$ /* @@ -355,7 +355,7 @@ CREATE TABLE actor.org_unit_setting ( org_unit INT NOT NULL REFERENCES actor.org_unit ON DELETE CASCADE, name TEXT NOT NULL, value TEXT NOT NULL, - CONSTRAINT name_once_per_value UNIQUE (org_unit,name) + CONSTRAINT ou_once_per_key UNIQUE (org_unit,name) ); COMMENT ON TABLE actor.org_unit_setting IS $$ /* -- 2.43.2