|
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 |
- |
|
|