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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +14 lines)
Lines 1810-1818 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1810
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1810
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1811
    ON DELETE SET NULL ON UPDATE SET NULL,
1811
    ON DELETE SET NULL ON UPDATE SET NULL,
1812
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1812
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1813
    ON DELETE SET NULL ON UPDATE SET NULL,
1813
   ON DELETE SET NULL ON UPDATE SET NULL
1814
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1815
    ON DELETE SET NULL ON UPDATE CASCADE
1816
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1814
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1817
1815
1818
--
1816
--
Lines 1891-1896 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1891
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1889
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1892
1890
1893
--
1891
--
1892
-- Table structure for table hold_group
1893
--
1894
1895
DROP TABLE IF EXISTS `hold_group`;
1896
CREATE TABLE `hold_group` (
1897
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1898
  PRIMARY KEY(`hold_group_id`)
1899
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1900
1901
--
1894
-- Table structure for table `reserves`
1902
-- Table structure for table `reserves`
1895
--
1903
--
1896
1904
Lines 1932-1947 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1932
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1940
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1933
1941
1934
--
1942
--
1935
-- Table structure for table hold_group
1936
--
1937
1938
DROP TABLE IF EXISTS `hold_group`;
1939
CREATE TABLE `hold_group` (
1940
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1941
  PRIMARY KEY(`hold_group_id`)
1942
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1943
1944
--
1945
-- Table structure for table `old_reserves`
1943
-- Table structure for table `old_reserves`
1946
--
1944
--
1947
1945
Lines 1980-1986 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1980
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1978
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1981
    ON DELETE SET NULL ON UPDATE SET NULL,
1979
    ON DELETE SET NULL ON UPDATE SET NULL,
1982
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1980
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1983
    ON DELETE SET NULL ON UPDATE SET NULL
1981
    ON DELETE SET NULL ON UPDATE SET NULL,
1982
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1983
    ON DELETE SET NULL ON UPDATE CASCADE
1984
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1984
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1985
1985
1986
--
1986
--
1987
- 

Return to bug 15516