https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516
Indranil Das Gupta <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #16 from Indranil Das Gupta <[email protected]> --- | biblioitems | CREATE TABLE `biblioitems` ( `biblioitemnumber` int(11) NOT NULL AUTO_INCREMENT, `biblionumber` int(11) NOT NULL DEFAULT 0, `volume` longtext DEFAULT NULL, `number` longtext DEFAULT NULL, `itemtype` varchar(10) DEFAULT NULL, `isbn` longtext DEFAULT NULL, `issn` longtext DEFAULT NULL, `ean` longtext DEFAULT NULL, `publicationyear` mediumtext DEFAULT NULL, `publishercode` varchar(255) DEFAULT NULL, `volumedate` date DEFAULT NULL, `volumedesc` mediumtext DEFAULT NULL, `collectiontitle` longtext DEFAULT NULL, `collectionissn` mediumtext DEFAULT NULL, `collectionvolume` longtext DEFAULT NULL, `editionstatement` mediumtext DEFAULT NULL, `editionresponsibility` mediumtext DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `illus` varchar(255) DEFAULT NULL, `pages` varchar(255) DEFAULT NULL, `notes` longtext DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)', `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', `url` mediumtext DEFAULT NULL, `cn_source` varchar(10) DEFAULT NULL, `cn_class` varchar(30) DEFAULT NULL, `cn_item` varchar(10) DEFAULT NULL, `cn_suffix` varchar(10) DEFAULT NULL, `cn_sort` varchar(255) DEFAULT NULL, `agerestriction` varchar(255) DEFAULT NULL, `totalissues` int(10) DEFAULT NULL, PRIMARY KEY (`biblioitemnumber`), KEY `bibinoidx` (`biblioitemnumber`), KEY `bibnoidx` (`biblionumber`), KEY `itemtype_idx` (`itemtype`), KEY `publishercode` (`publishercode`), 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=9794 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci | From trying to upgrade from 22.11.07 to 22.11.10-2 -- 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/
