|
Lines 1778-1786
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
| 1778 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1778 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
| 1779 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1779 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1780 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1780 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1781 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1781 |
ON DELETE SET NULL ON UPDATE SET NULL |
| 1782 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
|
|
| 1783 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1784 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1785 |
|
1783 |
|
| 1786 |
-- |
1784 |
-- |
|
Lines 1859-1864
CREATE TABLE `patronimage` ( -- information related to patron images
Link Here
|
| 1859 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1857 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1860 |
|
1858 |
|
| 1861 |
-- |
1859 |
-- |
|
|
1860 |
-- Table structure for table hold_group |
| 1861 |
-- |
| 1862 |
|
| 1863 |
DROP TABLE IF EXISTS `hold_group`; |
| 1864 |
CREATE TABLE `hold_group` ( |
| 1865 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1866 |
PRIMARY KEY(`hold_group_id`) |
| 1867 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1868 |
|
| 1869 |
-- |
| 1862 |
-- Table structure for table `reserves` |
1870 |
-- Table structure for table `reserves` |
| 1863 |
-- |
1871 |
-- |
| 1864 |
|
1872 |
|
|
Lines 1900-1915
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
| 1900 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1908 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1901 |
|
1909 |
|
| 1902 |
-- |
1910 |
-- |
| 1903 |
-- Table structure for table hold_group |
|
|
| 1904 |
-- |
| 1905 |
|
| 1906 |
DROP TABLE IF EXISTS `hold_group`; |
| 1907 |
CREATE TABLE `hold_group` ( |
| 1908 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1909 |
PRIMARY KEY(`hold_group_id`) |
| 1910 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1911 |
|
| 1912 |
-- |
| 1913 |
-- Table structure for table `old_reserves` |
1911 |
-- Table structure for table `old_reserves` |
| 1914 |
-- |
1912 |
-- |
| 1915 |
|
1913 |
|
|
Lines 1948-1954
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
| 1948 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1946 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1949 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1947 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1950 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1948 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 1951 |
ON DELETE SET NULL ON UPDATE SET NULL |
1949 |
ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
1950 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
| 1951 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1952 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1952 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1953 |
|
1953 |
|
| 1954 |
-- |
1954 |
-- |
| 1955 |
- |
|
|