From 213e0bc6bc26a40cd8a29daf997a9c46b1f10ce1 Mon Sep 17 00:00:00 2001
From: Falko Timme <ft@falkotimme.com>
Date: Wed, 30 Oct 2013 08:36:43 -0400
Subject: [PATCH] - Company ID can now have a length of up to 255 characters (instead of just 30).

---
 install/sql/ispconfig3.sql                 |    2 +-
 interface/web/client/form/client.tform.php |    2 +-
 install/sql/incremental/upd_0059.sql       |    1 +
 3 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/install/sql/incremental/upd_0059.sql b/install/sql/incremental/upd_0059.sql
new file mode 100644
index 0000000..247bb47
--- /dev/null
+++ b/install/sql/incremental/upd_0059.sql
@@ -0,0 +1 @@
+ALTER TABLE `client` CHANGE `company_id` `company_id` VARCHAR( 255 ) NULL DEFAULT NULL ;
\ No newline at end of file
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 24a0a98..565db7e 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -144,7 +144,7 @@
   `sys_perm_group` varchar(5) DEFAULT NULL,
   `sys_perm_other` varchar(5) DEFAULT NULL,
   `company_name` varchar(64) DEFAULT NULL,
-  `company_id` varchar(30) DEFAULT NULL,
+  `company_id` varchar(255) DEFAULT NULL,
   `gender` enum('','m','f') NOT NULL DEFAULT '',
   `contact_name` varchar(64) DEFAULT NULL,
   `customer_no` varchar(64) DEFAULT NULL,
diff --git a/interface/web/client/form/client.tform.php b/interface/web/client/form/client.tform.php
index 0362480..37d51bd 100644
--- a/interface/web/client/form/client.tform.php
+++ b/interface/web/client/form/client.tform.php
@@ -356,7 +356,7 @@
 			'value'		=> '',
 			'separator'	=> '',
 			'width'		=> '30',
-			'maxlength'	=> '20',
+			'maxlength'	=> '255',
 			'rows'		=> '',
 			'cols'		=> ''
 		),

--
Gitblit v1.9.1