[Web-erp-svn] SF.net SVN: web-erp:[7276] trunk/sql/mysql/upgrade4.11.3-4.11.4.sql

[<ex...@us...>]

Revision: 7276
          http://sourceforge.net/p/web-erp/reponame/7276
Author:   exsonqu
Date:     2015-04-26 02:43:50 +0000 (Sun, 26 Apr 2015)
Log Message:
-----------
26/04/15 Exson: Comment out the mrpparameters table update in sql file upgrade4.11.3-4.11.4.sql which made a misleading during upgrade and absolutely non-necessary.

Modified Paths:
--------------
    trunk/sql/mysql/upgrade4.11.3-4.11.4.sql

Modified: trunk/sql/mysql/upgrade4.11.3-4.11.4.sql
===================================================================
--- trunk/sql/mysql/upgrade4.11.3-4.11.4.sql	2015-04-26 02:39:34 UTC (rev 7275)
+++ trunk/sql/mysql/upgrade4.11.3-4.11.4.sql	2015-04-26 02:43:50 UTC (rev 7276)
@@ -75,7 +75,7 @@
 		AND locations.loccode = locationusers.loccode
         WHERE locationusers.userid IS NULL;
 
-ALTER TABLE  `mrpparameters` ADD  `userldemands` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'use RL requirements or not' AFTER  `usemrpdemands`;
+-- ALTER TABLE  `mrpparameters` ADD  `userldemands` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'use RL requirements or not' AFTER  `usemrpdemands`;
 
 INSERT INTO `scripts` ( `script` , `pagesecurity` , `description` ) VALUES ('WOCanBeProducedNow.php', '4', 'List of WO items that can be produced with available stock in location');
 INSERT INTO `scripts` ( `script` , `pagesecurity` , `description` ) VALUES ('PrintWOItemSlip.php', '4', 'PDF WO Item production Slip ');