Lines 1159-1164
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1159 |
`return` varchar(4) default NULL, |
1159 |
`return` varchar(4) default NULL, |
1160 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1160 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1161 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1161 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
|
|
1162 |
`auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1162 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1163 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1163 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1164 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1164 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1165 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
Lines 1658-1663
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1658 |
`return` varchar(4) default NULL, |
1659 |
`return` varchar(4) default NULL, |
1659 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1660 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1660 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1661 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
|
|
1662 |
`auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1661 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1663 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1662 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1664 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1663 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1665 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1664 |
- |
|
|