X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Flastschrift.sql;h=f468d3c44fa452e5cf8e554b306eae2d5b909e02;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=500b03e8257594f51783754045b972cf6c69149f;hpb=54598fded9096ab9e53623080e4210bdb4e83f06;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/lastschrift.sql b/sql/Pg-upgrade2/lastschrift.sql
index 500b03e82..f468d3c44 100644
--- 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;