https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35687
--- Comment #12 from Jonathan Druart <[email protected]> --- I still do not recreate. Server version: 8.0.35 MySQL Community Server - GPL MySQL [koha_kohadev]> show create table tmp_holdsqueue\G *************************** 1. row *************************** Table: tmp_holdsqueue Create Table: CREATE TABLE `tmp_holdsqueue` ( `biblionumber` int DEFAULT NULL, `itemnumber` int DEFAULT NULL, `barcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `surname` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `firstname` mediumtext COLLATE utf8mb4_unicode_ci, `phone` mediumtext COLLATE utf8mb4_unicode_ci, `borrowernumber` int NOT NULL, `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reservedate` date DEFAULT NULL, `title` longtext COLLATE utf8mb4_unicode_ci, `itemcallnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` mediumtext COLLATE utf8mb4_unicode_ci, `item_level_request` tinyint NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date and time this entry as added/last updated', KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`), KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`), CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci MySQL [koha_kohadev]> ALTER TABLE tmp_holdsqueue ADD PRIMARY KEY (itemnumber); Query OK, 0 rows affected (0.131 sec) Records: 0 Duplicates: 0 Warnings: 0 MySQL [koha_kohadev]> show create table tmp_holdsqueue\G *************************** 1. row *************************** Table: tmp_holdsqueue Create Table: CREATE TABLE `tmp_holdsqueue` ( `biblionumber` int DEFAULT NULL, `itemnumber` int NOT NULL, `barcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `surname` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `firstname` mediumtext COLLATE utf8mb4_unicode_ci, `phone` mediumtext COLLATE utf8mb4_unicode_ci, `borrowernumber` int NOT NULL, `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reservedate` date DEFAULT NULL, `title` longtext COLLATE utf8mb4_unicode_ci, `itemcallnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` mediumtext COLLATE utf8mb4_unicode_ci, `item_level_request` tinyint NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date and time this entry as added/last updated', PRIMARY KEY (`itemnumber`), KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`), KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`), CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 1 row in set (0.001 sec) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
