[Koha-bugs] [Bug 34516] Upgrade database fails for 22.11.07.003, points to web installer

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

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

Indranil Das Gupta <indradg at l2c2.co.in> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |indradg at l2c2.co.in

--- Comment #16 from Indranil Das Gupta <indradg at l2c2.co.in> ---
| 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.