This updates the database so the branchip field of the branches table is a 
mediumtext.  This will need to be added to the updatedatabase.pl.  I would but 
I don't want to end up stomping future database updates should this patch not 
be applied upstream.
---
 installer/data/Pg/kohastructure.sql    |    2 +-
 installer/data/mysql/kohastructure.sql |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/Pg/kohastructure.sql 
b/installer/data/Pg/kohastructure.sql
index 4d0b30a..226dd70 100644
--- a/installer/data/Pg/kohastructure.sql
+++ b/installer/data/Pg/kohastructure.sql
@@ -562,7 +562,7 @@ branchphone text,
 branchfax text,
 branchemail text,
 issuing int default NULL,
-branchip varchar(15) default NULL,
+branchip text default NULL,
 branchprinter varchar(100) default NULL
 );
 
diff --git a/installer/data/mysql/kohastructure.sql 
b/installer/data/mysql/kohastructure.sql
index 34970ee..992c2c8 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -578,7 +578,7 @@ CREATE TABLE `branches` (
   `branchfax` mediumtext,
   `branchemail` mediumtext,
   `issuing` tinyint(4) default NULL,
-  `branchip` varchar(15) default NULL,
+  `branchip` mediumtext default NULL,
   `branchprinter` varchar(100) default NULL,
   UNIQUE KEY `branchcode` (`branchcode`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
1.5.4.3

_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches

Reply via email to