From 795d6969d9871b23b2524f9a39692dd2ea034480 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 29 Jun 2005 19:09:04 +0000 Subject: [PATCH] adding holdable flag to config.copy_status git-svn-id: svn://svn.open-ils.org/ILS/trunk@973 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../perlmods/OpenILS/Application/Storage/CDBI/config.pm | 2 +- Open-ILS/src/sql/Postgres/002.schema.config.sql | 15 ++++++++------- 2 files changed, 9 insertions(+), 8 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm index 179e3feb7a..f80a08865e 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm @@ -66,7 +66,7 @@ package config::copy_status; use base qw/config/; __PACKAGE__->table('config_copy_status'); __PACKAGE__->columns(Primary => 'id'); -__PACKAGE__->columns(Essential => qw/name/); +__PACKAGE__->columns(Essential => qw/name holdable/); #------------------------------------------------------------------------------- package config::net_access_level; diff --git a/Open-ILS/src/sql/Postgres/002.schema.config.sql b/Open-ILS/src/sql/Postgres/002.schema.config.sql index 652ee06ce5..ad99586597 100644 --- a/Open-ILS/src/sql/Postgres/002.schema.config.sql +++ b/Open-ILS/src/sql/Postgres/002.schema.config.sql @@ -86,19 +86,20 @@ CREATE TABLE config.rule_age_hold_protect ( ); CREATE TABLE config.copy_status ( - id SERIAL PRIMARY KEY, - name TEXT NOT NULL UNIQUE + id SERIAL PRIMARY KEY, + name TEXT NOT NULL UNIQUE, + holdable BOOL NOT NULL DEFAULT 'F' ); -INSERT INTO config.copy_status (id,name) VALUES (0,'Available'); -INSERT INTO config.copy_status (name) VALUES ('Checked out'); +INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t'); +INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t'); 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) VALUES ('In process'); +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) VALUES ('Reshelving'); +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) VALUES ('On order'); +INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t'); INSERT INTO config.copy_status (name) VALUES ('ILL'); INSERT INTO config.copy_status (name) VALUES ('Cataloging'); INSERT INTO config.copy_status (name) VALUES ('Reserves'); -- 2.11.0