Lines 1635-1642
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1635 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1635 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1636 |
PRIMARY KEY (`issue_id`), |
1636 |
PRIMARY KEY (`issue_id`), |
1637 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1637 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1638 |
KEY `issuesborridx` (`borrowernumber`), |
|
|
1639 |
KEY `itemnumber_idx` (`itemnumber`), |
1640 |
KEY `branchcode_idx` (`branchcode`), |
1638 |
KEY `branchcode_idx` (`branchcode`), |
1641 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
1639 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
1642 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE, |
1640 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE, |
Lines 1666-1672
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1666 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1664 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1667 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1665 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1668 |
PRIMARY KEY (`issue_id`), |
1666 |
PRIMARY KEY (`issue_id`), |
1669 |
KEY `old_issuesborridx` (`borrowernumber`), |
|
|
1670 |
KEY `old_issuesitemidx` (`itemnumber`), |
1667 |
KEY `old_issuesitemidx` (`itemnumber`), |
1671 |
KEY `branchcode_idx` (`branchcode`), |
1668 |
KEY `branchcode_idx` (`branchcode`), |
1672 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |
1669 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |
1673 |
- |
|
|