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