From f8869126bfafbbec9593b1ad552e73ae52ac39b8 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 6 Mar 2009 21:44:25 +0000 Subject: [PATCH] make org unit name and shortname unique, to avoid mistakes git-svn-id: svn://svn.open-ils.org/ILS/trunk@12455 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 12e39d4553..d8eb74d1a2 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -332,8 +332,8 @@ CREATE TABLE actor.org_unit ( holds_address INT, mailing_address INT, billing_address INT, - shortname TEXT NOT NULL, - name TEXT NOT NULL, + shortname TEXT NOT NULL UNIQUE, + name TEXT NOT NULL UNIQUE, email TEXT, phone TEXT, opac_visible BOOL NOT NULL DEFAULT TRUE -- 2.11.0