Lines 1275-1280
CREATE TABLE `borrower_modifications` (
Link Here
|
1275 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1275 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1276 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1276 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1277 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1277 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1278 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1278 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1279 |
`streetnumber` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1279 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1280 |
`streettype` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1280 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1281 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
Lines 1393-1398
CREATE TABLE `borrowers` (
Link Here
|
1393 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1394 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1394 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1395 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1395 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
1396 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
1397 |
`pronouns` longtext COLLATE utfmb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
1396 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1398 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
1397 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1399 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
1398 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
1400 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
Lines 2405-2410
CREATE TABLE `deletedborrowers` (
Link Here
|
2405 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2407 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2406 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2408 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2407 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2409 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
|
2410 |
`pronouns` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower pronouns', |
2408 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2411 |
`streetnumber` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the house number for your patron/borrower''s primary address', |
2409 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2412 |
`streettype` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the street type (Rd., Blvd, etc) for your patron/borrower''s primary address', |
2410 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2413 |
`address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the first address line for your patron/borrower''s primary address', |
2411 |
- |
|
|