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

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

Revision: 7359
          http://sourceforge.net/p/web-erp/reponame/7359
Author:   exsonqu
Date:     2015-09-23 13:53:26 +0000 (Wed, 23 Sep 2015)
Log Message:
-----------
23/09/2015 Tim: ADD invoice to grns mapping data in SupplierInvoice.php. 

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-09-23 13:53:01 UTC (rev 7358)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql	2015-09-23 13:53:26 UTC (rev 7359)
@@ -12,6 +12,16 @@
 	('AnalysisHorizontalIncome.php', '8', 'Shows the horizontal analysis of the statement of comprehensive income'),
 	('AnalysisHorizontalPosition.php', '8', 'Shows the horizontal analysis of the statement of financial position');
 
+CREATE TABLE `suppinvstogrn` (
+  `suppinv` int(11) NOT NULL,
+  `grnno` int(11) NOT NULL,
+  PRIMARY KEY (`suppinv`,`grnno`),
+  KEY `suppinvstogrn_ibfk_2` (`grnno`),
+  CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES
+`supptrans` (`id`),
+  CONSTRAINT `suppinvstogrn_ibfk_2` FOREIGN KEY (`grnno`) REFERENCES
+`grns` (`grnno`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- Update version number:
 UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';