|
Lines 193-199
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
| 193 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
193 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
| 194 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
194 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
| 195 |
`totalissues` int(10), |
195 |
`totalissues` int(10), |
| 196 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
| 197 |
PRIMARY KEY (`biblioitemnumber`), |
196 |
PRIMARY KEY (`biblioitemnumber`), |
| 198 |
KEY `bibinoidx` (`biblioitemnumber`), |
197 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 199 |
KEY `bibnoidx` (`biblionumber`), |
198 |
KEY `bibnoidx` (`biblionumber`), |
|
Lines 547-553
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
| 547 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
546 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
| 548 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
547 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
| 549 |
`totalissues` int(10), |
548 |
`totalissues` int(10), |
| 550 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
| 551 |
PRIMARY KEY (`biblioitemnumber`), |
549 |
PRIMARY KEY (`biblioitemnumber`), |
| 552 |
KEY `bibinoidx` (`biblioitemnumber`), |
550 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 553 |
KEY `bibnoidx` (`biblionumber`), |
551 |
KEY `bibnoidx` (`biblionumber`), |
|
Lines 3921-3926
CREATE TABLE `article_requests` (
Link Here
|
| 3921 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
3919 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
| 3922 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3920 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3923 |
|
3921 |
|
|
|
3922 |
-- |
| 3923 |
-- Table structure for table `biblio_metadata` |
| 3924 |
-- |
| 3925 |
|
| 3926 |
CREATE TABLE biblio_metadata ( |
| 3927 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3928 |
`biblionumber` INT(11) NOT NULL, |
| 3929 |
`format` VARCHAR(16) NOT NULL, |
| 3930 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3931 |
`metadata` LONGTEXT NOT NULL, |
| 3932 |
PRIMARY KEY(id), |
| 3933 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 3934 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3935 |
|
| 3936 |
-- |
| 3937 |
-- Table structure for table `deletedbiblio_metadata` |
| 3938 |
-- |
| 3939 |
|
| 3940 |
CREATE TABLE deletedbiblio_metadata ( |
| 3941 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3942 |
`biblionumber` INT(11) NOT NULL, |
| 3943 |
`format` VARCHAR(16) NOT NULL, |
| 3944 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3945 |
`metadata` LONGTEXT NOT NULL, |
| 3946 |
PRIMARY KEY(id), |
| 3947 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 3948 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3949 |
|
| 3924 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3950 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 3925 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3951 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 3926 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3952 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 3927 |
- |
|
|