allow the database to support a NULL item price
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 8 Oct 2008 18:53:38 +0000 (18:53 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 8 Oct 2008 18:53:38 +0000 (18:53 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@10793 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/040.schema.asset.sql

index 598c445..805920f 100644 (file)
@@ -50,7 +50,7 @@ CREATE TABLE asset.copy (
        ref             BOOL                            NOT NULL DEFAULT FALSE,
        holdable        BOOL                            NOT NULL DEFAULT TRUE,
        deposit_amount  NUMERIC(6,2)                    NOT NULL DEFAULT 0.00,
        ref             BOOL                            NOT NULL DEFAULT FALSE,
        holdable        BOOL                            NOT NULL DEFAULT TRUE,
        deposit_amount  NUMERIC(6,2)                    NOT NULL DEFAULT 0.00,
-       price           NUMERIC(8,2)                    NOT NULL DEFAULT 0.00,
+       price           NUMERIC(8,2),
        barcode         TEXT                            NOT NULL,
        circ_modifier   TEXT,
        circ_as_type    TEXT,
        barcode         TEXT                            NOT NULL,
        circ_modifier   TEXT,
        circ_as_type    TEXT,