Lines 3022-3028
CREATE TABLE `issues` (
Link Here
|
3022 |
`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', |
3022 |
`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', |
3023 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3023 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3024 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3024 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3025 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3025 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3026 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3026 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3027 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3027 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3028 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3028 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
Lines 3921-3927
CREATE TABLE `old_issues` (
Link Here
|
3921 |
`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', |
3921 |
`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', |
3922 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3922 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned', |
3923 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3923 |
`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed', |
3924 |
`renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3924 |
`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed', |
3925 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3925 |
`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen', |
3926 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3926 |
`auto_renew` tinyint(1) DEFAULT 0 COMMENT 'automatic renewal', |
3927 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |
3927 |
`auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'automatic renewal error', |