From ed17965728399d530135538e83c436f844ec94ff Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 2 Dec 2010 09:11:03 +0100 Subject: [PATCH] =?utf8?q?Datenbankupgradescript=20f=C3=BCr=20Unterscheidu?= =?utf8?q?ng=20Bankeinzug/=C3=9Cberweisung=20bei=20SEPA?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/sepa_in.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/Pg-upgrade2/sepa_in.sql diff --git a/sql/Pg-upgrade2/sepa_in.sql b/sql/Pg-upgrade2/sepa_in.sql new file mode 100644 index 000000000..6373b8f7e --- /dev/null +++ b/sql/Pg-upgrade2/sepa_in.sql @@ -0,0 +1,12 @@ +-- @tag: sepa_in +-- @description: Erweiterung SEPA für Kontoeinzüge +-- @depends: release_2_6_1 +-- @charset: utf-8 +ALTER TABLE sepa_export ADD COLUMN vc varchar(10); +UPDATE sepa_export SET vc = 'vendor'; + +ALTER TABLE sepa_export_items ALTER COLUMN ap_id DROP NOT NULL; +ALTER TABLE sepa_export_items ADD COLUMN ar_id integer; +ALTER TABLE sepa_export_items ADD FOREIGN KEY (ar_id) REFERENCES ar (id); +ALTER TABLE sepa_export_items RENAME vendor_iban TO vc_iban; +ALTER TABLE sepa_export_items RENAME vendor_bic TO vc_bic; -- 2.20.1