From 9448c18c2a1e703ef866f42e167c0da01123e169 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jean-Andr=C3=A9=20Santoni?= Date: Fri, 6 Nov 2009 13:30:28 +0100 Subject: [PATCH] Fixed wrong SQL syntax in updatedatabase. --- installer/data/mysql/updatedatabase.pl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3dd731913d..42631b844a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3150,10 +3150,10 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.01.00.123"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do(qq{ - ALTER TABLE aqbasketgroups ADD deliveryplace VARCHAR(10), deliverycomment VARCHAR(255); + ALTER TABLE aqbasketgroups ADD deliveryplace VARCHAR(10) default NULL ADD deliverycomment VARCHAR(255) default NULL; }); - print "Upgrade to $DBversion done (adding deliveryplace deliverycomment to basketgroups)\n"; + print "Upgrade to $DBversion done (isbd updated)\n"; SetVersion ($DBversion); } @@ -3193,7 +3193,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.01.00.127"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do(qq{ - ALTER TABLE aqbasketgroups ADD 'billingplace' VARCHAR(10) AFTER 'deliverycomment'; + ALTER TABLE aqbasketgroups ADD billingplace VARCHAR(10) NOT NULL AFTER deliverycomment; }); print "Upgrade to $DBversion done (isbd updated)\n"; -- 2.20.1