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

[<lin...@us...>]

Revision: 3427
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3427&view=rev
Author:   lindsayh
Date:     2010-04-22 06:47:07 +0000 (Thu, 22 Apr 2010)

Log Message:
-----------
Add a missing semi colon from the second last line of the upgrade3.11.1-3.12.sql
script. which, surprisingly, fixes a syntax error.

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-04-21 19:50:15 UTC (rev 3426)
+++ trunk/doc/Change.log.html	2010-04-22 06:47:07 UTC (rev 3427)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>22/04/10 Lindsay: add missing ; to second last line of upgrade3.11.1-3.12.sql</p>
 <p>21/04/10 Matt Taylor: Z_ImportStocks.php : Fix bug in checking of perishable field.</p>
 <p>18/04/10 Ricard: InventoryPlanning.php - Remove discontinued items from inventory planning reports.</p>
 <p>15/04/10 Kalmer Piiskop: MiscFunctions.js - Update IsDAte() function for all date formats.</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-04-21 19:50:15 UTC (rev 3426)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-04-22 06:47:07 UTC (rev 3427)
@@ -132,6 +132,6 @@
 
 INSERT INTO `config` (`confname`, `confvalue`) VALUES ('RequirePickingNote',0);
 
-ALTER TABLE `prices` ADD `startdate` DATE NOT NULL , ADD `enddate` DATE NOT NULL DEFAULT '9999-12-31' 
+ALTER TABLE `prices` ADD `startdate` DATE NOT NULL , ADD `enddate` DATE NOT NULL DEFAULT '9999-12-31';
 ALTER TABLE prices DROP PRIMARY KEY ,
 ADD PRIMARY KEY ( `stockid` , `typeabbrev` , `currabrev` , `debtorno` , `startdate` , `enddate` ) ;


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