|
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 |
- |
|
|