Lines 3970-3976
CREATE TABLE `hold_fill_targets` (
Link Here
|
3970 |
`itemnumber` int(11) NOT NULL, |
3970 |
`itemnumber` int(11) NOT NULL, |
3971 |
`source_branchcode` varchar(10) default NULL, |
3971 |
`source_branchcode` varchar(10) default NULL, |
3972 |
`item_level_request` tinyint(4) NOT NULL default 0, |
3972 |
`item_level_request` tinyint(4) NOT NULL default 0, |
3973 |
`reserve_id` int(11) DEFAULT NULL |
3973 |
`reserve_id` int(11) DEFAULT NULL, |
3974 |
PRIMARY KEY `itemnumber` (`itemnumber`), |
3974 |
PRIMARY KEY `itemnumber` (`itemnumber`), |
3975 |
KEY `bib_branch` (`biblionumber`, `source_branchcode`), |
3975 |
KEY `bib_branch` (`biblionumber`, `source_branchcode`), |
3976 |
CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`) |
3976 |
CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`) |
3977 |
- |
|
|