Lines 1283-1288
CREATE TABLE `borrower_modifications` (
Link Here
|
1283 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1283 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1285 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1285 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1286 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1286 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1287 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1287 |
`password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1288 |
`password` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1288 |
`flags` int(11) DEFAULT NULL, |
1289 |
`flags` int(11) DEFAULT NULL, |
Lines 1399-1404
CREATE TABLE `borrowers` (
Link Here
|
1399 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
1400 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
1400 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
1401 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
1401 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
1402 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
|
|
1403 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
1402 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
1404 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
1403 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password', |
1405 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s Bcrypt encrypted password', |
1404 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
1406 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
Lines 2401-2406
CREATE TABLE `deletedborrowers` (
Link Here
|
2401 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
2403 |
`contactfirstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include first name of guarantor', |
2402 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
2404 |
`contacttitle` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include title (Mr., Mrs., etc) of guarantor', |
2403 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
2405 |
`borrowernotes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'a note on the patron/borrower''s account that is only visible in the staff interface', |
|
|
2406 |
`relationship` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'used for children to include the relationship to their guarantor', |
2404 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
2407 |
`sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s gender', |
2405 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password', |
2408 |
`password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s encrypted password', |
2406 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
2409 |
`flags` int(11) DEFAULT NULL COMMENT 'will include a number associated with the staff member''s permissions', |
2407 |
- |
|
|