View | Details | Raw Unified | Return to bug 8352
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 8352