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 |
- |
|
|