|
Lines 173-179
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
| 173 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
173 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
| 174 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
174 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
| 175 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
175 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
| 176 |
`marc` longblob, -- full bibliographic MARC record |
|
|
| 177 |
`url` text default NULL, -- url (MARC21 856$u) |
176 |
`url` text default NULL, -- url (MARC21 856$u) |
| 178 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
177 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
| 179 |
`cn_class` varchar(30) default NULL, |
178 |
`cn_class` varchar(30) default NULL, |
|
Lines 528-534
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
| 528 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
527 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
| 529 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
528 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
| 530 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
529 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
| 531 |
`marc` longblob, -- full bibliographic MARC record |
|
|
| 532 |
`url` text default NULL, -- url (MARC21 856$u) |
530 |
`url` text default NULL, -- url (MARC21 856$u) |
| 533 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
531 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
| 534 |
`cn_class` varchar(30) default NULL, |
532 |
`cn_class` varchar(30) default NULL, |
| 535 |
- |
|
|