Lines 3986-3995
CREATE TABLE `issues` (
Link Here
|
3986 |
`auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error', |
3986 |
`auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error', |
3987 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched', |
3987 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched', |
3988 |
`issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued', |
3988 |
`issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued', |
3989 |
`onsite_checkout` int(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag', |
3989 |
`onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag', |
3990 |
`note` longtext DEFAULT NULL COMMENT 'issue note text', |
3990 |
`note` longtext DEFAULT NULL COMMENT 'issue note text', |
3991 |
`notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)', |
3991 |
`notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)', |
3992 |
`noteseen` int(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null', |
3992 |
`noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null', |
3993 |
PRIMARY KEY (`issue_id`), |
3993 |
PRIMARY KEY (`issue_id`), |
3994 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3994 |
UNIQUE KEY `itemnumber` (`itemnumber`), |
3995 |
KEY `issuesborridx` (`borrowernumber`), |
3995 |
KEY `issuesborridx` (`borrowernumber`), |
Lines 5041-5050
CREATE TABLE `old_issues` (
Link Here
|
5041 |
`auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error', |
5041 |
`auto_renew_error` varchar(32) DEFAULT NULL COMMENT 'automatic renewal error', |
5042 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched', |
5042 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this record was last touched', |
5043 |
`issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued', |
5043 |
`issuedate` datetime DEFAULT NULL COMMENT 'date the item was checked out or issued', |
5044 |
`onsite_checkout` int(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag', |
5044 |
`onsite_checkout` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'in house use flag', |
5045 |
`note` longtext DEFAULT NULL COMMENT 'issue note text', |
5045 |
`note` longtext DEFAULT NULL COMMENT 'issue note text', |
5046 |
`notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)', |
5046 |
`notedate` datetime DEFAULT NULL COMMENT 'datetime of issue note (yyyy-mm-dd hh:mm::ss)', |
5047 |
`noteseen` int(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null', |
5047 |
`noteseen` tinyint(1) DEFAULT NULL COMMENT 'describes whether checkout note has been seen 1, not been seen 0 or doesn''t exist null', |
5048 |
PRIMARY KEY (`issue_id`), |
5048 |
PRIMARY KEY (`issue_id`), |
5049 |
KEY `old_issuesborridx` (`borrowernumber`), |
5049 |
KEY `old_issuesborridx` (`borrowernumber`), |
5050 |
KEY `old_issuesitemidx` (`itemnumber`), |
5050 |
KEY `old_issuesitemidx` (`itemnumber`), |
Lines 5120-5132
CREATE TABLE `overduerules` (
Link Here
|
5120 |
`categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for', |
5120 |
`categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for', |
5121 |
`delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent', |
5121 |
`delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent', |
5122 |
`letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice', |
5122 |
`letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice', |
5123 |
`debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)', |
5123 |
`debarred1` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)', |
5124 |
`delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent', |
5124 |
`delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent', |
5125 |
`debarred2` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)', |
5125 |
`debarred2` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)', |
5126 |
`letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice', |
5126 |
`letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice', |
5127 |
`delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent', |
5127 |
`delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent', |
5128 |
`letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice', |
5128 |
`letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice', |
5129 |
`debarred3` int(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)', |
5129 |
`debarred3` tinyint(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)', |
5130 |
PRIMARY KEY (`overduerules_id`), |
5130 |
PRIMARY KEY (`overduerules_id`), |
5131 |
UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`) |
5131 |
UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`) |
5132 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5132 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5133 |
- |
|
|