Kunden/-Lieferantenstamm: Flag "natürliche Person": DB-Upgrade + Rose

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index ef841126b71ead1ef2ee91b59a55e7781d27a456..d0e1b141427a500b2283fdae9712860cf3b0b58c 100644 (file)
--- 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 },
   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' },
   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 8be59fe1da1882b3ce915d80a29d65a4b01f1998..a4578028b4a0858685b5eb0b2baeb9ad5e4b8779 100644 (file)
--- 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 },
   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' },
   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 (file)
index 0000000..875b74c
--- /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;