Lines 1704-1710
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1704 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1704 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1705 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1705 |
CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
1706 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1706 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1707 |
CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) |
1707 |
CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`), |
|
|
1708 |
CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) |
1708 |
ON DELETE SET NULL ON UPDATE CASCADE |
1709 |
ON DELETE SET NULL ON UPDATE CASCADE |
1709 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1710 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1710 |
|
1711 |
|
Lines 1813-1818
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1813 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1814 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1814 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1815 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1815 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0, -- Is this a non priority hold |
1816 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0, -- Is this a non priority hold |
|
|
1817 |
`reserve_group_id` int unsigned NULL DEFAULT NULL, -- Id used on reservations spanning multiple titles |
1816 |
PRIMARY KEY (`reserve_id`), |
1818 |
PRIMARY KEY (`reserve_id`), |
1817 |
KEY priorityfoundidx (priority,found), |
1819 |
KEY priorityfoundidx (priority,found), |
1818 |
KEY `borrowernumber` (`borrowernumber`), |
1820 |
KEY `borrowernumber` (`borrowernumber`), |
Lines 1826-1832
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1826 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1828 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1827 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1829 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1828 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
1830 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
1829 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE |
1831 |
CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
1832 |
CONSTRAINT `reserves_ibfk_7` FOREIGN KEY (`reserve_group_id`) REFERENCES `reserve_group` (`reserve_group_id`) ON DELETE SET NULL ON UPDATE CASCADE |
1833 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1834 |
|
1835 |
-- |
1836 |
-- Table structure for table reserve_group |
1837 |
-- |
1838 |
|
1839 |
DROP TABLE IF EXISTS `reserve_group`; |
1840 |
CREATE TABLE `reserve_group` ( |
1841 |
`reserve_group_id` int unsigned NOT NULL AUTO_INCREMENT, |
1842 |
PRIMARY KEY(`reserve_group_id`) |
1830 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1843 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1831 |
|
1844 |
|
1832 |
-- |
1845 |
-- |
Lines 1858-1863
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1858 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1871 |
`itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting |
1859 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1872 |
`item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level |
1860 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0, -- Is this a non priority hold |
1873 |
`non_priority` tinyint(1) NOT NULL DEFAULT 0, -- Is this a non priority hold |
|
|
1874 |
`reserve_group_id` int unsigned NULL DEFAULT NULL, -- The id of a group of titles reservations fulfilled when one title is picked |
1861 |
PRIMARY KEY (`reserve_id`), |
1875 |
PRIMARY KEY (`reserve_id`), |
1862 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1876 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1863 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1877 |
KEY `old_reserves_biblionumber` (`biblionumber`), |