Lines 1384-1389
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1384 |
-- |
1384 |
-- |
1385 |
DROP TABLE IF EXISTS `old_reserves`; |
1385 |
DROP TABLE IF EXISTS `old_reserves`; |
1386 |
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have been completed (either filled or cancelled) |
1386 |
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have been completed (either filled or cancelled) |
|
|
1387 |
`reservenumber` int(11) NOT NULL, |
1387 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for |
1388 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for |
1388 |
`reservedate` date default NULL, -- the date the hold was places |
1389 |
`reservedate` date default NULL, -- the date the hold was places |
1389 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
1390 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on |
Lines 1400-1405
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1400 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1401 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1401 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1402 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1402 |
`lowestPriority` tinyint(1) NOT NULL, |
1403 |
`lowestPriority` tinyint(1) NOT NULL, |
|
|
1404 |
PRIMARY KEY (`reservenumber`), |
1403 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1405 |
KEY `old_reserves_borrowernumber` (`borrowernumber`), |
1404 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1406 |
KEY `old_reserves_biblionumber` (`biblionumber`), |
1405 |
KEY `old_reserves_itemnumber` (`itemnumber`), |
1407 |
KEY `old_reserves_itemnumber` (`itemnumber`), |
Lines 1559-1564
CREATE TABLE `reserveconstraints` (
Link Here
|
1559 |
|
1561 |
|
1560 |
DROP TABLE IF EXISTS `reserves`; |
1562 |
DROP TABLE IF EXISTS `reserves`; |
1561 |
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha |
1563 |
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha |
|
|
1564 |
`reservenumber` int(11) NOT NULL AUTO_INCREMENT, |
1562 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1565 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1563 |
`reservedate` date default NULL, -- the date the hold was places |
1566 |
`reservedate` date default NULL, -- the date the hold was places |
1564 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1567 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
Lines 1575-1580
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1575 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1578 |
`waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library |
1576 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1579 |
`expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) |
1577 |
`lowestPriority` tinyint(1) NOT NULL, |
1580 |
`lowestPriority` tinyint(1) NOT NULL, |
|
|
1581 |
PRIMARY KEY (`reservenumber`), |
1578 |
KEY priorityfoundidx (priority,found), |
1582 |
KEY priorityfoundidx (priority,found), |
1579 |
KEY `borrowernumber` (`borrowernumber`), |
1583 |
KEY `borrowernumber` (`borrowernumber`), |
1580 |
KEY `biblionumber` (`biblionumber`), |
1584 |
KEY `biblionumber` (`biblionumber`), |