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 ');
|