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

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

Revision: 7404
          http://sourceforge.net/p/web-erp/reponame/7404
Author:   exsonqu
Date:     2015-11-30 22:51:04 +0000 (Mon, 30 Nov 2015)
Log Message:
-----------
01/12/15 Exson: Remove the wrong foreign key in suppinvstogrn. Reported by rafael.

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	2015-11-30 01:26:16 UTC (rev 7403)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql	2015-11-30 22:51:04 UTC (rev 7404)
@@ -52,6 +52,7 @@
 ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4`;
 
 INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)');
+ALTER table suppinvstogrn DROP FOREIGN  KEY `suppinvstogrn_ibfk_1`;
 
 -- Update version number:
 UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';