From 5ae5002ce91e4104517e4ed9c90d9eb2a48046a6 Mon Sep 17 00:00:00 2001 From: Cem Aydin Date: Thu, 3 Feb 2022 21:52:49 +0100 Subject: [PATCH] =?utf8?q?Swiss=20QR-Bill:=20Datenbankupgrade=20Invoice/ar?= =?utf8?q?:=20Option=20Rechnung=20ohne=20Betrag=20hinzugef=C3=BCgt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Invoice.pm | 1 + sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql | 6 ++++++ 2 files changed, 7 insertions(+) create mode 100644 sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql diff --git a/SL/DB/MetaSetup/Invoice.pm b/SL/DB/MetaSetup/Invoice.pm index 441f9c590..e80b110e4 100644 --- a/SL/DB/MetaSetup/Invoice.pm +++ b/SL/DB/MetaSetup/Invoice.pm @@ -44,6 +44,7 @@ __PACKAGE__->meta->columns( ordnumber => { type => 'text' }, paid => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, payment_id => { type => 'integer' }, + qrbill_without_amount => { type => 'boolean', default => 'false' }, quodate => { type => 'date' }, quonumber => { type => 'text' }, salesman_id => { type => 'integer' }, diff --git a/sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql b/sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql new file mode 100644 index 000000000..15a1602db --- /dev/null +++ b/sql/Pg-upgrade2/ar_add_qrbill_without_amount.sql @@ -0,0 +1,6 @@ +-- @tag: ar_add_qrbill_without_amount +-- @description: Spalte für QR-Rechnung ohne Betrag +-- @depends: release_3_5_8 +ALTER TABLE ar ADD COLUMN qrbill_without_amount boolean; +ALTER TABLE ar ALTER COLUMN qrbill_without_amount SET DEFAULT FALSE; +UPDATE ar SET qrbill_without_amount = FALSE; -- 2.20.1