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