|
Lines 181-187
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
| 181 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
181 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
| 182 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
182 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
| 183 |
`totalissues` int(10), |
183 |
`totalissues` int(10), |
| 184 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
184 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
| 185 |
PRIMARY KEY (`biblioitemnumber`), |
185 |
PRIMARY KEY (`biblioitemnumber`), |
| 186 |
KEY `bibinoidx` (`biblioitemnumber`), |
186 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 187 |
KEY `bibnoidx` (`biblionumber`), |
187 |
KEY `bibnoidx` (`biblionumber`), |
|
Lines 812-818
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
| 812 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
812 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
| 813 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
813 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
| 814 |
`totalissues` int(10), |
814 |
`totalissues` int(10), |
| 815 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
815 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
| 816 |
PRIMARY KEY (`biblioitemnumber`), |
816 |
PRIMARY KEY (`biblioitemnumber`), |
| 817 |
KEY `bibinoidx` (`biblioitemnumber`), |
817 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 818 |
KEY `bibnoidx` (`biblionumber`), |
818 |
KEY `bibnoidx` (`biblionumber`), |