adding pub field to notes tables
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 6 Mar 2006 15:41:19 +0000 (15:41 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 6 Mar 2006 15:41:19 +0000 (15:41 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@3267 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/asset.pm
Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/biblio.pm
Open-ILS/src/sql/Pg/010.schema.biblio.sql
Open-ILS/src/sql/Pg/040.schema.asset.sql

index c5b9c39..030e00c 100644 (file)
@@ -27,7 +27,7 @@ use base qw/asset/;
 
 __PACKAGE__->table( 'asset_call_number_note' );
 __PACKAGE__->columns( Primary => qw/id/ );
-__PACKAGE__->columns( Essential => qw/call_number title creator create_date value/ );
+__PACKAGE__->columns( Essential => qw/call_number title creator create_date value pub/ );
 
 #-------------------------------------------------------------------------------
 package asset::copy;
@@ -71,7 +71,7 @@ use base qw/asset/;
 
 __PACKAGE__->table( 'asset_copy_note' );
 __PACKAGE__->columns( Primary => qw/id/ );
-__PACKAGE__->columns( Essential => qw/owning_copy title creator create_date value/ );
+__PACKAGE__->columns( Essential => qw/owning_copy title creator create_date value pub/ );
 
 #-------------------------------------------------------------------------------
 
index 0a2e4c8..38f0bb4 100644 (file)
@@ -19,7 +19,7 @@ use base qw/biblio/;
 
 biblio::record_note->table( 'biblio_record_note' );
 biblio::record_note->columns( Essential => qw/id record value creator
-                                       editor create_date edit_date/ );
+                                       editor create_date edit_date pub/ );
 #-------------------------------------------------------------------------------
 
 1;
index a1f36b4..139ab76 100644 (file)
@@ -33,6 +33,7 @@ CREATE TABLE biblio.record_note (
        value           TEXT            NOT NULL,
        creator         INT             NOT NULL DEFAULT 1,
        editor          INT             NOT NULL DEFAULT 1,
+       pub             BOOL            NOT NULL DEFAULT FALSE,
        create_date     TIMESTAMP WITH TIME ZONE        NOT NULL DEFAULT now(),
        edit_date       TIMESTAMP WITH TIME ZONE        NOT NULL DEFAULT now()
 );
index 7c83473..4bacfd1 100644 (file)
@@ -105,6 +105,7 @@ CREATE TABLE asset.copy_note (
        owning_copy     BIGINT                          NOT NULL,
        creator         BIGINT                          NOT NULL,
        create_date     TIMESTAMP WITH TIME ZONE        DEFAULT NOW(),
+       pub             BOOL                            NOT NULL DEFAULT FALSE,
        title           TEXT                            NOT NULL,
        value           TEXT                            NOT NULL
 );
@@ -133,6 +134,7 @@ CREATE TABLE asset.call_number_note (
        call_number     BIGINT                          NOT NULL,
        creator         BIGINT                          NOT NULL,
        create_date     TIMESTAMP WITH TIME ZONE        DEFAULT NOW(),
+       pub             BOOL                            NOT NULL DEFAULT FALSE,
        title           TEXT                            NOT NULL,
        value           TEXT                            NOT NULL
 );