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

(-)a/installer/data/mysql/updatedatabase.pl (-14 / +3 lines)
Lines 9679-9703 if(CheckVersion($DBversion)) { Link Here
9679
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9679
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9680
    });
9680
    });
9681
    $dbh->do(q{
9681
    $dbh->do(q{
9682
        ALTER TABLE old_issues DROP PRIMARY KEY
9683
    });
9684
    $dbh->do(q{
9685
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9682
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9686
    });
9683
    });
9687
    $dbh->do(q{
9684
    $dbh->do(q{
9688
        ALTER TABLE old_issues DROP INDEX itemnumber_idx
9689
    });
9690
    $dbh->do(q{
9691
        ALTER TABLE issues DROP PRIMARY KEY
9692
    });
9693
    $dbh->do(q{
9694
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9685
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9695
    });
9686
    });
9696
    $dbh->do(q{
9687
    $dbh->do(q{
9697
        ALTER TABLE issues DROP INDEX itemnumber_idx
9688
        ALTER TABLE issues
9698
    });
9689
            DROP INDEX itemnumber_idx,
9699
    $dbh->do(q{
9690
            ADD UNIQUE itemnumber_idx ( itemnumber )
9700
        ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber)
9701
    });
9691
    });
9702
    $dbh->do(qq{
9692
    $dbh->do(qq{
9703
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9693
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9704
- 

Return to bug 9303