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

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

Return to bug 15516