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