From a85acc90da4111514ce64b1e8a9d2655aa7c6d1c Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 18 Nov 2005 16:49:29 +0000 Subject: [PATCH] adding "voider" and "void_time" fields to billing 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 | 2 +- Open-ILS/src/sql/Pg/080.schema.money.sql | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/money.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/money.pm index 94337d5813..d762edaff0 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/money.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/money.pm @@ -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; diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 4655150c25..22e8437bb6 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -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 -- 2.43.2