Lines 1682-1688
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1682 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1682 |
`lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
1683 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1683 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) |
1684 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1684 |
`suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) |
1685 |
`printed` tinyint(1) DEFAULT NULL, |
1685 |
`printed` DATETIME DEFAULT NULL, |
1686 |
PRIMARY KEY (`reserve_id`), |
1686 |
PRIMARY KEY (`reserve_id`), |
1687 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1687 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1688 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1688 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
Lines 1860-1866
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1860 |
`lowestPriority` tinyint(1) NOT NULL, |
1860 |
`lowestPriority` tinyint(1) NOT NULL, |
1861 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1861 |
`suspend` BOOLEAN NOT NULL DEFAULT 0, |
1862 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1862 |
`suspend_until` DATETIME NULL DEFAULT NULL, |
1863 |
`printed` tinyint(1) DEFAULT NULL, |
1863 |
`printed` DATETIME DEFAULT NULL, |
1864 |
PRIMARY KEY (`reserve_id`), |
1864 |
PRIMARY KEY (`reserve_id`), |
1865 |
KEY priorityfoundidx (priority,found), |
1865 |
KEY priorityfoundidx (priority,found), |
1866 |
KEY `borrowernumber` (`borrowernumber`), |
1866 |
KEY `borrowernumber` (`borrowernumber`), |
1867 |
- |
|
|