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