Swiss QR-Bill: Datenbankupgrade Mandantenkonfiguration
authorCem Aydin <cem.aydin@gmx.ch>
Wed, 15 Dec 2021 15:53:08 +0000 (16:53 +0100)
committerAndreas Rudin <andreas.rudin@revamp-it.ch>
Thu, 23 Dec 2021 21:26:44 +0000 (22:26 +0100)
SL/DB/MetaSetup/Default.pm
sql/Pg-upgrade2/defaults_create_qrbill_data.sql [new file with mode: 0644]

index 4061051..516f292 100644 (file)
@@ -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 (file)
index 0000000..cffde9b
--- /dev/null
@@ -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;