From: <ex...@us...> - 2016-05-16 01:50:30
|
Revision: 7530 http://sourceforge.net/p/web-erp/reponame/7530 Author: exsonqu Date: 2016-05-16 01:50:27 +0000 (Mon, 16 May 2016) Log Message: ----------- 16/05/16 Exson: Remove extra comma to fix sql errors. Modified Paths: -------------- trunk/sql/mysql/country_sql/default.sql Modified: trunk/sql/mysql/country_sql/default.sql =================================================================== --- trunk/sql/mysql/country_sql/default.sql 2016-05-16 01:36:41 UTC (rev 7529) +++ trunk/sql/mysql/country_sql/default.sql 2016-05-16 01:50:27 UTC (rev 7530) @@ -2748,7 +2748,7 @@ KEY `loccode` (`loccode`), KEY `departmentid` (`departmentid`), CONSTRAINT `stockrequest_ibfk_1` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`), - CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`) REFERENCES `departments` (`departmentid`), + CONSTRAINT `stockrequest_ibfk_2` FOREIGN KEY (`departmentid`) REFERENCES `departments` (`departmentid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2771,7 +2771,7 @@ KEY `dispatchid` (`dispatchid`), KEY `stockid` (`stockid`), CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`) REFERENCES `stockrequest` (`dispatchid`), - CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`), + CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; |