|
Lines 8802-8808
if ( CheckVersion($DBversion) ) {
Link Here
|
| 8802 |
|
8802 |
|
| 8803 |
$DBversion = "3.17.00.XXX"; |
8803 |
$DBversion = "3.17.00.XXX"; |
| 8804 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
8804 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
| 8805 |
$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo')"); |
8805 |
$dbh->do(q{ |
|
|
8806 |
INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo') |
| 8807 |
}); |
| 8808 |
|
| 8809 |
$dbh->do(q{ |
| 8810 |
ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
| 8811 |
}); |
| 8812 |
$dbh->do(q{ |
| 8813 |
ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; |
| 8814 |
}); |
| 8815 |
$dbh->do(q{ |
| 8816 |
UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC |
| 8817 |
}); |
| 8806 |
|
8818 |
|
| 8807 |
print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n"; |
8819 |
print "Upgrade to $DBversion done (Bug 9011 - Add the ability to store the last patron to return an item)\n"; |
| 8808 |
} |
8820 |
} |
| 8809 |
- |
|
|