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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql (+2 lines)
Line 0 Link Here
1
ALTER TABLE reserves MODIFY lowestPriority tinyint(1) NOT NULL DEFAULT 0;
2
ALTER TABLE old_reserves MODIFY lowestPriority tinyint(1) NOT NULL DEFAULT 0;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 1895-1901 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1895
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1895
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1896
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1896
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1897
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1897
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1898
  `lowestPriority` tinyint(1) NOT NULL,
1898
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
1899
  `suspend` BOOLEAN NOT NULL DEFAULT 0,
1899
  `suspend` BOOLEAN NOT NULL DEFAULT 0,
1900
  `suspend_until` DATETIME NULL DEFAULT NULL,
1900
  `suspend_until` DATETIME NULL DEFAULT NULL,
1901
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1901
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
Lines 1934-1940 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1934
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1934
  `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
1935
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1935
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1936
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1936
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1937
  `lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1937
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1938
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1938
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1939
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1939
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1940
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1940
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1941
- 

Return to bug 20144