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

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

Revision: 3708
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3708&view=rev
Author:   tim_schofield
Date:     2010-09-06 10:18:00 +0000 (Mon, 06 Sep 2010)

Log Message:
-----------
Change syntax to work in both windows and linux

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-09-06 07:15:20 UTC (rev 3707)
+++ trunk/doc/Change.log.html	2010-09-06 10:18:00 UTC (rev 3708)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>06/09/10 Tim: upgrade3.11.1-3.12.sql - Change syntax to work in both windows and linux</p>
 <p>06/09/10 Tim: SupplierInvoice.php - Correct the roundings so that the double entry balances</p>
 <p>05/09/10 Tim: PO_AuthoriseMyOrders.php - Update correct status when language not English</p>
 <p>05/09/10 Tim: PcAssignCashToTab.php - Show authorised, notes, and receipt fields correctly. Changed to use DB_fetch_array() rather than DB_fetch_row().</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-09-06 07:15:20 UTC (rev 3707)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-09-06 10:18:00 UTC (rev 3708)
@@ -41,7 +41,7 @@
 ALTER TABLE `purchorders` ADD COLUMN `tel` varchar(15) NOT NULL DEFAULT '' AFTER deladd6;
 ALTER TABLE `purchorders` ADD COLUMN `port` varchar(40) NOT NULL DEFAULT '' ;
 
-ALTER TABLE `suppliers` DROP FOREIGN KEY `suppliers_ibfk_4`;
+ALTER TABLE `suppliers` DROP KEY `suppliers_ibfk_4`;
 UPDATE `suppliers` SET `factorcompanyid`=0 WHERE `factorcompanyid`=1;
 DELETE FROM `factorcompanies` WHERE `coyname`='None';
 


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