adding circ_duration to non-cat types
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 1 Feb 2006 22:29:55 +0000 (22:29 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 1 Feb 2006 22:29:55 +0000 (22:29 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@2929 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/config.pm
Open-ILS/src/sql/Pg/002.schema.config.sql

index 63fa569..ed06b86 100644 (file)
@@ -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;
index be84525..7657a4a 100644 (file)
@@ -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 $$
 /*