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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 4487-4493 CREATE TABLE `old_reserves` ( Link Here
4487
  `suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',
4487
  `suspend` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in this hold suspended (1 for yes, 0 for no)',
4488
  `suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',
4488
  `suspend_until` datetime DEFAULT NULL COMMENT 'the date this hold is suspended until (NULL for infinitely)',
4489
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
4489
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
4490
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hpld placed at item level',
4490
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
4491
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
4491
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
4492
  PRIMARY KEY (`reserve_id`),
4492
  PRIMARY KEY (`reserve_id`),
4493
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
4493
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
Lines 4936-4942 CREATE TABLE `reserves` ( Link Here
4936
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
4936
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
4937
  `suspend_until` datetime DEFAULT NULL,
4937
  `suspend_until` datetime DEFAULT NULL,
4938
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
4938
  `itemtype` varchar(10) DEFAULT NULL COMMENT 'If record level hold, the optional itemtype of the item the patron is requesting',
4939
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hpld placed at item level',
4939
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is the hold placed at item level',
4940
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
4940
  `non_priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this a non priority hold',
4941
  PRIMARY KEY (`reserve_id`),
4941
  PRIMARY KEY (`reserve_id`),
4942
  KEY `priorityfoundidx` (`priority`,`found`),
4942
  KEY `priorityfoundidx` (`priority`,`found`),
4943
- 

Return to bug 28674