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 1901-1916 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1901
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1909
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1902
1910
1903
--
1911
--
1904
-- Table structure for table hold_group
1905
--
1906
1907
DROP TABLE IF EXISTS `hold_group`;
1908
CREATE TABLE `hold_group` (
1909
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1910
  PRIMARY KEY(`hold_group_id`)
1911
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1912
1913
--
1914
-- Table structure for table `old_reserves`
1912
-- Table structure for table `old_reserves`
1915
--
1913
--
1916
1914
Lines 1949-1955 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1949
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1947
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1950
    ON DELETE SET NULL ON UPDATE SET NULL,
1948
    ON DELETE SET NULL ON UPDATE SET NULL,
1951
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1949
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1952
    ON DELETE SET NULL ON UPDATE SET NULL
1950
    ON DELETE SET NULL ON UPDATE SET NULL,
1951
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1952
    ON DELETE SET NULL ON UPDATE CASCADE
1953
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1953
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1954
1954
1955
--
1955
--
1956
- 

Return to bug 15516