Lines 1279-1284
CREATE TABLE `borrower_modifications` (
Link Here
|
1279 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1279 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1280 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1280 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1281 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1281 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1282 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1282 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1283 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1283 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1285 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
Lines 1398-1403
CREATE TABLE `borrowers` (
Link Here
|
1398 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1399 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1399 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1400 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1400 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
1401 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
1402 |
`pronouns` longtext COLLATE utfmb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
1401 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1403 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1402 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1404 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1403 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
1405 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
Lines 2534-2539
CREATE TABLE `deletedborrowers` (
Link Here
|
2534 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2536 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2535 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2537 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2536 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2538 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
2539 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
2537 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2540 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2538 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2541 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2539 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2542 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2540 |
- |
|
|