Lines 1727-1733
CREATE TABLE `issues` ( -- information related to check outs or issues
Link Here
|
1727 |
`branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out |
1727 |
`branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out |
1728 |
`returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues |
1728 |
`returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues |
1729 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1729 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1730 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1730 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1731 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1731 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1732 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1732 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1733 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1733 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
Lines 1759-1765
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
Link Here
|
1759 |
`branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out |
1759 |
`branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out |
1760 |
`returndate` datetime default NULL, -- date the item was returned |
1760 |
`returndate` datetime default NULL, -- date the item was returned |
1761 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1761 |
`lastreneweddate` datetime default NULL, -- date the item was last renewed |
1762 |
`renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed |
1762 |
`renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed |
1763 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1763 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
1764 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1764 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error |
1765 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1765 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched |
1766 |
- |
|
|