/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.6.16-1~exp1 : Database - test1
*********************************************************************
*/




/*Table structure for table `contentMaster` */


CREATE TABLE `contentMaster` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `description` varchar(2000) NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `contentMaster` */

insert  into `contentMaster`(`id`,`type`,`description`,`status`,`createdOn`,`createdBy`,`servCDate`,`modifiedOn`,`modifiedBy`) values (1,'content1','Engliesh content14','A','2020-09-28 00:20:46',NULL,NULL,'2020-09-28 00:28:29',NULL),(2,'banner1','Welcome to<br/>Great Forex','A','2020-09-28 00:28:59',NULL,NULL,'2020-10-08 23:01:25',NULL);

/*Table structure for table `currencyMaster` */


CREATE TABLE `currencyMaster` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `currName` varchar(50) NOT NULL,
  `symbol` char(5) DEFAULT NULL,
  `currShortName` char(5) NOT NULL,
  `baseCurr` char(5) DEFAULT NULL,
  `precision` smallint(6) DEFAULT NULL,
  `currRate` float NOT NULL DEFAULT '1',
  `cashBid` int(11) DEFAULT '0',
  `cashAsk` int(11) DEFAULT '0',
  `bid` int(11) NOT NULL DEFAULT '0',
  `ask` int(11) NOT NULL DEFAULT '0',
  `homeView` char(1) DEFAULT 'I',
  `status` char(1) NOT NULL DEFAULT 'A',
  `buffer` float NOT NULL DEFAULT '0',
  `toCurr` char(5) DEFAULT NULL,
  `decimal` varchar(30) DEFAULT NULL,
  `smallName` varchar(200) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8;

/*Data for the table `currencyMaster` */

insert  into `currencyMaster`(`id`,`currName`,`symbol`,`currShortName`,`baseCurr`,`precision`,`currRate`,`cashBid`,`cashAsk`,`bid`,`ask`,`homeView`,`status`,`buffer`,`toCurr`,`decimal`,`smallName`,`modifiedOn`,`servCDate`) values (2,'Albania, Leke','','ALL','AUD',0,0.7,7,5,-10,300,'A','I',0,'ALL','76, 101, 107','Albania','2020-10-10 01:38:14','0000-00-00 00:00:00'),(4,'Afghanistan, Afghanis','','AFN','AUD',0,56.3621,0,0,0,0,'A','A',0,'AFN','65,102','Afghanistan','2020-10-10 01:31:20','0000-00-00 00:00:00'),(5,'Argentina, Pesos','','ARS','AUD',0,6.89737,0,0,0,0,'I','A',0,'ARS','65,82,36','Argentina',NULL,'0000-00-00 00:00:00'),(7,'Australia, Dollars','','AUD','AUD',0,1.14417,0,0,0,0,'I','A',0,'AUD','65,85,36','Australia',NULL,'0000-00-00 00:00:00'),(8,'Azerbaijan, New Manats','','AZN','AUD',0,0.784,0,0,0,0,'I','A',0,'AZN','109,97,110,46','Azerbaijan',NULL,'0000-00-00 00:00:00'),(9,'Bahamas, Dollars','','BSD','AUD',0,1,0,0,0,0,'I','A',0,'BSD','66,36','Bahamas',NULL,'0000-00-00 00:00:00'),(10,'Barbados, Dollars','','BBD','AUD',0,2,0,0,0,0,'I','A',0,'BBD','36','Barbados',NULL,'0000-00-00 00:00:00'),(11,'Belarus, Rubles','','BYR','AUD',0,9611.25,0,0,0,0,'I','A',0,'BYR','66, 114','Belarus',NULL,'0000-00-00 00:00:00'),(13,'Belize, Dollars','','BZD','AUD',0,1.98674,0,0,0,0,'I','A',0,'BZD','66, 90, 36','Belize',NULL,'0000-00-00 00:00:00'),(14,'Bermuda, Dollars','','BMD','AUD',0,1,0,0,0,0,'I','A',0,'BMD','36','Bermuda',NULL,'0000-00-00 00:00:00'),(15,'Bolivia, Bolivianos','','BOB','AUD',0,6.89293,0,0,0,0,'I','A',0,'BOB','66,115','Bolivia',NULL,'0000-00-00 00:00:00'),(16,'Bosnia and Herzegovina, Convertible Marka','','BAM','AUD',0,1.4318,0,0,0,0,'I','A',0,'BAM','75, 77','Bosnia and Herzegovina',NULL,'0000-00-00 00:00:00'),(17,'Botswana, Pulas','','BWP','AUD',0,8.90448,0,0,0,0,'I','A',0,'BWP','66,87,80','Botswana',NULL,'0000-00-00 00:00:00'),(18,'Bulgaria, Leva','','BGN','AUD',0,1.43094,0,0,0,0,'I','A',0,'BGN','1083, 1074','Bulgaria',NULL,'0000-00-00 00:00:00'),(19,'Brazil, Reais','','BRL','AUD',0,2.39339,0,0,0,0,'I','A',0,'BRL','82, 36','Brazil',NULL,'0000-00-00 00:00:00'),(21,'Brunei Darussalam, Dollars','','BND','AUD',0,1.27668,0,0,0,0,'I','A',0,'BND','66,78,36','Brunei Darussalam',NULL,'0000-00-00 00:00:00'),(22,'Cambodia, Riels','','KHR','AUD',0,3998.96,0,0,0,0,'I','A',0,'KHR','6107','Cambodia',NULL,'0000-00-00 00:00:00'),(23,'Canada, Dollars','','CAD','AUD',0,1.26005,0,0,0,0,'I','A',0,'CAD','67,65,36','Canada','2020-09-08 19:21:05','0000-00-00 00:00:00'),(24,'Cayman Islands, Dollars','','KYD','AUD',0,0.825803,0,0,0,0,'I','A',0,'KYD','36','Cayman Islands',NULL,'0000-00-00 00:00:00'),(25,'Chile, Pesos','','CLP','AUD',0,548.576,0,0,0,0,'I','A',0,'CLP','67,76,36','Chile',NULL,'0000-00-00 00:00:00'),(26,'China, Yuan Renminbi','','CNY','AUD',0,6.0586,0,0,0,0,'I','A',0,'CNY','67,78,165','China',NULL,'0000-00-00 00:00:00'),(27,'Colombia, Pesos','','COP','AUD',0,1997.44,0,0,0,0,'I','A',0,'COP','67,79,80,36','Colombia',NULL,'0000-00-00 00:00:00'),(28,'Costa Rica, Col','','CRC','AUD',0,500.945,0,0,0,0,'I','A',0,'CRC','8353','Costa Rica',NULL,'0000-00-00 00:00:00'),(29,'Croatia, Kuna','','HRK','AUD',0,5.59079,0,0,0,0,'I','A',0,'HRK','107, 110','Croatia',NULL,'0000-00-00 00:00:00'),(30,'Cuba, Pesos','','CUP','AUD',0,22.6874,0,0,0,0,'I','A',0,'CUP','8369','Cuba',NULL,'0000-00-00 00:00:00'),(32,'Czech Republic, Koruny','','CZK','AUD',0,20.1011,0,0,0,0,'I','A',0,'CZK','75, 269','Czech Republic',NULL,'0000-00-00 00:00:00'),(33,'Denmark, Kroner','','DKK','AUD',0,5.45822,0,0,0,0,'I','A',0,'DKK','107, 114','Denmark',NULL,'0000-00-00 00:00:00'),(34,'Dominican Republic, Pesos','','DOP','AUD',0,42.733,0,0,0,0,'I','A',0,'DOP','82, 68, 36','Dominican Republic',NULL,'0000-00-00 00:00:00'),(35,'East Caribbean, Dollars','','XCD','AUD',0,2.70156,0,0,0,0,'I','A',0,'XCD','36','East Caribbean',NULL,'0000-00-00 00:00:00'),(36,'Egypt, Pounds','','EGP','AUD',0,6.96154,0,0,0,0,'I','A',0,'EGP','163','Egypt',NULL,'0000-00-00 00:00:00'),(37,'El Salvador, Colones','','SVC','AUD',0,8.72726,0,0,0,0,'I','A',0,'SVC','36','El Salvador',NULL,'0000-00-00 00:00:00'),(39,'Estonia, Krooni','','EEK','AUD',0,11.6584,0,0,0,0,'I','A',0,'EEK','107, 114','Estonia',NULL,'0000-00-00 00:00:00'),(40,'Euro','','EUR','AUD',0,0.806942,0,0,0,0,'I','A',0,'EUR','8364','','2020-09-08 19:21:05','0000-00-00 00:00:00'),(41,'Falkland Islands, Pounds','','FKP','AUD',0,0.601128,0,0,0,0,'I','A',0,'FKP','163','Falkland Islands',NULL,'0000-00-00 00:00:00'),(42,'Fiji, Dollars','','FJD','AUD',0,1.89799,0,0,0,0,'I','A',0,'FJD','70,74,36','Fiji',NULL,'0000-00-00 00:00:00'),(44,'Ghana, Cedis','','GHS','AUD',0,2.41117,0,0,0,0,'I','A',0,'GHS','71,72,162','Ghana',NULL,'0000-00-00 00:00:00'),(45,'Gibraltar, Pounds','','GIP','AUD',0,0.601128,0,0,0,0,'I','A',0,'GIP','163','Gibraltar',NULL,'0000-00-00 00:00:00'),(47,'Guatemala, Quetzales','','GTQ','AUD',0,7.79442,0,0,0,0,'I','A',0,'GTQ','71,84,81','Guatemala',NULL,'0000-00-00 00:00:00'),(49,'Guyana, Dollars','','GYD','AUD',0,205.254,0,0,0,0,'I','A',0,'GYD','36','Guyana',NULL,'0000-00-00 00:00:00'),(51,'Honduras, Lempiras','','HNL','AUD',0,19.9295,0,0,0,0,'I','A',0,'HNL','72,78,76','Honduras',NULL,'0000-00-00 00:00:00'),(55,'Hong Kong, Dollars (HSBC notes)','','HKD','AUD',0,7.76184,0,0,0,0,'I','A',0,'HKD','72,75,36','Hong Kong',NULL,'0000-00-00 00:00:00'),(56,'Hungary, Forint','','HUF','AUD',0,223.078,0,0,0,0,'I','A',0,'HUF','70, 116','Hungary',NULL,'0000-00-00 00:00:00'),(57,'Iceland, Kronur','','ISK','AUD',0,115.267,0,0,0,0,'I','A',0,'ISK','107, 114','Iceland',NULL,'0000-00-00 00:00:00'),(58,'India, Rupees (Rs or Rs. are commonly used instead','','INR','AUD',0,68.615,0,0,0,0,'I','A',0,'INR','8360','India',NULL,'0000-00-00 00:00:00'),(59,'Indonesia, Rupiahs','','IDR','AUD',0,12139.2,0,0,0,0,'I','A',0,'IDR','82, 112','Indonesia',NULL,'0000-00-00 00:00:00'),(60,'Iran, Rials','','IRR','AUD',0,24789.7,0,0,0,0,'I','A',0,'IRR','65020','Iran',NULL,'0000-00-00 00:00:00'),(62,'Isle of Man, Pounds','','IMP','AUD',0,0,0,0,0,0,'I','A',0,'IMP','163','Isle of Man',NULL,'0000-00-00 00:00:00'),(63,'Israel, New Shekels','','ILS','AUD',0,3.48474,0,0,0,0,'I','A',0,'ILS','8362','Israel',NULL,'0000-00-00 00:00:00'),(65,'Jamaica, Dollars','','JMD','AUD',0,106.534,0,0,0,0,'I','A',0,'JMD','74, 36','Jamaica',NULL,'0000-00-00 00:00:00'),(66,'Japan, Yen','','JPY','AUD',0,103.488,0,0,0,0,'I','A',0,'JPY','165','Japan',NULL,'0000-00-00 00:00:00'),(67,'Jersey, Pounds','','JEP','AUD',0,0.601128,0,0,0,0,'I','A',0,'JEP','163','Jersey',NULL,'0000-00-00 00:00:00'),(68,'Kazakhstan, Tenge','','KZT','AUD',0,154.818,0,0,0,0,'I','A',0,'KZT','1083, 1074','Kazakhstan',NULL,'0000-00-00 00:00:00'),(71,'Kyrgyzstan, Soms','','KGS','AUD',0,50.2539,0,0,0,0,'I','A',0,'KGS','1083, 1074','Kyrgyzstan',NULL,'0000-00-00 00:00:00'),(72,'Laos, Kips','','LAK','AUD',0,8028.85,0,0,0,0,'I','A',0,'LAK','8365','Laos',NULL,'0000-00-00 00:00:00'),(73,'Latvia, Lati','','LVL','AUD',0,0.514125,0,0,0,0,'I','A',0,'LVL','76, 115','Latvia',NULL,'0000-00-00 00:00:00'),(74,'Lebanon, Pounds','','LBP','AUD',0,1503.76,0,0,0,0,'I','A',0,'LBP','76, 66, 80','Lebanon',NULL,'0000-00-00 00:00:00'),(75,'Liberia, Dollars','','LRD','AUD',0,85.5,0,0,0,0,'I','A',0,'LRD','76,36','Liberia',NULL,'0000-00-00 00:00:00'),(77,'Lithuania, Litai','','LTL','AUD',0,2.52531,0,0,0,0,'I','A',0,'LTL','76, 116','Lithuania',NULL,'0000-00-00 00:00:00'),(79,'Macedonia, Denars','','MKD','AUD',0,45.1159,0,0,0,0,'I','A',0,'MKD','1076, 1077, 1085','Macedonia',NULL,'0000-00-00 00:00:00'),(82,'Mauritius, Rupees','','MUR','AUD',0,30.1825,0,0,0,0,'I','A',0,'MUR','82,70','Mauritius',NULL,'0000-00-00 00:00:00'),(83,'Mexico, Pesos','','MXN','AUD',0,13.4088,0,0,0,0,'I','A',0,'MXN','36','Mexico',NULL,'0000-00-00 00:00:00'),(84,'Mongolia, Tugriks','','MNT','AUD',0,1706.5,0,0,0,0,'I','A',0,'MNT','8366','Mongolia',NULL,'0000-00-00 00:00:00'),(85,'Mozambique, Meticais','','MZN','AUD',0,30.4735,0,0,0,0,'I','A',0,'MZN','77, 84','Mozambique',NULL,'0000-00-00 00:00:00'),(86,'Namibia, Dollars','','NAD','AUD',0,10.9558,0,0,0,0,'I','A',0,'NAD','78,36','Namibia',NULL,'0000-00-00 00:00:00'),(87,'Nepal, Rupees','','NPR','AUD',0,98.9296,0,0,0,0,'I','A',0,'NPR','8360','Nepal',NULL,'0000-00-00 00:00:00'),(90,'New Zealand, Dollars','','NZD','AUD',0,1.20872,0,0,0,0,'I','A',0,'NZD','78,90,36','New Zealand',NULL,'0000-00-00 00:00:00'),(91,'Nicaragua, Cordobas','','NIO','AUD',0,25.4531,0,0,0,0,'I','A',0,'NIO','67, 36','Nicaragua',NULL,'0000-00-00 00:00:00'),(92,'Nigeria, Nairas','','NGN','AUD',0,159.529,0,0,0,0,'I','A',0,'NGN','8358','Nigeria',NULL,'0000-00-00 00:00:00'),(93,'North Korea, Won','','KPW','AUD',0,900,0,0,0,0,'I','A',0,'KPW','8361','North Korea',NULL,'0000-00-00 00:00:00'),(94,'Norway, Krone','','NOK','AUD',0,6.10039,0,0,0,0,'I','A',0,'NOK','78,107,114','Norway',NULL,'0000-00-00 00:00:00'),(95,'Oman, Rials','','OMR','AUD',0,0.385029,0,0,0,0,'I','A',0,'OMR','65020','Oman',NULL,'0000-00-00 00:00:00'),(96,'Pakistan, Rupees','','PKR','AUD',0,105.301,0,0,0,0,'I','A',0,'PKR','80,75,82,115','Pakistan',NULL,'0000-00-00 00:00:00'),(97,'Panama, Balboa','','PAB','AUD',0,1,0,0,0,0,'I','A',0,'PAB','66, 47, 46','Panama',NULL,'0000-00-00 00:00:00'),(99,'Peru, Nuevos Soles','','PEN','AUD',0,2.80603,0,0,0,0,'I','A',0,'PEN','83, 47, 46','Peru',NULL,'0000-00-00 00:00:00'),(100,'Philippines, Pesos','','PHP','AUD',0,45.328,0,0,0,0,'I','A',0,'PHP','8369','Philippines',NULL,'0000-00-00 00:00:00'),(101,'Poland, Zlotych','','PLN','AUD',0,3.05629,0,0,0,0,'I','A',0,'PLN','122, 322','Poland',NULL,'0000-00-00 00:00:00'),(102,'Qatar, Rials','','QAR','AUD',0,3.64155,0,0,0,0,'I','A',0,'QAR','81,82','Qatar',NULL,'0000-00-00 00:00:00'),(103,'Romania, New Lei','','RON','AUD',0,3.31518,0,0,0,0,'I','A',0,'RON','108, 101, 105','Romania',NULL,'0000-00-00 00:00:00'),(104,'Russia, Rubles','','RUB','AUD',0,34.1089,0,0,0,0,'I','A',0,'RUB','1088, 1091, 1073','Russia',NULL,'0000-00-00 00:00:00'),(105,'Saint Helena, Pounds','','SHP','AUD',0,0.601128,0,0,0,0,'I','A',0,'SHP','163','Saint Helena',NULL,'0000-00-00 00:00:00'),(106,'Saudi Arabia, Riyals','','SAR','AUD',0,3.75043,0,0,0,0,'I','A',0,'SAR','83,82','Saudi Arabia',NULL,'0000-00-00 00:00:00'),(108,'Seychelles, Rupees','','SCR','AUD',0,12.0972,0,0,0,0,'I','A',0,'SCR','8360','Seychelles',NULL,'0000-00-00 00:00:00'),(109,'Singapore, Dollars','','SGD','AUD',0,1.27907,0,0,0,0,'I','A',0,'SGD','83,36','Singapore',NULL,'0000-00-00 00:00:00'),(111,'Solomon Islands, Dollars','','SBD','AUD',0,7.20808,0,0,0,0,'I','A',0,'SBD','36','Solomon Islands',NULL,'0000-00-00 00:00:00'),(112,'Somalia, Shillings','','SOS','AUD',0,1093.62,0,0,0,0,'I','A',0,'SOS','83,115,104','Somalia',NULL,'0000-00-00 00:00:00'),(113,'South Africa, Rand','','ZAR','AUD',0,10.9868,0,0,0,0,'I','A',0,'ZAR','82','South Africa',NULL,'0000-00-00 00:00:00'),(114,'South Korea, Won','','KRW','AUD',0,1076.06,0,0,0,0,'I','A',0,'KRW','8361','South Korea',NULL,'0000-00-00 00:00:00'),(116,'Sri Lanka, Rupees','','LKR','AUD',0,130.721,0,0,0,0,'I','A',0,'LKR','83,76,8360','Sri Lanka',NULL,'0000-00-00 00:00:00'),(117,'Sweden, Kronor','','SEK','AUD',0,6.42239,0,0,0,0,'I','A',0,'SEK','83,107,114','Sweden',NULL,'0000-00-00 00:00:00'),(118,'Switzerland, Francs','','CHF','AUD',0,0.933058,0,0,0,0,'I','A',0,'CHF','67,72,70','Switzerland','2020-09-08 19:21:05','0000-00-00 00:00:00'),(119,'Suriname, Dollars','','SRD','AUD',0,3.2875,0,0,0,0,'I','A',0,'SRD','36','Suriname',NULL,'0000-00-00 00:00:00'),(120,'Syria, Pounds','','SYP','AUD',0,141.63,0,0,0,0,'I','A',0,'SYP','83,89,163','Syria',NULL,'0000-00-00 00:00:00'),(121,'Taiwan, New Dollars','','TWD','AUD',0,30.1816,0,0,0,0,'I','A',0,'TWD','78, 84, 36','Taiwan',NULL,'0000-00-00 00:00:00'),(122,'Thailand, Baht','','THB','AUD',0,32.8789,0,0,0,0,'I','A',0,'THB','3647','Thailand',NULL,'0000-00-00 00:00:00'),(123,'Trinidad and Tobago, Dollars','','TTD','AUD',0,6.39939,0,0,0,0,'I','A',0,'TTD','84, 84, 36','Trinidad and Tobago',NULL,'0000-00-00 00:00:00'),(124,'Turkey, New Lira','','TRY','AUD',0,2.28854,0,0,0,0,'I','A',0,'TRY','89,84,76','Turkey',NULL,'0000-00-00 00:00:00'),(125,'Turkey, Liras','','TRL','AUD',0,0,0,0,0,0,'I','A',0,'TRL','8356','Turkey',NULL,'0000-00-00 00:00:00'),(126,'Tuvalu, Dollars','','TVD','AUD',0,0,0,0,0,0,'I','A',0,'TVD','36','Tuvalu',NULL,'0000-00-00 00:00:00'),(127,'Ukraine, Hryvnia','','UAH','AUD',0,8.39905,0,0,0,0,'I','A',0,'UAH','8372','Ukraine',NULL,'0000-00-00 00:00:00'),(128,'United Kingdom, Pounds','','GBP','AUD',0,0.719154,0,0,0,0,'I','A',0,'GBP','163','United Kingdom','2020-09-08 19:21:05','0000-00-00 00:00:00'),(129,'United States of America, Dollars','','USD','AUD',0,0.7,0,0,-10,300,'I','A',0,'USD','36','United States of America',NULL,'0000-00-00 00:00:00'),(130,'Uruguay, Pesos','','UYU','AUD',0,21.3661,0,0,0,0,'I','A',0,'UYU','36, 85','Uruguay',NULL,'0000-00-00 00:00:00'),(131,'Uzbekistan, Sums','','UZS','AUD',0,2202.18,0,0,0,0,'I','A',0,'UZS','1083, 1074','Uzbekistan',NULL,'0000-00-00 00:00:00'),(133,'Venezuela, Bolivares Fuertes','','VEF','AUD',0,6.29155,0,0,0,0,'I','A',0,'VEF','66,115,46,70,46','Venezuela',NULL,'0000-00-00 00:00:00'),(134,'Vietnam, Dong','','VND','AUD',0,21081.2,0,0,0,0,'I','A',0,'VND','8363','Vietnam',NULL,'0000-00-00 00:00:00'),(135,'Yemen, Rials','','YER','AUD',0,215.014,0,0,0,0,'I','A',0,'YER','89,82','Yemen',NULL,'0000-00-00 00:00:00'),(136,'Zimbabwe, Zimbabwe Dollars','','ZWD','AUD',0,0,0,0,0,0,'I','A',0,'ZWD','90, 36','Zimbabwe',NULL,'0000-00-00 00:00:00'),(137,'CFA franc BEAC','','XAF','AUD',0,480.414,0,0,0,0,'I','A',0,'XAF','70,67,70,65','CFA franc BEAC',NULL,'0000-00-00 00:00:00'),(138,'Cape Verde, Escudo','','CVE','AUD',0,80.7569,0,0,0,0,'I','A',0,'CVE','36','Cape Verde',NULL,'0000-00-00 00:00:00'),(139,'Iraq, Dinar','0','IQD','AUD',0,1164.7,0,0,0,0,'I','A',0,'IQD','73,68','Iraq',NULL,'0000-00-00 00:00:00'),(140,'Jordan, Dinar','','JOD','AUD',0,0.706895,0,0,0,0,'I','A',0,'JOD','74,68','Jordan',NULL,'0000-00-00 00:00:00'),(141,'Kenya, Shilling','','KES','AUD',0,85.5134,0,0,0,0,'I','A',0,'KES','75,83,104','Kenya',NULL,'0000-00-00 00:00:00'),(142,'Kuwait, Dinar','','KWD','AUD',0,0.282842,0,0,0,0,'I','A',0,'KWD','75,68','Kuwait',NULL,'0000-00-00 00:00:00'),(143,'Lesotho, Loti','','LSL','AUD',0,10.9594,0,0,0,0,'I','A',0,'LSL','76,116','Lesotho',NULL,'0000-00-00 00:00:00'),(144,'Malawi, Kwacha','','MWK','AUD',0,449.272,0,0,0,0,'I','A',0,'MWK','','Malawi',NULL,'0000-00-00 00:00:00'),(145,'Malaysia, Ringgit','','MYR','AUD',0,3.32978,0,0,0,0,'I','A',0,'MYR','82,77','Malaysia',NULL,'0000-00-00 00:00:00'),(146,'Mauritania, Ouguiya','','MRO','AUD',0,290.033,0,0,0,0,'I','A',0,'MRO','85, 77','Mauritania',NULL,'0000-00-00 00:00:00'),(147,'Moldova, Leu','','MDL','AUD',0,13.2843,0,0,0,0,'I','A',0,'MDL','77,68,76','Moldova',NULL,'0000-00-00 00:00:00'),(148,'Morocco, Dirham','','MAD','AUD',0,8.21023,0,0,0,0,'I','A',0,'MAD','68, 104','Morocco',NULL,'0000-00-00 00:00:00'),(149,'Myanmar (Burma), Kyat','','MMK','AUD',0,982.768,0,0,0,0,'I','A',0,'MMK','77,77,75','Myanmar (Burma)',NULL,'0000-00-00 00:00:00'),(150,'Paraguay, Guarani','','PYG','AUD',0,4634.94,0,0,0,0,'I','A',0,'PYG','71,115','Paraguay',NULL,'0000-00-00 00:00:00'),(151,'Rwanda, Franc','','RWF','AUD',0,678.352,0,0,0,0,'I','A',0,'RWF','82,70','Rwanda',NULL,'0000-00-00 00:00:00'),(152,'S&atilde;o Tome and Principe, Dobra','','STD','AUD',0,17985,0,0,0,0,'I','A',0,'STD','','S&atilde;o Tome and Principe',NULL,'0000-00-00 00:00:00'),(153,'Sierra Leone, Leone','','SLL','AUD',0,4310.33,0,0,0,0,'I','A',0,'SLL','','Sierra Leone',NULL,'0000-00-00 00:00:00'),(154,'Sudan, Pound','','SDG','AUD',0,5.68628,0,0,0,0,'I','A',0,'SDG','83,68,71','Sudan',NULL,'0000-00-00 00:00:00'),(155,'Swaziland, Lilangeni','','SZL','AUD',0,10.9451,0,0,0,0,'I','A',0,'SZL','76','Swaziland',NULL,'0000-00-00 00:00:00'),(156,'Tanzania, Shilling','','TZS','AUD',0,1620.92,0,0,0,0,'I','A',0,'TZS','84,83,104','Tanzania',NULL,'0000-00-00 00:00:00'),(157,'Tonga, Pa\'anga','','TDP','AUD',0,0,0,0,0,0,'I','A',0,'TDP','','Tonga',NULL,'0000-00-00 00:00:00'),(158,'Tunisia, Dinar','','TND','AUD',0,1.62617,0,0,0,0,'I','A',0,'TND','68,84','Tunisia',NULL,'0000-00-00 00:00:00'),(159,'Turkmenistan, New Manat','','TMT','AUD',0,2.85017,0,0,0,0,'I','A',0,'TMT','','Turkmenistan',NULL,'0000-00-00 00:00:00'),(160,'Uganda, Shilling','Ush','UGX','AUD',0,2472.95,0,0,0,0,'I','A',0,'UGX','85,83,104','Uganda',NULL,'0000-00-00 00:00:00'),(161,'Vanuatu, Vatu','','VUV','AUD',0,96.52,0,0,0,0,'I','A',0,'VUV','86,84','Vanuatu',NULL,'0000-00-00 00:00:00'),(162,'Samoa, Tala','','WST','AUD',0,2.3291,0,0,0,0,'I','A',0,'WST','87,83,36','Samoa',NULL,'0000-00-00 00:00:00'),(163,'Zambia, Kwacha','','ZMW','AUD',0,5252.02,0,0,0,0,'I','A',0,'ZMW','90,77,87','Zambia',NULL,'0000-00-00 00:00:00'),(164,'Angola, Kwanza','','AOA','AUD',0,97.616,0,0,0,0,'I','A',0,'AOA','75,122','Angola',NULL,'0000-00-00 00:00:00'),(165,'Armenia, Dram','','AMD','AUD',0,406.943,0,0,0,0,'I','A',0,'AMD','','Armenia',NULL,'0000-00-00 00:00:00'),(166,'Aruba, Guilder','','AWG','AUD',0,1.78985,0,0,0,0,'I','A',0,'AWG','402','Aruba',NULL,'0000-00-00 00:00:00'),(167,'United Arab Emirates, Dirham','','AED','AUD',0,3.67298,0,0,0,0,'I','A',0,'AED','65,69,68','United Arab Emirates',NULL,'0000-00-00 00:00:00'),(168,'Bahrain, Dinar','','BHD','AUD',0,0.377011,0,0,0,0,'I','A',0,'BHD','66,68','Bahrain',NULL,'0000-00-00 00:00:00'),(169,'Bangladesh, Taka','','BDT','AUD',0,77.5472,0,0,0,0,'I','A',0,'BDT','84,107','Bangladesh',NULL,'0000-00-00 00:00:00'),(170,'Algeria, Dinar','','DZD','AUD',0,78.0426,0,0,0,0,'I','A',0,'DZD','68,65','Algeria',NULL,'0000-00-00 00:00:00'),(171,'Guernsey, Pound','','GGP','AUD',0,0,0,0,0,0,'I','A',0,'GGP','163','Guernsey',NULL,'0000-00-00 00:00:00'),(172,'Netherlands Antillean, Guilders','f','ANG','AUD',0,1.789,0,0,0,0,'I','A',0,'ANG','402','Caribbean Guilder',NULL,'0000-00-00 00:00:00'),(173,'Serbian, Dinar','','RSD','AUD',0,84.6015,0,0,0,0,'I','A',0,'RSD','1044,1080,1085,46','Serbian Dinar',NULL,'0000-00-00 00:00:00'),(174,'Djiboutian Franc','Fdj','DJF','AUD',0,177.941,0,0,0,0,'I','A',0,'DJF','8355','Djiboutian Franc',NULL,'0000-00-00 00:00:00'),(175,'Maldivian rufiyaa','Rf.','MVR','AUD',0,15.4305,0,0,0,0,'I','A',0,'MVR','82,102,46','Maldivian rufiyaa',NULL,'0000-00-00 00:00:00'),(176,'Haitian Gourde','G','HTG','AUD',0,41.8428,0,0,0,0,'I','A',0,'HTG','71','Gourde',NULL,'0000-00-00 00:00:00'),(177,'Digital Currency, Bitcoin','','BTC','AUD',0,0,0,0,0,0,'I','I',0,'BTC','3647','Bitcoin','2020-10-10 01:34:05','2014-02-10 14:05:00'),(178,'Ethiopian Currency, Birr','','ETB','AUD',0,0,0,0,0,0,'I','I',0,'ETB','66,114','Birr','2020-10-10 01:34:16','2014-05-27 18:30:00'),(179,'Malagasy Ariary','Ar','MGA','AUD',0,0,0,0,0,0,'I','I',0,'MGA','65,114','Ariary','2020-10-10 01:34:21','2014-11-07 18:50:00'),(180,'Georgian Lari','','GEL','AUD',0,1.89797,0,0,0,0,'I','I',0,'GEL','4314','lari','2020-10-10 01:34:29','2014-11-07 18:50:00'),(184,'Papua New Guinea, Kina','','PGK','AUD',0,0.32,0,0,0,0,'I','I',0,'PGK','75','Papua New Guinea','2020-10-10 01:35:00','0000-00-00 00:00:00'),(185,'Congolese franc','','CDF','AUD',0,1560,0,0,0,0,'I','I',0,'CDF','67,68,70','Congolese franc','2020-10-10 01:35:04','2017-09-19 17:44:30'),(186,'Bhutanese,Ngultrum','Nu.','BTN','AUD',0,64.77,0,0,0,0,'I','I',0,'BTN','78,117,46','Bhutan','2020-10-10 01:34:55','2017-10-31 16:42:18'),(187,'Gambia,Gambian dalasi','D','GMD','AUD',0,47.94,0,0,0,0,'I','I',0,'GMD','68','Gambia','2020-10-10 01:34:44','2017-11-03 13:28:07');

/*Table structure for table `fxsetting` */


CREATE TABLE `fxsetting` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `val` varchar(1000) NOT NULL,
  `createdOn` datetime NOT NULL,
  `updatedOn` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='to store global settings';

/*Data for the table `fxsetting` */

insert  into `fxsetting`(`id`,`name`,`val`,`createdOn`,`updatedOn`) values (1,'siteStatus','0','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'marqueText','Great Forex Glen Waverley branch will open soon!','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'location','165 Coleman Parade, Glen Waverley, 3150, VIC Australia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'contactNo','03 70230398','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'email','info@greatforex.com','0000-00-00 00:00:00','0000-00-00 00:00:00');

/*Table structure for table `languageMaster` */


CREATE TABLE `languageMaster` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `code` char(5) NOT NULL,
  `isDefault` tinyint(1) DEFAULT '0',
  `createdOn` datetime DEFAULT NULL,
  `status` char(2) NOT NULL DEFAULT 'A',
  `flagImage` varchar(255) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `languageMaster` */

insert  into `languageMaster`(`id`,`title`,`code`,`isDefault`,`createdOn`,`status`,`flagImage`,`modifiedOn`,`modifiedBy`) values (1,'English','en',1,'2020-09-01 01:24:57','A','us-flag.gif','2020-09-02 01:25:12',1),(2,'China','ch',0,'2020-09-03 01:26:22','A','ch-flag.jpg','2020-09-02 01:26:39',1);

/*Table structure for table `multiLangContent` */


CREATE TABLE `multiLangContent` (
  `languageId` mediumint(9) NOT NULL,
  `refId` int(11) NOT NULL,
  `tableName` varchar(200) NOT NULL,
  `contentXML` mediumtext,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT '0',
  `servCDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT '0',
  PRIMARY KEY (`languageId`,`refId`,`tableName`(20)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `multiLangContent` */

insert  into `multiLangContent`(`languageId`,`refId`,`tableName`,`contentXML`,`createdOn`,`createdBy`,`servCDate`,`modifiedOn`,`modifiedBy`) values (1,1,'contentMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Engliesh content14]]></description>\n</multiLangText>\n','2020-09-28 00:28:29',0,'2020-09-28 00:28:29','2020-09-28 00:28:29',0),(1,1,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[e content1]]></description>\n</multiLangText>\n','2020-09-28 00:20:46',0,'2020-09-28 00:20:46','2020-09-28 00:20:46',0),(1,2,'contentMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Welcome to<br/>Great Forex]]></description>\n</multiLangText>\n','2020-10-08 23:01:25',0,'2020-10-08 23:01:25','2020-10-08 23:01:25',0),(1,2,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Company news English]]></description>\n</multiLangText>\n','2020-09-04 00:47:22',0,'2020-09-04 00:47:22','2020-09-04 00:47:22',0),(1,3,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Company news English 1]]></description>\n</multiLangText>\n','2020-09-04 00:47:04',0,'2020-09-04 00:47:04','2020-09-04 00:47:04',0),(1,4,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Duis aute irure dolor in reprehenderit in]]></description>\n</multiLangText>\n','2020-09-04 00:45:37',0,'2020-09-04 00:45:37','2020-09-04 00:45:37',0),(1,5,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Englist Content1]]></description>\n</multiLangText>\n','2020-10-08 22:59:21',0,'2020-10-08 22:59:21','2020-10-08 22:59:21',0),(2,1,'contentMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Chines Content 14]]></description>\n</multiLangText>\n','2020-09-28 00:28:29',0,'2020-09-28 00:28:29','2020-09-28 00:28:29',0),(2,1,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[c content1]]></description>\n</multiLangText>\n','2020-09-28 00:20:46',0,'2020-09-28 00:20:46','2020-09-28 00:20:46',0),(2,2,'contentMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Welcome to<br/>Great Forex]]></description>\n</multiLangText>\n','2020-10-08 23:01:25',0,'2020-10-08 23:01:25','2020-10-08 23:01:25',0),(2,2,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Company news Chines 2]]></description>\n</multiLangText>\n','2020-09-04 00:47:22',0,'2020-09-04 00:47:22','2020-09-04 00:47:22',0),(2,3,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Company news Chines 1]]></description>\n</multiLangText>\n','2020-09-04 00:47:04',0,'2020-09-04 00:47:04','2020-09-04 00:47:04',0),(2,4,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[Duis aute irure dolor in reprehenderit in]]></description>\n</multiLangText>\n','2020-09-04 00:45:37',0,'2020-09-04 00:45:37','2020-09-04 00:45:37',0),(2,5,'newsMaster','<?xml version=\"1.0\"?>\n<multiLangText>\n  <description><![CDATA[china Content2]]></description>\n</multiLangText>\n','2020-10-08 22:59:21',0,'2020-10-08 22:59:21','2020-10-08 22:59:21',0);

/*Table structure for table `newsMaster` */


CREATE TABLE `newsMaster` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `type` enum('MARKET','COMPANY') DEFAULT 'MARKET',
  `description` varchar(2000) NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `newsMaster` */

insert  into `newsMaster`(`id`,`type`,`description`,`status`,`createdOn`,`createdBy`,`servCDate`,`modifiedOn`,`modifiedBy`) values (1,'MARKET','english Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint','A','2020-09-03 00:58:41',1,NULL,'2020-09-04 00:45:17',NULL),(2,'COMPANY','Company news English','A','2020-09-01 19:00:35',NULL,NULL,'2020-09-04 00:47:22',NULL),(3,'COMPANY','Company news English 1','A','2020-09-01 19:02:09',NULL,NULL,'2020-09-04 00:47:04',NULL),(4,'MARKET','Duis aute irure dolor in reprehenderit in','A','2020-09-01 19:03:05',NULL,NULL,'2020-09-04 00:45:37',NULL),(5,'COMPANY','Englist Content1','A','2020-09-28 00:18:09',NULL,NULL,'2020-10-08 22:59:21',NULL);

/*Table structure for table `user` */


CREATE TABLE `user` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `userTypeId` int(11) NOT NULL,
  `employeeId` varchar(50) NOT NULL,
  `departmentId` mediumint(9) DEFAULT '0',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `status` char(2) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`id`,`userTypeId`,`employeeId`,`departmentId`,`createdOn`,`createdBy`,`servCDate`,`status`,`modifiedOn`,`modifiedBy`) values (1,1,'123',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00','A','0000-00-00 00:00:00',0);

/*Table structure for table `userType` */


CREATE TABLE `userType` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `description` varchar(2000) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `status` char(2) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `userType` */

insert  into `userType`(`id`,`title`,`description`,`createdOn`,`createdBy`,`servCDate`,`status`,`modifiedOn`,`modifiedBy`) values (1,'admin','check','0000-00-00 00:00:00',0,'0000-00-00 00:00:00','A',NULL,NULL);

