Zusatzspalten fuer Kontoinhaber

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index 2d5a155b9b7578774b099dbcfbcbe564ca47ed07..3652c7a6859b09c7f722117e25aa0d9df42c6444 100644 (file)
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
@@ -26,6 +26,7 @@ __PACKAGE__->meta->columns(
   delivery_term_id    => { type => 'integer' },
   department_1        => { type => 'varchar', length => 75 },
   department_2        => { type => 'varchar', length => 75 },
+  depositor           => { type => 'text' },
   direct_debit        => { type => 'boolean', default => 'false' },
   discount            => { type => 'float', precision => 4 },
   email               => { type => 'text' },

diff --git a/SL/DB/MetaSetup/SepaExportItem.pm b/SL/DB/MetaSetup/SepaExportItem.pm
index 08dd06e18963d74309530d04bbeb950c12d115cf..4746572ddfd2454d4586bc8b75b75118d4a9f93e 100644 (file)
--- a/SL/DB/MetaSetup/SepaExportItem.pm
+++ b/SL/DB/MetaSetup/SepaExportItem.pm
@@ -18,11 +18,13 @@ __PACKAGE__->meta->columns(
   execution_date           => { type => 'date' },
   id                       => { type => 'integer', not_null => 1, sequence => 'id' },
   our_bic                  => { type => 'varchar', length => 100 },
+  our_depositor            => { type => 'text' },
   our_iban                 => { type => 'varchar', length => 100 },
   reference                => { type => 'varchar', length => 35 },
   requested_execution_date => { type => 'date' },
   sepa_export_id           => { type => 'integer', not_null => 1 },
   vc_bic                   => { type => 'varchar', length => 100 },
+  vc_depositor             => { type => 'text' },
   vc_iban                  => { type => 'varchar', length => 100 },
 );
 

diff --git a/SL/DB/MetaSetup/Vendor.pm b/SL/DB/MetaSetup/Vendor.pm
index f2988ad74de66e863790bd00252a8e42bce903ec..0493aa3744de4a42c8f3662b4b507372f0929bbc 100644 (file)
--- a/SL/DB/MetaSetup/Vendor.pm
+++ b/SL/DB/MetaSetup/Vendor.pm
@@ -24,6 +24,7 @@ __PACKAGE__->meta->columns(
   delivery_term_id => { type => 'integer' },
   department_1     => { type => 'varchar', length => 75 },
   department_2     => { type => 'varchar', length => 75 },
+  depositor        => { type => 'text' },
   direct_debit     => { type => 'boolean', default => 'false' },
   discount         => { type => 'float', precision => 4 },
   email            => { type => 'text' },

diff --git a/sql/Pg-upgrade2/add_depositor_for_customer_vendor.sql b/sql/Pg-upgrade2/add_depositor_for_customer_vendor.sql
new file mode 100644 (file)
index 0000000..cba51d7
--- /dev/null
+++ b/sql/Pg-upgrade2/add_depositor_for_customer_vendor.sql
@@ -0,0 +1,11 @@
+-- @tag: add_depositor_for_customer_vendor
+-- @description: Einführen einer Depositor (Kontoinhaber) Spalte bei Customer bzw. Vendor
+-- @depends: sepa
+
+ALTER TABLE customer          ADD depositor     text;
+ALTER TABLE vendor            ADD depositor     text;
+ALTER TABLE sepa_export_items ADD our_depositor text;
+ALTER TABLE sepa_export_items ADD vc_depositor  text;
+
+UPDATE customer SET depositor = name;
+UPDATE vendor   SET depositor = name;