[Web-erp-svn] SF.net SVN: web-erp:[6699] trunk

[<te...@us...>]

Revision: 6699
          http://sourceforge.net/p/web-erp/reponame/6699
Author:   tehonu
Date:     2014-04-26 03:49:49 +0000 (Sat, 26 Apr 2014)
Log Message:
-----------
Change consignment field to VARCHAR(20) as some carriers need 20 char for AWN

Modified Paths:
--------------
    trunk/ConfirmDispatch_Invoice.php
    trunk/sql/mysql/upgrade4.11-4.12.sql

Modified: trunk/ConfirmDispatch_Invoice.php
===================================================================
--- trunk/ConfirmDispatch_Invoice.php	2014-04-25 14:36:49 UTC (rev 6698)
+++ trunk/ConfirmDispatch_Invoice.php	2014-04-26 03:49:49 UTC (rev 6699)
@@ -1670,7 +1670,7 @@
 	$j++;
 	echo '<tr>
 			<td>' . _('Consignment Note Ref'). ':</td>
-			<td><input tabindex="'.$j.'" type="text" data-type="no-illegal-chars" title="' . _('Enter the consignment note reference to enable tracking of the delivery in the event of customer proof of delivery issues') . '" maxlength="15" size="15" name="Consignment" value="' . $_POST['Consignment'] . '" /></td>
+			<td><input tabindex="'.$j.'" type="text" data-type="no-illegal-chars" title="' . _('Enter the consignment note reference to enable tracking of the delivery in the event of customer proof of delivery issues') . '" maxlength="20" size="20" name="Consignment" value="' . $_POST['Consignment'] . '" /></td>
 		</tr>';
 	$j++;
 	echo '<tr>

Modified: trunk/sql/mysql/upgrade4.11-4.12.sql
===================================================================
--- trunk/sql/mysql/upgrade4.11-4.12.sql	2014-04-25 14:36:49 UTC (rev 6698)
+++ trunk/sql/mysql/upgrade4.11-4.12.sql	2014-04-26 03:49:49 UTC (rev 6699)
@@ -21,3 +21,5 @@
   CONSTRAINT ` custitem _ibfk_2` FOREIGN KEY (`debtorno`) REFERENCES `debtorsmaster` (`debtorno`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 UPDATE config SET confvalue='4.12' WHERE confname='VersionNumber';
+
+ALTER TABLE  `debtortrans` CHANGE  `consignment`  `consignment` VARCHAR( 20 ) NOT NULL DEFAULT  '';