Lines 1670-1675
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1670 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1670 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1671 |
`constrainttype` varchar(1) default NULL, |
1671 |
`constrainttype` varchar(1) default NULL, |
1672 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1672 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
|
|
1673 |
`deskcode` varchar(10) default NULL, -- foreign key from the desks table defining which desk the patron may pick this hold up from |
1673 |
`notificationdate` date default NULL, -- currently unused |
1674 |
`notificationdate` date default NULL, -- currently unused |
1674 |
`reminderdate` date default NULL, -- currently unused |
1675 |
`reminderdate` date default NULL, -- currently unused |
1675 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1676 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
Lines 1857-1862
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1857 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1858 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1858 |
`constrainttype` varchar(1) default NULL, |
1859 |
`constrainttype` varchar(1) default NULL, |
1859 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1860 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
|
|
1861 |
`deskcode` varchar(10) default NULL, -- foreign key from the desks table defining which desk the patron may pick this hold up from |
1860 |
`notificationdate` date default NULL, -- currently unused |
1862 |
`notificationdate` date default NULL, -- currently unused |
1861 |
`reminderdate` date default NULL, -- currently unused |
1863 |
`reminderdate` date default NULL, -- currently unused |
1862 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1864 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
Lines 1876-1885
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1876 |
KEY `biblionumber` (`biblionumber`), |
1878 |
KEY `biblionumber` (`biblionumber`), |
1877 |
KEY `itemnumber` (`itemnumber`), |
1879 |
KEY `itemnumber` (`itemnumber`), |
1878 |
KEY `branchcode` (`branchcode`), |
1880 |
KEY `branchcode` (`branchcode`), |
|
|
1881 |
KEY `deskcode` (`deskcode`), |
1879 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1882 |
CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1880 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1883 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1881 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1884 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1882 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
1885 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
1886 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`deskcode`) REFERENCES `desks` (`deskcode`) ON DELETE CASCADE ON UPDATE CASCADE |
1883 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1887 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1884 |
|
1888 |
|
1885 |
-- |
1889 |
-- |