[Weberp-cvs] SF.net SVN: web-erp:[3403] trunk

[<tim...@us...>]

Revision: 3403
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3403&view=rev
Author:   tim_schofield
Date:     2010-04-04 14:55:24 +0000 (Sun, 04 Apr 2010)

Log Message:
-----------
Tim: upgrade3.11.1-3.12.sql - Enlarge fieldname column in reportfields to 60 characters

Modified Paths:
--------------
    trunk/doc/Change.log.html
    trunk/sql/mysql/upgrade3.11.1-3.12.sql

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-04-04 08:40:48 UTC (rev 3402)
+++ trunk/doc/Change.log.html	2010-04-04 14:55:24 UTC (rev 3403)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>04/04/10 Tim: upgrade3.11.1-3.12.sql - Enlarge fieldname column in reportfields to 60 characters</p>
 <p>01/04/10 Harald: PDFSuppTransListing.php - Typing error in script title</p>
 <p>30/03/10 Tim: PrintCustStatements.php - Use new layout when all statements printed</p>
 <p>22/03/10 Tim: SelectCustomer.php - Remove extra '<' character</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-04-04 08:40:48 UTC (rev 3402)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-04-04 14:55:24 UTC (rev 3403)
@@ -126,4 +126,6 @@
   ADD COLUMN `inputdate` datetime NOT NULL AFTER `duedate` ;
 
 ALTER TABLE `debtortrans`
-  ADD COLUMN `inputdate` datetime NOT NULL AFTER `trandate` ;
\ No newline at end of file
+  ADD COLUMN `inputdate` datetime NOT NULL AFTER `trandate` ;
+
+AL>TER TABLE `reportfields` CHANGE COLUMN `fieldname` `fieldname` VARCHAR(60) NOT NULL DEFAULT '';
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.