|
Lines 4962-4969
DROP TABLE IF EXISTS `overduerules`;
Link Here
|
| 4962 |
/*!40101 SET character_set_client = utf8 */; |
4962 |
/*!40101 SET character_set_client = utf8 */; |
| 4963 |
CREATE TABLE `overduerules` ( |
4963 |
CREATE TABLE `overduerules` ( |
| 4964 |
`overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', |
4964 |
`overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', |
| 4965 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)', |
4965 |
`branchcode` varchar(10) NULL DEFAULT NULL COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)', |
| 4966 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'foreign key from the categories table to define which patron category this rule is for', |
4966 |
`categorycode` varchar(10) NULL DEFAULT NULL COMMENT 'foreign key from the categories table to define which patron category this rule is for', |
| 4967 |
`delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent', |
4967 |
`delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent', |
| 4968 |
`letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice', |
4968 |
`letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice', |
| 4969 |
`debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)', |
4969 |
`debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)', |
| 4970 |
- |
|
|