Lines 181-187
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
181 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
181 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
182 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
182 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
183 |
`totalissues` int(10), |
183 |
`totalissues` int(10), |
184 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
185 |
PRIMARY KEY (`biblioitemnumber`), |
184 |
PRIMARY KEY (`biblioitemnumber`), |
186 |
KEY `bibinoidx` (`biblioitemnumber`), |
185 |
KEY `bibinoidx` (`biblioitemnumber`), |
187 |
KEY `bibnoidx` (`biblionumber`), |
186 |
KEY `bibnoidx` (`biblionumber`), |
Lines 535-541
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
535 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
534 |
`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting |
536 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
535 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
537 |
`totalissues` int(10), |
536 |
`totalissues` int(10), |
538 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
539 |
PRIMARY KEY (`biblioitemnumber`), |
537 |
PRIMARY KEY (`biblioitemnumber`), |
540 |
KEY `bibinoidx` (`biblioitemnumber`), |
538 |
KEY `bibinoidx` (`biblioitemnumber`), |
541 |
KEY `bibnoidx` (`biblionumber`), |
539 |
KEY `bibnoidx` (`biblionumber`), |
Lines 3795-3800
CREATE TABLE `hold_fill_targets` (
Link Here
|
3795 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
3793 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
3796 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3794 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3797 |
|
3795 |
|
|
|
3796 |
-- |
3797 |
-- Table structure for table `biblio_metadata` |
3798 |
-- |
3799 |
|
3800 |
CREATE TABLE biblio_metadata ( |
3801 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
3802 |
`biblionumber` INT(11) NOT NULL, |
3803 |
`format` VARCHAR(16) NOT NULL, |
3804 |
`marcflavour` VARCHAR(16) NOT NULL, |
3805 |
`metadata` LONGTEXT NOT NULL, |
3806 |
PRIMARY KEY(id), |
3807 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3808 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3809 |
|
3810 |
-- |
3811 |
-- Table structure for table `deletedbiblio_metadata` |
3812 |
-- |
3813 |
|
3814 |
CREATE TABLE deletedbiblio_metadata ( |
3815 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
3816 |
`biblionumber` INT(11) NOT NULL, |
3817 |
`format` VARCHAR(16) NOT NULL, |
3818 |
`marcflavour` VARCHAR(16) NOT NULL, |
3819 |
`metadata` LONGTEXT NOT NULL, |
3820 |
PRIMARY KEY(id), |
3821 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3822 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3823 |
|
3824 |
|
3798 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3825 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3799 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3826 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3800 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3827 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3801 |
- |
|
|