Lines 5112-5117
CREATE TABLE `old_reserves` (
Link Here
|
5112 |
KEY `old_reserves_branchcode` (`branchcode`), |
5112 |
KEY `old_reserves_branchcode` (`branchcode`), |
5113 |
KEY `old_reserves_itemtype` (`itemtype`), |
5113 |
KEY `old_reserves_itemtype` (`itemtype`), |
5114 |
KEY `old_reserves_ibfk_ig` (`item_group_id`), |
5114 |
KEY `old_reserves_ibfk_ig` (`item_group_id`), |
|
|
5115 |
KEY `old_reserves_ibfk_hg` (`hold_group_id`), |
5115 |
CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5116 |
CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5116 |
CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5117 |
CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5117 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
5118 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
Lines 5686-5691
CREATE TABLE `reserves` (
Link Here
|
5686 |
KEY `desk_id` (`desk_id`), |
5687 |
KEY `desk_id` (`desk_id`), |
5687 |
KEY `itemtype` (`itemtype`), |
5688 |
KEY `itemtype` (`itemtype`), |
5688 |
KEY `reserves_ibfk_ig` (`item_group_id`), |
5689 |
KEY `reserves_ibfk_ig` (`item_group_id`), |
|
|
5690 |
KEY `reserves_ibfk_hg` (`hold_group_id`), |
5689 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5691 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5690 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5692 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5691 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5693 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5692 |
- |
|
|