[Web-erp-svn] SF.net SVN: web-erp:[7963] trunk

[<tu...@us...>]

Revision: 7963
          http://sourceforge.net/p/web-erp/reponame/7963
Author:   turbopt
Date:     2018-02-16 07:19:54 +0000 (Fri, 16 Feb 2018)
Log Message:
-----------
PaulT: upgrade4.14.1-4.14.2.sql: Add SQL update to support commit 7961.

Modified Paths:
--------------
    trunk/doc/Change.log
    trunk/sql/mysql/upgrade4.14.1-4.14.2.sql

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2018-02-16 07:11:14 UTC (rev 7962)
+++ trunk/doc/Change.log	2018-02-16 07:19:54 UTC (rev 7963)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+16/2/18  PaulT: upgrade4.14.1-4.14.2.sql: Add SQL update to support commit 7961.
 16/2/18  Paul Becker (PaulT commit): AgedControlledInventory.php: Add UOM to output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8091&pid=14286#pid14286)
 16/2/18  Paul Becker (PaulT commit): Z_ChangeSalesmanCode.php: New script to change a salesman code. (Forum contribution: http://www.weberp.org/forum/showthread.php?tid=8094)
 13/2/18  Paul Becker (PaulT commit): InternalStockRequestFulfill.php: Minor change to remove number from input field committed with 7946, and add attributes on two input fields. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8089&pid=14266#pid14266)

Modified: trunk/sql/mysql/upgrade4.14.1-4.14.2.sql
===================================================================
--- trunk/sql/mysql/upgrade4.14.1-4.14.2.sql	2018-02-16 07:11:14 UTC (rev 7962)
+++ trunk/sql/mysql/upgrade4.14.1-4.14.2.sql	2018-02-16 07:19:54 UTC (rev 7963)
@@ -119,5 +119,7 @@
            JOIN pickinglists ON pickinglistdetails.pickinglistno = pickinglists.pickinglistno
            JOIN salesorderdetails ON salesorderdetails.orderno = pickinglists.orderno;
 
+INSERT INTO `scripts` ( `script` , `pagesecurity` , `description` ) VALUES ('Z_ChangeSalesmanCode.php', '15', '');
+
 UPDATE config SET confvalue='4.15' WHERE confname='VersionNumber';