|
Lines 4953-5003
CREATE TABLE `old_reserves` (
Link Here
|
| 4953 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4953 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4954 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4954 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4955 |
|
4955 |
|
| 4956 |
-- |
|
|
| 4957 |
-- Table structure for table `overduerules` |
| 4958 |
-- |
| 4959 |
|
| 4960 |
DROP TABLE IF EXISTS `overduerules`; |
| 4961 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 4962 |
/*!40101 SET character_set_client = utf8 */; |
| 4963 |
CREATE TABLE `overduerules` ( |
| 4964 |
`overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', |
| 4965 |
`branchcode` varchar(10) NOT NULL DEFAULT '' 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) NOT NULL DEFAULT '' 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', |
| 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)', |
| 4970 |
`delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent', |
| 4971 |
`debarred2` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)', |
| 4972 |
`letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice', |
| 4973 |
`delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent', |
| 4974 |
`letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice', |
| 4975 |
`debarred3` int(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)', |
| 4976 |
PRIMARY KEY (`overduerules_id`), |
| 4977 |
UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`) |
| 4978 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4979 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4980 |
|
| 4981 |
-- |
| 4982 |
-- Table structure for table `overduerules_transport_types` |
| 4983 |
-- |
| 4984 |
|
| 4985 |
DROP TABLE IF EXISTS `overduerules_transport_types`; |
| 4986 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 4987 |
/*!40101 SET character_set_client = utf8 */; |
| 4988 |
CREATE TABLE `overduerules_transport_types` ( |
| 4989 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 4990 |
`letternumber` int(1) NOT NULL DEFAULT 1, |
| 4991 |
`message_transport_type` varchar(20) NOT NULL DEFAULT 'email', |
| 4992 |
`overduerules_id` int(11) NOT NULL, |
| 4993 |
PRIMARY KEY (`id`), |
| 4994 |
KEY `overduerules_fk` (`overduerules_id`), |
| 4995 |
KEY `mtt_fk` (`message_transport_type`), |
| 4996 |
CONSTRAINT `mtt_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 4997 |
CONSTRAINT `overduerules_fk` FOREIGN KEY (`overduerules_id`) REFERENCES `overduerules` (`overduerules_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4998 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4999 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5000 |
|
| 5001 |
-- |
4956 |
-- |
| 5002 |
-- Table structure for table `patron_consent` |
4957 |
-- Table structure for table `patron_consent` |
| 5003 |
-- |
4958 |
-- |
| 5004 |
- |
|
|