Lines 3006-3012
CREATE TABLE `issues` (
Link Here
|
3006 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3006 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3007 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3007 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3008 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3008 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3009 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3009 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3010 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3010 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3011 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3011 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3012 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3012 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
Lines 3905-3911
CREATE TABLE `old_issues` (
Link Here
|
3905 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3905 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3906 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3906 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3907 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3907 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3908 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3908 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3909 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3909 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3910 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3910 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3911 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3911 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |