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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +14 lines)
Lines 1791-1799 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1791
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1791
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1792
    ON DELETE SET NULL ON UPDATE SET NULL,
1792
    ON DELETE SET NULL ON UPDATE SET NULL,
1793
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1793
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1794
    ON DELETE SET NULL ON UPDATE SET NULL,
1794
   ON DELETE SET NULL ON UPDATE SET NULL
1795
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1796
    ON DELETE SET NULL ON UPDATE CASCADE
1797
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1795
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1798
1796
1799
--
1797
--
Lines 1872-1877 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1872
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1870
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1873
1871
1874
--
1872
--
1873
-- Table structure for table hold_group
1874
--
1875
1876
DROP TABLE IF EXISTS `hold_group`;
1877
CREATE TABLE `hold_group` (
1878
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1879
  PRIMARY KEY(`hold_group_id`)
1880
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1881
1882
--
1875
-- Table structure for table `reserves`
1883
-- Table structure for table `reserves`
1876
--
1884
--
1877
1885
Lines 1913-1928 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1913
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1921
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1914
1922
1915
--
1923
--
1916
-- Table structure for table hold_group
1917
--
1918
1919
DROP TABLE IF EXISTS `hold_group`;
1920
CREATE TABLE `hold_group` (
1921
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1922
  PRIMARY KEY(`hold_group_id`)
1923
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1924
1925
--
1926
-- Table structure for table `old_reserves`
1924
-- Table structure for table `old_reserves`
1927
--
1925
--
1928
1926
Lines 1961-1967 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1961
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1959
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1962
    ON DELETE SET NULL ON UPDATE SET NULL,
1960
    ON DELETE SET NULL ON UPDATE SET NULL,
1963
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1961
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1964
    ON DELETE SET NULL ON UPDATE SET NULL
1962
    ON DELETE SET NULL ON UPDATE SET NULL,
1963
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1964
    ON DELETE SET NULL ON UPDATE CASCADE
1965
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1965
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1966
1966
1967
--
1967
--
1968
- 

Return to bug 15516