Lines 1757-1763
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1757 |
`reminderdate` date default NULL, -- currently unused |
1757 |
`reminderdate` date default NULL, -- currently unused |
1758 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1758 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1759 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1759 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1760 |
`priority` smallint(6) NOT NULL, -- where in the queue the patron sits |
1760 |
`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits |
1761 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1761 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1762 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1762 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1763 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
1763 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
Lines 1797-1803
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1797 |
`reminderdate` date default NULL, -- currently unused |
1797 |
`reminderdate` date default NULL, -- currently unused |
1798 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1798 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1799 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1799 |
`reservenotes` LONGTEXT, -- notes related to this hold |
1800 |
`priority` smallint(6) NOT NULL, -- where in the queue the patron sits |
1800 |
`priority` smallint(6) NOT NULL DEFAULT 1, -- where in the queue the patron sits |
1801 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1801 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1802 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1802 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1803 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
1803 |
`itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |