|
Lines 1402-1407
CREATE TABLE `borrower_modifications` (
Link Here
|
| 1402 |
`surname` longtext DEFAULT NULL, |
1402 |
`surname` longtext DEFAULT NULL, |
| 1403 |
`firstname` mediumtext DEFAULT NULL, |
1403 |
`firstname` mediumtext DEFAULT NULL, |
| 1404 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1404 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
1405 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
| 1405 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1406 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1406 |
`title` longtext DEFAULT NULL, |
1407 |
`title` longtext DEFAULT NULL, |
| 1407 |
`othernames` longtext DEFAULT NULL, |
1408 |
`othernames` longtext DEFAULT NULL, |
|
Lines 1524-1529
CREATE TABLE `borrowers` (
Link Here
|
| 1524 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
1525 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 1525 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
1526 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
| 1526 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
1527 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
1528 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
| 1527 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
1529 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 1528 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
1530 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 1529 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
1531 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
|
Lines 2661-2666
CREATE TABLE `deletedborrowers` (
Link Here
|
| 2661 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
2663 |
`surname` longtext DEFAULT NULL COMMENT 'patron/borrower''s last name (surname)', |
| 2662 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
2664 |
`firstname` mediumtext DEFAULT NULL COMMENT 'patron/borrower''s first name', |
| 2663 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
2665 |
`preferred_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s preferred name', |
|
|
2666 |
`sort_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s name to be used for sorting', |
| 2664 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
2667 |
`middle_name` longtext DEFAULT NULL COMMENT 'patron/borrower''s middle name', |
| 2665 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
2668 |
`title` longtext DEFAULT NULL COMMENT 'patron/borrower''s title, for example: Mr. or Mrs.', |
| 2666 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |
2669 |
`othernames` longtext DEFAULT NULL COMMENT 'any other names associated with the patron/borrower', |