Lines 1663-1669
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1663 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1663 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1664 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1664 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1665 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1665 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1666 |
`printed` tinyint(1) DEFAULT NULL, |
1666 |
`printed` DATETIME DEFAULT NULL, |
1667 |
PRIMARY KEY (`reserve_id`), |
1667 |
PRIMARY KEY (`reserve_id`), |
1668 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1668 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1669 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1669 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 1839-1845
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1839 |
`lowestPriority` tinyint(1) NOT NULL, |
1839 |
`lowestPriority` tinyint(1) NOT NULL, |
1840 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1840 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1841 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1841 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1842 |
`printed` tinyint(1) DEFAULT NULL, |
1842 |
`printed` DATETIME DEFAULT NULL, |
1843 |
PRIMARY KEY (`reserve_id`), |
1843 |
PRIMARY KEY (`reserve_id`), |
1844 |
KEY priorityfoundidx (priority,found), |
1844 |
KEY priorityfoundidx (priority,found), |
1845 |
KEY `borrowernumber` (`borrowernumber`), |
1845 |
KEY `borrowernumber` (`borrowernumber`), |
1846 |
- |
|
|