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




/*Table structure for table `aclGroup` */


CREATE TABLE `aclGroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `code` varchar(20) DEFAULT NULL,
  `workArea` varchar(50) NOT NULL,
  `status` enum('A','I','D') NOT NULL DEFAULT 'A',
  `isReverseRole` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` int(9) NOT NULL,
  `createdOn` datetime NOT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `indx_grpName` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `aclGroup` */

insert  into `aclGroup`(`id`,`parentId`,`name`,`code`,`workArea`,`status`,`isReverseRole`,`createdBy`,`createdOn`,`servCDate`) values (1,0,'Dashboard','DASH','MENU','A',0,0,'2020-12-20 21:07:14','2020-12-20 21:07:14'),(2,0,'User Manager','USRM','MENU','A',0,0,'2020-12-20 21:07:29','2020-12-20 21:07:29'),(3,2,'Roles','ROLE','MENU','A',0,0,'2020-12-20 21:07:51','2020-12-20 21:07:51'),(4,2,'Permissions','PERMISSION','MENU','A',0,0,'2020-12-20 21:08:19','2020-12-20 21:08:19');

/*Table structure for table `aclResource` */


CREATE TABLE `aclResource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(25) NOT NULL,
  `controller` varchar(25) NOT NULL,
  `action` varchar(45) NOT NULL,
  `actionType` enum('DUMMY','ORIGINAL') NOT NULL DEFAULT 'ORIGINAL',
  `description` varchar(100) DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `module` (`module`,`controller`,`action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `aclResource` */

/*Table structure for table `aclResourceGroupMapping` */


