Lines 4487-4493
CREATE TABLE `old_reserves` (
Link Here
|
4487 |
`suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)', |
4487 |
`suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)', |
4488 |
`suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)', |
4488 |
`suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)', |
4489 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
4489 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
4490 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hpld placed at item level', |
4490 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
4491 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
4491 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
4492 |
PRIMARY KEY (`reserve_id`), |
4492 |
PRIMARY KEY (`reserve_id`), |
4493 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
4493 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
Lines 4936-4942
CREATE TABLE `reserves` (
Link Here
|
4936 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, |
4936 |
`suspend` tinyint(1) NOT NULL DEFAULT 0, |
4937 |
`suspend_until` datetime DEFAULT NULL, |
4937 |
`suspend_until` datetime DEFAULT NULL, |
4938 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
4938 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting', |
4939 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hpld placed at item level', |
4939 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level', |
4940 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
4940 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold', |
4941 |
PRIMARY KEY (`reserve_id`), |
4941 |
PRIMARY KEY (`reserve_id`), |
4942 |
KEY `priorityfoundidx` (`priority`,`found`), |
4942 |
KEY `priorityfoundidx` (`priority`,`found`), |
4943 |
- |
|
|