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

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

Revision: 3679
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3679&view=rev
Author:   tim_schofield
Date:     2010-07-28 14:02:38 +0000 (Wed, 28 Jul 2010)

Log Message:
-----------
Change locatransfers table so that recd quantity on bulk stock transfers is a double field not integer

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-07-28 13:32:33 UTC (rev 3678)
+++ trunk/doc/Change.log.html	2010-07-28 14:02:38 UTC (rev 3679)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>28/07/10 Simon Peter Otandeka: Change locatransfers table so that recd quantity on bulk stock transfers is a double field not integer</p>
 <p>28/07/10 Tim: class.pdf.php - Ensure ellipse() method has compatible declaration with ancestor class</p>
 <p>28/07/10 Tim: class.pdf.php - Ensure line() method has compatible declaration with ancestor class</p>
 <p>26/07/10 Tim: PDFGrn.php - Sql quoting corrections, bug fixes</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-07-28 13:32:33 UTC (rev 3678)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-07-28 14:02:38 UTC (rev 3679)
@@ -282,4 +282,6 @@
 UPDATE `securitytokens` SET `tokenname`='Prices Security' WHERE tokenid=12;
 
 ALTER TABLE `www_users` CHANGE `supplierid` `supplierid` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
-ALTER TABLE `orderdeliverydifferenceslog` DROP PRIMARY KEY;
\ No newline at end of file
+ALTER TABLE `orderdeliverydifferenceslog` DROP PRIMARY KEY;
+
+ALTER TABLE `loctransfers` CHANGE COLUMN `recqty` `recqty` double NOT NULL DEFAULT 0.0;
\ No newline at end of file


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