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

(-)a/installer/data/mysql/updatedatabase.pl (-14 / +3 lines)
Lines 9701-9725 if(CheckVersion($DBversion)) { Link Here
9701
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9701
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9702
    });
9702
    });
9703
    $dbh->do(q{
9703
    $dbh->do(q{
9704
        ALTER TABLE old_issues DROP PRIMARY KEY
9705
    });
9706
    $dbh->do(q{
9707
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9704
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9708
    });
9705
    });
9709
    $dbh->do(q{
9706
    $dbh->do(q{
9710
        ALTER TABLE old_issues DROP INDEX itemnumber_idx
9711
    });
9712
    $dbh->do(q{
9713
        ALTER TABLE issues DROP PRIMARY KEY
9714
    });
9715
    $dbh->do(q{
9716
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9707
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9717
    });
9708
    });
9718
    $dbh->do(q{
9709
    $dbh->do(q{
9719
        ALTER TABLE issues DROP INDEX itemnumber_idx
9710
        ALTER TABLE issues
9720
    });
9711
            DROP INDEX itemnumber_idx,
9721
    $dbh->do(q{
9712
            ADD UNIQUE itemnumber_idx ( itemnumber )
9722
        ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber)
9723
    });
9713
    });
9724
    $dbh->do(qq{
9714
    $dbh->do(qq{
9725
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9715
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9726
- 

Return to bug 9303