|
Lines 1274-1280
CREATE TABLE `borrower_modifications` (
Link Here
|
| 1274 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1274 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1275 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1275 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1276 |
`password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1276 |
`password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1277 |
`flags` int(11) DEFAULT NULL, |
|
|
| 1278 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1277 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1279 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1278 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1280 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1279 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
Lines 1392-1398
CREATE TABLE `borrowers` (
Link Here
|
| 1392 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
1391 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
| 1393 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
1392 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
| 1394 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password', |
1393 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password', |
| 1395 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
|
|
| 1396 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in', |
1394 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in', |
| 1397 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface', |
1395 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface', |
| 1398 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address', |
1396 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address', |
|
Lines 2399-2405
CREATE TABLE `deletedborrowers` (
Link Here
|
| 2399 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
2397 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
| 2400 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
2398 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
| 2401 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password', |
2399 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password', |
| 2402 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
|
|
| 2403 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in', |
2400 |
`userid` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s opac and/or staff interface log in', |
| 2404 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface', |
2401 |
`opacnote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is visible in the OPAC and staff interface', |
| 2405 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address', |
2402 |
`contactnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note related to the patron/borrower''s alternate address', |
|
Lines 4069-4079
DROP TABLE IF EXISTS `permissions`;
Link Here
|
| 4069 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4066 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 4070 |
/*!40101 SET character_set_client = utf8 */; |
4067 |
/*!40101 SET character_set_client = utf8 */; |
| 4071 |
CREATE TABLE `permissions` ( |
4068 |
CREATE TABLE `permissions` ( |
| 4072 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
4069 |
`parent` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, |
| 4073 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
4070 |
`code` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', |
| 4074 |
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4071 |
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, |
| 4075 |
PRIMARY KEY (`module_bit`,`code`), |
4072 |
PRIMARY KEY (`code`), |
| 4076 |
CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`) ON DELETE CASCADE ON UPDATE CASCADE |
4073 |
KEY `parent` (`parent`), |
|
|
4074 |
CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `permissions` (`code`) |
| 4077 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4075 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4078 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4076 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4079 |
|
4077 |
|
|
Lines 5158-5187
CREATE TABLE `uploaded_files` (
Link Here
|
| 5158 |
DROP TABLE IF EXISTS `user_permissions`; |
5156 |
DROP TABLE IF EXISTS `user_permissions`; |
| 5159 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5157 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5160 |
/*!40101 SET character_set_client = utf8 */; |
5158 |
/*!40101 SET character_set_client = utf8 */; |
|
|
5159 |
DROP TABLE IF EXISTS `user_permissions`; |
| 5161 |
CREATE TABLE `user_permissions` ( |
5160 |
CREATE TABLE `user_permissions` ( |
| 5162 |
`borrowernumber` int(11) NOT NULL DEFAULT 0, |
5161 |
`borrowernumber` int(11) NOT NULL DEFAULT '0', |
| 5163 |
`module_bit` int(11) NOT NULL DEFAULT 0, |
5162 |
`code` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, |
| 5164 |
`code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
| 5165 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
5163 |
KEY `user_permissions_ibfk_1` (`borrowernumber`), |
| 5166 |
KEY `user_permissions_ibfk_2` (`module_bit`,`code`), |
5164 |
KEY `user_permissions_ibfk_2` (`code`), |
| 5167 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5165 |
CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`code`) REFERENCES `permissions` (`code`), |
| 5168 |
CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`) ON DELETE CASCADE ON UPDATE CASCADE |
5166 |
CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 5169 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
|
|
| 5170 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5171 |
|
| 5172 |
-- |
| 5173 |
-- Table structure for table `userflags` |
| 5174 |
-- |
| 5175 |
|
| 5176 |
DROP TABLE IF EXISTS `userflags`; |
| 5177 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5178 |
/*!40101 SET character_set_client = utf8 */; |
| 5179 |
CREATE TABLE `userflags` ( |
| 5180 |
`bit` int(11) NOT NULL DEFAULT 0, |
| 5181 |
`flag` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 5182 |
`flagdesc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 5183 |
`defaulton` int(11) DEFAULT NULL, |
| 5184 |
PRIMARY KEY (`bit`) |
| 5185 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5167 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5186 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5168 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5187 |
|
5169 |
|
| 5188 |
- |
|
|