View | Details | Raw Unified | Return to bug 16402
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_16402.sql (-3 / +14 lines)
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
- 

Return to bug 16402