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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +14 lines)
Lines 1713-1721 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1713
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1713
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1714
    ON DELETE SET NULL ON UPDATE SET NULL,
1714
    ON DELETE SET NULL ON UPDATE SET NULL,
1715
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1715
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1716
    ON DELETE SET NULL ON UPDATE SET NULL,
1716
   ON DELETE SET NULL ON UPDATE SET NULL
1717
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1718
    ON DELETE SET NULL ON UPDATE CASCADE
1719
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1717
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1720
1718
1721
--
1719
--
Lines 1793-1798 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1793
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1791
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1794
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1792
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1795
1793
1794
--
1795
-- Table structure for table hold_group
1796
--
1797
1798
DROP TABLE IF EXISTS `hold_group`;
1799
CREATE TABLE `hold_group` (
1800
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1801
  PRIMARY KEY(`hold_group_id`)
1802
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1803
1796
--
1804
--
1797
-- Table structure for table `reserves`
1805
-- Table structure for table `reserves`
1798
--
1806
--
Lines 1835-1850 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1835
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
1843
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`hold_group_id`) REFERENCES `hold_group` (`hold_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
1836
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1844
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1837
1845
1838
--
1839
-- Table structure for table hold_group
1840
--
1841
1842
DROP TABLE IF EXISTS `hold_group`;
1843
CREATE TABLE `hold_group` (
1844
  `hold_group_id` int unsigned NOT NULL AUTO_INCREMENT,
1845
  PRIMARY KEY(`hold_group_id`)
1846
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1847
1848
--
1846
--
1849
-- Table structure for table `old_reserves`
1847
-- Table structure for table `old_reserves`
1850
--
1848
--
Lines 1885-1891 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1885
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1883
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1886
    ON DELETE SET NULL ON UPDATE SET NULL,
1884
    ON DELETE SET NULL ON UPDATE SET NULL,
1887
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1885
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1888
    ON DELETE SET NULL ON UPDATE SET NULL
1886
    ON DELETE SET NULL ON UPDATE SET NULL,
1887
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id)
1888
    ON DELETE SET NULL ON UPDATE CASCADE
1889
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1889
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1890
1890
1891
--
1891
--
1892
- 

Return to bug 15516