Lines 3011-3017
CREATE TABLE `issues` (
Link Here
|
3011 |
`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', |
3011 |
`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', |
3012 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3012 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3013 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3013 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3014 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3014 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3015 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3015 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3016 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3016 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3017 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3017 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
Lines 3910-3916
CREATE TABLE `old_issues` (
Link Here
|
3910 |
`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', |
3910 |
`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', |
3911 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3911 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3912 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3912 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3913 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3913 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3914 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3914 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3915 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3915 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3916 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3916 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |