From 9dbe6a5cc3980073abd4988f99e3471297cd0f35 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 11 Mar 2020 12:43:52 +0100 Subject: [PATCH] =?utf8?q?ZUGFeRD:=20Bankkonten:=20Standardwert=20=C2=BBus?= =?utf8?q?e=5Ffor=5Fzugferd=C2=AB=20auf=20FALSE=20gesetzt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/BankAccount.pm | 2 +- sql/Pg-upgrade2/bank_account_flag_for_zugferd_usage.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/SL/DB/MetaSetup/BankAccount.pm b/SL/DB/MetaSetup/BankAccount.pm index cd3ffce45..5589ee43d 100644 --- a/SL/DB/MetaSetup/BankAccount.pm +++ b/SL/DB/MetaSetup/BankAccount.pm @@ -21,7 +21,7 @@ __PACKAGE__->meta->columns( reconciliation_starting_balance => { type => 'numeric', precision => 15, scale => 5 }, reconciliation_starting_date => { type => 'date' }, sortkey => { type => 'integer', not_null => 1 }, - use_for_zugferd => { type => 'boolean', not_null => 1 }, + use_for_zugferd => { type => 'boolean', default => 'false', not_null => 1 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); diff --git a/sql/Pg-upgrade2/bank_account_flag_for_zugferd_usage.sql b/sql/Pg-upgrade2/bank_account_flag_for_zugferd_usage.sql index d62d7ee1c..793575471 100644 --- a/sql/Pg-upgrade2/bank_account_flag_for_zugferd_usage.sql +++ b/sql/Pg-upgrade2/bank_account_flag_for_zugferd_usage.sql @@ -11,4 +11,5 @@ SET use_for_zugferd = ( ) = 1; ALTER TABLE bank_accounts +ALTER COLUMN use_for_zugferd SET DEFAULT FALSE, ALTER COLUMN use_for_zugferd SET NOT NULL; -- 2.20.1