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

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

Revision: 3145
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3145&view=rev
Author:   tim_schofield
Date:     2009-12-09 12:01:59 +0000 (Wed, 09 Dec 2009)

Log Message:
-----------
Correct inconsistency with area code field length in cogsglpostings table

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

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2009-12-06 21:22:16 UTC (rev 3144)
+++ trunk/doc/Change.log.html	2009-12-09 12:01:59 UTC (rev 3145)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p>
+<p>09/12/09 Pak Ricard: upgrade3.11-3.12.sql - Correct inconsistency with area code field length in cogsglpostings table
 <p>04/12/09 Tim: SpecialOrder.php -  Correction to produce sales order correctly
 <p>04/12/09 Tim: WriteForm.inc -  Change to make the file name have a default extension of pdf as per suggestion from Javier
 <p>04/12/09 Tim: WriteReport.inc -  Change to make the file name have a default extension of pdf as per suggestion from Javier

Modified: trunk/sql/mysql/upgrade3.11-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11-3.12.sql	2009-12-06 21:22:16 UTC (rev 3144)
+++ trunk/sql/mysql/upgrade3.11-3.12.sql	2009-12-09 12:01:59 UTC (rev 3145)
@@ -45,4 +45,6 @@
 DELETE FROM `factorcompanies` WHERE `coyname`='None';
 
 INSERT INTO  `config` (`confname`, `confvalue`) VALUES ('LogPath', '');
-INSERT INTO  `config` (`confname`, `confvalue`) VALUES ('LogSeverity', '0');
\ No newline at end of file
+INSERT INTO  `config` (`confname`, `confvalue`) VALUES ('LogSeverity', '0');
+
+ALTER TABLE `cogsglpostings` CHANGE `area` `area` CHAR( 3 ) NOT NULL;
\ No newline at end of file


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