[Koha-bugs] [Bug 32630] Don't delete ILL requests when patron is deleted

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32630

--- Comment #1 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
illrequests:

[...]
  `orderid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backend` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`illrequest_id`),
  UNIQUE KEY `illrequest_id` (`illrequest_id`),
  KEY `illrequests_bnfk` (`borrowernumber`),
  KEY `illrequests_bcfk_2` (`branchcode`),
  KEY `illrequests_safk` (`status_alias`),
  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_safk` FOREIGN KEY (`status_alias`) REFERENCES
`authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.