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 |
- |
|
|