1 ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '';
2 ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT '';
4 -- $DBversion = "3.23.00.XXX";
5 -- if(CheckVersion($DBversion)) {
7 -- ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT ''
10 -- ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT '';
12 -- print "Upgrade to $DBversion done (Bug 16402: Fix DB structure to work on MySQL 5.7)\n";
13 -- SetVersion($DBversion);