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', |