Lines 1668-1674
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1668 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1668 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1669 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1669 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1670 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1670 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1671 |
`printed` tinyint(1) DEFAULT NULL, |
1671 |
`printed` DATETIME DEFAULT NULL, |
1672 |
PRIMARY KEY (`reserve_id`), |
1672 |
PRIMARY KEY (`reserve_id`), |
1673 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1673 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1674 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1674 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 1856-1862
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1856 |
`lowestPriority` tinyint(1) NOT NULL, |
1856 |
`lowestPriority` tinyint(1) NOT NULL, |
1857 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1857 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1858 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1858 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1859 |
`printed` tinyint(1) DEFAULT NULL, |
1859 |
`printed` DATETIME DEFAULT NULL, |
1860 |
PRIMARY KEY (`reserve_id`), |
1860 |
PRIMARY KEY (`reserve_id`), |
1861 |
KEY priorityfoundidx (priority,found), |
1861 |
KEY priorityfoundidx (priority,found), |
1862 |
KEY `borrowernumber` (`borrowernumber`), |
1862 |
KEY `borrowernumber` (`borrowernumber`), |
1863 |
- |
|
|