Lines 1742-1748
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1742 |
`return` varchar(4) default NULL, |
1742 |
`return` varchar(4) default NULL, |
1743 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1743 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1744 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1744 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1745 |
`auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1745 |
`auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1746 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1746 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1747 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1747 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1748 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1748 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
Lines 1772-1778
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1772 |
`return` varchar(4) default NULL, |
1772 |
`return` varchar(4) default NULL, |
1773 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1773 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1774 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1774 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1775 |
`auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1775 |
`auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error |
1776 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1776 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1777 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1777 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1778 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1778 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1779 |
- |
|
|