|
Lines 1791-1799
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
| 1791 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
1791 |
CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) |
| 1792 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1792 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1793 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1793 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1794 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1794 |
ON DELETE SET NULL ON UPDATE SET NULL |
| 1795 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
|
|
| 1796 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1797 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1795 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1798 |
|
1796 |
|
| 1799 |
-- |
1797 |
-- |
|
Lines 1872-1877
CREATE TABLE `patronimage` ( -- information related to patron images
Link Here
|
| 1872 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1870 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1873 |
|
1871 |
|
| 1874 |
-- |
1872 |
-- |
|
|
1873 |
-- Table structure for table hold_group |
| 1874 |
-- |
| 1875 |
|
| 1876 |
DROP TABLE IF EXISTS `hold_group`; |
| 1877 |
CREATE TABLE `hold_group` ( |
| 1878 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1879 |
PRIMARY KEY(`hold_group_id`) |
| 1880 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1881 |
|
| 1882 |
-- |
| 1875 |
-- Table structure for table `reserves` |
1883 |
-- Table structure for table `reserves` |
| 1876 |
-- |
1884 |
-- |
| 1877 |
|
1885 |
|
|
Lines 1913-1928
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
| 1913 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1921 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1914 |
|
1922 |
|
| 1915 |
-- |
1923 |
-- |
| 1916 |
-- Table structure for table hold_group |
|
|
| 1917 |
-- |
| 1918 |
|
| 1919 |
DROP TABLE IF EXISTS `hold_group`; |
| 1920 |
CREATE TABLE `hold_group` ( |
| 1921 |
`hold_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 1922 |
PRIMARY KEY(`hold_group_id`) |
| 1923 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1924 |
|
| 1925 |
-- |
| 1926 |
-- Table structure for table `old_reserves` |
1924 |
-- Table structure for table `old_reserves` |
| 1927 |
-- |
1925 |
-- |
| 1928 |
|
1926 |
|
|
Lines 1961-1967
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
| 1961 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1959 |
CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 1962 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1960 |
ON DELETE SET NULL ON UPDATE SET NULL, |
| 1963 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1961 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
| 1964 |
ON DELETE SET NULL ON UPDATE SET NULL |
1962 |
ON DELETE SET NULL ON UPDATE SET NULL, |
|
|
1963 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) |
| 1964 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 1965 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1965 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1966 |
|
1966 |
|
| 1967 |
-- |
1967 |
-- |
| 1968 |
- |
|
|