[Koha-bugs] [Bug 30451] Delete a subscription deletes the linked order
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jul 20 14:00:00 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30451
--- Comment #4 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
DROP TABLE IF EXISTS `aqorders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aqorders` (
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique
identifier assigned by Koha to each line',
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio
being ordered (biblio.biblionumber)',
`deleted_biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the
deleted bibliographic record (deletedbiblio.biblionumber)',
`entrydate` date DEFAULT NULL COMMENT 'the date the bib was added to the
basket',
[...]
CONSTRAINT `aqorders_invoice_currency` FOREIGN KEY (`invoice_currency`)
REFERENCES `currency` (`currency`) ON DELETE SET NULL ON UPDATE SET NULL,
CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`)
REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE
CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
The constraint needs to be updated to be: ON DELETE SET NULL
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list