[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