Lines 168-174
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
168 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
168 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
169 |
`isbn` mediumtext, -- ISBN (MARC21 020$a) |
169 |
`isbn` mediumtext, -- ISBN (MARC21 020$a) |
170 |
`issn` mediumtext, -- ISSN (MARC21 022$a) |
170 |
`issn` mediumtext, -- ISSN (MARC21 022$a) |
171 |
`ean` varchar(13) default NULL, |
171 |
`ean` mediumtext default NULL, |
172 |
`publicationyear` text, |
172 |
`publicationyear` text, |
173 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
173 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
174 |
`volumedate` date default NULL, |
174 |
`volumedate` date default NULL, |
Lines 199-204
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
199 |
KEY `itemtype_idx` (`itemtype`), |
199 |
KEY `itemtype_idx` (`itemtype`), |
200 |
KEY `isbn` (`isbn`(255)), |
200 |
KEY `isbn` (`isbn`(255)), |
201 |
KEY `issn` (`issn`(255)), |
201 |
KEY `issn` (`issn`(255)), |
|
|
202 |
KEY `ean` (`ean`(255)), |
202 |
KEY `publishercode` (`publishercode`), |
203 |
KEY `publishercode` (`publishercode`), |
203 |
KEY `timestamp` (`timestamp`), |
204 |
KEY `timestamp` (`timestamp`), |
204 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
205 |
CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
Lines 524-530
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
524 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
525 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
525 |
`isbn` mediumtext default NULL, -- ISBN (MARC21 020$a) |
526 |
`isbn` mediumtext default NULL, -- ISBN (MARC21 020$a) |
526 |
`issn` mediumtext default NULL, -- ISSN (MARC21 022$a) |
527 |
`issn` mediumtext default NULL, -- ISSN (MARC21 022$a) |
527 |
`ean` varchar(13) default NULL, |
528 |
`ean` mediumtext default NULL, |
528 |
`publicationyear` text, |
529 |
`publicationyear` text, |
529 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
530 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
530 |
`volumedate` date default NULL, |
531 |
`volumedate` date default NULL, |
Lines 554-559
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
554 |
KEY `bibnoidx` (`biblionumber`), |
555 |
KEY `bibnoidx` (`biblionumber`), |
555 |
KEY `itemtype_idx` (`itemtype`), |
556 |
KEY `itemtype_idx` (`itemtype`), |
556 |
KEY `isbn` (`isbn`(255)), |
557 |
KEY `isbn` (`isbn`(255)), |
|
|
558 |
KEY `ean` (`ean`(255)), |
557 |
KEY `publishercode` (`publishercode`), |
559 |
KEY `publishercode` (`publishercode`), |
558 |
KEY `timestamp` (`timestamp`) |
560 |
KEY `timestamp` (`timestamp`) |
559 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
561 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
560 |
- |
|
|