[Web-erp-svn] SF.net SVN: web-erp:[7486] trunk/sql/mysql/upgrade4.12.3-4.13.sql

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

Revision: 7486
          http://sourceforge.net/p/web-erp/reponame/7486
Author:   exsonqu
Date:     2016-04-07 06:40:58 +0000 (Thu, 07 Apr 2016)
Log Message:
-----------
07/04/16 Exson: add sql of multiple assigner and authority of Pc module.

Modified Paths:
--------------
    trunk/sql/mysql/upgrade4.12.3-4.13.sql

Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql	2016-04-07 06:35:44 UTC (rev 7485)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql	2016-04-07 06:40:58 UTC (rev 7486)
@@ -51,7 +51,9 @@
 INSERT INTO scripts VALUES('CollectiveWorkOrderCost.php',2,'Multiple work orders cost review');
 ALTER table bom ADD remark varchar(500) NOT NULL DEFAULT '';
 INSERT INTO scripts VALUES ('SuppWhereAlloc.php',3,'Suppliers Where allocated');
+ALTER table pctabs DROP FOREIGN KEY `pctabs_ibfk_4`;
+ALTER table pctabs CHANGE authorizer authorizer varchar(100);
+ALTER table pctabs CHANGE assigner assigner varchar(100);
 
-
 -- Update version number:
 UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';