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

(-)a/installer/data/mysql/atomicupdate/bug_15516.sql (+3 lines)
Lines 6-8 CREATE TABLE reserve_group ( Link Here
6
6
7
ALTER TABLE reserves ADD COLUMN reserve_group_id int unsigned NULL DEFAULT NULL;
7
ALTER TABLE reserves ADD COLUMN reserve_group_id int unsigned NULL DEFAULT NULL;
8
ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_5 FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) ON DELETE SET NULL ON UPDATE CASCADE;
8
ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_5 FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) ON DELETE SET NULL ON UPDATE CASCADE;
9
10
ALTER TABLE old_reserves ADD COLUMN reserve_group_id int unsigned NULL DEFAULT NULL;
11
ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_4 FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 1703-1708 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1703
  `lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1703
  `lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1704
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1704
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1705
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1705
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1706
  reserve_group_id int unsigned NULL DEFAULT NULL,
1706
  PRIMARY KEY (`reserve_id`),
1707
  PRIMARY KEY (`reserve_id`),
1707
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1708
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1708
  KEY `old_reserves_biblionumber` (`biblionumber`),
1709
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 1714-1719 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1714
    ON DELETE SET NULL ON UPDATE SET NULL,
1715
    ON DELETE SET NULL ON UPDATE SET NULL,
1715
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1716
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1716
    ON DELETE SET NULL ON UPDATE SET NULL
1717
    ON DELETE SET NULL ON UPDATE SET NULL
1718
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id)
1719
    ON DELETE SET NULL ON UPDATE CASCADE
1717
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1720
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1718
1721
1719
--
1722
--
1720
- 

Return to bug 15516