View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 6716