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

(-)a/installer/data/mysql/updatedatabase.pl (-14 / +3 lines)
Lines 9618-9642 if(CheckVersion($DBversion)) { Link Here
9618
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9618
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
9619
    });
9619
    });
9620
    $dbh->do(q{
9620
    $dbh->do(q{
9621
        ALTER TABLE old_issues DROP PRIMARY KEY
9622
    });
9623
    $dbh->do(q{
9624
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9621
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9625
    });
9622
    });
9626
    $dbh->do(q{
9623
    $dbh->do(q{
9627
        ALTER TABLE old_issues DROP INDEX itemnumber_idx
9628
    });
9629
    $dbh->do(q{
9630
        ALTER TABLE issues DROP PRIMARY KEY
9631
    });
9632
    $dbh->do(q{
9633
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9624
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9634
    });
9625
    });
9635
    $dbh->do(q{
9626
    $dbh->do(q{
9636
        ALTER TABLE issues DROP INDEX itemnumber_idx
9627
        ALTER TABLE issues
9637
    });
9628
            DROP INDEX itemnumber_idx,
9638
    $dbh->do(q{
9629
            ADD UNIQUE itemnumber_idx ( itemnumber )
9639
        ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber)
9640
    });
9630
    });
9641
    $dbh->do(qq{
9631
    $dbh->do(qq{
9642
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9632
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9643
- 

Return to bug 9303