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