From b22de90405d62c01961faf8d7abe449cc42be426 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 1 Feb 2006 22:29:55 +0000 Subject: [PATCH] adding circ_duration to non-cat types git-svn-id: svn://svn.open-ils.org/ILS/trunk@2929 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../perlmods/OpenILS/Application/Storage/CDBI/config.pm | 2 +- Open-ILS/src/sql/Pg/002.schema.config.sql | 7 ++++--- 2 files changed, 5 insertions(+), 4 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 63fa5696b0..ed06b86a1f 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm @@ -10,7 +10,7 @@ package config::non_cataloged_type; use base qw/config/; __PACKAGE__->table('config_non_cataloged_type'); __PACKAGE__->columns(Primary => 'id'); -__PACKAGE__->columns(Essential => qw/owning_lib name/); +__PACKAGE__->columns(Essential => qw/owning_lib name circ_duration/); #------------------------------------------------------------------------------- package config::standing; diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index be84525d1f..7657a4a0b8 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -147,9 +147,10 @@ INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject' INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */ CREATE TABLE config.non_cataloged_type ( - id SERIAL PRIMARY KEY, - owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id), - name TEXT NOT NULL UNIQUE + id SERIAL PRIMARY KEY, + owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id), + name TEXT NOT NULL UNIQUE, + circ_duration INTERVAL NOT NULL DEFAULT '14 days'::INTERVAL ); COMMENT ON TABLE config.non_cataloged_type IS $$ /* -- 2.43.2