Lines 173-179
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
173 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
173 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
174 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
174 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
175 |
`marc` longblob, -- full bibliographic MARC record |
175 |
`marc` longblob, -- full bibliographic MARC record |
176 |
`url` varchar(255) default NULL, -- url (MARC21 856$u) |
176 |
`url` text default NULL, -- url (MARC21 856$u) |
177 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
177 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
178 |
`cn_class` varchar(30) default NULL, |
178 |
`cn_class` varchar(30) default NULL, |
179 |
`cn_item` varchar(10) default NULL, |
179 |
`cn_item` varchar(10) default NULL, |
Lines 775-781
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
775 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
775 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
776 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
776 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
777 |
`marc` longblob, -- full bibliographic MARC record |
777 |
`marc` longblob, -- full bibliographic MARC record |
778 |
`url` varchar(255) default NULL, -- url (MARC21 856$u) |
778 |
`url` text default NULL, -- url (MARC21 856$u) |
779 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
779 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
780 |
`cn_class` varchar(30) default NULL, |
780 |
`cn_class` varchar(30) default NULL, |
781 |
`cn_item` varchar(10) default NULL, |
781 |
`cn_item` varchar(10) default NULL, |