|
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 3790-3795
CREATE TABLE `hold_fill_targets` (
Link Here
|
| 3790 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
3788 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3791 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3789 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3792 |
|
3790 |
|
|
|
3791 |
-- |
| 3792 |
-- Table structure for table `biblio_metadata` |
| 3793 |
-- |
| 3794 |
|
| 3795 |
CREATE TABLE biblio_metadata ( |
| 3796 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3797 |
`biblionumber` INT(11) NOT NULL, |
| 3798 |
`format` VARCHAR(16) NOT NULL, |
| 3799 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3800 |
`metadata` LONGTEXT NOT NULL, |
| 3801 |
PRIMARY KEY(id), |
| 3802 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 3803 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3804 |
|
| 3805 |
-- |
| 3806 |
-- Table structure for table `deletedbiblio_metadata` |
| 3807 |
-- |
| 3808 |
|
| 3809 |
CREATE TABLE deletedbiblio_metadata ( |
| 3810 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 3811 |
`biblionumber` INT(11) NOT NULL, |
| 3812 |
`format` VARCHAR(16) NOT NULL, |
| 3813 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3814 |
`metadata` LONGTEXT NOT NULL, |
| 3815 |
PRIMARY KEY(id), |
| 3816 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 3817 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3818 |
|
| 3819 |
|
| 3793 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3820 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 3794 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3821 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 3795 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3822 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 3796 |
- |
|
|