adding "voider" and "void_time" fields to billing
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 18 Nov 2005 16:49:29 +0000 (16:49 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 18 Nov 2005 16:49:29 +0000 (16:49 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@2073 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/money.pm
Open-ILS/src/sql/Pg/080.schema.money.sql

index 94337d5..d762eda 100644 (file)
@@ -72,7 +72,7 @@ package money::billing;
 use base qw/money/;
 __PACKAGE__->table('money_billing');
 __PACKAGE__->columns(Primary => 'id');
-__PACKAGE__->columns(Essential => qw/xact amount billing_ts billing_type note voided/);
+__PACKAGE__->columns(Essential => qw/xact amount billing_ts billing_type note voided voider void_time/);
 #-------------------------------------------------------------------------------
 
 package money::payment;
index 4655150..22e8437 100644 (file)
@@ -22,6 +22,8 @@ CREATE TABLE money.billing (
        xact            BIGINT                          NOT NULL, -- money.billable_xact.id
        billing_ts      TIMESTAMP WITH TIME ZONE        NOT NULL DEFAULT NOW(),
        voided          BOOL                            NOT NULL DEFAULT FALSE,
+       voider          INT,
+       void_time       TIMESTAMP WITH TIME ZONE,
        amount          NUMERIC(6,2)                    NOT NULL,
        billing_type    TEXT                            NOT NULL,
        note            TEXT