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 3922-3927
CREATE TABLE `article_requests` (
Link Here
|
3922 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
3920 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
3923 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3921 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3924 |
|
3922 |
|
|
|
3923 |
-- |
3924 |
-- Table structure for table `biblio_metadata` |
3925 |
-- |
3926 |
|
3927 |
CREATE TABLE biblio_metadata ( |
3928 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
3929 |
`biblionumber` INT(11) NOT NULL, |
3930 |
`format` VARCHAR(16) NOT NULL, |
3931 |
`marcflavour` VARCHAR(16) NOT NULL, |
3932 |
`metadata` LONGTEXT NOT NULL, |
3933 |
PRIMARY KEY(id), |
3934 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3935 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3936 |
|
3937 |
-- |
3938 |
-- Table structure for table `deletedbiblio_metadata` |
3939 |
-- |
3940 |
|
3941 |
CREATE TABLE deletedbiblio_metadata ( |
3942 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
3943 |
`biblionumber` INT(11) NOT NULL, |
3944 |
`format` VARCHAR(16) NOT NULL, |
3945 |
`marcflavour` VARCHAR(16) NOT NULL, |
3946 |
`metadata` LONGTEXT NOT NULL, |
3947 |
PRIMARY KEY(id), |
3948 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3949 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3950 |
|
3925 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3951 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3926 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3952 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3927 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3953 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3928 |
- |
|
|