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

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

Revision: 3519
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3519&view=rev
Author:   tim_schofield
Date:     2010-06-24 16:42:16 +0000 (Thu, 24 Jun 2010)

Log Message:
-----------
upgrade3.11.1-3.12.sql - Add fields in salesorderfdetails table to enable new salesman commission program

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-06-24 11:15:00 UTC (rev 3518)
+++ trunk/doc/Change.log.html	2010-06-24 16:42:16 UTC (rev 3519)
@@ -1,6 +1,7 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
-<p>24/6/10 Phil: WOCosting.php fix to variances calculation were based on total quantity of the work order items required not the actual quantity of the work order items received as finished!!! Was correct when first released but has been wrong for several years</p>
+<p>24/06/10 Tim: upgrade3.11.1-3.12.sql - Add fields in salesorderfdetails table to enable new salesman commission program</p>
+<p>24/06/10 Phil: WOCosting.php fix to variances calculation were based on total quantity of the work order items required not the actual quantity of the work order items received as finished!!! Was correct when first released but has been wrong for several years</p>
 <p>24/06/10 Tim: Update SMTP server details from the UI rather than hard code into the scripts.</p>
 <p>23/06/10 Tim: View, accept, or reject any offers made.</p>
 <p>21/06/10 Pak Ricard: Z_ChangeStockCode.php - updated Z_ChangeStockCode.php as the last one broke due to the recent changes in contractBOM table (just changed the field name).</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-06-24 11:15:00 UTC (rev 3518)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-06-24 16:42:16 UTC (rev 3519)
@@ -264,3 +264,6 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 INSERT INTO emailsettings VALUES(Null, 'localhost', 25, 'helo', '', '', 5, '', 0);
+
+ALTER TABLE `salesorderdetails` ADD COLUMN `commissionrate` double NOT NULL DEFAULT 0.0;
+ALTER TABLE `salesorderdetails` ADD COLUMN `commissionearned` double NOT NULL DEFAULT 0.0;


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