Lines 1676-1681
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1676 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1676 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1677 |
`constrainttype` varchar(1) default NULL, |
1677 |
`constrainttype` varchar(1) default NULL, |
1678 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1678 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
|
|
1679 |
`deskcode` varchar(10) default NULL, -- foreign key from the desks table defining which desk the patron may pick this hold up from |
1679 |
`notificationdate` date default NULL, -- currently unused |
1680 |
`notificationdate` date default NULL, -- currently unused |
1680 |
`reminderdate` date default NULL, -- currently unused |
1681 |
`reminderdate` date default NULL, -- currently unused |
1681 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1682 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
Lines 1863-1868
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1863 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1864 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1864 |
`constrainttype` varchar(1) default NULL, |
1865 |
`constrainttype` varchar(1) default NULL, |
1865 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1866 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
|
|
1867 |
`deskcode` varchar(10) default NULL, -- foreign key from the desks table defining which desk the patron may pick this hold up from |
1866 |
`notificationdate` date default NULL, -- currently unused |
1868 |
`notificationdate` date default NULL, -- currently unused |
1867 |
`reminderdate` date default NULL, -- currently unused |
1869 |
`reminderdate` date default NULL, -- currently unused |
1868 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1870 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
Lines 1882-1891
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1882 |
KEY `biblionumber` (`biblionumber`), |
1884 |
KEY `biblionumber` (`biblionumber`), |
1883 |
KEY `itemnumber` (`itemnumber`), |
1885 |
KEY `itemnumber` (`itemnumber`), |
1884 |
KEY `branchcode` (`branchcode`), |
1886 |
KEY `branchcode` (`branchcode`), |
|
|
1887 |
KEY `deskcode` (`deskcode`), |
1885 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1888 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1886 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1889 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1887 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1890 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1888 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
1891 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
1892 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`deskcode`) REFERENCES `desks` (`deskcode`) ON DELETE CASCADE ON UPDATE CASCADE |
1889 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1893 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1890 |
|
1894 |
|
1891 |
-- |
1895 |
-- |