Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[kivitendo-erp.git] / sql / Pg-upgrade2 / lastschrift.sql

diff --git a/sql/Pg-upgrade2/lastschrift.sql b/sql/Pg-upgrade2/lastschrift.sql
index 500b03e..f468d3c 100644 (file)
--- a/sql/Pg-upgrade2/lastschrift.sql
+++ b/sql/Pg-upgrade2/lastschrift.sql
@@ -1,5 +1,7 @@
 -- @tag: direct_debit 
 -- @description: Schalter fuer Lastschrift
 -- @depends: release_2_4_3
-ALTER TABLE customer ADD COLUMN direct_debit boolean DEFAULT false;
-ALTER TABLE vendor ADD COLUMN  direct_debit boolean DEFAULT false;
+ALTER TABLE customer ADD COLUMN direct_debit boolean;
+ALTER TABLE customer ALTER direct_debit SET DEFAULT false;
+ALTER TABLE vendor ADD COLUMN  direct_debit boolean;
+ALTER TABLE vendor ALTER direct_debit SET DEFAULT false;