Lines 1393-1399
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1393 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1393 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1394 |
`reservenotes` mediumtext, -- notes related to this hold |
1394 |
`reservenotes` mediumtext, -- notes related to this hold |
1395 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1395 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1396 |
`found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed |
1396 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1397 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1397 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1398 |
`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 |
1398 |
`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 |
1399 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1399 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
Lines 1568-1574
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1568 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1568 |
`cancellationdate` date default NULL, -- the date this hold was cancelled |
1569 |
`reservenotes` mediumtext, -- notes related to this hold |
1569 |
`reservenotes` mediumtext, -- notes related to this hold |
1570 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1570 |
`priority` smallint(6) default NULL, -- where in the queue the patron sits |
1571 |
`found` varchar(1) default NULL, -- a one letter code defining what the the status is of the hold is after it has been confirmed |
1571 |
`found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed |
1572 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1572 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated |
1573 |
`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 |
1573 |
`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 |
1574 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1574 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |