Lines 4310-4315
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
Link Here
|
4310 |
SetVersion ($DBversion); |
4310 |
SetVersion ($DBversion); |
4311 |
} |
4311 |
} |
4312 |
|
4312 |
|
|
|
4313 |
$DBversion = "3.03.00.XXX"; |
4314 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
4315 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
4316 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE borrowernumber IS NULL"); |
4317 |
$dbh->do("DELETE FROM issues WHERE borrowernumber IS NULL"); |
4318 |
|
4319 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
4320 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE itemnumber IS NULL"); |
4321 |
$dbh->do("DELETE FROM issues WHERE itemnumber IS NULL"); |
4322 |
|
4323 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
4324 |
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)"); |
4325 |
$dbh->do("DELETE FROM issues WHERE NOT EXISTS (SELECT * FROM borrowers WHERE borrowernumber = issues.borrowernumber)"); |
4326 |
|
4327 |
$dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate) |
4328 |
SELECT borrowernumber, itemnumber, date_due, branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp, issuedate FROM issues WHERE NOT EXISTS (SELECT * FROM borrowers WHERE itemnumber = issues.itemnumber)"); |
4329 |
$dbh->do("DELETE FROM issues WHERE NOT EXISTS (SELECT * FROM items WHERE itemnumber = issues.itemnumber)"); |
4330 |
|
4331 |
$dbh->do("ALTER TABLE issues ALTER COLUMN borrowernumber DROP DEFAULT"); |
4332 |
$dbh->do("ALTER TABLE issues ALTER COLUMN itemnumber DROP DEFAULT"); |
4333 |
$dbh->do("ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL"); |
4334 |
$dbh->do("ALTER TABLE issues MODIFY COLUMN itemnumber int(11) NOT NULL"); |
4335 |
$dbh->do("ALTER TABLE issues DROP KEY `issuesitemidx`"); |
4336 |
$dbh->do("ALTER TABLE issues ADD PRIMARY KEY (`itemnumber`)"); |
4337 |
$dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_1`"); |
4338 |
$dbh->do("ALTER TABLE issues DROP FOREIGN KEY `issues_ibfk_2`"); |
4339 |
$dbh->do("ALTER TABLE issues ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE"); |
4340 |
$dbh->do("ALTER TABLE issues ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE"); |
4341 |
|
4342 |
print "Upgrade to $DBversion done (issues referential integrity)\n"; |
4343 |
SetVersion ($DBversion); |
4344 |
} |
4345 |
|
4313 |
=head1 FUNCTIONS |
4346 |
=head1 FUNCTIONS |
4314 |
|
4347 |
|
4315 |
=head2 DropAllForeignKeys($table) |
4348 |
=head2 DropAllForeignKeys($table) |
4316 |
- |
|
|