|
Lines 1272-1277
CREATE TABLE `borrower_modifications` (
Link Here
|
| 1272 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1272 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1273 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1273 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1274 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1274 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
1275 |
`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1275 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1276 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1276 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1277 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1277 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1278 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
Lines 1390-1395
CREATE TABLE `borrowers` (
Link Here
|
| 1390 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1391 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 1391 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1392 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 1392 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1393 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
1394 |
`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1393 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1395 |
`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', |
1396 |
`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', |
1397 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
|
Lines 2403-2408
CREATE TABLE `deletedborrowers` (
Link Here
|
| 2403 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2405 |
`cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 2404 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2406 |
`surname` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 2405 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2407 |
`firstname` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
2408 |
`middle_name` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 2406 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2409 |
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 2407 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2410 |
`othernames` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
| 2408 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
2411 |
`initials` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'initials for your patron/borrower', |
| 2409 |
- |
|
|