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

(-)a/installer/data/mysql/updatedatabase.pl (-14 / +3 lines)
Lines 8962-8986 if(CheckVersion($DBversion)) { Link Here
8962
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
8962
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'
8963
    });
8963
    });
8964
    $dbh->do(q{
8964
    $dbh->do(q{
8965
        ALTER TABLE old_issues DROP PRIMARY KEY
8966
    });
8967
    $dbh->do(q{
8968
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8965
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8969
    });
8966
    });
8970
    $dbh->do(q{
8967
    $dbh->do(q{
8971
        ALTER TABLE old_issues DROP INDEX itemnumber_idx
8972
    });
8973
    $dbh->do(q{
8974
        ALTER TABLE issues DROP PRIMARY KEY
8975
    });
8976
    $dbh->do(q{
8977
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8968
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
8978
    });
8969
    });
8979
    $dbh->do(q{
8970
    $dbh->do(q{
8980
        ALTER TABLE issues DROP INDEX itemnumber_idx
8971
        ALTER TABLE issues
8981
    });
8972
            DROP INDEX itemnumber_idx,
8982
    $dbh->do(q{
8973
            ADD UNIQUE itemnumber_idx ( itemnumber )
8983
        ALTER TABLE issues ADD UNIQUE itemnumber_idx (itemnumber)
8984
    });
8974
    });
8985
    $dbh->do(qq{
8975
    $dbh->do(qq{
8986
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8976
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
8987
- 

Return to bug 9303