|
Lines 4332-4337
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
| 4332 |
SetVersion($DBversion); |
4332 |
SetVersion($DBversion); |
| 4333 |
} |
4333 |
} |
| 4334 |
|
4334 |
|
|
|
4335 |
$DBversion = "3.05.00.XXX"; |
| 4336 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
| 4337 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
| 4338 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE borrowernumber IS NULL"); |
| 4339 |
$dbh->do("DELETE FROM issues WHERE borrowernumber IS NULL"); |
| 4340 |
|
| 4341 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
| 4342 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE itemnumber IS NULL"); |
| 4343 |
$dbh->do("DELETE FROM issues WHERE itemnumber IS NULL"); |
| 4344 |
|
| 4345 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
| 4346 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE NOT EXISTS (SELECT * FROM borrowers WHERE borrowernumber = issues.borrowernumber)"); |
| 4347 |
$dbh->do("DELETE FROM issues WHERE NOT EXISTS (SELECT * FROM borrowers WHERE borrowernumber = issues.borrowernumber)"); |
| 4348 |
|
| 4349 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
| 4350 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE NOT EXISTS (SELECT * FROM items WHERE itemnumber = issues.itemnumber)"); |
| 4351 |
$dbh->do("DELETE FROM issues WHERE NOT EXISTS (SELECT * FROM items WHERE itemnumber = issues.itemnumber)"); |
| 4352 |
|
| 4353 |
$dbh->do("ALTER TABLE issues ALTER COLUMN borrowernumber DROP DEFAULT"); |
| 4354 |
$dbh->do("ALTER TABLE issues ALTER COLUMN itemnumber DROP DEFAULT"); |
| 4355 |
$dbh->do("ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL"); |
| 4356 |
$dbh->do("ALTER TABLE issues MODIFY COLUMN itemnumber int(11) NOT NULL"); |
| 4357 |
$dbh->do("ALTER TABLE issues DROP KEY `issuesitemidx`"); |
| 4358 |
$dbh->do("ALTER TABLE issues ADD PRIMARY KEY (`itemnumber`)"); |
| 4359 |
$dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_1`"); |
| 4360 |
$dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_2`"); |
| 4361 |
$dbh->do("ALTER TABLE issues ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE"); |
| 4362 |
$dbh->do("ALTER TABLE issues ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE"); |
| 4363 |
|
| 4364 |
print "Upgrade to $DBversion done (issues referential integrity)\n"; |
| 4365 |
SetVersion ($DBversion); |
| 4366 |
} |
| 4367 |
|
| 4335 |
=head1 FUNCTIONS |
4368 |
=head1 FUNCTIONS |
| 4336 |
|
4369 |
|
| 4337 |
=head2 DropAllForeignKeys($table) |
4370 |
=head2 DropAllForeignKeys($table) |
| 4338 |
- |
|
|