From c0591c923d1a5f86eca1db2bb4cb40242a1b8445 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 5 Dec 2008 15:50:31 +0000 Subject: [PATCH] =?utf8?q?PostgreSQL-Versionen=20vor=208.0=20erlauben=20ni?= =?utf8?q?cht,=20in=20einem=20Befehl=20neue=20Spalten=20hinzuzuf=C3=BCgen?= =?utf8?q?=20und=20gleichzeitig=20den=20Defaultwert=20zu=20setzen.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/lastschrift.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) 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; -- 2.20.1