[Koha-patches] [PATCH] Bug 6716: Update borrowers tables altaddress definiton
Nicole C. Engard
nengard at bywatersolutions.com
Wed Sep 5 21:14:49 CEST 2012
The comment on the altcontactaddress3 said it was the 3rd address line
but in reality it was the city. This fixes the documentation of
that field
---
installer/data/mysql/kohastructure.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 91d42a2..e1ef469 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -256,7 +256,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower
- `altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower
+ `altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
@@ -727,7 +727,7 @@ CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower
- `altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower
+ `altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower
--
1.7.2.3
More information about the Koha-patches
mailing list