From 4e172a46b8d52759ae72b032c40dc0d06fbcf563 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 16 May 2016 12:36:56 -0300 Subject: [PATCH] Bug 16402: (QA followup) Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/atomicupdate/bug_16402.sql | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_16402.sql b/installer/data/mysql/atomicupdate/bug_16402.sql index 914e791..44f13d1 100644 --- a/installer/data/mysql/atomicupdate/bug_16402.sql +++ b/installer/data/mysql/atomicupdate/bug_16402.sql @@ -1,2 +1,14 @@ -alter table letter modify column branchcode varchar(10) not null default ''; -alter table permissions modify column code varchar(64) not null default ''; +ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT ''; +ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT ''; + +-- $DBversion = "3.23.00.XXX"; +-- if(CheckVersion($DBversion)) { +-- $dbh->do(q{ +-- ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '' +-- }); +-- $dbh->do(q{ +-- ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT ''; +-- }); +-- print "Upgrade to $DBversion done (Bug 16402: Fix DB structure to work on MySQL 5.7)\n"; +-- SetVersion($DBversion); +-- } -- 2.7.4