Lines 1144-1149
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1144 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1144 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1145 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1145 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1146 |
PRIMARY KEY (`issue_id`), |
1146 |
PRIMARY KEY (`issue_id`), |
|
|
1147 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
1147 |
KEY `issuesborridx` (`borrowernumber`), |
1148 |
KEY `issuesborridx` (`borrowernumber`), |
1148 |
KEY `itemnumber_idx` (`itemnumber`), |
1149 |
KEY `itemnumber_idx` (`itemnumber`), |
1149 |
KEY `branchcode_idx` (`branchcode`), |
1150 |
KEY `branchcode_idx` (`branchcode`), |