Lines 1410-1415
CREATE TABLE `borrower_modifications` (
Link Here
|
1410 |
`surname` longtext DEFAULT NULL, |
1410 |
`surname` longtext DEFAULT NULL, |
1411 |
`firstname` mediumtext DEFAULT NULL, |
1411 |
`firstname` mediumtext DEFAULT NULL, |
1412 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1412 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
1413 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
1413 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1414 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1414 |
`title` longtext DEFAULT NULL, |
1415 |
`title` longtext DEFAULT NULL, |
1415 |
`othernames` longtext DEFAULT NULL, |
1416 |
`othernames` longtext DEFAULT NULL, |
Lines 1532-1537
CREATE TABLE `borrowers` (
Link Here
|
1532 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1533 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1533 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1534 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1534 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1535 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
1536 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
1535 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1537 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1536 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1538 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1537 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1539 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
Lines 2668-2673
CREATE TABLE `deletedborrowers` (
Link Here
|
2668 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2670 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2669 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2671 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2670 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
2672 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
2673 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
2671 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
2674 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
2672 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2675 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2673 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2676 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |