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

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

Return to bug 15516