From 55d2c2d507634ded299c8a66e5c043cc277f5d5c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Tue, 5 May 2020 12:24:40 +0200 Subject: [PATCH] =?utf8?q?Kunden/-Lieferantenstamm:=20Flag=20"nat=C3=BCrli?= =?utf8?q?che=20Person":=20DB-Upgrade=20+=20Rose?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Customer.pm | 1 + SL/DB/MetaSetup/Vendor.pm | 1 + sql/Pg-upgrade2/customer_vendor_add_natural_person.sql | 6 ++++++ 3 files changed, 8 insertions(+) create mode 100644 sql/Pg-upgrade2/customer_vendor_add_natural_person.sql diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm index ef841126b..d0e1b1414 100644 --- a/SL/DB/MetaSetup/Customer.pm +++ b/SL/DB/MetaSetup/Customer.pm @@ -49,6 +49,7 @@ __PACKAGE__->meta->columns( mandator_id => { type => 'text' }, mtime => { type => 'timestamp' }, name => { type => 'text', not_null => 1 }, + natural_person => { type => 'boolean', default => 'false' }, notes => { type => 'text' }, obsolete => { type => 'boolean', default => 'false' }, order_lock => { type => 'boolean', default => 'false' }, diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm index 8be59fe1d..a4578028b 100644 --- a/SL/DB/MetaSetup/Vendor.pm +++ b/SL/DB/MetaSetup/Vendor.pm @@ -39,6 +39,7 @@ __PACKAGE__->meta->columns( language_id => { type => 'integer' }, mtime => { type => 'timestamp' }, name => { type => 'text', not_null => 1 }, + natural_person => { type => 'boolean', default => 'false' }, notes => { type => 'text' }, obsolete => { type => 'boolean', default => 'false' }, payment_id => { type => 'integer' }, diff --git a/sql/Pg-upgrade2/customer_vendor_add_natural_person.sql b/sql/Pg-upgrade2/customer_vendor_add_natural_person.sql new file mode 100644 index 000000000..875b74ce9 --- /dev/null +++ b/sql/Pg-upgrade2/customer_vendor_add_natural_person.sql @@ -0,0 +1,6 @@ +-- @tag: customer_vendor_add_natural_person +-- @description: neue Spalte für "natürliche Person" bei Kunden/Lieferanten +-- @depends: release_3_5_5 + +ALTER TABLE customer ADD COLUMN natural_person BOOLEAN DEFAULT FALSE; +ALTER TABLE vendor ADD COLUMN natural_person BOOLEAN DEFAULT FALSE; -- 2.20.1