@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_16402.sql | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_16402.sql +++ a/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); +-- } --