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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +14 lines)
Lines 1780-1788 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1780
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1780
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1781
    ON DELETE SET NULL ON UPDATE SET NULL,
1781
    ON DELETE SET NULL ON UPDATE SET NULL,
1782
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1782
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1783
    ON DELETE SET NULL ON UPDATE SET NULL,
1783
   ON DELETE SET NULL ON UPDATE SET NULL
1784
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1785
    ON DELETE SET NULL ON UPDATE CASCADE
1786
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1784
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1787
1785
1788
--
1786
--
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