@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 16 +++------------- 1 files changed, 3 insertions(+), 13 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -9679,25 +9679,15 @@ if(CheckVersion($DBversion)) { ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' }); $dbh->do(q{ - ALTER TABLE old_issues DROP PRIMARY KEY - }); - $dbh->do(q{ ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST }); $dbh->do(q{ - ALTER TABLE old_issues DROP INDEX itemnumber_idx - }); - $dbh->do(q{ - ALTER TABLE issues DROP PRIMARY KEY - }); - $dbh->do(q{ ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST }); $dbh->do(q{ - ALTER TABLE issues DROP INDEX itemnumber_idx - }); - $dbh->do(q{ - ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber) + ALTER TABLE issues + DROP INDEX itemnumber_idx, + ADD UNIQUE itemnumber_idx ( itemnumber ) }); $dbh->do(qq{ UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC --