Lines 256-262
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
256 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
256 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
257 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
257 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
258 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
258 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
259 |
`altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower |
259 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
260 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
260 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
261 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
261 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
Lines 727-733
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
727 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
727 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
728 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
728 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
729 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
729 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
730 |
`altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower |
730 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
731 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
731 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
732 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
732 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
733 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
733 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
734 |
- |
|
|