CREATE TABLE `aclResourceGroupMapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aclGroupId` int(11) NOT NULL,
  `aclResourceId` int(11) NOT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `indx_resoGrp_reso` (`aclGroupId`,`aclResourceId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `aclResourceGroupMapping` */

/*Table structure for table `admin` */


CREATE TABLE `admin` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `regNumber` varchar(50) DEFAULT NULL,
  `codeNo` varchar(100) NOT NULL,
  `salutation` varchar(5) DEFAULT NULL,
  `fName` varchar(50) DEFAULT NULL,
  `mName` varchar(50) DEFAULT NULL,
  `lName` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` char(1) DEFAULT 'm',
  `businessName` varchar(1000) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `createdOn` datetime NOT NULL,
  `createdBy` mediumint(9) NOT NULL,
  `servCDate` datetime NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  `roleId` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `regNumber` (`regNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`id`,`regNumber`,`codeNo`,`salutation`,`fName`,`mName`,`lName`,`dob`,`gender`,`businessName`,`description`,`createdOn`,`createdBy`,`servCDate`,`status`,`modifiedOn`,`modifiedBy`,`roleId`) values (1,'12w','sc','Title','Murli','','Jha','2020-12-01','m','3e','MJ','0000-00-00 00:00:00',0,'0000-00-00 00:00:00','A','2020-12-17 19:08:52',NULL,-1),(2,'123','A2',NULL,NULL,NULL,NULL,NULL,'m','appuser','MJ','0000-00-00 00:00:00',0,'0000-00-00 00:00:00','A',NULL,NULL,0),(3,'','',NULL,NULL,NULL,NULL,NULL,'m','musa',NULL,'2020-11-07 20:32:48',3,'0000-00-00 00:00:00','A','2020-12-12 21:19:56',NULL,5),(5,'qwe','','Title','Santosh','','Gupta','2020-12-19','m','',NULL,'2020-12-20 21:02:54',1,'0000-00-00 00:00:00','A','2020-12-20 21:02:54',1,4);

/*Table structure for table `adminRole` */


CREATE TABLE `adminRole` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `description` varchar(2000) NOT NULL,
  `createdOn` datetime NOT NULL,
  `createdBy` mediumint(9) NOT NULL,
  `servCDate` datetime NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `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 `adminRole` */

insert  into `adminRole`(`id`,`title`,`description`,`createdOn`,`createdBy`,`servCDate`,`status`,`modifiedOn`,`modifiedBy`) values (4,'Admin Role','ABCE','2020-11-19 20:57:14',3,'0000-00-00 00:00:00','A','2020-12-20 21:16:24',1),(5,'ORDER Manager','','2020-11-27 21:24:53',3,'0000-00-00 00:00:00','A','2020-12-12 21:37:33',1);

/*Table structure for table `adminRoleAclGroup` */


CREATE TABLE `adminRoleAclGroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refId` int(11) NOT NULL,
  `type` enum('admin') NOT NULL,
  `workArea` varchar(50) DEFAULT NULL,
  `aclGroupId` int(11) NOT NULL,
  `createdBy` int(9) NOT NULL,
  `createdOn` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `indx_userRole_aclGrp` (`refId`,`aclGroupId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

/*Data for the table `adminRoleAclGroup` */

insert  into `adminRoleAclGroup`(`id`,`refId`,`type`,`workArea`,`aclGroupId`,`createdBy`,`createdOn`) values (100,5,'admin','MENU',9,1,'2020-12-13 00:00:00'),(101,5,'admin','MENU',13,1,'2020-12-13 00:00:00'),(102,5,'admin','MENU',14,1,'2020-12-13 00:00:00'),(103,5,'admin','MENU',17,1,'2020-12-13 00:00:00'),(104,5,'admin','MENU',16,1,'2020-12-13 00:00:00'),(105,5,'admin','MENU',11,1,'2020-12-13 00:00:00'),(106,5,'admin','MENU',12,1,'2020-12-13 00:00:00'),(107,5,'admin','MENU',5,1,'2020-12-13 00:00:00'),(108,5,'admin','MENU',7,1,'2020-12-13 00:00:00'),(109,5,'admin','MENU',6,1,'2020-12-13 00:00:00'),(110,5,'admin','MENU',8,1,'2020-12-13 00:00:00'),(111,4,'admin','MENU',1,1,'2020-12-21 00:00:00'),(112,4,'admin','MENU',2,1,'2020-12-21 00:00:00'),(113,4,'admin','MENU',4,1,'2020-12-21 00:00:00');

/*Table structure for table `adminSettings` */


CREATE TABLE `adminSettings` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `currency` varchar(50) DEFAULT NULL,
  `convertionRate` decimal(18,6) DEFAULT NULL,
  `convertionMargin` decimal(18,6) DEFAULT NULL,
  `convertionRateC` decimal(18,6) DEFAULT NULL,
  `serviceChargeC` decimal(18,6) DEFAULT NULL,
  `serviceCharge` decimal(18,6) DEFAULT NULL,
  `bsb` varchar(50) DEFAULT NULL,
  `siteNotification` text,
  `siteNoticePopup` text,
  `accountNo` varchar(50) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table `adminSettings` */

insert  into `adminSettings`(`id`,`currency`,`convertionRate`,`convertionMargin`,`convertionRateC`,`serviceChargeC`,`serviceCharge`,`bsb`,`siteNotification`,`siteNoticePopup`,`accountNo`,`createdOn`,`servCDate`,`modifiedOn`,`modifiedBy`) values (3,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','Covid 19',NULL,'s','2020-07-08 01:00:22',NULL,'2020-07-08 01:00:22',3),(4,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇',NULL,'s','2020-10-18 13:19:01',NULL,'2020-10-18 13:19:01',3),(5,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇',NULL,'s','2020-10-18 13:21:57',NULL,'2020-10-18 13:21:57',3),(6,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇','aaa','s','2020-12-04 21:15:23',NULL,'2020-12-04 21:15:23',3),(7,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇','aaa','s','2020-12-04 21:15:27',NULL,'2020-12-04 21:15:27',3),(8,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇','aaa ccc','s','2020-12-04 21:15:31',NULL,'2020-12-04 21:15:31',3),(9,'AUD',80.000000,NULL,82.000000,10.000000,10.000000,'s','关于天天速汇','Dear Customer,<br /> We Don\'t take Standard Charter Bank at all and NABIL bank more than $2000. ','s','2020-12-04 21:40:03',NULL,'2020-12-04 21:40:03',3);

/*Table structure for table `bcode` */


CREATE TABLE `bcode` (
  `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=3 DEFAULT CHARSET=utf8 COMMENT='to store browser settings';

/*Data for the table `bcode` */

insert  into `bcode`(`id`,`name`,`val`,`createdOn`,`updatedOn`) values (1,'siteStatus','76dfbed24aa0336a9bb633e9dd692190','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'santosh','3444','0000-00-00 00:00:00','0000-00-00 00:00:00');

/*Table structure for table `beneficiary` */


CREATE TABLE `beneficiary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `address` varchar(500) DEFAULT NULL,
  `account` varchar(50) DEFAULT NULL,
  `bank` varchar(100) DEFAULT NULL,
  `createdBy` int(9) NOT NULL,
  `createdOn` datetime NOT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `indx_benefName` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `beneficiary` */

insert  into `beneficiary`(`id`,`customerId`,`name`,`address`,`account`,`bank`,`createdBy`,`createdOn`,`servCDate`) values (1,9,'Mohan','ranti','123','pnb',1,'2021-03-17 21:40:02','2021-03-17 21:40:02');

/*Table structure for table `cashCounter` */


CREATE TABLE `cashCounter` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `description` varchar(2000) NOT NULL,
  `createdOn` datetime NOT NULL,
  `createdBy` mediumint(9) NOT NULL,
  `servCDate` datetime DEFAULT NULL,
  `modifiedOn` datetime NOT NULL,
  `modifiedBy` mediumint(9) NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `counterStatus` enum('OPEN','CLOSE') NOT NULL DEFAULT 'CLOSE',
  `adminId` mediumint(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `cashCounter` */

insert  into `cashCounter`(`id`,`title`,`description`,`createdOn`,`createdBy`,`servCDate`,`modifiedOn`,`modifiedBy`,`status`,`counterStatus`,`adminId`) values (1,'cash counter','','2021-01-24 17:31:19',1,NULL,'2021-02-16 22:03:23',1,'A','OPEN',1);

/*Table structure for table `cashCounterSession` */


CREATE TABLE `cashCounterSession` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `counterId` int(11) NOT NULL,
  `counterStatus` enum('OPEN','CLOSE') NOT NULL DEFAULT 'OPEN',
  `createdBy` int(11) NOT NULL,
  `createdOn` datetime NOT NULL,
  `modifiedBy` int(11) DEFAULT NULL,
  `modifiedOn` datetime NOT NULL,
  `servCDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `indx_countersession_counter_status` (`counterId`,`counterStatus`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `cashCounterSession` */

insert  into `cashCounterSession`(`id`,`counterId`,`counterStatus`,`createdBy`,`createdOn`,`modifiedBy`,`modifiedOn`,`servCDate`) values (2,1,'CLOSE',1,'2021-01-31 14:24:21',1,'2021-01-31 14:30:43','2021-01-31 14:24:21'),(3,1,'CLOSE',1,'2021-01-31 14:31:18',1,'2021-01-31 15:37:03','2021-01-31 14:31:18'),(4,1,'OPEN',1,'2021-01-31 15:40:14',1,'2021-01-31 15:40:14','2021-01-31 15:40:14'),(5,1,'OPEN',1,'2021-02-16 22:03:23',1,'2021-02-16 22:03:23','2021-02-16 22:03:23');

/*Table structure for table `cashDrawerMaster` */


CREATE TABLE `cashDrawerMaster` (
  `id` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `counterId` mediumint(9) NOT NULL,
  `currency` char(3) NOT NULL,
  `createdOn` datetime NOT NULL,
  `createdBy` mediumint(9) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `cashDrawerMaster` */

insert  into `cashDrawerMaster`(`id`,`counterId`,`currency`,`createdOn`,`createdBy`) values (1,1,'USD','0000-00-00 00:00:00',1),(2,1,'AUD','0000-00-00 00:00:00',1),(3,1,'CNY','0000-00-00 00:00:00',1);

/*Table structure for table `companyAccount` */


CREATE TABLE `companyAccount` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `accCurr` varchar(50) DEFAULT NULL,
  `accName` varchar(50) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `companyAccount` */

insert  into `companyAccount`(`id`,`accCurr`,`accName`,`status`,`createdOn`,`createdBy`,`servCDate`) values (1,'USD','HDBC UNCffff','A','2021-01-21 21:51:25',1,'2021-01-21 21:51:25');

/*Table structure for table `companyAccountStatement` */


CREATE TABLE `companyAccountStatement` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) DEFAULT '0',
  `transDate` date DEFAULT NULL,
  `currency` char(3) NOT NULL,
  `amount` decimal(18,6) DEFAULT '0.000000',
  `accountType` enum('CASH','NCASH') DEFAULT 'CASH',
  `accountId` int(11) DEFAULT '0',
  `description` varchar(100) DEFAULT NULL,
  `transType` enum('WITHDRAW','DEPOSIT') DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(11) DEFAULT '0',
  `modifiedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` mediumint(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `indx_transDate` (`transDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `contactAddressMaster` */


CREATE TABLE `contactAddressMaster` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `refId` int(11) NOT NULL,
  `tableName` varchar(30) NOT NULL,
  `phoneNo` varchar(50) NOT NULL,
  `phExtention` varchar(20) NOT NULL,
  `mobileNo` varchar(50) DEFAULT NULL,
  `mobileNo2` varchar(50) NOT NULL,
  `faxNo` varchar(50) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `email2` varchar(50) NOT NULL,
  `website` varchar(500) NOT NULL,
  `address1` varchar(500) NOT NULL,
  `address2` varchar(500) NOT NULL,
  `city` varchar(500) NOT NULL,
  `stateId` mediumint(9) NOT NULL,
  `otherState` varchar(500) NOT NULL,
  `zipCode` varchar(100) NOT NULL,
  `countryId` mediumint(9) NOT NULL,
  `status` char(2) NOT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` int(11) NOT NULL DEFAULT '0',
  `servCDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `countryId` (`countryId`),
  KEY `stateId` (`stateId`),
  KEY `refId` (`refId`,`tableName`)
) ENGINE=InnoDB AUTO_INCREMENT=16216 DEFAULT CHARSET=utf8;

/*Data for the table `contactAddressMaster` */

insert  into `contactAddressMaster`(`id`,`refId`,`tableName`,`phoneNo`,`phExtention`,`mobileNo`,`mobileNo2`,`faxNo`,`email`,`email2`,`website`,`address1`,`address2`,`city`,`stateId`,`otherState`,`zipCode`,`countryId`,`status`,`modifiedOn`,`modifiedBy`,`servCDate`) values (1,1,'admin','','','99680','','','m@g.com','m@g.com','','','','',191,'','',13,'',NULL,0,NULL),(16212,9,'customer','','','99','99','','murlijha82@gmail.com','murlijha82@gmail.com','','abcdfff','','madhubani',1479,'','124',99,'',NULL,0,NULL),(16213,7,'customer','','','99','89','','murlijha82@gmail.com','jhamurli@ymail.com','','sdsd','','sssd',1479,'','',99,'',NULL,0,NULL),(16214,10,'customer','','','9968040558','22','','murlijha82@gmail.com','murlijha82@gmail.com','','aaa','','madhubani',1479,'','456',99,'',NULL,0,NULL),(16215,5,'admin','','','1234','','','abc@xyz','','','','','',1479,'','',99,'',NULL,0,NULL);

/*Table structure for table `countries` */


CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `iso_code_2` char(2) NOT NULL DEFAULT '',
  `iso_code_3` char(3) NOT NULL DEFAULT '',
  `currShortName` char(5) DEFAULT NULL,
  `status` char(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_COUNTRIES_NAME` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8;

/*Data for the table `countries` */

insert  into `countries`(`id`,`name`,`iso_code_2`,`iso_code_3`,`currShortName`,`status`) values (1,'Afghanistan','AF','AFG','AFN','A'),(2,'Albania','AL','ALB','ALL','A'),(3,'Algeria','DZ','DZA','DZD','A'),(4,'American Samoa','AS','ASM','USD','A'),(5,'Andorra','AD','AND','EUR','A'),(6,'Angola','AO','AGO','AOA','A'),(7,'Anguilla','AI','AIA','XCD','A'),(8,'Antarctica','AQ','ATA','USD','A'),(9,'Antigua and Barbuda','AG','ATG','XCD','A'),(10,'Argentina','AR','ARG','ARS','A'),(11,'Armenia','AM','ARM','AMD','A'),(12,'Aruba','AW','ABW','AWG','A'),(13,'Australia','AU','AUS','AUD','A'),(14,'Austria','AT','AUT','EUR','A'),(15,'Azerbaijan','AZ','AZE','AZN','A'),(16,'Bahamas','BS','BHS','BSD','A'),(17,'Bahrain','BH','BHR','BHD','A'),(18,'Bangladesh','BD','BGD','BDT','A'),(19,'Barbados','BB','BRB','BBD','A'),(20,'Belarus','BY','BLR','BYR','A'),(21,'Belgium','BE','BEL','EUR','A'),(22,'Belize','BZ','BLZ','BZD','A'),(23,'Benin','BJ','BEN','USD','A'),(24,'Bermuda','BM','BMU','BMD','A'),(25,'Bhutan','BT','BTN','INR','A'),(26,'Bolivia','BO','BOL','BOB','A'),(27,'Bosnia and Herzegowina','BA','BIH','BAM','A'),(28,'Botswana','BW','BWA','BWP','A'),(29,'Bouvet Island','BV','BVT','GBP','A'),(30,'Brazil','BR','BRA','BRL','A'),(31,'British Indian Ocean Territory','IO','IOT','GBP','A'),(32,'Brunei Darussalam','BN','BRN','BND','A'),(33,'Bulgaria','BG','BGR','BGN','A'),(34,'Burkina Faso','BF','BFA','USD','A'),(35,'Burundi','BI','BDI','USD','A'),(36,'Cambodia','KH','KHM','KHR','A'),(37,'Cameroon','CM','CMR','XAF','A'),(38,'Canada','CA','CAN','CAD','A'),(39,'Cape Verde','CV','CPV','CVE','A'),(40,'Cayman Islands','KY','CYM','KYD','A'),(41,'Central African Republic','CF','CAF','XAF','A'),(42,'Chad','TD','TCD','XAF','A'),(43,'Chile','CL','CHL','CLP','A'),(44,'China','CN','CHN','CNY','A'),(45,'Christmas Island','CX','CXR','AUD','A'),(46,'Cocos (Keeling), Islands','CC','CCK','AUD','A'),(47,'Colombia','CO','COL','COP','A'),(48,'Comoros','KM','COM','USD','A'),(49,'Congo','CG','COG','XAF','A'),(50,'Cook Islands','CK','COK','NZD','A'),(51,'Costa Rica','CR','CRI','CRC','A'),(52,'Cote DIvoire','CI','CIV','USD','A'),(53,'Croatia','HR','HRV','HRK','A'),(54,'Cuba','CU','CUB','CUP','A'),(55,'Cyprus','CY','CYP','EUR','A'),(56,'Czech Republic','CZ','CZE','CZK','A'),(57,'Denmark','DK','DNK','DKK','A'),(58,'Djibouti','DJ','DJI','DJF','A'),(59,'Dominica','DM','DMA','XCD','A'),(60,'Dominican Republic','DO','DOM','DOP','A'),(61,'East Timor','TP','TMP','USD','A'),(62,'Ecuador','EC','ECU','USD','A'),(63,'Egypt','EG','EGY','EGP','A'),(64,'El Salvador','SV','SLV','SVC','A'),(65,'Equatorial Guinea','GQ','GNQ','EUR','A'),(66,'Eritrea','ER','ERI','USD','A'),(67,'Estonia','EE','EST','EEK','A'),(68,'Ethiopia','ET','ETH','ETB','A'),(69,'Falkland Islands (Malvinas),','FK','FLK','FKP','A'),(70,'Faroe Islands','FO','FRO','DKK','A'),(71,'Fiji','FJ','FJI','FJD','A'),(72,'Finland','FI','FIN','EUR','A'),(73,'France','FR','FRA','EUR','A'),(74,'France, Metropolitan','FX','FXX','EUR','A'),(75,'French Guiana','GF','GUF','EUR','A'),(76,'French Polynesia','PF','PYF','FKP','A'),(77,'French Southern Territories','TF','ATF','EUR','A'),(78,'Gabon','GA','GAB','XAF','A'),(79,'Gambia','GM','GMB','XAF','A'),(80,'Georgia','GE','GEO','GEL','A'),(81,'Germany','DE','DEU','EUR','A'),(82,'Ghana','GH','GHA','GHS','A'),(83,'Gibraltar','GI','GIB','GIP','A'),(84,'Greece','GR','GRC','EUR','A'),(85,'Greenland','GL','GRL','DKK','A'),(86,'Grenada','GD','GRD','XCD','A'),(87,'Guadeloupe','GP','GLP','EUR','A'),(88,'Guam','GU','GUM','USD','A'),(89,'Guatemala','GT','GTM','GTQ','A'),(90,'Guinea','GN','GIN','XAF','A'),(91,'Guinea-bissau','GW','GNB','XAF','A'),(92,'Guyana','GY','GUY','GYD','A'),(93,'Haiti','HT','HTI','HTG','A'),(94,'Heard and Mc Donald Islands','HM','HMD','USD','A'),(95,'Honduras','HN','HND','HNL','A'),(96,'Hong Kong','HK','HKG','HKD','A'),(97,'Hungary','HU','HUN','HUF','A'),(98,'Iceland','IS','ISL','ISK','A'),(99,'India','IN','IND','INR','A'),(100,'Indonesia','ID','IDN','IDR','A'),(101,'Iran (Islamic Republic of),','IR','IRN','IRR','A'),(102,'Iraq','IQ','IRQ','IQD','A'),(103,'Ireland','IE','IRL','EUR','A'),(104,'Israel','IL','ISR','ILS','A'),(105,'Italy','IT','ITA','EUR','A'),(106,'Jamaica','JM','JAM','JMD','A'),(107,'Japan','JP','JPN','JPY','A'),(108,'Jordan','JO','JOR','JOD','A'),(109,'Kazakhstan','KZ','KAZ','KZT','A'),(110,'Kenya','KE','KEN','KES','A'),(111,'Kiribati','KI','KIR','AUD','A'),(112,'Korea, Democratic Peoples Republic of','KP','PRK','KPW','A'),(113,'Korea, Republic of','KR','KOR','KPW','A'),(114,'Kuwait','KW','KWT','KWD','A'),(115,'Kyrgyzstan','KG','KGZ','KGS','A'),(116,'Lao Peoples Democratic Republic','LA','LAO','USD','A'),(117,'Latvia','LV','LVA','LVL','A'),(118,'Lebanon','LB','LBN','LBP','A'),(119,'Lesotho','LS','LSO','LSL','A'),(120,'Liberia','LR','LBR','LRD','A'),(121,'Libyan Arab Jamahiriya','LY','LBY','LYD','A'),(122,'Liechtenstein','LI','LIE','CHF','A'),(123,'Lithuania','LT','LTU','LTL','A'),(124,'Luxembourg','LU','LUX','EUR','A'),(125,'Macau','MO','MAC','MKD','A'),(126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','MKD','A'),(127,'Madagascar','MG','MDG','MGA','A'),(128,'Malawi','MW','MWI','MWK','A'),(129,'Malaysia','MY','MYS','MYR','A'),(130,'Maldives','MV','MDV','MVR','A'),(131,'Mali','ML','MLI','XCD','A'),(132,'Malta','MT','MLT','EUR','A'),(133,'Marshall Islands','MH','MHL','USD','A'),(134,'Martinique','MQ','MTQ','EUR','A'),(135,'Mauritania','MR','MRT','MRO','A'),(136,'Mauritius','MU','MUS','MUR','A'),(137,'Mayotte','YT','MYT','EUR','A'),(138,'Mexico','MX','MEX','MXN','A'),(139,'Micronesia, Federated States of','FM','FSM','USD','A'),(140,'Moldova, Republic of','MD','MDA','MDL','A'),(141,'Monaco','MC','MCO','EUR','A'),(142,'Mongolia','MN','MNG','MNT','A'),(143,'Montserrat','MS','MSR','XCD','A'),(144,'Morocco','MA','MAR','MAD','A'),(145,'Mozambique','MZ','MOZ','MZN','A'),(146,'Myanmar','MM','MMR','MMK','A'),(147,'Namibia','NA','NAM','NAD','A'),(148,'Nauru','NR','NRU','AUD','A'),(149,'Nepal','NP','NPL','NPR','A'),(150,'Netherlands','NL','NLD','EUR','A'),(151,'Dutch Caribbean','NL','NLD','ANG','A'),(152,'New Caledonia','NC','NCL','AUD','A'),(153,'New Zealand','NZ','NZL','NZD','A'),(154,'Nicaragua','NI','NIC','NIO','A'),(155,'Niger','NE','NER','XCD','A'),(156,'Nigeria','NG','NGA','NGN','A'),(157,'Niue','NU','NIU','NZD','A'),(158,'Norfolk Island','NF','NFK','AUD','A'),(159,'Northern Mariana Islands','MP','MNP','USD','A'),(160,'Norway','NO','NOR','NOK','A'),(161,'Oman','OM','OMN','OMR','A'),(162,'Pakistan','PK','PAK','PKR','A'),(163,'Palau','PW','PLW','USD','A'),(164,'Panama','PA','PAN','PAB','A'),(165,'Papua New Guinea','PG','PNG','PGK','A'),(166,'Paraguay','PY','PRY','PYG','A'),(167,'Peru','PE','PER','PEN','A'),(168,'Philippines','PH','PHL','PHP','A'),(169,'Pitcairn','PN','PCN','NZD','A'),(170,'Poland','PL','POL','PLN','A'),(171,'Portugal','PT','PRT','EUR','A'),(172,'Puerto Rico','PR','PRI','USD','A'),(173,'Qatar','QA','QAT','QAR','A'),(174,'Reunion','RE','REU','USD','A'),(175,'Romania','RO','ROM','RON','A'),(176,'Russian Federation','RU','RUS','RUB','A'),(177,'Rwanda','RW','RWA','RWF','A'),(178,'Saint Kitts and Nevis','KN','KNA','XCD','A'),(179,'Saint Lucia','LC','LCA','XCD','A'),(180,'Saint Vincent and the Grenadines','VC','VCT','XCD','A'),(181,'Samoa','WS','WSM','WST','A'),(182,'San Marino','SM','SMR','EUR','A'),(183,'Sao Tome and Principe','ST','STP','STD','A'),(184,'Saudi Arabia','SA','SAU','SAR','A'),(185,'Senegal','SN','SEN','XAF','A'),(186,'Seychelles','SC','SYC','SCR','A'),(187,'Sierra Leone','SL','SLE','SLL','A'),(188,'Singapore','SG','SGP','SGD','A'),(189,'Slovakia (Slovak Republic),','SK','SVK','EUR','A'),(190,'Slovenia','SI','SVN','EUR','A'),(191,'Solomon Islands','SB','SLB','SBD','A'),(192,'Somalia','SO','SOM','SOS','A'),(193,'South Africa','ZA','ZAF','ZAR','A'),(194,'South Georgia and the South Sandwich Islands','GS','SGS','GBP','A'),(195,'Spain','ES','ESP','EUR','A'),(196,'Sri Lanka','LK','LKA','LKR','A'),(197,'St. Helena','SH','SHN','SHP','A'),(198,'St. Pierre and Miquelon','PM','SPM','EUR','A'),(199,'Sudan','SD','SDN','SDG','A'),(200,'Suriname','SR','SUR','SRD','A'),(201,'Svalbard and Jan Mayen Islands','SJ','SJM','NOK','A'),(202,'Swaziland','SZ','SWZ','SZL','A'),(203,'Sweden','SE','SWE','SEK','A'),(204,'Switzerland','CH','CHE','CHF','A'),(205,'Syrian Arab Republic','SY','SYR','SYP','A'),(206,'Taiwan','TW','TWN','TWD','A'),(207,'Tajikistan','TJ','TJK','RUB','A'),(208,'Tanzania, United Republic of','TZ','TZA','TZS','A'),(209,'Thailand','TH','THA','THB','A'),(210,'Togo','TG','TGO','XCD','A'),(211,'Tokelau','TK','TKL','NZD','A'),(212,'Tonga','TO','TON','TOP','A'),(213,'Trinidad and Tobago','TT','TTO','TTD','A'),(214,'Tunisia','TN','TUN','TND','A'),(215,'Turkey','TR','TUR','TRY','A'),(216,'Turkmenistan','TM','TKM','TMT','A'),(217,'Turks and Caicos Islands','TC','TCA','USD','A'),(218,'Tuvalu','TV','TUV','TVD','A'),(219,'Uganda','UG','UGA','UGX','A'),(220,'Ukraine','UA','UKR','UAH','A'),(221,'United Arab Emirates','AE','ARE','AED','A'),(222,'United Kingdom','GB','GBR','GBP','A'),(223,'United States','US','USA','USD','A'),(224,'United States Minor Outlying Islands','UM','UMI','USD','A'),(225,'Uruguay','UY','URY','UYU','A'),(226,'Uzbekistan','UZ','UZB','UZS','A'),(227,'Vanuatu','VU','VUT','VUV','A'),(228,'Vatican City State (Holy See),','VA','VAT','EUR','A'),(229,'Venezuela','VE','VEN','VEF','A'),(230,'Viet Nam','VN','VNM','VND','A'),(231,'Virgin Islands (British),','VG','VGB','GBP','A'),(232,'Virgin Islands (U.S.),','VI','VIR','USD','A'),(233,'Wallis and Futuna Islands','WF','WLF','AUD','A'),(234,'Western Sahara','EH','ESH','MAD','A'),(235,'Yemen','YE','YEM','YER','A'),(236,'Yugoslavia','YU','YUG','DIN','A'),(237,'Zaire','ZR','ZAR','CDF','A'),(238,'Zambia','ZM','ZMB','ZMW','A'),(239,'Zimbabwe','ZW','ZWE','ZWD','A'),(240,'Cura&#231ao','CW','CUW','ANG','A'),(241,'Sint Maarten','MF','MAF','ANG','A'),(242,'Bonaire, Sint Eustatius AND Saba','BQ','BES','USD','A'),(243,'Serbia','RS','SRB','RSD','A'),(244,'Jersey','JE','JEY','GBP','A'),(245,'Scotland','AB','SCT','GBP','A');

/*Table structure for table `currencyMaster_del` */


CREATE TABLE `currencyMaster_del` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `currName` varchar(50) NOT NULL,
  `baseCurr` char(5) DEFAULT NULL,
  `toCurr` char(5) 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',
  `decimal` varchar(30) DEFAULT NULL,
  `smallName` varchar(200) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `currOrder` mediumint(3) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8;

/*Data for the table `currencyMaster_del` */

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

/*Table structure for table `customer` */


CREATE TABLE `customer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `regNumber` bigint(20) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'A',
  `customerType` enum('I','C','V') NOT NULL DEFAULT 'I' COMMENT 'I:Indivisual, C:Corporate',
  `companyName` varchar(100) DEFAULT NULL,
  `companyInfo` varchar(200) DEFAULT NULL,
  `salutation` varchar(5) DEFAULT NULL,
  `fName` varchar(50) DEFAULT NULL,
  `mName` varchar(50) DEFAULT NULL,
  `lName` varchar(50) NOT NULL,
  `dob` date NOT NULL,
  `gender` char(1) NOT NULL DEFAULT 'm',
  `risk` char(1) NOT NULL DEFAULT 'l',
  `designation` varchar(50) DEFAULT NULL,
  `referrer` varchar(50) NOT NULL,
  `occupation` varchar(50) DEFAULT NULL,
  `id_json` varchar(10000) DEFAULT NULL,
  `contact_json` varchar(10000) DEFAULT NULL,
  `file_json` varchar(1000) DEFAULT NULL,
  `message` varchar(2000) DEFAULT NULL,
  `notes` varchar(2000) DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `customer` */

insert  into `customer`(`id`,`regNumber`,`status`,`customerType`,`companyName`,`companyInfo`,`salutation`,`fName`,`mName`,`lName`,`dob`,`gender`,`risk`,`designation`,`referrer`,`occupation`,`id_json`,`contact_json`,`file_json`,`message`,`notes`,`createdBy`,`updatedBy`,`createdOn`,`updatedOn`) values (7,9596,'A','V',NULL,NULL,NULL,'Murli',NULL,'Jha','2020-12-12','f','m',NULL,'2','Engineerrr','[{\"idType\":\"other\",\"otherID\":\"iiii\",\"idNumber\":\"abcd\",\"holderName\":\"h\",\"issuer\":\"o\",\"issueDate\":\"2022-11-11\",\"expiryDate\":\"2020-05-05\"},{\"idType\":\"au_post_keypass_id\",\"otherID\":\"\",\"idNumber\":\"fd\",\"holderName\":\"ddhhh\",\"issuer\":\"dfdjk\",\"issueDate\":\"2020-02-02\",\"expiryDate\":\"2020-03-03\"}]',NULL,'[{\"name\":\"photo\",\"full_path\":\"\\/var\\/www\\/html\\/fxsoft\\/data\\/customer\\/7_ID_0.jpeg\"},{\"name\":\"bijliBill\",\"full_path\":\"\\/var\\/www\\/html\\/fxsoft\\/data\\/customer\\/7_ID_1.jpeg\"}]','dssgggggggggg','ddfd',1,1,'2021-01-20 23:49:46','2021-01-20 21:24:54'),(9,5191,'A','I',NULL,NULL,NULL,'Santosh',NULL,'Jee','2007-06-05','m','l',NULL,'pawan','manager','[{\"idType\":\"passport\",\"otherID\":\"\",\"idNumber\":\"xyz\",\"holderName\":\"holder\",\"issuer\":\"is\",\"issueDate\":\"2020-12-12\",\"expiryDate\":\"2020-12-12\"},{\"idType\":\"photo_card\",\"otherID\":\"\",\"idNumber\":\"kkk\",\"holderName\":\"mj\",\"issuer\":\"austlie\",\"issueDate\":\"\",\"expiryDate\":\"\"}]',NULL,NULL,'ddd','tfr',1,1,'2021-01-17 20:48:31','2021-01-17 20:48:31'),(10,7166,'A','C','MusaSoftech1','musaSoftech',NULL,NULL,NULL,'','2002-11-11','m','m',NULL,'1',NULL,'[{\"idType\":\"other\",\"otherID\":\"id1\",\"idNumber\":\"idnumber\",\"holderName\":\"holder name\",\"issuer\":\"austrelia\",\"issueDate\":\"2020-11-11\",\"expiryDate\":\"2020-02-20\"},{\"idType\":\"au_business_no\",\"otherID\":\"id 2\",\"idNumber\":\"idnumer244\",\"holderName\":\"mohan\",\"issuer\":\"austrlie\",\"issueDate\":\"2020-03-02\",\"expiryDate\":\"2020-03-01\"}]','[{\"name\":\"mis menuk\",\"gender\":\"o\",\"position\":\"Manager\",\"address\":\"delhi\",\"mobile\":\"11\",\"idType\":\"passport\",\"otherID\":\"\",\"idNumber\":\"ddd\",\"holderName\":\"dddd\",\"issuer\":\"ddd\",\"issueDate\":\"2020-11-11\",\"expiryDate\":\"2020-03-02\"},{\"name\":\"mohan\",\"gender\":\"f\",\"position\":\"Directoer\",\"address\":\"fff\",\"mobile\":\"ddd\",\"idType\":\"other\",\"otherID\":\"DSC\",\"idNumber\":\"ddd\",\"holderName\":\"ddfd\",\"issuer\":\"ddd\",\"issueDate\":\"2020-02-02\",\"expiryDate\":\"2020-01-01\"}]','[{\"name\":\"voter\",\"full_path\":\"\\/var\\/www\\/html\\/fxsoft\\/data\\/ccustomer\\/10_CID_0.jpeg\"},{\"name\":\"addar\",\"full_path\":\"\\/var\\/www\\/html\\/fxsoft\\/data\\/ccustomer\\/10_CID_0_1.jpeg\"}]','ok','notes',1,1,'2021-01-20 21:21:44','2021-01-20 21:21:44');

/*Table structure for table `customerAccountMaster` */


CREATE TABLE `customerAccountMaster` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `customerId` mediumint(9) DEFAULT NULL,
  `accCurr` char(5) DEFAULT NULL,
  `accType` enum('CASH','NCASH') DEFAULT 'CASH',
  `lastBalance` decimal(18,6) DEFAULT '0.000000',
  `balance` decimal(18,6) DEFAULT '0.000000',
  `status` char(1) NOT NULL DEFAULT 'A',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniqueCustomerAccount` (`customerId`,`accCurr`,`accType`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `customerAccountMaster` */

insert  into `customerAccountMaster`(`id`,`customerId`,`accCurr`,`accType`,`lastBalance`,`balance`,`status`,`createdOn`,`createdBy`,`modifiedBy`,`modifiedOn`,`servCDate`) values (1,9,'USD','CASH',0.000000,0.000000,'A','2021-01-05 21:29:56',1,1,'2021-01-05 21:29:56','2021-01-05 21:29:56'),(2,9,'USD','NCASH',350.000000,375.000000,'A','2021-01-05 21:36:22',1,1,'2021-03-02 13:27:00','2021-01-05 21:36:22'),(3,9,'CNY','CASH',400.000000,400.000000,'A','2021-02-17 21:58:53',1,1,'2021-03-02 12:46:22','2021-02-17 21:58:53'),(4,9,'CNY','NCASH',0.000000,0.000000,'A','2021-02-17 22:02:12',1,1,'2021-02-17 22:02:12','2021-02-17 22:02:12'),(5,9,'AUD','NCASH',0.000000,700.000000,'A','2021-03-03 15:23:42',1,1,'2021-03-03 16:08:42','2021-03-03 15:23:42');

/*Table structure for table `customerDeposit` */


CREATE TABLE `customerDeposit` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `customerId` mediumint(9) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `depositType` varchar(5) DEFAULT 'CASH',
  `customerAccount` varchar(5) DEFAULT NULL,
  `companyAccountId` int(9) DEFAULT '0',
  `clearStatus` tinyint(1) DEFAULT '0',
  `clearAmount` decimal(18,6) DEFAULT '0.000000',
  `clearDetail` varchar(1000) DEFAULT NULL,
  `fdClearDetail` varchar(1000) DEFAULT NULL,
  `amount` decimal(18,6) DEFAULT '0.000000',
  `depositDetail` varchar(500) DEFAULT NULL,
  `sourceOfFund` varchar(500) DEFAULT NULL,
  `file_json` varchar(1000) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `clearedOn` datetime DEFAULT NULL,
  `clearedBy` mediumint(9) DEFAULT NULL,
  `fdClearedOn` datetime DEFAULT NULL,
  `fdClearedBy` mediumint(9) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT '0',
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

/*Data for the table `customerDeposit` */

insert  into `customerDeposit`(`id`,`customerId`,`currency`,`depositType`,`customerAccount`,`companyAccountId`,`clearStatus`,`clearAmount`,`clearDetail`,`fdClearDetail`,`amount`,`depositDetail`,`sourceOfFund`,`file_json`,`status`,`clearedOn`,`clearedBy`,`fdClearedOn`,`fdClearedBy`,`modifiedOn`,`modifiedBy`,`createdOn`,`createdBy`,`servCDate`) values (1,9,'USD','CASH','NCASH',1,0,0.000000,NULL,NULL,499.000000,'kkk','ggg',NULL,'A',NULL,NULL,NULL,NULL,NULL,NULL,'2021-02-20 22:23:34',1,'2021-02-20 22:23:34'),(2,9,'CNY','CASH','NCASH',0,0,0.000000,NULL,NULL,300.000000,'fff','www',NULL,'A',NULL,NULL,NULL,NULL,NULL,NULL,'2021-02-21 18:51:49',1,'2021-02-21 18:51:49'),(3,9,'USD','CASH','CASH',1,0,0.000000,NULL,NULL,100.000000,'hh','hhdd',NULL,'A',NULL,NULL,NULL,NULL,'2021-02-24 16:07:03',1,'2021-02-24 16:07:03',1,'2021-02-24 16:07:03'),(4,9,'USD','NCASH','NCASH',1,2,350.000000,'ok',NULL,400.000000,'gg','ddd',NULL,'A','2021-03-02 11:30:22',1,'2021-03-02 12:14:51',1,'2021-03-02 12:14:51',1,'2021-02-24 16:10:06',1,'2021-02-24 16:10:06'),(6,9,'USD','CASH','CASH',1,1,300.000000,'ok',NULL,400.000000,'f','d','[{\"name\":\"depositFile\",\"full_path\":\"\\/var\\/www\\/html\\/fxsoft\\/data\\/deposit\\/6_ID_0.png\"}]','A',NULL,NULL,NULL,NULL,'2021-02-26 21:57:00',1,'2021-02-24 16:39:49',1,'2021-02-24 16:39:49'),(7,9,'USD','CASH','CASH',1,1,600.000000,'ok',NULL,700.000000,'g','g',NULL,'A','2021-02-27 18:56:18',1,NULL,NULL,'2021-02-27 18:56:18',1,'2021-02-24 16:59:11',1,'2021-02-24 16:59:11'),(13,9,'CNY','CASH','CASH',0,0,400.000000,NULL,NULL,400.000000,'h','d',NULL,'A',NULL,NULL,NULL,NULL,'2021-03-02 12:29:15',1,'2021-03-02 12:29:15',1,'2021-03-02 12:29:15'),(18,9,'CNY','CASH','CASH',0,0,400.000000,NULL,NULL,400.000000,'fff','sss',NULL,'A',NULL,NULL,NULL,NULL,'2021-03-02 12:46:22',1,'2021-03-02 12:46:22',1,'2021-03-02 12:46:22'),(19,9,'USD','NCASH','NCASH',1,2,375.000000,'ok',NULL,400.000000,'f','d',NULL,'A','2021-03-02 13:25:52',1,'2021-03-02 13:27:00',1,'2021-03-02 13:27:00',1,'2021-03-02 13:25:31',1,'2021-03-02 13:25:31'),(20,9,'AUD','NCASH','NCASH',1,2,700.000000,'ok','s',697.000000,'','',NULL,'A','2021-03-03 16:05:02',1,'2021-03-03 16:08:42',1,'2021-03-03 16:08:42',1,'2021-03-03 16:02:25',1,'2021-03-03 16:02:25');

/*Table structure for table `customerWithdraw` */


CREATE TABLE `customerWithdraw` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `customerId` mediumint(9) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `withdrawType` varchar(5) DEFAULT 'CASH',
  `customerAccount` varchar(5) DEFAULT NULL,
  `companyAccountId` int(9) DEFAULT '0',
  `amount` decimal(18,6) DEFAULT '0.000000',
  `fee` decimal(18,6) DEFAULT '0.000000',
  `feeType` varchar(6) DEFAULT 'CASH',
  `feeAccountCurr` varchar(3) DEFAULT 'AUD',
  `beneficiaryId` int(9) DEFAULT '0',
  `beneficiary_json` varchar(1000) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'A',
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `modifiedBy` mediumint(9) DEFAULT '0',
  `modifiedOn` datetime DEFAULT NULL,
  `servCDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `customerWithdraw` */

insert  into `customerWithdraw`(`id`,`customerId`,`currency`,`withdrawType`,`customerAccount`,`companyAccountId`,`amount`,`fee`,`feeType`,`feeAccountCurr`,`beneficiaryId`,`beneficiary_json`,`status`,`createdOn`,`createdBy`,`modifiedBy`,`modifiedOn`,`servCDate`) values (1,9,'USD','NCASH','CASH',0,700.000000,50.000000,'CASH','AUD',1,'\"{\\\"name\\\":\\\"Mohan\\\",\\\"address\\\":\\\"ranti\\\",\\\"account\\\":\\\"123\\\",\\\"bank\\\":\\\"pnb\\\"}\"','A','2021-03-17 21:40:02',1,1,'2021-03-17 21:40:02','2021-03-17 21:40:02'),(2,0,'CNY','CASH','CASH',1,400.000000,40.000000,'NCASHA','AUD',0,NULL,'A','2021-03-18 21:59:57',1,1,'2021-03-18 21:59:57','2021-03-18 21:59:57');

/*Table structure for table `namsteLog` */


CREATE TABLE `namsteLog` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `logType` varchar(50) DEFAULT NULL,
  `refId` int(11) DEFAULT '0',
  `logText` text,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT '0',
  `servCDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*Data for the table `namsteLog` */

insert  into `namsteLog`(`id`,`logType`,`refId`,`logText`,`createdOn`,`createdBy`,`servCDate`) values (7,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":false}',NULL,0,'2020-07-08 00:27:12'),(8,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:29:44'),(9,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:32:07'),(10,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:45:18'),(11,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:45:38'),(12,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:55:55'),(13,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:56:32'),(14,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":\"<?xml version=\\\"1.0\\\" encoding=\\\"utf-8\\\"?><soap:Envelope xmlns:soap=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:xsi=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema-instance\\\" xmlns:xsd=\\\"http:\\/\\/www.w3.org\\/2001\\/XMLSchema\\\"><soap:Body><GetAgentListResponse xmlns=\\\"ClientWebService\\\"><GetAgentListResult><Return_AGENTLIST><CODE>6002<\\/CODE><AGENT_SESSION_ID>agent_MQ==<\\/AGENT_SESSION_ID><MESSAGE>Your IP 106.210.102.245 is not whitelisted. Please contact Support Team<\\/MESSAGE><\\/Return_AGENTLIST><\\/GetAgentListResult><\\/GetAgentListResponse><\\/soap:Body><\\/soap:Envelope>\"}',NULL,0,'2020-07-08 00:57:04'),(15,'API',0,'{\"url\":\"http:\\/\\/esarauat.iremit.com.np\\/SendWS\\/txnservice.asmx\",\"request\":\"<soapenv:Envelope xmlns:soapenv=\\\"http:\\/\\/schemas.xmlsoap.org\\/soap\\/envelope\\/\\\" xmlns:cli=\\\"ClientWebService\\\">\\n        <soapenv:Header\\/><soapenv:Body><cli:GetAgentList>\\n        <cli:AGENT_CODE>3<\\/cli:AGENT_CODE>\\n        <cli:USER_ID>33<\\/cli:USER_ID>\\n        <cli:AGENT_SESSION_ID>agent_MQ==<\\/cli:AGENT_SESSION_ID>\\n        <cli:PAYMENTTYPE>C<\\/cli:PAYMENTTYPE>\\n        <cli:PAYOUT_COUNTRY>NPL<\\/cli:PAYOUT_COUNTRY>\\n        <cli:SIGNATURE>602d15005ed6845e11080b4c3b2d1ff4d37cb941bf24a9dccc745ac4a304e59f<\\/cli:SIGNATURE>\\n        <\\/cli:GetAgentList><\\/soapenv:Body><\\/soapenv:Envelope>\",\"response\":false}',NULL,0,'2020-07-12 16:34:49');

/*Table structure for table `referrer` */


CREATE TABLE `referrer` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `salutation` varchar(10) DEFAULT NULL,
  `fName` varchar(50) DEFAULT NULL,
  `mName` varchar(50) DEFAULT NULL,
  `lName` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` char(1) DEFAULT 'm',
  `mobileNo` varchar(12) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `businessName` varchar(50) DEFAULT NULL,
  `description` varbinary(100) DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `createdBy` mediumint(9) DEFAULT NULL,
  `servCDate` datetime DEFAULT NULL,
  `status` char(1) DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `referrer` */

insert  into `referrer`(`id`,`salutation`,`fName`,`mName`,`lName`,`dob`,`gender`,`mobileNo`,`email`,`businessName`,`description`,`createdOn`,`createdBy`,`servCDate`,`status`) values (1,'Title','Mohan','','Bhagwat','2021-01-05','m','99','avc@gmail.com','ss','dfd','2021-01-17 17:11:30',1,NULL,'A'),(2,'Mr.','Sohan',NULL,'jha','0000-00-00','','','abc@g.com','','','2021-01-20 21:09:34',1,NULL,'A');

/*Table structure for table `zones` */


CREATE TABLE `zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `code` varchar(32) NOT NULL,
  `name` varchar(56) NOT NULL,
  `time_zone` varbinary(100) DEFAULT NULL,
  `status` char(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `indx_countryId` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5106 DEFAULT CHARSET=utf8;

/*Data for the table `zones` */

insert  into `zones`(`id`,`country_id`,`code`,`name`,`time_zone`,`status`) values (191,13,'ACT','Australian Capital Territory','Australia/Sydney','A'),(192,13,'NSW','New South Wales','Australia/Sydney','A'),(193,13,'NT','Northern Territory','Australia/Darwin','A'),(194,13,'QLD','Queensland','Australia/Brisbane','A'),(195,13,'SA','South Australia','Australia/Adelaide','A'),(196,13,'TAS','Tasmania','Australia/Hobart','A'),(197,13,'VIC','Victoria','Australia/Melbourne','A'),(198,13,'WA','Western Australia','Australia/Perth','A'),(1475,99,'AN','Andaman and Nicobar Islands','Asia/Calcutta','A'),(1476,99,'AP','Andhra Pradesh','Asia/Calcutta','A'),(1477,99,'AR','Arunachal Pradesh','Asia/Calcutta','A'),(1478,99,'AS','Assam','Asia/Calcutta','A'),(1479,99,'BI','Bihar','Asia/Calcutta','A'),(1480,99,'CH','Chandigarh','Asia/Calcutta','A'),(1481,99,'DA','Dadra and Nagar Haveli','Asia/Calcutta','A'),(1482,99,'DM','Daman and Diu','Asia/Calcutta','A'),(1483,99,'DE','Delhi','Asia/Calcutta','A'),(1484,99,'GO','Goa','Asia/Calcutta','A'),(1485,99,'GU','Gujarat','Asia/Calcutta','A'),(1486,99,'HA','Haryana','Asia/Calcutta','A'),(1487,99,'HP','Himachal Pradesh','Asia/Calcutta','A'),(1488,99,'JA','Jammu and Kashmir','Asia/Calcutta','A'),(1489,99,'KA','Karnataka','Asia/Calcutta','A'),(1490,99,'KE','Kerala','Asia/Calcutta','A'),(1491,99,'LI','Lakshadweep Islands','Asia/Calcutta','A'),(1492,99,'MP','Madhya Pradesh','Asia/Calcutta','A'),(1493,99,'MA','Maharashtra','Asia/Calcutta','A'),(1494,99,'MN','Manipur','Asia/Calcutta','A'),(1495,99,'ME','Meghalaya','Asia/Calcutta','A'),(1496,99,'MI','Mizoram','Asia/Calcutta','A'),(1497,99,'NA','Nagaland','Asia/Calcutta','A'),(1498,99,'OR','Orissa','Asia/Calcutta','A'),(1499,99,'PO','Pondicherry','Asia/Calcutta','A'),(1500,99,'PU','Punjab','Asia/Calcutta','A'),(1501,99,'RA','Rajasthan','Asia/Calcutta','A'),(1502,99,'SI','Sikkim','Asia/Calcutta','A'),(1503,99,'TN','Tamil Nadu','Asia/Calcutta','A'),(1504,99,'TR','Tripura','Asia/Calcutta','A'),(1505,99,'UP','Uttar Pradesh','Asia/Calcutta','A'),(1506,99,'WB','West Bengal','Asia/Calcutta','A'),(2400,149,'BA','Bagmati','Asia/Katmandu','A'),(2401,149,'BH','Bheri','Asia/Katmandu','A'),(2402,149,'DH','Dhawalagiri','Asia/Katmandu','A'),(2403,149,'GA','Gandaki','Asia/Katmandu','A'),(2404,149,'JA','Janakpur','Asia/Katmandu','A'),(2405,149,'KA','Karnali','Asia/Katmandu','A'),(2406,149,'KO','Kosi','Asia/Katmandu','A'),(2407,149,'LU','Lumbini','Asia/Katmandu','A'),(2408,149,'MA','Mahakali','Asia/Katmandu','A'),(2409,149,'ME','Mechi','Asia/Katmandu','A'),(2410,149,'NA','Narayani','Asia/Katmandu','A'),(2411,149,'RA','Rapti','Asia/Katmandu','A'),(2412,149,'SA','Sagarmatha','Asia/Katmandu','A'),(2413,149,'SE','Seti','Asia/Katmandu','A'),(3959,99,'UL','Uttarakhand','Asia/Calcutta','A'),(4104,99,'IN-JH','Jharkhand','Asia/Calcutta','A'),(4105,99,'IN-TG','Telangana','Asia/Calcutta','A'),(4106,1,'BDS','Badakhshan','Asia/Kabul','A'),(4107,1,'BDG','Badghis','Asia/Kabul','A'),(4108,1,'BGL','Baghlan','Asia/Kabul','A'),(4109,1,'BAL','Balkh','Asia/Kabul','A'),(4110,1,'BAM','Bamian','Asia/Kabul','A'),(4111,1,'FRA','Farah','Asia/Kabul','A'),(4112,1,'FYB','Faryab','Asia/Kabul','A'),(4113,1,'GHA','Ghazni','Asia/Kabul','A'),(4114,1,'GHO','Ghowr','Asia/Kabul','A'),(4115,1,'HEL','Helmand','Asia/Kabul','A'),(4116,1,'HER','Herat','Asia/Kabul','A'),(4117,1,'JOW','Jowzjan','Asia/Kabul','A'),(4118,1,'KAB','Kabul','Asia/Kabul','A'),(4119,1,'KAN','Kandahar','Asia/Kabul','A'),(4120,1,'KAP','Kapisa','Asia/Kabul','A'),(4121,1,'KHO','Khost','Asia/Kabul','A'),(4122,1,'KNR','Konar','Asia/Kabul','A'),(4123,1,'KDZ','Kondoz','Asia/Kabul','A'),(4124,1,'LAG','Laghman','Asia/Kabul','A'),(4125,1,'LOW','Lowgar','Asia/Kabul','A'),(4126,1,'NAN','Nangrahar','Asia/Kabul','A'),(4127,1,'NIM','Nimruz','Asia/Kabul','A'),(4128,1,'NUR','Nurestan','Asia/Kabul','A'),(4129,1,'ORU','Oruzgan','Asia/Kabul','A'),(4130,1,'PIA','Paktia','Asia/Kabul','A'),(4131,1,'PKA','Paktika','Asia/Kabul','A'),(4132,1,'PAR','Parwan','Asia/Kabul','A'),(4133,1,'SAM','Samangan','Asia/Kabul','A'),(4134,1,'SAR','Sar-e Pol','Asia/Kabul','A'),(4135,1,'TAK','Takhar','Asia/Kabul','A'),(4136,1,'WAR','Wardak','Asia/Kabul','A'),(4137,1,'ZAB','Zabol','Asia/Kabul','A'),(4138,2,'BR','Berat','Europe/Tirane','A'),(4139,2,'BU','Bulqize','Europe/Tirane','A'),(4140,2,'DL','Delvine','Europe/Tirane','A'),(4141,2,'DV','Devoll','Europe/Tirane','A'),(4142,2,'DI','Diber','Europe/Tirane','A'),(4143,2,'DR','Durres','Europe/Tirane','A'),(4144,2,'EL','Elbasan','Europe/Tirane','A'),(4145,2,'ER','Kolonje','Europe/Tirane','A'),(4146,2,'FR','Fier','Europe/Tirane','A'),(4147,2,'GJ','Gjirokaster','Europe/Tirane','A'),(4148,2,'GR','Gramsh','Europe/Tirane','A'),(4149,2,'HA','Has','Europe/Tirane','A'),(4150,2,'KA','Kavaje','Europe/Tirane','A'),(4151,2,'KB','Kurbin','Europe/Tirane','A'),(4152,2,'KC','Kucove','Europe/Tirane','A'),(4153,2,'KO','Korce','Europe/Tirane','A'),(4154,2,'KR','Kruje','Europe/Tirane','A'),(4155,2,'KU','Kukes','Europe/Tirane','A'),(4156,2,'LB','Librazhd','Europe/Tirane','A'),(4157,2,'LE','Lezhe','Europe/Tirane','A'),(4158,2,'LU','Lushnje','Europe/Tirane','A'),(4159,2,'MM','Malesi e Madhe','Europe/Tirane','A'),(4160,2,'MK','Mallakaster','Europe/Tirane','A'),(4161,2,'MT','Mat','Europe/Tirane','A'),(4162,2,'MR','Mirdite','Europe/Tirane','A'),(4163,2,'PQ','Peqin','Europe/Tirane','A'),(4164,2,'PR','Permet','Europe/Tirane','A'),(4165,2,'PG','Pogradec','Europe/Tirane','A'),(4166,2,'PU','Puke','Europe/Tirane','A'),(4167,2,'SH','Shkoder','Europe/Tirane','A'),(4168,2,'SK','Skrapar','Europe/Tirane','A'),(4169,2,'SR','Sarande','Europe/Tirane','A'),(4170,2,'TE','Tepelene','Europe/Tirane','A'),(4171,2,'TP','Tropoje','Europe/Tirane','A'),(4172,2,'TR','Tirane','Europe/Tirane','A'),(4173,2,'VL','Vlore','Europe/Tirane','A'),(4174,3,'ADR','Adrar','Africa/Algiers','A'),(4175,3,'ADE','Ain Defla','Africa/Algiers','A'),(4176,3,'ATE','Ain Temouchent','Africa/Algiers','A'),(4177,3,'ALG','Alger','Africa/Algiers','A'),(4178,3,'ANN','Annaba','Africa/Algiers','A'),(4179,3,'BAT','Batna','Africa/Algiers','A'),(4180,3,'BEC','Bechar','Africa/Algiers','A'),(4181,3,'BEJ','Bejaia','Africa/Algiers','A'),(4182,3,'BIS','Biskra','Africa/Algiers','A'),(4183,3,'BLI','Blida','Africa/Algiers','A'),(4184,3,'BBA','Bordj Bou Arreridj','Africa/Algiers','A'),(4185,3,'BOA','Bouira','Africa/Algiers','A'),(4186,3,'BMD','Boumerdes','Africa/Algiers','A'),(4187,3,'CHL','Chlef','Africa/Algiers','A'),(4188,3,'CON','Constantine','Africa/Algiers','A'),(4189,3,'DJE','Djelfa','Africa/Algiers','A'),(4190,3,'EBA','El Bayadh','Africa/Algiers','A'),(4191,3,'EOU','El Oued','Africa/Algiers','A'),(4192,3,'ETA','El Tarf','Africa/Algiers','A'),(4193,3,'GHA','Ghardaia','Africa/Algiers','A'),(4194,3,'GUE','Guelma','Africa/Algiers','A'),(4195,3,'ILL','Illizi','Africa/Algiers','A'),(4196,3,'JIJ','Jijel','Africa/Algiers','A'),(4197,3,'KHE','Khenchela','Africa/Algiers','A'),(4198,3,'LAG','Laghouat','Africa/Algiers','A'),(4199,3,'MUA','Muaskar','Africa/Algiers','A'),(4200,3,'MED','Medea','Africa/Algiers','A'),(4201,3,'MIL','Mila','Africa/Algiers','A'),(4202,3,'MOS','Mostaganem','Africa/Algiers','A'),(4203,3,'MSI','MSila','Africa/Algiers','A'),(4204,3,'NAA','Naama','Africa/Algiers','A'),(4205,3,'ORA','Oran','Africa/Algiers','A'),(4206,3,'OUA','Ouargla','Africa/Algiers','A'),(4207,3,'OEB','Oum el-Bouaghi','Africa/Algiers','A'),(4208,3,'REL','Relizane','Africa/Algiers','A'),(4209,3,'SAI','Saida','Africa/Algiers','A'),(4210,3,'SET','Setif','Africa/Algiers','A'),(4211,3,'SBA','Sidi Bel Abbes','Africa/Algiers','A'),(4212,3,'SKI','Skikda','Africa/Algiers','A'),(4213,3,'SAH','Souk Ahras','Africa/Algiers','A'),(4214,3,'TAM','Tamanghasset','Africa/Algiers','A'),(4215,3,'TEB','Tebessa','Africa/Algiers','A'),(4216,3,'TIA','Tiaret','Africa/Algiers','A'),(4217,3,'TIN','Tindouf','Africa/Algiers','A'),(4218,3,'TIP','Tipaza','Africa/Algiers','A'),(4219,3,'TIS','Tissemsilt','Africa/Algiers','A'),(4220,3,'TOU','Tizi Ouzou','Africa/Algiers','A'),(4221,3,'TLE','Tlemcen','Africa/Algiers','A'),(4222,4,'E','Eastern','Pacific/Pago_Pago','A'),(4223,4,'M','Manua','Pacific/Pago_Pago','A'),(4224,4,'R','Rose Island','Pacific/Pago_Pago','A'),(4225,4,'S','Swains Island','Pacific/Pago_Pago','A'),(4226,4,'W','Western','Pacific/Pago_Pago','A'),(4227,5,'ALV','Andorra la Vella','Europe/Andorra','A'),(4228,5,'CAN','Canillo','Europe/Andorra','A'),(4229,5,'ENC','Encamp','Europe/Andorra','A'),(4230,5,'ESE','Escaldes-Engordany','Europe/Andorra','A'),(4231,5,'LMA','La Massana','Europe/Andorra','A'),(4232,5,'ORD','Ordino','Europe/Andorra','A'),(4233,5,'SJL','Sant Julia de L','Europe/Andorra','A'),(4234,6,'BGO','Bengo','Africa/Luanda','A'),(4235,6,'BGU','Benguela','Africa/Luanda','A'),(4236,6,'BIE','Bie','Africa/Luanda','A'),(4237,6,'CAB','Cabinda','Africa/Luanda','A'),(4238,6,'CCU','Cuando-Cubango','Africa/Luanda','A'),(4239,6,'CNO','Cuanza Norte','Africa/Luanda','A'),(4240,6,'CUS','Cuanza Sul','Africa/Luanda','A'),(4241,6,'CNN','Cunene','Africa/Luanda','A'),(4242,6,'HUA','Huambo','Africa/Luanda','A'),(4243,6,'HUI','Huila','Africa/Luanda','A'),(4244,6,'LUA','Luanda','Africa/Luanda','A'),(4245,6,'LNO','Lunda Norte','Africa/Luanda','A'),(4246,6,'LSU','Lunda Sul','Africa/Luanda','A'),(4247,6,'MAL','Malange','Africa/Luanda','A'),(4248,6,'MOX','Moxico','Africa/Luanda','A'),(4249,6,'NAM','Namibe','Africa/Luanda','A'),(4250,6,'UIG','Uige','Africa/Luanda','A'),(4251,6,'ZAI','Zaire','Africa/Luanda','A'),(4252,7,'AI','Anguilla',NULL,'A'),(4253,8,'AQ','Antarctica',NULL,'A'),(4254,9,'ASG','Saint George','America/Antigua','A'),(4255,9,'ASJ','Saint John','America/Antigua','A'),(4256,9,'ASM','Saint Mary','America/Antigua','A'),(4257,9,'ASL','Saint Paul','America/Antigua','A'),(4258,9,'ASR','Saint Peter','America/Antigua','A'),(4259,9,'ASH','Saint Philip','America/Antigua','A'),(4260,9,'BAR','Barbuda','America/Antigua','A'),(4261,9,'RED','Redonda','America/Antigua','A'),(4262,10,'AN','Antartida e Islas del Atlantico Sur','America/Buenos_Aires','A'),(4263,10,'BA','Buenos Aires','America/Buenos_Aires','A'),(4264,10,'CA','Catamarca','America/Catamarca','A'),(4265,10,'CH','Chaco','America/Cordoba','A'),(4266,10,'CU','Chubut','America/Catamarca','A'),(4267,10,'CO','Cordoba','America/Cordoba','A'),(4268,10,'CR','Corrientes','America/Cordoba','A'),(4269,10,'CF','Capital Federal','America/Buenos_Aires','A'),(4270,10,'ER','Entre Rios','America/Cordoba','A'),(4271,10,'FO','Formosa','America/Cordoba','A'),(4272,10,'JU','Jujuy','America/Jujuy','A'),(4273,10,'LP','La Pampa','America/Cordoba','A'),(4274,10,'LR','La Rioja','America/Argentina/La_Rioja','A'),(4275,10,'ME','Mendoza','America/Mendoza','A'),(4276,10,'MI','Misiones','America/Cordoba','A'),(4277,10,'NE','Neuquen','America/Cordoba','A'),(4278,10,'RN','Rio Negro','America/Cordoba','A'),(4279,10,'SA','Salta','America/Cordoba','A'),(4280,10,'SJ','San Juan','America/Cordoba','A'),(4281,10,'SL','San Luis','America/Cordoba','A'),(4282,10,'SC','Santa Cruz','America/Argentina/Rio_Gallegos','A'),(4283,10,'SF','Santa Fe','America/Cordoba','A'),(4284,10,'SD','Santiago del Estero','America/Cordoba','A'),(4285,10,'TF','Tierra del Fuego','America/Argentina/Ushuaia','A'),(4286,10,'TU','Tucuman','America/Argentina/Tucuman','A'),(4287,11,'AGT','Aragatsotn','Asia/Yerevan','A'),(4288,11,'ARR','Ararat','Asia/Yerevan','A'),(4289,11,'ARM','Armavir','Asia/Yerevan','A'),(4290,11,'GEG','Gegharkunik','Asia/Yerevan','A'),(4291,11,'KOT','Kotayk','Asia/Yerevan','A'),(4292,11,'LOR','Lorri','Asia/Yerevan','A'),(4293,11,'SHI','Shirak','Asia/Yerevan','A'),(4294,11,'SYU','Syunik','Asia/Yerevan','A'),(4295,11,'TAV','Tavush','Asia/Yerevan','A'),(4296,11,'VAY','Vayots Dzor','Asia/Yerevan','A'),(4297,11,'YER','Yerevan','Asia/Yerevan','A'),(4298,12,'AW','Aruba',NULL,'A'),(4299,14,'BUR','Burgenland','Europe/Vienna','A'),(4300,14,'KAR','K&auml;rnten','Europe/Vienna','A'),(4301,14,'NOS','Nieder&ouml;esterreich','Europe/Vienna','A'),(4302,14,'OOS','Ober&ouml;esterreich','Europe/Vienna','A'),(4303,14,'SAL','Salzburg','Europe/Vienna','A'),(4304,14,'STE','Steiermark','Europe/Vienna','A'),(4305,14,'TIR','Tirol','Europe/Vienna','A'),(4306,14,'VOR','Vorarlberg','Europe/Vienna','A'),(4307,14,'WIE','Wien','Europe/Vienna','A'),(4308,15,'AB','Ali Bayramli','Asia/Baku','A'),(4309,15,'ABS','Abseron','Asia/Baku','A'),(4310,15,'AGC','AgcabAdi','Asia/Baku','A'),(4311,15,'AGM','Agdam','Asia/Baku','A'),(4312,15,'AGS','Agdas','Asia/Baku','A'),(4313,15,'AGA','Agstafa','Asia/Baku','A'),(4314,15,'AGU','Agsu','Asia/Baku','A'),(4315,15,'AST','Astara','Asia/Baku','A'),(4316,15,'BA','Baki','Asia/Baku','A'),(4317,15,'BAB','BabAk','Asia/Baku','A'),(4318,15,'BAL','BalakAn','Asia/Baku','A'),(4319,15,'BAR','BArdA','Asia/Baku','A'),(4320,15,'BEY','Beylaqan','Asia/Baku','A'),(4321,15,'BIL','Bilasuvar','Asia/Baku','A'),(4322,15,'CAB','Cabrayil','Asia/Baku','A'),(4323,15,'CAL','Calilabab','Asia/Baku','A'),(4324,15,'CUL','Culfa','Asia/Baku','A'),(4325,15,'DAS','Daskasan','Asia/Baku','A'),(4326,15,'DAV','Davaci','Asia/Baku','A'),(4327,15,'FUZ','Fuzuli','Asia/Baku','A'),(4328,15,'GA','Ganca','Asia/Baku','A'),(4329,15,'GAD','Gadabay','Asia/Baku','A'),(4330,15,'GOR','Goranboy','Asia/Baku','A'),(4331,15,'GOY','Goycay','Asia/Baku','A'),(4332,15,'HAC','Haciqabul','Asia/Baku','A'),(4333,15,'IMI','Imisli','Asia/Baku','A'),(4334,15,'ISM','Ismayilli','Asia/Baku','A'),(4335,15,'KAL','Kalbacar','Asia/Baku','A'),(4336,15,'KUR','Kurdamir','Asia/Baku','A'),(4337,15,'LA','Lankaran','Asia/Baku','A'),(4338,15,'LAC','Lacin','Asia/Baku','A'),(4339,15,'LAN','Lankaran','Asia/Baku','A'),(4340,15,'LER','Lerik','Asia/Baku','A'),(4341,15,'MAS','Masalli','Asia/Baku','A'),(4342,15,'MI','Mingacevir','Asia/Baku','A'),(4343,15,'NA','Naftalan','Asia/Baku','A'),(4344,15,'NEF','Neftcala','Asia/Baku','A'),(4345,15,'OGU','Oguz','Asia/Baku','A'),(4346,15,'ORD','Ordubad','Asia/Baku','A'),(4347,15,'QAB','Qabala','Asia/Baku','A'),(4348,15,'QAX','Qax','Asia/Baku','A'),(4349,15,'QAZ','Qazax','Asia/Baku','A'),(4350,15,'QOB','Qobustan','Asia/Baku','A'),(4351,15,'QBA','Quba','Asia/Baku','A'),(4352,15,'QBI','Qubadli','Asia/Baku','A'),(4353,15,'QUS','Qusar','Asia/Baku','A'),(4354,15,'SA','Saki','Asia/Baku','A'),(4355,15,'SAT','Saatli','Asia/Baku','A'),(4356,15,'SAB','Sabirabad','Asia/Baku','A'),(4357,15,'SAD','Sadarak','Asia/Baku','A'),(4358,15,'SAH','Sahbuz','Asia/Baku','A'),(4359,15,'SAK','Saki','Asia/Baku','A'),(4360,15,'SAL','Salyan','Asia/Baku','A'),(4361,15,'SM','Sumqayit','Asia/Baku','A'),(4362,15,'SMI','Samaxi','Asia/Baku','A'),(4363,15,'SKR','Samkir','Asia/Baku','A'),(4364,15,'SMX','Samux','Asia/Baku','A'),(4365,15,'SAR','Sarur','Asia/Baku','A'),(4366,15,'SIY','Siyazan','Asia/Baku','A'),(4367,15,'SS','Susa','Asia/Baku','A'),(4368,15,'SUS','Susa','Asia/Baku','A'),(4369,15,'TAR','Tartar','Asia/Baku','A'),(4370,15,'TOV','Tovuz','Asia/Baku','A'),(4371,15,'UCA','Ucar','Asia/Baku','A'),(4372,15,'XA','Xankandi','Asia/Baku','A'),(4373,15,'XAC','Xacmaz','Asia/Baku','A'),(4374,15,'XAN','Xanlar','Asia/Baku','A'),(4375,15,'XIZ','Xizi','Asia/Baku','A'),(4376,15,'XCI','Xocali','Asia/Baku','A'),(4377,15,'XVD','Xocavand','Asia/Baku','A'),(4378,15,'YAR','Yardimli','Asia/Baku','A'),(4379,15,'YEV','Yevlax','Asia/Baku','A'),(4380,15,'ZAN','Zangilan','Asia/Baku','A'),(4381,15,'ZAQ','Zaqatala','Asia/Baku','A'),(4382,15,'ZAR','Zardab','Asia/Baku','A'),(4383,15,'NX','Naxcivan','Asia/Baku','A'),(4384,16,'ACK','Acklins','America/Nassau','A'),(4385,16,'BER','Berry Islands','America/Nassau','A'),(4386,16,'BIM','Bimini','America/Nassau','A'),(4387,16,'BLK','Black Point','America/Nassau','A'),(4388,16,'CAT','Cat Island','America/Nassau','A'),(4389,16,'CAB','Central Abaco','America/Nassau','A'),(4390,16,'CAN','Central Andros','America/Nassau','A'),(4391,16,'CEL','Central Eleuthera','America/Nassau','A'),(4392,16,'FRE','City of Freeport','America/Nassau','A'),(4393,16,'CRO','Crooked Island','America/Nassau','A'),(4394,16,'EGB','East Grand Bahama','America/Nassau','A'),(4395,16,'EXU','Exuma','America/Nassau','A'),(4396,16,'GRD','Grand Cay','America/Nassau','A'),(4397,16,'HAR','Harbour Island','America/Nassau','A'),(4398,16,'HOP','Hope Town','America/Nassau','A'),(4399,16,'INA','Inagua','America/Nassau','A'),(4400,16,'LNG','Long Island','America/Nassau','A'),(4401,16,'MAN','Mangrove Cay','America/Nassau','A'),(4402,16,'MAY','Mayaguana','America/Nassau','A'),(4403,16,'MOO','Moores Island','America/Nassau','A'),(4404,16,'NAB','North Abaco','America/Nassau','A'),(4405,16,'NAN','North Andros','America/Nassau','A'),(4406,16,'NEL','North Eleuthera','America/Nassau','A'),(4407,16,'RAG','Ragged Island','America/Nassau','A'),(4408,16,'RUM','Rum Cay','America/Nassau','A'),(4409,16,'SAL','San Salvador','America/Nassau','A'),(4410,16,'SAB','South Abaco','America/Nassau','A'),(4411,16,'SAN','South Andros','America/Nassau','A'),(4412,16,'SEL','South Eleuthera','America/Nassau','A'),(4413,16,'SWE','Spanish Wells','America/Nassau','A'),(4414,16,'WGB','West Grand Bahama','America/Nassau','A'),(4415,16,'NP','Nassau','America/Nassau','A'),(4416,17,'CAP','Capital','Asia/Bahrain','A'),(4417,17,'CEN','Central','Asia/Bahrain','A'),(4418,17,'MUH','Muharraq','Asia/Bahrain','A'),(4419,17,'NOR','Northern','Asia/Bahrain','A'),(4420,17,'SOU','Southern','Asia/Bahrain','A'),(4421,18,'BAR','Barisal','Asia/Dhaka','A'),(4422,18,'CHI','Chittagong','Asia/Dhaka','A'),(4423,18,'DHA','Dhaka','Asia/Dhaka','A'),(4424,18,'KHU','Khulna','Asia/Dhaka','A'),(4425,18,'RAJ','Rajshahi','Asia/Dhaka','A'),(4426,18,'SYL','Sylhet','Asia/Dhaka','A'),(4427,19,'CC','Christ Church','America/Barbados','A'),(4428,19,'AND','Saint Andrew','America/Barbados','A'),(4429,19,'GEO','Saint George','America/Barbados','A'),(4430,19,'JAM','Saint James','America/Barbados','A'),(4431,19,'JOH','Saint John','America/Barbados','A'),(4432,19,'JOS','Saint Joseph','America/Barbados','A'),(4433,19,'LUC','Saint Lucy','America/Barbados','A'),(4434,19,'MIC','Saint Michael','America/Barbados','A'),(4435,19,'PET','Saint Peter','America/Barbados','A'),(4436,19,'PHI','Saint Philip','America/Barbados','A'),(4437,19,'THO','Saint Thomas','America/Barbados','A'),(4438,20,'BR','Brestskaya (Brest)','Europe/Minsk','A'),(4439,20,'HO','Homyelskaya (Homyel)','Europe/Minsk','A'),(4440,20,'HM','Horad Minsk','Europe/Minsk','A'),(4441,20,'HR','Hrodzyenskaya (Hrodna)','Europe/Minsk','A'),(4442,20,'MA','Mahilyowskaya (Mahilyow)','Europe/Minsk','A'),(4443,20,'MI','Minskaya','Europe/Minsk','A'),(4444,20,'VI','Vitsyebskaya (Vitsyebsk)','Europe/Minsk','A'),(4445,21,'VAN','Antwerpen','Europe/Brussels','A'),(4446,21,'WBR','Brabant Wallon','Europe/Brussels','A'),(4447,21,'WHT','Hainaut','Europe/Brussels','A'),(4448,21,'WLG','Liege','Europe/Brussels','A'),(4449,21,'VLI','Limburg','Europe/Brussels','A'),(4450,21,'WLX','Luxembourg','Europe/Brussels','A'),(4451,21,'WNA','Namur','Europe/Brussels','A'),(4452,21,'VOV','Oost-Vlaanderen','Europe/Brussels','A'),(4453,21,'VBR','Vlaams Brabant','Europe/Brussels','A'),(4454,21,'VWV','West-Vlaanderen','Europe/Brussels','A'),(4455,21,'BE10','Bruxelles Capitale','Europe/Brussels','A'),(4456,22,'BZ','Belize','America/Belize','A'),(4457,22,'CY','Cayo','America/Belize','A'),(4458,22,'CR','Corozal','America/Belize','A'),(4459,22,'OW','Orange Walk','America/Belize','A'),(4460,22,'SC','Stann Creek','America/Belize','A'),(4461,22,'TO','Toledo','America/Belize','A'),(4462,22,'22','22','','22'),(4463,23,'AL','Alibori','Africa/Porto-Novo','A'),(4464,23,'AK','Atakora','Africa/Porto-Novo','A'),(4465,23,'AQ','Atlantique','Africa/Porto-Novo','A'),(4466,23,'BO','Borgou','Africa/Porto-Novo','A'),(4467,23,'CO','Collines','Africa/Porto-Novo','A'),(4468,23,'DO','Donga','Africa/Porto-Novo','A'),(4469,23,'KO','Kouffo','Africa/Porto-Novo','A'),(4470,23,'LI','Littoral','Africa/Porto-Novo','A'),(4471,23,'MO','Mono','Africa/Porto-Novo','A'),(4472,23,'OU','Oueme','Africa/Porto-Novo','A'),(4473,23,'PL','Plateau','Africa/Porto-Novo','A'),(4474,23,'ZO','Zou','Africa/Porto-Novo','A'),(4475,24,'DS','Devonshire','Atlantic/Bermuda','A'),(4476,24,'HC','Hamilton City','Atlantic/Bermuda','A'),(4477,24,'HA','Hamilton','Atlantic/Bermuda','A'),(4478,24,'PG','Paget','Atlantic/Bermuda','A'),(4479,24,'PB','Pembroke','Atlantic/Bermuda','A'),(4480,24,'GC','Saint George City','Atlantic/Bermuda','A'),(4481,24,'SG','Saint Georges','Atlantic/Bermuda','A'),(4482,24,'SA','Sandys','Atlantic/Bermuda','A'),(4483,24,'SM','Smiths','Atlantic/Bermuda','A'),(4484,24,'SH','Southampton','Atlantic/Bermuda','A'),(4485,24,'WA','Warwick','Atlantic/Bermuda','A'),(4486,25,'BUM','Bumthang','Asia/Thimphu','A'),(4487,25,'CHU','Chukha','Asia/Thimphu','A'),(4488,25,'DAG','Dagana','Asia/Thimphu','A'),(4489,25,'GAS','Gasa','Asia/Thimphu','A'),(4490,25,'HAA','Haa','Asia/Thimphu','A'),(4491,25,'LHU','Lhuntse','Asia/Thimphu','A'),(4492,25,'MON','Mongar','Asia/Thimphu','A'),(4493,25,'PAR','Paro','Asia/Thimphu','A'),(4494,25,'PEM','Pemagatshel','Asia/Thimphu','A'),(4495,25,'PUN','Punakha','Asia/Thimphu','A'),(4496,25,'SJO','Samdrup Jongkhar','Asia/Thimphu','A'),(4497,25,'SAT','Samtse','Asia/Thimphu','A'),(4498,25,'SAR','Sarpang','Asia/Thimphu','A'),(4499,25,'THI','Thimphu','Asia/Thimphu','A'),(4500,25,'TRG','Trashigang','Asia/Thimphu','A'),(4501,25,'TRY','Trashiyangste','Asia/Thimphu','A'),(4502,25,'TRO','Trongsa','Asia/Thimphu','A'),(4503,25,'TSI','Tsirang','Asia/Thimphu','A'),(4504,25,'WPH','Wangdue Phodrang','Asia/Thimphu','A'),(4505,25,'ZHE','Zhemgang','Asia/Thimphu','A'),(4506,26,'BEN','Beni','America/La_Paz','A'),(4507,26,'CHU','Chuquisaca','America/La_Paz','A'),(4508,26,'COC','Cochabamba','America/La_Paz','A'),(4509,26,'LPZ','La Paz','America/La_Paz','A'),(4510,26,'ORU','Oruro','America/La_Paz','A'),(4511,26,'PAN','Pando','America/La_Paz','A'),(4512,26,'POT','Potosi','America/La_Paz','A'),(4513,26,'SCZ','Santa Cruz','America/La_Paz','A'),(4514,26,'TAR','Tarija','America/La_Paz','A'),(4515,27,'BRO','Brcko district','Europe/Sarajevo','A'),(4516,27,'FUS','Unsko-Sanski Kanton','Europe/Sarajevo','A'),(4517,27,'FPO','Posavski Kanton','Europe/Sarajevo','A'),(4518,27,'FTU','Tuzlanski Kanton','Europe/Sarajevo','A'),(4519,27,'FZE','Zenicko-Dobojski Kanton','Europe/Sarajevo','A'),(4520,27,'FBP','Bosanskopodrinjski Kanton','Europe/Sarajevo','A'),(4521,27,'FSB','Srednjebosanski Kanton','Europe/Sarajevo','A'),(4522,27,'FHN','Hercegovacko-neretvanski Kanton','Europe/Sarajevo','A'),(4523,27,'FZH','Zapadnohercegovacka Zupanija','Europe/Sarajevo','A'),(4524,27,'FSA','Kanton Sarajevo','Europe/Sarajevo','A'),(4525,27,'FZA','Zapadnobosanska','Europe/Sarajevo','A'),(4526,27,'SBL','Banja Luka','Europe/Sarajevo','A'),(4527,27,'SDO','Doboj','Europe/Sarajevo','A'),(4528,27,'SBI','Bijeljina','Europe/Sarajevo','A'),(4529,27,'SVL','Vlasenica','Europe/Sarajevo','A'),(4530,27,'SSR','Sarajevo-Romanija or Sokolac','Europe/Sarajevo','A'),(4531,27,'SFO','Foca','Europe/Sarajevo','A'),(4532,27,'STR','Trebinje','Europe/Sarajevo','A'),(4533,28,'CE','Central','Africa/Gaborone','A'),(4534,28,'GH','Ghanzi','Africa/Gaborone','A'),(4535,28,'KD','Kgalagadi','Africa/Gaborone','A'),(4536,28,'KT','Kgatleng','Africa/Gaborone','A'),(4537,28,'KW','Kweneng','Africa/Gaborone','A'),(4538,28,'NG','Ngamiland','Africa/Gaborone','A'),(4539,28,'NE','North East','Africa/Gaborone','A'),(4540,28,'NW','North West','Africa/Gaborone','A'),(4541,28,'SE','South East','Africa/Gaborone','A'),(4542,28,'SO','Southern','Africa/Gaborone','A'),(4543,29,'BV','Bouvet Island',NULL,'A'),(4544,30,'AC','Acre','America/Rio_Branco','A'),(4545,30,'AL','Alagoas','America/Maceio','A'),(4546,30,'AP','Amapa','America/Belem','A'),(4547,30,'AM','Amazonas','America/Manaus','A'),(4548,30,'BA','Bahia','America/Bahia','A'),(4549,30,'CE','Ceara','America/Fortaleza','A'),(4550,30,'DF','Distrito Federal','America/Sao_Paulo','A'),(4551,30,'ES','Espirito Santo','America/Sao_Paulo','A'),(4552,30,'GO','Goias','America/Sao_Paulo','A'),(4553,30,'MA','Maranhao','America/Fortaleza','A'),(4554,30,'MT','Mato Grosso','America/Cuiaba','A'),(4555,30,'MS','Mato Grosso do Sul','America/Campo_Grande','A'),(4556,30,'MG','Minas Gerais','America/Sao_Paulo','A'),(4557,30,'PA','Para','America/Belem','A'),(4558,30,'PB','Paraiba','America/Fortaleza','A'),(4559,30,'PR','Parana','America/Sao_Paulo','A'),(4560,30,'PE','Pernambuco','America/Noronha','A'),(4561,30,'PI','Piaui','America/Fortaleza','A'),(4562,30,'RJ','Rio de Janeiro','America/Sao_Paulo','A'),(4563,30,'RN','Rio Grande do Norte','America/Fortaleza','A'),(4564,30,'RS','Rio Grande do Sul','America/Sao_Paulo','A'),(4565,30,'RO','Rondonia','America/Porto_Velho','A'),(4566,30,'RR','Roraima','America/Boa_Vista','A'),(4567,30,'SC','Santa Catarina','America/Sao_Paulo','A'),(4568,30,'SP','Sao Paulo','America/Sao_Paulo','A'),(4569,30,'SE','Sergipe','America/Maceio','A'),(4570,30,'TO','Tocantins','America/Araguaina','A'),(4571,31,'PB','Peros Banhos','Indian/Chagos','A'),(4572,31,'SI','Salomon Islands','Indian/Chagos','A'),(4573,31,'NI','Nelsons Island','Indian/Chagos','A'),(4574,31,'TB','Three Brothers','Indian/Chagos','A'),(4575,31,'EA','Eagle Islands','Indian/Chagos','A'),(4576,31,'DI','Danger Island','Indian/Chagos','A'),(4577,31,'EG','Egmont Islands','Indian/Chagos','A'),(4578,31,'DG','Diego Garcia','Indian/Chagos','A'),(4579,32,'BEL','Belait','Asia/Brunei','A'),(4580,32,'BRM','Brunei and Muara','Asia/Brunei','A'),(4581,32,'TEM','Temburong','Asia/Brunei','A'),(4582,32,'TUT','Tutong','Asia/Brunei','A'),(4583,33,'BG01','Blagoevgrad','Europe/Sofia','A'),(4584,33,'BG02','Burgas','Europe/Sofia','A'),(4585,33,'BG08','Dobrich','Europe/Sofia','A'),(4586,33,'BG07','Gabrovo','Europe/Sofia','A'),(4587,33,'BG26','Haskovo','Europe/Sofia','A'),(4588,33,'BG09','Kardjali','Europe/Sofia','A'),(4589,33,'BG10','Kyustendil','Europe/Sofia','A'),(4590,33,'BG11','Lovech','Europe/Sofia','A'),(4591,33,'BG12','Montana','Europe/Sofia','A'),(4592,33,'BG13','Pazardjik','Europe/Sofia','A'),(4593,33,'BG14','Pernik','Europe/Sofia','A'),(4594,33,'BG15','Pleven','Europe/Sofia','A'),(4595,33,'BG16','Plovdiv','Europe/Sofia','A'),(4596,33,'BG17','Razgrad','Europe/Sofia','A'),(4597,33,'BG27','Shumen','Europe/Sofia','A'),(4598,33,'BG19','Silistra','Europe/Sofia','A'),(4599,33,'BG20','Sliven','Europe/Sofia','A'),(4600,33,'BG21','Smolyan','Europe/Sofia','A'),(4601,33,'BG23','Sofia','Europe/Sofia','A'),(4602,33,'BG22','Sofia - town','Europe/Sofia','A'),(4603,33,'BG24','Stara Zagora','Europe/Sofia','A'),(4604,33,'BG25','Targovishte','Europe/Sofia','A'),(4605,33,'BG03','Varna','Europe/Sofia','A'),(4606,33,'BG04','Veliko Tarnovo','Europe/Sofia','A'),(4607,33,'BG05','Vidin','Europe/Sofia','A'),(4608,33,'BG06','Vratza','Europe/Sofia','A'),(4609,33,'BG28','Yambol','Europe/Sofia','A'),(4610,33,'BG18','Ruse','Europe/Sofia','A'),(4611,34,'BAL','Bale','Africa/Ouagadougou','A'),(4612,34,'BAM','Bam','Africa/Ouagadougou','A'),(4613,34,'BAN','Banwa','Africa/Ouagadougou','A'),(4614,34,'BAZ','Bazega','Africa/Ouagadougou','A'),(4615,34,'BOR','Bougouriba','Africa/Ouagadougou','A'),(4616,34,'BLG','Boulgou','Africa/Ouagadougou','A'),(4617,34,'BOK','Boulkiemde','Africa/Ouagadougou','A'),(4618,34,'COM','Comoe','Africa/Ouagadougou','A'),(4619,34,'GAN','Ganzourgou','Africa/Ouagadougou','A'),(4620,34,'GNA','Gnagna','Africa/Ouagadougou','A'),(4621,34,'GOU','Gourma','Africa/Ouagadougou','A'),(4622,34,'HOU','Houet','Africa/Ouagadougou','A'),(4623,34,'IOA','Ioba','Africa/Ouagadougou','A'),(4624,34,'KAD','Kadiogo','Africa/Ouagadougou','A'),(4625,34,'KEN','Kenedougou','Africa/Ouagadougou','A'),(4626,34,'KOD','Komondjari','Africa/Ouagadougou','A'),(4627,34,'KOP','Kompienga','Africa/Ouagadougou','A'),(4628,34,'KOS','Kossi','Africa/Ouagadougou','A'),(4629,34,'KOL','Koulpelogo','Africa/Ouagadougou','A'),(4630,34,'KOT','Kouritenga','Africa/Ouagadougou','A'),(4631,34,'KOW','Kourweogo','Africa/Ouagadougou','A'),(4632,34,'LER','Leraba','Africa/Ouagadougou','A'),(4633,34,'LOR','Loroum','Africa/Ouagadougou','A'),(4634,34,'MOU','Mouhoun','Africa/Ouagadougou','A'),(4635,34,'NAH','Nahouri','Africa/Ouagadougou','A'),(4636,34,'NAM','Namentenga','Africa/Ouagadougou','A'),(4637,34,'NAY','Nayala','Africa/Ouagadougou','A'),(4638,34,'NOU','Noumbiel','Africa/Ouagadougou','A'),(4639,34,'OUB','Oubritenga','Africa/Ouagadougou','A'),(4640,34,'OUD','Oudalan','Africa/Ouagadougou','A'),(4641,34,'PAS','Passore','Africa/Ouagadougou','A'),(4642,34,'PON','Poni','Africa/Ouagadougou','A'),(4643,34,'SAG','Sanguie','Africa/Ouagadougou','A'),(4644,34,'SAM','Sanmatenga','Africa/Ouagadougou','A'),(4645,34,'SEN','Seno','Africa/Ouagadougou','A'),(4646,34,'SIS','Sissili','Africa/Ouagadougou','A'),(4647,34,'SOM','Soum','Africa/Ouagadougou','A'),(4648,34,'SOR','Sourou','Africa/Ouagadougou','A'),(4649,34,'TAP','Tapoa','Africa/Ouagadougou','A'),(4650,34,'TUY','Tuy','Africa/Ouagadougou','A'),(4651,34,'YAG','Yagha','Africa/Ouagadougou','A'),(4652,34,'YAT','Yatenga','Africa/Ouagadougou','A'),(4653,34,'ZIR','Ziro','Africa/Ouagadougou','A'),(4654,34,'ZOD','Zondoma','Africa/Ouagadougou','A'),(4655,34,'ZOW','Zoundweogo','Africa/Ouagadougou','A'),(4656,35,'BB','Bubanza','Africa/Bujumbura','A'),(4657,35,'BJ','Bujumbura','Africa/Bujumbura','A'),(4658,35,'BR','Bururi','Africa/Bujumbura','A'),(4659,35,'CA','Cankuzo','Africa/Bujumbura','A'),(4660,35,'CI','Cibitoke','Africa/Bujumbura','A'),(4661,35,'GI','Gitega','Africa/Bujumbura','A'),(4662,35,'KR','Karuzi','Africa/Bujumbura','A'),(4663,35,'KY','Kayanza','Africa/Bujumbura','A'),(4664,35,'KI','Kirundo','Africa/Bujumbura','A'),(4665,35,'MA','Makamba','Africa/Bujumbura','A'),(4666,35,'MU','Muramvya','Africa/Bujumbura','A'),(4667,35,'MY','Muyinga','Africa/Bujumbura','A'),(4668,35,'MW','Mwaro','Africa/Bujumbura','A'),(4669,35,'NG','Ngozi','Africa/Bujumbura','A'),(4670,35,'RT','Rutana','Africa/Bujumbura','A'),(4671,35,'RY','Ruyigi','Africa/Bujumbura','A'),(4672,36,'PP','Phnom Penh','Asia/Phnom_Penh','A'),(4673,36,'PS','Preah Seihanu (Kompong Som or Sihanoukville)','Asia/Phnom_Penh','A'),(4674,36,'PA','Pailin','Asia/Phnom_Penh','A'),(4675,36,'KB','Keb','Asia/Phnom_Penh','A'),(4676,36,'BM','Banteay Meanchey','Asia/Phnom_Penh','A'),(4677,36,'BA','Battambang','Asia/Phnom_Penh','A'),(4678,36,'KM','Kampong Cham','Asia/Phnom_Penh','A'),(4679,36,'KN','Kampong Chhnang','Asia/Phnom_Penh','A'),(4680,36,'KU','Kampong Speu','Asia/Phnom_Penh','A'),(4681,36,'KO','Kampong Som','Asia/Phnom_Penh','A'),(4682,36,'KT','Kampong Thom','Asia/Phnom_Penh','A'),(4683,36,'KP','Kampot','Asia/Phnom_Penh','A'),(4684,36,'KL','Kandal','Asia/Phnom_Penh','A'),(4685,36,'KK','Kaoh Kong','Asia/Phnom_Penh','A'),(4686,36,'KR','Kratie','Asia/Phnom_Penh','A'),(4687,36,'MK','Mondul Kiri','Asia/Phnom_Penh','A'),(4688,36,'OM','Oddar Meancheay','Asia/Phnom_Penh','A'),(4689,36,'PU','Pursat','Asia/Phnom_Penh','A'),(4690,36,'PR','Preah Vihear','Asia/Phnom_Penh','A'),(4691,36,'PG','Prey Veng','Asia/Phnom_Penh','A'),(4692,36,'RK','Ratanak Kiri','Asia/Phnom_Penh','A'),(4693,36,'SI','Siemreap','Asia/Phnom_Penh','A'),(4694,36,'ST','Stung Treng','Asia/Phnom_Penh','A'),(4695,36,'SR','Svay Rieng','Asia/Phnom_Penh','A'),(4696,36,'TK','Takeo','Asia/Phnom_Penh','A'),(4697,37,'ADA','Adamawa (Adamaoua)','Africa/Douala','A'),(4698,37,'CEN','Centre','Africa/Douala','A'),(4699,37,'EST','East (Est)','Africa/Douala','A'),(4700,37,'EXN','Extreme North (Extr','Africa/Douala','A'),(4701,37,'LIT','Littoral','Africa/Douala','A'),(4702,37,'NOR','North (Nord)','Africa/Douala','A'),(4703,37,'NOT','Northwest (Nord-Ouest)','Africa/Douala','A'),(4704,37,'OUE','West (Ouest)','Africa/Douala','A'),(4705,37,'SUD','South (Sud)','Africa/Douala','A'),(4706,37,'SOU','Southwest (Sud-Ouest).','Africa/Douala','A'),(4707,38,'AB','Alberta','America/Edmonton','A'),(4708,38,'BC','British Columbia','America/Edmonton','A'),(4709,38,'MB','Manitoba','America/Winnipeg','A'),(4710,38,'NB','New Brunswick','America/Moncton','A'),(4711,38,'NL','Newfoundland and Labrador','America/St_Johns','A'),(4712,38,'NT','Northwest Territories','America/Yellowknife','A'),(4713,38,'NS','Nova Scotia','America/Halifax','A'),(4714,38,'NU','Nunavut','America/Pangnirtung','A'),(4715,38,'ON','Ontario','America/Winnipeg','A'),(4716,38,'PE','Prince Edward Island','America/Coral_Harbou','A'),(4717,38,'QC','Quebec','America/Halifax','A'),(4718,38,'SK','Saskatchewan','America/Regina','A'),(4719,38,'YT','Yukon Territory','America/Whitehorse','A'),(4720,39,'BV','Boa Vista','Atlantic/Cape_Verde','A'),(4721,39,'BR','Brava','Atlantic/Cape_Verde','A'),(4722,39,'CS','Calheta de Sao Miguel','Atlantic/Cape_Verde','A'),(4723,39,'MA','Maio','Atlantic/Cape_Verde','A'),(4724,39,'MO','Mosteiros','Atlantic/Cape_Verde','A'),(4725,39,'PA','Paul','Atlantic/Cape_Verde','A'),(4726,39,'PN','Porto Novo','Atlantic/Cape_Verde','A'),(4727,39,'PR','Praia','Atlantic/Cape_Verde','A'),(4728,39,'RG','Ribeira Grande','Atlantic/Cape_Verde','A'),(4729,39,'SL','Sal','Atlantic/Cape_Verde','A'),(4730,39,'CA','Santa Catarina','Atlantic/Cape_Verde','A'),(4731,39,'CR','Santa Cruz','Atlantic/Cape_Verde','A'),(4732,39,'SD','Sao Domingos','Atlantic/Cape_Verde','A'),(4733,39,'SF','Sao Filipe','Atlantic/Cape_Verde','A'),(4734,39,'SN','Sao Nicolau','Atlantic/Cape_Verde','A'),(4735,39,'SV','Sao Vicente','Atlantic/Cape_Verde','A'),(4736,39,'TA','Tarrafal','Atlantic/Cape_Verde','A'),(4737,40,'CR','Creek','America/Cayman','A'),(4738,40,'EA','Eastern','America/Cayman','A'),(4739,40,'ML','Midland','America/Cayman','A'),(4740,40,'ST','South Town','America/Cayman','A'),(4741,40,'SP','Spot Bay','America/Cayman','A'),(4742,40,'SK','Stake Bay','America/Cayman','A'),(4743,40,'WD','West End ','America/Cayman','A'),(4744,40,'WN','Western','America/Cayman','A'),(4745,41,'BBA','Bamingui-Bangoran','Africa/Bangui','A'),(4746,41,'BKO','Basse-Kotto','Africa/Bangui','A'),(4747,41,'HKO','Haute-Kotto','Africa/Bangui','A'),(4748,41,'HMB','Haut-Mbomou','Africa/Bangui','A'),(4749,41,'KEM','Kemo','Africa/Bangui','A'),(4750,41,'LOB','Lobaye','Africa/Bangui','A'),(4751,41,'MKD','Mambere-Kade','Africa/Bangui','A'),(4752,41,'MBO','Mbomou','Africa/Bangui','A'),(4753,41,'NMM','Nana-Mambere','Africa/Bangui','A'),(4754,41,'OMP','Ombella-MPoko','Africa/Bangui','A'),(4755,41,'OUK','Ouaka','Africa/Bangui','A'),(4756,41,'OUH','Ouham','Africa/Bangui','A'),(4757,41,'OPE','Ouham-Pende','Africa/Bangui','A'),(4758,41,'VAK','Vakaga','Africa/Bangui','A'),(4759,41,'NGR','Nana-Grebizi','Africa/Bangui','A'),(4760,41,'SMB','Sangha-Mbaere','Africa/Bangui','A'),(4761,41,'BAN','Bangui','Africa/Bangui','A'),(4762,42,'BA','Batha','Africa/Ndjamena','A'),(4763,42,'BI','Biltine','Africa/Ndjamena','A'),(4764,42,'BE','Borkou-Ennedi-Tibesti','Africa/Ndjamena','A'),(4765,42,'CB','Chari-Baguirmi','Africa/Ndjamena','A'),(4766,42,'GU','Guera','Africa/Ndjamena','A'),(4767,42,'KA','Kanem','Africa/Ndjamena','A'),(4768,42,'LA','Lac','Africa/Ndjamena','A'),(4769,42,'LC','Logone Occidental','Africa/Ndjamena','A'),(4770,42,'LR','Logone Oriental','Africa/Ndjamena','A'),(4771,42,'MK','Mayo-Kebbi','Africa/Ndjamena','A'),(4772,42,'MC','Moyen-Chari','Africa/Ndjamena','A'),(4773,42,'OU','Ouaddai','Africa/Ndjamena','A'),(4774,42,'SA','Salamat','Africa/Ndjamena','A'),(4775,42,'TA','Tandjile','Africa/Ndjamena','A'),(4776,43,'AI','Aisen del General Carlos Ibanez del Campo','America/Santiago','A'),(4777,43,'AN','Antofagasta','America/Santiago','A'),(4778,43,'AR','Araucania','America/Santiago','A'),(4779,43,'AT','Atacama','America/Santiago','A'),(4780,43,'BI','Bio-Bio','America/Santiago','A'),(4781,43,'CO','Coquimbo','America/Santiago','A'),(4782,43,'LI','Libertador General Bernardo OHiggins','America/Santiago','A'),(4783,43,'LL','Los Lagos','America/Santiago','A'),(4784,43,'MA','Magallanes y de la Antartica Chilena','America/Santiago','A'),(4785,43,'ML','Maule','America/Santiago','A'),(4786,43,'RM','Region Metropolitana','America/Santiago','A'),(4787,43,'TA','Tarapaca','America/Santiago','A'),(4788,43,'VS','Valparaiso','America/Santiago','A'),(4789,44,'AN','Anhui','Asia/Shanghai','A'),(4790,44,'BE','Beijing','Asia/Shanghai','A'),(4791,44,'CH','Chongqing','Asia/Shanghai','A'),(4792,44,'FU','Fujian','Asia/Shanghai','A'),(4793,44,'GA','Gansu','Asia/Shanghai','A'),(4794,44,'GU','Guangdong','Asia/Shanghai','A'),(4795,44,'GX','Guangxi','Asia/Shanghai','A'),(4796,44,'GZ','Guizhou','Asia/Shanghai','A'),(4797,44,'HA','Hainan','Asia/Shanghai','A'),(4798,44,'HB','Hebei','Asia/Shanghai','A'),(4799,44,'HL','Heilongjiang','Asia/Shanghai','A'),(4800,44,'HE','Henan','Asia/Shanghai','A'),(4801,44,'HK','Hong Kong','Asia/Hong_Kong','A'),(4802,44,'HU','Hubei','Asia/Shanghai','A'),(4803,44,'HN','Hunan','Asia/Shanghai','A'),(4804,44,'IM','Inner Mongolia','Asia/Shanghai','A'),(4805,44,'JI','Jiangsu','Asia/Shanghai','A'),(4806,44,'JX','Jiangxi','Asia/Shanghai','A'),(4807,44,'JL','Jilin','Asia/Shanghai','A'),(4808,44,'LI','Liaoning','Asia/Shanghai','A'),(4809,44,'MA','Macau','Asia/Shanghai','A'),(4810,44,'NI','Ningxia','Asia/Shanghai','A'),(4811,44,'SH','Shaanxi','Asia/Shanghai','A'),(4812,44,'SA','Shandong','Asia/Shanghai','A'),(4813,44,'SG','Shanghai','Asia/Shanghai','A'),(4814,44,'SX','Shanxi','Asia/Shanghai','A'),(4815,44,'SI','Sichuan','Asia/Shanghai','A'),(4816,44,'TI','Tianjin','Asia/Shanghai','A'),(4817,44,'XI','Xinjiang','Asia/Shanghai','A'),(4818,44,'YU','Yunnan','Asia/Shanghai','A'),(4819,44,'ZH','Zhejiang','Asia/Shanghai','A'),(4820,45,'CX','Christmas Island',NULL,'A'),(4821,46,'D','Direction Island','Indian/Cocos','A'),(4822,46,'H','Home Island','Indian/Cocos','A'),(4823,46,'O','Horsburgh Island','Indian/Cocos','A'),(4824,46,'S','South Island','Indian/Cocos','A'),(4825,46,'W','West Island','Indian/Cocos','A'),(4826,47,'AMZ','Amazonas','America/Bogota','A'),(4827,47,'ANT','Antioquia','America/Bogota','A'),(4828,47,'ARA','Arauca','America/Bogota','A'),(4829,47,'ATL','Atlantico','America/Bogota','A'),(4830,47,'BDC','Bogota D.C.','America/Bogota','A'),(4831,47,'BOL','Bolivar','America/Bogota','A'),(4832,47,'BOY','Boyaca','America/Bogota','A'),(4833,47,'CAL','Caldas','America/Bogota','A'),(4834,47,'CAQ','Caqueta','America/Bogota','A'),(4835,47,'CAS','Casanare','America/Bogota','A'),(4836,47,'CAU','Cauca','America/Bogota','A'),(4837,47,'CES','Cesar','America/Bogota','A'),(4838,47,'CHO','Choco','America/Bogota','A'),(4839,47,'COR','Cordoba','America/Bogota','A'),(4840,47,'CAM','Cundinamarca','America/Bogota','A'),(4841,47,'GNA','Guainia','America/Bogota','A'),(4842,47,'GJR','Guajira','America/Bogota','A'),(4843,47,'GVR','Guaviare','America/Bogota','A'),(4844,47,'HUI','Huila','America/Bogota','A'),(4845,47,'MAG','Magdalena','America/Bogota','A'),(4846,47,'MET','Meta','America/Bogota','A'),(4847,47,'NAR','Narino','America/Bogota','A'),(4848,47,'NDS','Norte de Santander','America/Bogota','A'),(4849,47,'PUT','Putumayo','America/Bogota','A'),(4850,47,'QUI','Quindio','America/Bogota','A'),(4851,47,'RIS','Risaralda','America/Bogota','A'),(4852,47,'SAP','San Andres y Providencia','America/Bogota','A'),(4853,47,'SAN','Santander','America/Bogota','A'),(4854,47,'SUC','Sucre','America/Bogota','A'),(4855,47,'TOL','Tolima','America/Bogota','A'),(4856,47,'VDC','Valle del Cauca','America/Bogota','A'),(4857,47,'VAU','Vaupes','America/Bogota','A'),(4858,47,'VIC','Vichada','America/Bogota','A'),(4859,48,'G','Grande Comore','Indian/Comoro','A'),(4860,48,'A','Anjouan','Indian/Comoro','A'),(4861,48,'M','Moheli','Indian/Comoro','A'),(4862,49,'11','Bouenza','Africa/Brazzaville','A'),(4863,49,'BZV','Brazzaville','Africa/Brazzaville','A'),(4864,49,'8','Cuvette','Africa/Brazzaville','A'),(4865,49,'15','Cuvette-Ouest','Africa/Brazzaville','A'),(4866,49,'5','Kouilou','Africa/Brazzaville','A'),(4867,49,'2','Lekoumou','Africa/Brazzaville','A'),(4868,49,'7','Likouala','Africa/Brazzaville','A'),(4869,49,'9','Niari','Africa/Brazzaville','A'),(4870,49,'14','Plateaux','Africa/Brazzaville','A'),(4871,49,'12','Pool ','Africa/Brazzaville','A'),(4872,49,'13','Sangha','Africa/Brazzaville','A'),(4873,49,'16','Pointe-Noire','Africa/Brazzaville','A'),(4874,50,'PU','Pukapuka','Pacific/Rarotonga','A'),(4875,50,'RK','Rakahanga','Pacific/Rarotonga','A'),(4876,50,'MK','Manihiki','Pacific/Rarotonga','A'),(4877,50,'PE','Penrhyn','Pacific/Rarotonga','A'),(4878,50,'NI','Nassau Island','Pacific/Rarotonga','A'),(4879,50,'SU','Surwarrow','Pacific/Rarotonga','A'),(4880,50,'PA','Palmerston','Pacific/Rarotonga','A'),(4881,50,'AI','Aitutaki','Pacific/Rarotonga','A'),(4882,50,'MA','Manuae','Pacific/Rarotonga','A'),(4883,50,'TA','Takutea','Pacific/Rarotonga','A'),(4884,50,'MT','Mitiaro','Pacific/Rarotonga','A'),(4885,50,'AT','Atiu','Pacific/Rarotonga','A'),(4886,50,'MU','Mauke','Pacific/Rarotonga','A'),(4887,50,'RR','Rarotonga','Pacific/Rarotonga','A'),(4888,50,'MG','Mangaia','Pacific/Rarotonga','A'),(4889,51,'AL','Alajuela','America/Costa_Rica','A'),(4890,51,'CA','Cartago','America/Costa_Rica','A'),(4891,51,'GU','Guanacaste','America/Costa_Rica','A'),(4892,51,'HE','Heredia','America/Costa_Rica','A'),(4893,51,'LI','Limon','America/Costa_Rica','A'),(4894,51,'PU','Puntarenas','America/Costa_Rica','A'),(4895,51,'SJ','San Jose','America/Costa_Rica','A'),(4896,52,'ABE','Abengourou','Africa/Abidjan','A'),(4897,52,'ABI','Abidjan','Africa/Abidjan','A'),(4898,52,'ABO','Aboisso','Africa/Abidjan','A'),(4899,52,'ADI','Adiake','Africa/Abidjan','A'),(4900,52,'ADZ','Adzope','Africa/Abidjan','A'),(4901,52,'AGB','Agboville','Africa/Abidjan','A'),(4902,52,'AGN','Agnibilekrou','Africa/Abidjan','A'),(4903,52,'ALE','Alepe','Africa/Abidjan','A'),(4904,52,'BOC','Bocanda','Africa/Abidjan','A'),(4905,52,'BAN','Bangolo','Africa/Abidjan','A'),(4906,52,'BEO','Beoumi','Africa/Abidjan','A'),(4907,52,'BIA','Biankouma','Africa/Abidjan','A'),(4908,52,'BDK','Bondoukou','Africa/Abidjan','A'),(4909,52,'BGN','Bongouanou','Africa/Abidjan','A'),(4910,52,'BFL','Bouafle','Africa/Abidjan','A'),(4911,52,'BKE','Bouake','Africa/Abidjan','A'),(4912,52,'BNA','Bouna','Africa/Abidjan','A'),(4913,52,'BDL','Boundiali','Africa/Abidjan','A'),(4914,52,'DKL','Dabakala','Africa/Abidjan','A'),(4915,52,'DBU','Dabou','Africa/Abidjan','A'),(4916,52,'DAL','Daloa','Africa/Abidjan','A'),(4917,52,'DAN','Danane','Africa/Abidjan','A'),(4918,52,'DAO','Daoukro','Africa/Abidjan','A'),(4919,52,'DIM','Dimbokro','Africa/Abidjan','A'),(4920,52,'DIV','Divo','Africa/Abidjan','A'),(4921,52,'DUE','Duekoue','Africa/Abidjan','A'),(4922,52,'FER','Ferkessedougou','Africa/Abidjan','A'),(4923,52,'GAG','Gagnoa','Africa/Abidjan','A'),(4924,52,'GBA','Grand-Bassam','Africa/Abidjan','A'),(4925,52,'GLA','Grand-Lahou','Africa/Abidjan','A'),(4926,52,'GUI','Guiglo','Africa/Abidjan','A'),(4927,52,'ISS','Issia','Africa/Abidjan','A'),(4928,52,'JAC','Jacqueville','Africa/Abidjan','A'),(4929,52,'KAT','Katiola','Africa/Abidjan','A'),(4930,52,'KOR','Korhogo','Africa/Abidjan','A'),(4931,52,'LAK','Lakota','Africa/Abidjan','A'),(4932,52,'MAN','Man','Africa/Abidjan','A'),(4933,52,'MKN','Mankono','Africa/Abidjan','A'),(4934,52,'MBA','Mbahiakro','Africa/Abidjan','A'),(4935,52,'ODI','Odienne','Africa/Abidjan','A'),(4936,52,'OUM','Oume','Africa/Abidjan','A'),(4937,52,'SAK','Sakassou','Africa/Abidjan','A'),(4938,52,'SPE','San-Pedro','Africa/Abidjan','A'),(4939,52,'SAS','Sassandra','Africa/Abidjan','A'),(4940,52,'SEG','Seguela','Africa/Abidjan','A'),(4941,52,'SIN','Sinfra','Africa/Abidjan','A'),(4942,52,'SOU','Soubre','Africa/Abidjan','A'),(4943,52,'TAB','Tabou','Africa/Abidjan','A'),(4944,52,'TAN','Tanda','Africa/Abidjan','A'),(4945,52,'TIE','Tiebissou','Africa/Abidjan','A'),(4946,52,'TIN','Tingrela','Africa/Abidjan','A'),(4947,52,'TIA','Tiassale','Africa/Abidjan','A'),(4948,52,'TBA','Touba','Africa/Abidjan','A'),(4949,52,'TLP','Toulepleu','Africa/Abidjan','A'),(4950,52,'TMD','Toumodi','Africa/Abidjan','A'),(4951,52,'VAV','Vavoua','Africa/Abidjan','A'),(4952,52,'YAM','Yamoussoukro','Africa/Abidjan','A'),(4953,52,'ZUE','Zuenoula','Africa/Abidjan','A'),(4954,53,'BB','Bjelovar-Bilogora','Europe/Zagreb','A'),(4955,53,'CZ','City of Zagreb','Europe/Zagreb','A'),(4956,53,'DN','Dubrovnik-Neretva','Europe/Zagreb','A'),(4957,53,'IS','Istra','Europe/Zagreb','A'),(4958,53,'KA','Karlovac','Europe/Zagreb','A'),(4959,53,'KK','Koprivnica-Krizevci','Europe/Zagreb','A'),(4960,53,'KZ','Krapina-Zagorje','Europe/Zagreb','A'),(4961,53,'LS','Lika-Senj','Europe/Zagreb','A'),(4962,53,'ME','Medimurje','Europe/Zagreb','A'),(4963,53,'OB','Osijek-Baranja','Europe/Zagreb','A'),(4964,53,'PS','Pozega-Slavonia','Europe/Zagreb','A'),(4965,53,'PG','Primorje-Gorski Kotar','Europe/Zagreb','A'),(4966,53,'SI','Sibenik','Europe/Zagreb','A'),(4967,53,'SM','Sisak-Moslavina','Europe/Zagreb','A'),(4968,53,'SB','Slavonski Brod-Posavina','Europe/Zagreb','A'),(4969,53,'SD','Split-Dalmatia','Europe/Zagreb','A'),(4970,53,'VA','Varazdin','Europe/Zagreb','A'),(4971,53,'VP','Virovitica-Podravina','Europe/Zagreb','A'),(4972,53,'VS','Vukovar-Srijem','Europe/Zagreb','A'),(4973,53,'ZK','Zadar-Knin','Europe/Zagreb','A'),(4974,53,'ZA','Zagreb','Europe/Zagreb','A'),(4975,54,'CA','Camaguey','America/Havana','A'),(4976,54,'CD','Ciego de Avila','America/Havana','A'),(4977,54,'CI','Cienfuegos','America/Havana','A'),(4978,54,'CH','Ciudad de La Habana','America/Havana','A'),(4979,54,'GR','Granma','America/Havana','A'),(4980,54,'GU','Guantanamo','America/Havana','A'),(4981,54,'HO','Holguin','America/Havana','A'),(4982,54,'IJ','Isla de la Juventud','America/Havana','A'),(4983,54,'LH','La Habana','America/Havana','A'),(4984,54,'LT','Las Tunas','America/Havana','A'),(4985,54,'MA','Matanzas','America/Havana','A'),(4986,54,'PR','Pinar del Rio','America/Havana','A'),(4987,54,'SS','Sancti Spiritus','America/Havana','A'),(4988,54,'SC','Santiago de Cuba','America/Havana','A'),(4989,54,'VC','Villa Clara','America/Havana','A'),(4990,55,'F','Famagusta','Asia/Nicosia','A'),(4991,55,'K','Kyrenia','Asia/Nicosia','A'),(4992,55,'A','Larnaca','Asia/Nicosia','A'),(4993,55,'I','Limassol','Asia/Nicosia','A'),(4994,55,'N','Nicosia','Asia/Nicosia','A'),(4995,55,'P','Paphos','Asia/Nicosia','A'),(4996,56,'U','&Uacute;steck&#253;','Europe/Prague','A'),(4997,56,'C','Jiho&#269;esk&#253;','Europe/Prague','A'),(4998,56,'B','Jihomoravsk&#253;','Europe/Prague','A'),(4999,56,'K','Karlovarsk&#253;','Europe/Prague','A'),(5000,56,'H','Kr&aacute;lov&eacute;hradeck&#253;','Europe/Prague','A'),(5001,56,'L','Libereck&#253;','Europe/Prague','A'),(5002,56,'T','Moravskoslezsk&#253;','Europe/Prague','A'),(5003,56,'M','Olomouck&#253;','Europe/Prague','A'),(5004,56,'E','Pardubick&#253;','Europe/Prague','A'),(5005,56,'P','Plze&#328;sk&#253;','Europe/Prague','A'),(5006,56,'A','Hlavn&iacute; m&#283;sto Praha','Europe/Prague','A'),(5007,56,'S','St&#345;edo&#269;esk&#253;','Europe/Prague','A'),(5008,56,'J','Vyso&#269;ina','Europe/Prague','A'),(5009,56,'Z','Zl&iacute;nsk&#253;','Europe/Prague','A'),(5010,57,'AR','Arhus','Europe/Copenhagen','A'),(5011,57,'BH','Bornholm','Europe/Copenhagen','A'),(5012,57,'CO','Copenhagen','Europe/Copenhagen','A'),(5013,57,'FO','Faroe Islands','Europe/Copenhagen','A'),(5014,57,'FR','Frederiksborg','Europe/Copenhagen','A'),(5015,57,'FY','Fyn','Europe/Copenhagen','A'),(5016,57,'KO','Kobenhavn','Europe/Copenhagen','A'),(5017,57,'NO','Nordjylland','Europe/Copenhagen','A'),(5018,57,'RI','Ribe','Europe/Copenhagen','A'),(5019,57,'RK','Ringkobing','Europe/Copenhagen','A'),(5020,57,'RO','Roskilde','Europe/Copenhagen','A'),(5021,57,'SO','Sonderjylland','Europe/Copenhagen','A'),(5022,57,'ST','Storstrom','Europe/Copenhagen','A'),(5023,57,'VK','Vejle','Europe/Copenhagen','A'),(5024,57,'VJ','Vestj&aelig;lland','Europe/Copenhagen','A'),(5025,57,'VB','Viborg','Europe/Copenhagen','A'),(5026,58,'S','Ali Sabih','Africa/Djibouti','A'),(5027,58,'K','Dikhil','Africa/Djibouti','A'),(5028,58,'J','Djibouti','Africa/Djibouti','A'),(5029,58,'O','Obock','Africa/Djibouti','A'),(5030,58,'T','Tadjoura','Africa/Djibouti','A'),(5031,59,'AND','Saint Andrew Parish','America/Dominica','A'),(5032,59,'DAV','Saint David Parish','America/Dominica','A'),(5033,59,'GEO','Saint George Parish','America/Dominica','A'),(5034,59,'JOH','Saint John Parish','America/Dominica','A'),(5035,59,'JOS','Saint Joseph Parish','America/Dominica','A'),(5036,59,'LUK','Saint Luke Parish','America/Dominica','A'),(5037,59,'MAR','Saint Mark Parish','America/Dominica','A'),(5038,59,'PAT','Saint Patrick Parish','America/Dominica','A'),(5039,59,'PAU','Saint Paul Parish','America/Dominica','A'),(5040,59,'PET','Saint Peter Parish','America/Dominica','A'),(5041,60,'DN','Distrito Nacional','America/Santo_Domingo','A'),(5042,60,'AZ','Azua','America/Santo_Domingo','A'),(5043,60,'BC','Baoruco','America/Santo_Domingo','A'),(5044,60,'BH','Barahona','America/Santo_Domingo','A'),(5045,60,'DJ','Dajabon','America/Santo_Domingo','A'),(5046,60,'DU','Duarte','America/Santo_Domingo','A'),(5047,60,'EL','Elias Pina','America/Santo_Domingo','A'),(5048,60,'SY','El Seybo','America/Santo_Domingo','A'),(5049,60,'ET','Espaillat','America/Santo_Domingo','A'),(5050,60,'HM','Hato Mayor','America/Santo_Domingo','A'),(5051,60,'IN','Independencia','America/Santo_Domingo','A'),(5052,60,'AL','La Altagracia','America/Santo_Domingo','A'),(5053,60,'RO','La Romana','America/Santo_Domingo','A'),(5054,60,'VE','La Vega','America/Santo_Domingo','A'),(5055,60,'MT','Maria Trinidad Sanchez','America/Santo_Domingo','A'),(5056,60,'MN','Monsenor Nouel','America/Santo_Domingo','A'),(5057,60,'MC','Monte Cristi','America/Santo_Domingo','A'),(5058,60,'MP','Monte Plata','America/Santo_Domingo','A'),(5059,60,'PD','Pedernales','America/Santo_Domingo','A'),(5060,60,'PR','Peravia (Bani)','America/Santo_Domingo','A'),(5061,60,'PP','Puerto Plata','America/Santo_Domingo','A'),(5062,60,'SL','Salcedo','America/Santo_Domingo','A'),(5063,60,'SM','Samana','America/Santo_Domingo','A'),(5064,60,'SH','Sanchez Ramirez','America/Santo_Domingo','A'),(5065,60,'SC','San Cristobal','America/Santo_Domingo','A'),(5066,60,'JO','San Jose de Ocoa','America/Santo_Domingo','A'),(5067,60,'SJ','San Juan','America/Santo_Domingo','A'),(5068,60,'PM','San Pedro de Macoris','America/Santo_Domingo','A'),(5069,60,'SA','Santiago','America/Santo_Domingo','A'),(5070,60,'ST','Santiago Rodriguez','America/Santo_Domingo','A'),(5071,60,'SD','Santo Domingo','America/Santo_Domingo','A'),(5072,60,'VA','Valverde','America/Santo_Domingo','A'),(5073,61,'AL','Aileu','','A'),(5074,61,'AN','Ainaro','','A'),(5075,61,'BA','Baucau','','A'),(5076,61,'BO','Bobonaro','','A'),(5077,61,'CO','Cova Lima','','A'),(5078,61,'DI','Dili','','A'),(5079,61,'ER','Ermera','','A'),(5080,61,'LA','Lautem','','A'),(5081,61,'LI','Liquica','','A'),(5082,61,'MT','Manatuto','','A'),(5083,61,'MF','Manufahi','','A'),(5084,61,'OE','Oecussi','','A'),(5085,61,'VI','Viqueque','','A'),(5086,62,'AZU','Azuay','America/Guayaquil','A'),(5087,62,'BOL','Bolivar','America/Guayaquil','A'),(5088,62,'CAN','Ca&ntilde;ar','America/Guayaquil','A'),(5089,62,'CAR','Carchi','America/Guayaquil','A'),(5090,62,'CHI','Chimborazo','America/Guayaquil','A'),(5091,62,'COT','Cotopaxi','America/Guayaquil','A'),(5092,62,'EOR','El Oro','America/Guayaquil','A'),(5093,62,'ESM','Esmeraldas','America/Guayaquil','A'),(5094,62,'GPS','Gal&aacute;pagos','America/Guayaquil','A'),(5095,62,'GUA','Guayas','America/Guayaquil','A'),(5096,62,'IMB','Imbabura','America/Guayaquil','A'),(5097,62,'LOJ','Loja','America/Guayaquil','A'),(5098,62,'LRO','Los R','America/Guayaquil','A'),(5099,62,'MAN','Manab&iacute;','America/Guayaquil','A'),(5100,62,'MSA','Morona Santiago','America/Guayaquil','A'),(5101,62,'NAP','Napo','America/Guayaquil','A'),(5102,62,'ORE','Orellana','America/Guayaquil','A'),(5103,62,'PAS','Pastaza','America/Guayaquil','A'),(5104,62,'PIC','Pichincha','America/Guayaquil','A'),(5105,62,'SUC','Sucumb&iacute;os','America/Guayaquil','A');

