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

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

Revision: 4168
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4168&view=rev
Author:   tim_schofield
Date:     2010-11-26 11:23:53 +0000 (Fri, 26 Nov 2010)

Log Message:
-----------
Add default date for stockcheckdate field in stockcheckfreeze table

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

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-11-26 09:43:55 UTC (rev 4167)
+++ trunk/doc/Change.log.html	2010-11-26 11:23:53 UTC (rev 4168)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>26/11/10 Tim: upgrade3.11.1-4.00.sql - Add default date for stockcheckdate field in stockcheckfreeze table</p>
 <p>26/11/10 Otandeka: CounterSales.php - Fix bug in counter sales script.</p>
 <p>24/11/10 Phil: GoodsReceived.php - modified to insert fixedassettrans and to post nominal POs to fixed asset cost account from fixedassetcategories.costact</p>
 <p>23/11/10 Pak Ricard: MRP.php and MRPShortages.php fixed temporary tables to use utf-8 - code failed without probably depends on mysql server settings</p>

Modified: trunk/sql/mysql/upgrade3.11.1-4.00.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-4.00.sql	2010-11-26 09:43:55 UTC (rev 4167)
+++ trunk/sql/mysql/upgrade3.11.1-4.00.sql	2010-11-26 11:23:53 UTC (rev 4168)
@@ -493,4 +493,6 @@
 INDEX ( inputdate )
 ) ENGINE = InnoDB DEFAULT CHARSET = utf8;
 
+ALTER TABLE stockcheckfreeze CHANGE stockcheckdate stockcheckdate date NOT NULL DEFAULT '0000-00-00';
+
 UPDATE config SET confvalue='4.0-RC2' WHERE confname='VersionName';
\ No newline at end of file


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