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