Bugzilla – Attachment 51542 Details for
Bug 16402
DB structure cannot be loaded in MySQL 5.7
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16402: (QA followup)
Bug-16402-QA-followup.patch (text/plain), 1.38 KB, created by
Tomás Cohen Arazi
on 2016-05-16 15:38:19 UTC
(
hide
)
Description:
Bug 16402: (QA followup)
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi
Created:
2016-05-16 15:38:19 UTC
Size:
1.38 KB
patch
obsolete
>From 4e172a46b8d52759ae72b032c40dc0d06fbcf563 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Mon, 16 May 2016 12:36:56 -0300 >Subject: [PATCH] Bug 16402: (QA followup) > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16402
:
51046
|
51235
|
51301
|
51305
|
51328
|
51540
|
51541
| 51542