Lines 3978-3984
CREATE TABLE `hold_fill_targets` (
Link Here
|
3978 |
`itemnumber` int(11) NOT NULL, |
3978 |
`itemnumber` int(11) NOT NULL, |
3979 |
`source_branchcode` varchar(10) default NULL, |
3979 |
`source_branchcode` varchar(10) default NULL, |
3980 |
`item_level_request` tinyint(4) NOT NULL default 0, |
3980 |
`item_level_request` tinyint(4) NOT NULL default 0, |
3981 |
`reserve_id` int(11) DEFAULT NULL |
3981 |
`reserve_id` int(11) DEFAULT NULL, |
3982 |
PRIMARY KEY `itemnumber` (`itemnumber`), |
3982 |
PRIMARY KEY `itemnumber` (`itemnumber`), |
3983 |
KEY `bib_branch` (`biblionumber`, `source_branchcode`), |
3983 |
KEY `bib_branch` (`biblionumber`, `source_branchcode`), |
3984 |
CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`) |
3984 |
CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`) |
3985 |
- |
|
|