From 6b9ca28a377a197c1233875c8013c94a8a6ea811 Mon Sep 17 00:00:00 2001 From: Kyle M Hall 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 Signed-off-by: Marcel de Rooy Signed-off-by: Tomas Cohen Arazi --- 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 a27bc66fae..ec7005ec54 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -10160,6 +10160,10 @@ if(CheckVersion($DBversion)) { ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST }); + $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 }); -- 2.39.5