From a11b7df14a0b1099250ba78d948c05a5396b4cdd Mon Sep 17 00:00:00 2001 From: Cem Aydin Date: Wed, 15 Dec 2021 16:53:08 +0100 Subject: [PATCH] Swiss QR-Bill: Datenbankupgrade Mandantenkonfiguration --- SL/DB/MetaSetup/Default.pm | 1 + sql/Pg-upgrade2/defaults_create_qrbill_data.sql | 5 +++++ 2 files changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/defaults_create_qrbill_data.sql diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index 406105145..516f2927e 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -46,6 +46,7 @@ __PACKAGE__->meta->columns( contact_departments_use_textfield => { type => 'boolean' }, contact_titles_use_textfield => { type => 'boolean' }, create_part_if_not_found => { type => 'boolean', default => 'false' }, + create_qrbill_invoices => { type => 'boolean' }, create_zugferd_invoices => { type => 'integer' }, currency_id => { type => 'integer', not_null => 1 }, customer_hourly_rate => { type => 'numeric', precision => 8, scale => 2 }, diff --git a/sql/Pg-upgrade2/defaults_create_qrbill_data.sql b/sql/Pg-upgrade2/defaults_create_qrbill_data.sql new file mode 100644 index 000000000..cffde9b58 --- /dev/null +++ b/sql/Pg-upgrade2/defaults_create_qrbill_data.sql @@ -0,0 +1,5 @@ +-- @tag: defaults_create_qrbill_data +-- @description: Swiss QR-Bill Informationserzeugung Einstellungsoption +-- @depends: release_3_5_6_1 +ALTER TABLE defaults ADD COLUMN create_qrbill_invoices BOOLEAN; +UPDATE defaults SET create_qrbill_invoices = FALSE; -- 2.20.1