Lines 1280-1285
CREATE TABLE `borrower_modifications` (
Link Here
|
1280 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1280 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1281 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1281 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1282 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1282 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1283 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1283 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1284 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1285 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1285 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1286 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
Lines 1399-1404
CREATE TABLE `borrowers` (
Link Here
|
1399 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1400 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1400 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1401 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1401 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
1402 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
1403 |
`pronouns` longtext COLLATE utfmb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
1402 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1404 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1403 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1405 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1404 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
1406 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
Lines 2544-2549
CREATE TABLE `deletedborrowers` (
Link Here
|
2544 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2546 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2545 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2547 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2546 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2548 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
2549 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
2547 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2550 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2548 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2551 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2549 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2552 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2550 |
- |
|
|