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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +14 lines)
Lines 1778-1786 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1778
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1778
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1779
    ON DELETE SET NULL ON UPDATE SET NULL,
1779
    ON DELETE SET NULL ON UPDATE SET NULL,
1780
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1780
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1781
    ON DELETE SET NULL ON UPDATE SET NULL,
1781
   ON DELETE SET NULL ON UPDATE SET NULL
1782
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1783
    ON DELETE SET NULL ON UPDATE CASCADE
1784
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1782
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1785
1783
1786
--
1784
--
Lines 1859-1864 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1859
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1857
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1860
1858
1861
--
1859
--
1860
-- Table structure for table hold_group
1861
--
1862
1863
DROP TABLE IF EXISTS `hold_group`;
1864
CREATE TABLE `hold_group` (
1865
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1866
  PRIMARY KEY(`hold_group_id`)
1867
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1868
1869
--
1862
-- Table structure for table `reserves`
1870
-- Table structure for table `reserves`
1863
--
1871
--
1864
1872
Lines 1900-1915 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1900
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1908
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1901
1909
1902
--
1910
--
1903
-- Table structure for table hold_group
1904
--
1905
1906
DROP TABLE IF EXISTS `hold_group`;
1907
CREATE TABLE `hold_group` (
1908
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1909
  PRIMARY KEY(`hold_group_id`)
1910
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1911
1912
--
1913
-- Table structure for table `old_reserves`
1911
-- Table structure for table `old_reserves`
1914
--
1912
--
1915
1913
Lines 1948-1954 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1948
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1946
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1949
    ON DELETE SET NULL ON UPDATE SET NULL,
1947
    ON DELETE SET NULL ON UPDATE SET NULL,
1950
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1948
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1951
    ON DELETE SET NULL ON UPDATE SET NULL
1949
    ON DELETE SET NULL ON UPDATE SET NULL,
1950
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1951
    ON DELETE SET NULL ON UPDATE CASCADE
1952
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1952
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1953
1953
1954
--
1954
--
1955
- 

Return to bug 15516