[Koha-bugs] [Bug 34276] upgrading 23.05 to 23.05.002
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Aug 31 16:34:15 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276
--- Comment #33 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
Yes that makes sense, currently, if we:
git checkout v22.11.05
reset_all
git checkout master
updatedatabase
koha-mysql kohadev -e 'show create table illrequests'
we get:
KEY `illrequests_bnfk` (`borrowernumber`),
KEY `illrequests_bcfk_2` (`branchcode`),
KEY `illrequests_safk` (`status_alias`),
KEY `illrequests_bibfk` (`biblio_id`),
CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES
`branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `illrequests_ibfk_1` FOREIGN KEY (`biblio_id`) REFERENCES `biblio`
(`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES
`authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE
So those who have already upgraded may or may not still have a
illrequests_ibfk_1 lingering. Is this what you mean?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list