Lines 1109-1115
CREATE TABLE `biblioitems` (
Link Here
|
1109 |
`notes` longtext DEFAULT NULL, |
1109 |
`notes` longtext DEFAULT NULL, |
1110 |
`size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)', |
1110 |
`size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)', |
1111 |
`place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)', |
1111 |
`place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)', |
1112 |
`lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', |
1112 |
`lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', |
1113 |
`url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', |
1113 |
`url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', |
1114 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', |
1114 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', |
1115 |
`cn_class` varchar(30) DEFAULT NULL, |
1115 |
`cn_class` varchar(30) DEFAULT NULL, |
Lines 2508-2514
CREATE TABLE `deletedbiblioitems` (
Link Here
|
2508 |
`notes` longtext DEFAULT NULL, |
2508 |
`notes` longtext DEFAULT NULL, |
2509 |
`size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)', |
2509 |
`size` varchar(255) DEFAULT NULL COMMENT 'material size (MARC21 300$c)', |
2510 |
`place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)', |
2510 |
`place` varchar(255) DEFAULT NULL COMMENT 'publication place (MARC21 260$a)', |
2511 |
`lccn` varchar(25) DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', |
2511 |
`lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', |
2512 |
`url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', |
2512 |
`url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', |
2513 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', |
2513 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', |
2514 |
`cn_class` varchar(30) DEFAULT NULL, |
2514 |
`cn_class` varchar(30) DEFAULT NULL, |
2515 |
- |
|
|