|
Lines 1244-1249
CREATE TABLE `borrower_modifications` (
Link Here
|
| 1244 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1244 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1245 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1245 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1246 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1246 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1247 |
`preferredname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 1247 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1248 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1248 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1249 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1249 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1250 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
Lines 1362-1367
CREATE TABLE `borrowers` (
Link Here
|
| 1362 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1363 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 1363 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1364 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 1364 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1365 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
1366 |
`preferredname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 1365 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1367 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 1366 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1368 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
| 1367 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
1369 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
Lines 2369-2374
CREATE TABLE `deletedborrowers` (
Link Here
|
| 2369 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2371 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 2370 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2372 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 2371 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2373 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
2374 |
`preferredname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 2372 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2375 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 2373 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2376 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
| 2374 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2377 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |