web-erp-svn

[Web-erp-svn] SF.net SVN: web-erp:[6788] trunk/sql/mysql/country_sql/default.sql

[<dai...@us...>]

Revision: 6788
          http://sourceforge.net/p/web-erp/reponame/6788
Author:   daintree
Date:     2014-07-07 06:09:40 +0000 (Mon, 07 Jul 2014)
Log Message:
-----------
Giberto: fixes to duplicate foreign key constraints

Modified Paths:
--------------
    trunk/sql/mysql/country_sql/default.sql

Modified: trunk/sql/mysql/country_sql/default.sql
===================================================================
--- trunk/sql/mysql/country_sql/default.sql	2014-07-07 06:05:55 UTC (rev 6787)
+++ trunk/sql/mysql/country_sql/default.sql	2014-07-07 06:09:40 UTC (rev 6788)
@@ -2622,6 +2622,7 @@
   KEY `stockid_2` (`stockid`),
   CONSTRAINT `stockrequestitems_ibfk_1` FOREIGN KEY (`dispatchid`) REFERENCES `stockrequest` (`dispatchid`),
   CONSTRAINT `stockrequestitems_ibfk_2` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

[Web-erp-svn] SF.net SVN: web-erp:[6949] trunk/sql/mysql/country_sql/default.sql

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

Revision: 6949
          http://sourceforge.net/p/web-erp/reponame/6949
Author:   exsonqu
Date:     2014-10-28 11:24:10 +0000 (Tue, 28 Oct 2014)
Log Message:
-----------
28/10/14 Exson: Add Chinese Yuan to default.sql to prevent wrong Chinese Yuan input which leads lots of problem. Advised by Thumb.

Modified Paths:
--------------
    trunk/sql/mysql/country_sql/default.sql

Modified: trunk/sql/mysql/country_sql/default.sql
===================================================================
--- trunk/sql/mysql/country_sql/default.sql	2014-10-28 07:14:01 UTC (rev 6948)
+++ trunk/sql/mysql/country_sql/default.sql	2014-10-28 11:24:10 UTC (rev 6949)
@@ -3455,6 +3455,7 @@
 INSERT INTO `currencies` VALUES ('Pounds','GBP','England','Pence',2,0.6217,0);
 INSERT INTO `currencies` VALUES ('Kenyian Shillings','KES','Kenya','none',0,89.15,0);
 INSERT INTO `currencies` VALUES ('US Dollars','USD','United States','Cents',2,1,1);
+INSERT INTO `currencies` VALUES ('Chinese Yuan','CNY','China','Cents',2,6.1141,0);
 
 --
 -- Dumping data for table `holdreasons`

[Web-erp-svn] SF.net SVN: web-erp:[7530] trunk/sql/mysql/country_sql/default.sql

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

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 */;