Bugzilla – Attachment 38184 Details for
Bug 13790
Add unique id issue_id to issues and old_issues tables
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13790 [QA Followup] - Disable auto increment on old_issues after pk values are created
Bug-13790-QA-Followup---Disable-auto-increment-on-.patch (text/plain), 969 bytes, created by
Marcel de Rooy
on 2015-04-20 12:27:12 UTC
(
hide
)
Description:
Bug 13790 [QA Followup] - Disable auto increment on old_issues after pk values are created
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2015-04-20 12:27:12 UTC
Size:
969 bytes
patch
obsolete
>From 2346b1aad7ce421621d4bcbc550a15ae0776d29f Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Mon, 20 Apr 2015 08:21:08 -0400 >Subject: [PATCH] Bug 13790 [QA Followup] - Disable auto increment on > old_issues after pk values are created >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/updatedatabase.pl | 4 ++++ > 1 file changed, 4 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 4c1db85..70394ca 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -10046,6 +10046,10 @@ if(CheckVersion($DBversion)) { > }); > > $dbh->do(q{ >+ ALTER TABLE old_issues CHANGE issue_id issue_id INT( 11 ) NOT NULL >+ }); >+ >+ $dbh->do(q{ > ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST > }); > >-- >1.7.10.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 13790
:
36441
|
36442
|
37108
|
37109
|
37709
|
37710
|
38073
|
38081
|
38082
|
38155
|
38156
|
38157
|
38158
|
38182
|
38184
|
38349
|
38350
|
38351
|
38352
|
38353
|
38354
|
38429