From 5e2846341faf8e034ec97972cd329b75a38e1bab Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Wed, 17 Mar 2021 16:25:32 +0100 Subject: [PATCH] Mahnungen: merken, ob die originale Rechnung gedruckt wurde: DB+Rose --- SL/DB/MetaSetup/Dunning.pm | 25 ++++++++++--------- .../dunning_original_invoice_printed.sql | 5 ++++ 2 files changed, 18 insertions(+), 12 deletions(-) create mode 100644 sql/Pg-upgrade2/dunning_original_invoice_printed.sql diff --git a/SL/DB/MetaSetup/Dunning.pm b/SL/DB/MetaSetup/Dunning.pm index ee6ab4ef4..6869197c0 100644 --- a/SL/DB/MetaSetup/Dunning.pm +++ b/SL/DB/MetaSetup/Dunning.pm @@ -9,18 +9,19 @@ use parent qw(SL::DB::Object); __PACKAGE__->meta->table('dunning'); __PACKAGE__->meta->columns( - duedate => { type => 'date' }, - dunning_config_id => { type => 'integer' }, - dunning_id => { type => 'integer' }, - dunning_level => { type => 'integer' }, - fee => { type => 'numeric', precision => 15, scale => 5 }, - fee_interest_ar_id => { type => 'integer' }, - id => { type => 'integer', not_null => 1, sequence => 'id' }, - interest => { type => 'numeric', precision => 15, scale => 5 }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - trans_id => { type => 'integer' }, - transdate => { type => 'date' }, + duedate => { type => 'date' }, + dunning_config_id => { type => 'integer' }, + dunning_id => { type => 'integer' }, + dunning_level => { type => 'integer' }, + fee => { type => 'numeric', precision => 15, scale => 5 }, + fee_interest_ar_id => { type => 'integer' }, + id => { type => 'integer', not_null => 1, sequence => 'id' }, + interest => { type => 'numeric', precision => 15, scale => 5 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + original_invoice_printed => { type => 'boolean', default => 'false' }, + trans_id => { type => 'integer' }, + transdate => { type => 'date' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); diff --git a/sql/Pg-upgrade2/dunning_original_invoice_printed.sql b/sql/Pg-upgrade2/dunning_original_invoice_printed.sql new file mode 100644 index 000000000..bd140e692 --- /dev/null +++ b/sql/Pg-upgrade2/dunning_original_invoice_printed.sql @@ -0,0 +1,5 @@ +-- @tag: dunning_original_invoice_printed +-- @description: In der Tabelle dunning merken, ob beim Mahnlauf die originale Rechnung gedruckt wurde +-- @depends: release_3_5_6_1 + +ALTER TABLE dunning ADD COLUMN original_invoice_printed BOOLEAN DEFAULT false; -- 2.20.1