X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=sql%2FPg-upgrade2%2Fsepa_items_payment_type.sql;fp=sql%2FPg-upgrade2%2Fsepa_items_payment_type.sql;h=c4444b611e60d278c7e31b84cb1e6d5365438fad;hb=15f58ff3dfd79651a95535b53f864ea0e8cb6620;hp=0000000000000000000000000000000000000000;hpb=6a3494478a287c2820e3f68a09bef700af1f57e0;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/sepa_items_payment_type.sql b/sql/Pg-upgrade2/sepa_items_payment_type.sql
new file mode 100644
index 000000000..c4444b611
--- /dev/null
+++ b/sql/Pg-upgrade2/sepa_items_payment_type.sql
@@ -0,0 +1,10 @@
+-- @tag: sepa_items_payment_type
+-- @description: Zahlungsart und Skontobetrag in SEPA-Auftrag speichern
+-- @depends: release_3_2_0
+-- @ignore: 0
+
+ALTER TABLE sepa_export_items ADD COLUMN payment_type TEXT;
+UPDATE sepa_export_items SET payment_type = 'without_skonto' WHERE payment_type IS NULL;
+ALTER TABLE sepa_export_items ALTER COLUMN payment_type SET DEFAULT 'without_skonto';
+
+ALTER TABLE sepa_export_items ADD COLUMN skonto_amount NUMERIC(25,5);