Lines 1-2
Link Here
|
1 |
alter table letter modify column branchcode varchar(10) not null default ''; |
1 |
ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT ''; |
2 |
alter table permissions modify column code varchar(64) not null default ''; |
2 |
ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT ''; |
|
|
3 |
|
4 |
-- $DBversion = "3.23.00.XXX"; |
5 |
-- if(CheckVersion($DBversion)) { |
6 |
-- $dbh->do(q{ |
7 |
-- ALTER TABLE letter MODIFY COLUMN branchcode varchar(10) NOT NULL DEFAULT '' |
8 |
-- }); |
9 |
-- $dbh->do(q{ |
10 |
-- ALTER TABLE permissions MODIFY COLUMN code varchar(64) NOT NULL DEFAULT ''; |
11 |
-- }); |
12 |
-- print "Upgrade to $DBversion done (Bug 16402: Fix DB structure to work on MySQL 5.7)\n"; |
13 |
-- SetVersion($DBversion); |
14 |
-- } |
3 |
- |
|
|