Lines 1652-1658
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1652 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for |
1652 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for |
1653 |
`reservedate` date default NULL, -- the date the hold was places |
1653 |
`reservedate` date default NULL, -- the date the hold was places |
1654 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1654 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1655 |
`constrainttype` varchar(1) default NULL, |
|
|
1656 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1655 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1657 |
`notificationdate` date default NULL, -- currently unused |
1656 |
`notificationdate` date default NULL, -- currently unused |
1658 |
`reminderdate` date default NULL, -- currently unused |
1657 |
`reminderdate` date default NULL, -- currently unused |
Lines 1817-1835
CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for
Link Here
|
1817 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1816 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1818 |
|
1817 |
|
1819 |
-- |
1818 |
-- |
1820 |
-- Table structure for table `reserveconstraints` |
|
|
1821 |
-- |
1822 |
|
1823 |
DROP TABLE IF EXISTS `reserveconstraints`; |
1824 |
CREATE TABLE `reserveconstraints` ( |
1825 |
`borrowernumber` int(11) NOT NULL default 0, |
1826 |
`reservedate` date default NULL, |
1827 |
`biblionumber` int(11) NOT NULL default 0, |
1828 |
`biblioitemnumber` int(11) default NULL, |
1829 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP |
1830 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1831 |
|
1832 |
-- |
1833 |
-- Table structure for table `reserves` |
1819 |
-- Table structure for table `reserves` |
1834 |
-- |
1820 |
-- |
1835 |
|
1821 |
|
Lines 1839-1845
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1839 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1825 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1840 |
`reservedate` date default NULL, -- the date the hold was places |
1826 |
`reservedate` date default NULL, -- the date the hold was places |
1841 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1827 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1842 |
`constrainttype` varchar(1) default NULL, |
|
|
1843 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1828 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1844 |
`notificationdate` date default NULL, -- currently unused |
1829 |
`notificationdate` date default NULL, -- currently unused |
1845 |
`reminderdate` date default NULL, -- currently unused |
1830 |
`reminderdate` date default NULL, -- currently unused |
1846 |
- |
|
|