Lines 1638-1644
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1638 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1638 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1639 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1639 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1640 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1640 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1641 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1641 |
`checkout_type` ENUM('CHECKOUT', 'ONSITE') NOT NULL default 'CHECKOUT', -- checkout type |
1642 |
`note` LONGTEXT default NULL, -- issue note text |
1642 |
`note` LONGTEXT default NULL, -- issue note text |
1643 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1643 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1644 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1644 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
Lines 1670-1676
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1670 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1670 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1671 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1671 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1672 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1672 |
`issuedate` datetime default NULL, -- date the item was checked out or issued |
1673 |
`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag |
1673 |
`checkout_type` ENUM('CHECKOUT', 'ONSITE') NOT NULL default 'CHECKOUT', -- checkout type |
1674 |
`note` LONGTEXT default NULL, -- issue note text |
1674 |
`note` LONGTEXT default NULL, -- issue note text |
1675 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1675 |
`notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) |
1676 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1676 |
`noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null |
1677 |
- |
|
|