|
Lines 1810-1818
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
| 1810 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1810 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
| 1811 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1811 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1812 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1812 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1813 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1813 |
ON DELETE SET NULL ON UPDATE SET NULL |
| 1814 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
|
|
| 1815 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1816 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1814 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1817 |
|
1815 |
|
| 1818 |
-- |
1816 |
-- |
|
Lines 1891-1896
CREATE TABLE `patronimage` ( -- information related to patron images
Link Here
|
| 1891 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1889 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1892 |
|
1890 |
|
| 1893 |
-- |
1891 |
-- |
|
|
1892 |
-- Table structure for table hold_group |
| 1893 |
-- |
| 1894 |
|
| 1895 |
DROP TABLE IF EXISTS `hold_group`; |
| 1896 |
CREATE TABLE `hold_group` ( |
| 1897 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1898 |
PRIMARY KEY(`hold_group_id`) |
| 1899 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1900 |
|
| 1901 |
-- |
| 1894 |
-- Table structure for table `reserves` |
1902 |
-- Table structure for table `reserves` |
| 1895 |
-- |
1903 |
-- |
| 1896 |
|
1904 |
|
|
Lines 1932-1947
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
| 1932 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1940 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1933 |
|
1941 |
|
| 1934 |
-- |
1942 |
-- |
| 1935 |
-- Table structure for table hold_group |
|
|
| 1936 |
-- |
| 1937 |
|
| 1938 |
DROP TABLE IF EXISTS `hold_group`; |
| 1939 |
CREATE TABLE `hold_group` ( |
| 1940 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1941 |
PRIMARY KEY(`hold_group_id`) |
| 1942 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1943 |
|
| 1944 |
-- |
| 1945 |
-- Table structure for table `old_reserves` |
1943 |
-- Table structure for table `old_reserves` |
| 1946 |
-- |
1944 |
-- |
| 1947 |
|
1945 |
|
|
Lines 1980-1986
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
| 1980 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1978 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1981 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1979 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1982 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1980 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 1983 |
ON DELETE SET NULL ON UPDATE SET NULL |
1981 |
ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
1982 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
| 1983 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1984 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1984 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1985 |
|
1985 |
|
| 1986 |
-- |
1986 |
-- |
| 1987 |
- |
|
|