https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516
--- Comment #7 from [email protected] --- It might indeed too late but here is the info you requested: mysql Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) biblioitems | CREATE TABLE `biblioitems` ( `biblioitemnumber` int NOT NULL AUTO_INCREMENT, `biblionumber` int NOT NULL DEFAULT '0', `volume` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `number` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `itemtype` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isbn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `issn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ean` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `publicationyear` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `publishercode` text COLLATE utf8mb4_unicode_ci COMMENT 'publisher (MARC21 260$b and 264$b)', `volumedate` date DEFAULT NULL, `volumedesc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `collectiontitle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `collectionissn` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `collectionvolume` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `editionstatement` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `editionresponsibility` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `illus` text COLLATE utf8mb4_unicode_ci COMMENT 'illustrations (MARC21 300$b)', `pages` text COLLATE utf8mb4_unicode_ci COMMENT 'number of pages (MARC21 300$a)', `notes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `size` text COLLATE utf8mb4_unicode_ci COMMENT 'material size (MARC21 300$c)', `place` text COLLATE utf8mb4_unicode_ci COMMENT 'publication place (MARC21 260$a and 264$a)', `lccn` longtext COLLATE utf8mb4_unicode_ci COMMENT 'library of congress control number (MARC21 010$a)', `url` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `cn_source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cn_class` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cn_item` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cn_suffix` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cn_sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agerestriction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `totalissues` int DEFAULT NULL, PRIMARY KEY (`biblioitemnumber`), KEY `bibinoidx` (`biblioitemnumber`), KEY `bibnoidx` (`biblionumber`), KEY `itemtype_idx` (`itemtype`), KEY `isbn` (`isbn`(255)), KEY `issn` (`issn`(255)), KEY `timestamp` (`timestamp`), KEY `ean` (`ean`(255)), CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=20499 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ 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/
