From 28930dce0ec5660dd4394a17e6ba578aa8858110 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 22 Jul 2005 23:08:04 +0000 Subject: [PATCH] updating for the alpha load git-svn-id: svn://svn.open-ils.org/ILS/trunk@1372 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/002.schema.config.sql | 2 +- Open-ILS/src/sql/Postgres/005.schema.actors.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Postgres/002.schema.config.sql b/Open-ILS/src/sql/Postgres/002.schema.config.sql index 9ca88a5fd1..84dd426bc1 100644 --- a/Open-ILS/src/sql/Postgres/002.schema.config.sql +++ b/Open-ILS/src/sql/Postgres/002.schema.config.sql @@ -369,7 +369,7 @@ INSERT INTO config.copy_status (name) VALUES ('Bindery'); INSERT INTO config.copy_status (name) VALUES ('Lost'); INSERT INTO config.copy_status (name) VALUES ('Missing'); INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t'); -INSERT INTO config.copy_status (name) VALUES ('In transit'); +INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t'); INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t'); INSERT INTO config.copy_status (name) VALUES ('On holds shelf'); INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t'); diff --git a/Open-ILS/src/sql/Postgres/005.schema.actors.sql b/Open-ILS/src/sql/Postgres/005.schema.actors.sql index 83f6226738..a28744db28 100644 --- a/Open-ILS/src/sql/Postgres/005.schema.actors.sql +++ b/Open-ILS/src/sql/Postgres/005.schema.actors.sql @@ -235,7 +235,7 @@ CREATE TABLE actor.stat_cat_entry_usr_map ( stat_cat_entry TEXT NOT NULL, stat_cat INT NOT NULL, target_usr INT NOT NULL, - CONSTRAINT sce_once_per_copy UNIQUE (target_usr,stat_cat) + CONSTRAINT sc_once_per_usr UNIQUE (target_usr,stat_cat) ); COMMENT ON TABLE actor.stat_cat_entry_usr_map IS $$ /* -- 2.43.2