Lines 1261-1266
CREATE TABLE `borrower_modifications` (
Link Here
|
1261 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1261 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1262 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1262 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1263 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1263 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1264 |
`preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1264 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1265 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1265 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1266 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1266 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1267 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
Lines 1379-1384
CREATE TABLE `borrowers` (
Link Here
|
1379 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1380 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1380 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1381 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1381 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1382 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
1383 |
`preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1382 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1384 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1383 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1385 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1384 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
1386 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
Lines 2387-2392
CREATE TABLE `deletedborrowers` (
Link Here
|
2387 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2389 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2388 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2390 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2389 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2391 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
2392 |
`preferred_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
2390 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2393 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2391 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2394 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2392 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2395 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |