From 2bf17cb3630bc0a6a8e4d25552181bf01c425231 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 4 Apr 2008 02:23:13 +0000 Subject: [PATCH] make the row unique git-svn-id: svn://svn.open-ils.org/ILS/trunk@9214 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 8670de17a1..c145672915 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -381,7 +381,7 @@ CREATE TABLE actor.org_lasso_map ( lasso INT NOT NULL REFERENCES actor.org_lasso (id) ON DELETE CASCADE, org_unit INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE ); -CREATE INDEX ou_lasso_lasso_idx ON actor.org_lasso_map (lasso); +CREATE UNIQUE INDEX ou_lasso_lasso_ou_idx ON actor.org_lasso_map (lasso, org_unit); CREATE INDEX ou_lasso_org_unit_idx ON actor.org_lasso_map (org_unit); CREATE TABLE actor.org_unit_proximity ( -- 2.43.2