|
Lines 1408-1413
CREATE TABLE `borrower_modifications` (
Link Here
|
| 1408 |
`cardnumber` varchar(32) DEFAULT NULL, |
1408 |
`cardnumber` varchar(32) DEFAULT NULL, |
| 1409 |
`surname` longtext DEFAULT NULL, |
1409 |
`surname` longtext DEFAULT NULL, |
| 1410 |
`firstname` mediumtext DEFAULT NULL, |
1410 |
`firstname` mediumtext DEFAULT NULL, |
|
|
1411 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 1411 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1412 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1412 |
`title` longtext DEFAULT NULL, |
1413 |
`title` longtext DEFAULT NULL, |
| 1413 |
`othernames` longtext DEFAULT NULL, |
1414 |
`othernames` longtext DEFAULT NULL, |
|
Lines 1529-1534
CREATE TABLE `borrowers` (
Link Here
|
| 1529 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
1530 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 1530 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1531 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 1531 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1532 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
1533 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 1532 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1534 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1533 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1535 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 1534 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1536 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
|
Lines 2664-2669
CREATE TABLE `deletedborrowers` (
Link Here
|
| 2664 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
2666 |
`cardnumber` varchar(32) DEFAULT NULL COMMENT 'unique key, library assigned ID number for patrons/borrowers', |
| 2665 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2667 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 2666 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2668 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
|
|
2669 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
| 2667 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
2670 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 2668 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2671 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 2669 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2672 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
| 2670 |
- |
|
|