Lines 5382-5387
CREATE TABLE `tmp_holdsqueue` (
Link Here
|
5382 |
`pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5382 |
`pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5383 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5383 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5384 |
`item_level_request` tinyint(4) NOT NULL DEFAULT 0, |
5384 |
`item_level_request` tinyint(4) NOT NULL DEFAULT 0, |
|
|
5385 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this entry as added/last updated', |
5385 |
KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), |
5386 |
KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), |
5386 |
KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`), |
5387 |
KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`), |
5387 |
KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`), |
5388 |
KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`), |
5388 |
- |
|
|