Lines 2458-2464
CREATE TABLE `tmp_holdsqueue` (
Link Here
|
2458 |
`holdingbranch` varchar(10) default NULL, |
2458 |
`holdingbranch` varchar(10) default NULL, |
2459 |
`pickbranch` varchar(10) default NULL, |
2459 |
`pickbranch` varchar(10) default NULL, |
2460 |
`notes` MEDIUMTEXT, |
2460 |
`notes` MEDIUMTEXT, |
2461 |
`item_level_request` tinyint(4) NOT NULL default 0 |
2461 |
`item_level_request` tinyint(4) NOT NULL default 0, |
|
|
2462 |
CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) |
2463 |
REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2462 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2464 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2463 |
|
2465 |
|
2464 |
-- |
2466 |
-- |
2465 |
- |
|
|