Lines 12345-12365
print "Upgrade to $DBversion done (Bug 12478 - Elasticsearch support for Koha)\n
Link Here
|
12345 |
|
12345 |
|
12346 |
$DBversion = "3.23.00.051"; |
12346 |
$DBversion = "3.23.00.051"; |
12347 |
if ( CheckVersion($DBversion) ) { |
12347 |
if ( CheckVersion($DBversion) ) { |
12348 |
$dbh->do(q{ |
12348 |
$dbh->do(q{ |
12349 |
ALTER TABLE edifact_messages |
12349 |
ALTER TABLE edifact_messages |
12350 |
DROP FOREIGN KEY emfk_vendor, |
12350 |
DROP FOREIGN KEY emfk_vendor, |
12351 |
DROP FOREIGN KEY emfk_edi_acct, |
12351 |
DROP FOREIGN KEY emfk_edi_acct, |
12352 |
DROP FOREIGN KEY emfk_basketno; |
12352 |
DROP FOREIGN KEY emfk_basketno; |
12353 |
|
12353 |
}); |
|
|
12354 |
$dbh->do(q{ |
12354 |
ALTER TABLE edifact_messages |
12355 |
ALTER TABLE edifact_messages |
12355 |
ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
12356 |
ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
12356 |
ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
12357 |
ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
12357 |
ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE; |
12358 |
ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE; |
12358 |
}); |
12359 |
}); |
12359 |
|
12360 |
|
12360 |
print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n"; |
12361 |
print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n"; |
12361 |
SetVersion($DBversion); |
12362 |
SetVersion($DBversion); |
12362 |
} |
12363 |
} |
12363 |
|
12364 |
|
12364 |
|
12365 |
|
12365 |
# DEVELOPER PROCESS, search for anything to execute in the db_update directory |
12366 |
# DEVELOPER PROCESS, search for anything to execute in the db_update directory |
12366 |
- |
|
|