Lines 153-160
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
153 |
`volume` mediumtext, |
153 |
`volume` mediumtext, |
154 |
`number` mediumtext, |
154 |
`number` mediumtext, |
155 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
155 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
156 |
`isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a) |
156 |
`isbn` mediumtext, -- ISBN (MARC21 020$a) |
157 |
`issn` varchar(9) default NULL, -- ISSN (MARC21 022$a) |
157 |
`issn` mediumtext, -- ISSN (MARC21 022$a) |
158 |
`ean` varchar(13) default NULL, |
158 |
`ean` varchar(13) default NULL, |
159 |
`publicationyear` text, |
159 |
`publicationyear` text, |
160 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
160 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
Lines 186-193
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
186 |
KEY `bibinoidx` (`biblioitemnumber`), |
186 |
KEY `bibinoidx` (`biblioitemnumber`), |
187 |
KEY `bibnoidx` (`biblionumber`), |
187 |
KEY `bibnoidx` (`biblionumber`), |
188 |
KEY `itemtype_idx` (`itemtype`), |
188 |
KEY `itemtype_idx` (`itemtype`), |
189 |
KEY `isbn` (`isbn`), |
189 |
KEY `isbn` (`isbn`(255)), |
190 |
KEY `issn` (`issn`), |
190 |
KEY `issn` (`issn`(255)), |
191 |
KEY `publishercode` (`publishercode`), |
191 |
KEY `publishercode` (`publishercode`), |
192 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
192 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
193 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
193 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |