making copies psuedo-deletable
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 17 Mar 2006 16:33:27 +0000 (16:33 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 17 Mar 2006 16:33:27 +0000 (16:33 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@3386 dcc99617-32d9-48b4-a31d-7c20da2025e4

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

index 030e00c..ca1dbd2 100644 (file)
@@ -39,7 +39,7 @@ __PACKAGE__->columns( Essential => qw/call_number barcode creator create_date ed
                                   edit_date copy_number status loan_duration circ_lib
                                   fine_level circulate deposit price ref opac_visible
                                   circ_as_type circ_modifier deposit_amount location
-                                  holdable dummy_title dummy_author/ );
+                                  holdable dummy_title dummy_author deleted/ );
 
 #-------------------------------------------------------------------------------
 package asset::stat_cat;
index 4bacfd1..6a9db92 100644 (file)
@@ -38,7 +38,8 @@ CREATE TABLE asset.copy (
        circ_as_type    TEXT,
        dummy_title     TEXT,
        dummy_author    TEXT,
-       opac_visible    BOOL                            NOT NULL DEFAULT TRUE
+       opac_visible    BOOL                            NOT NULL DEFAULT TRUE,
+       deleted         BOOL                            NOT NULL DEFAULT FALSE
 );
 CREATE INDEX cp_cn_idx ON asset.copy (call_number);
 CREATE INDEX cp_avail_cn_idx ON asset.copy (call_number) WHERE status = 0;