INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) 
VALUES ('SBC','$','SBC',1,'sbc/SbcMstServerSummary',1,3,'Subscription','1','','','SERM24050645','Subscription','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`)
 VALUES ('SBCMST','SBC','SBCMST',3,'sbc/SbcMstServerSummary',2,NULL,'Master','1','','','','Master','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) 
VALUES ('SBCMSTSER','SBCMST','SBCMSTSER',3,'sbc/SbcMstServerSummary',3,NULL,'Server','1','','','','Server','','','','N','N',NULL,NULL,NULL,NULL,'Y','/sbc/SbcMstServerSummary',NULL,NULL,NULL);

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) 
VALUES ('SBCMSTCON','SBCMST','SBCMSTCON',4,'sbc/SbcMstConsumerSummary',3,NULL,'Consumer','1','','','','Consumer','','','','N','N',NULL,NULL,NULL,NULL,'Y','/sbc/SbcMstConsumerSummary',NULL,NULL,NULL);

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`)
 VALUES ('SSQM2408090001', 'SERV', 'Server Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');

select * from adm_mst_tprivilegeangular;

INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911001',NULL,'SBC',NULL,'U1','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911002',NULL,'SBCMST',NULL,'U1','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911003',NULL,'SBCMSTSER',NULL,'U1','SBCMST',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911003',NULL,'SBCMSTCON',NULL,'U1','SBCMST',NULL,NULL,NULL,NULL);

 INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`)
 VALUES ('SSQM2408140001', 'CONG', 'Consumer Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');
 INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`)
 VALUES ('SSQM2408140002', 'COLO', 'Consumerlog Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');
   CREATE TABLE `adm_mst_tconsumer` (
  `consumer_gid` int(11) NOT NULL AUTO_INCREMENT,
  `server_gid` varchar(64) DEFAULT NULL,
  `company_code` varchar(64) DEFAULT NULL,
  `consumer_url` longtext,
  `subscription_details` longtext,
  `status` char(1) DEFAULT 'Y',
  PRIMARY KEY (`consumer_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
    
CREATE TABLE `duplicate_records` (
  `duplicaterecord_gid` int(11) NOT NULL AUTO_INCREMENT,
  `original_data` varchar(2000) DEFAULT NULL,
  `error_message` longtext,
  PRIMARY KEY (`duplicaterecord_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO `adm_mst_tuser` (`user_gid`,`usergroup_gid`,`user_code`,`user_firstname`,`user_lastname`,`user_password`,`user_status`,`password_suspend`,`password_changedate`,`user_password1`,`user_password2`,`user_password3`,`user_password4`,`user_password5`,`login_attempt`,`emailpassword`,`incoming_server`,`incoming_port`,`updated_by`,`updated_date`,`regional_username`,`super_authorizer`,`ticket_admin`,`created_by`,`created_date`,`dashboard_flag`) 
VALUES ('SUSM1709250001',NULL,'VCX001','Ramachandran','Kamalanathan','114','Y',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N','U1','2023-10-02 00:00:00',NULL);

INSERT INTO `adm_mst_tuser` (`user_gid`,`usergroup_gid`,`user_code`,`user_firstname`,`user_lastname`,`user_password`,`user_status`,`password_suspend`,`password_changedate`,`user_password1`,`user_password2`,`user_password3`,`user_password4`,`user_password5`,`login_attempt`,`emailpassword`,`incoming_server`,`incoming_port`,`updated_by`,`updated_date`,`regional_username`,`super_authorizer`,`ticket_admin`,`created_by`,`created_date`,`dashboard_flag`) 
VALUES ('SUSM2405140013',NULL,'VCX008','Chandra Sekhar','Nallagonda','114','Y',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N','U1','2023-10-02 00:00:00',NULL);


INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411001',NULL,'SBC',NULL,'SUSM1709250001','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411002',NULL,'SBCMST',NULL,'SUSM1709250001','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411003',NULL,'SBCMSTSER',NULL,'SUSM1709250001','SBCMST',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911007',NULL,'SBCMSTCON',NULL,'SUSM1709250001','SBCMST',NULL,NULL,NULL,NULL);

INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411004',NULL,'SBC',NULL,'SUSM2405140013','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411005',NULL,'SBCMST',NULL,'SUSM2405140013','SBC',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24081411006',NULL,'SBCMSTSER',NULL,'SUSM2405140013','SBCMST',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tprivilegeangular` (`privilege_gid`,`usergroup_gid`,`module_gid`,`isallow`,`user_gid`,`module_parent_gid`,`created_by`,`created_date`,`updated_by`,`updated_date`) 
VALUES ('SPGM24080911008',NULL,'SBCMSTCON',NULL,'SUSM2405140013','SBCMST',NULL,NULL,NULL,NULL);


CREATE TABLE `adm_mst_tconsumerlog` (
   `consumerlog_gid` int(11) NOT NULL AUTO_INCREMENT,
   `consumer_gid` varchar(64) DEFAULT NULL,
   `remarks` longtext,
   `status` char(1) DEFAULT 'Y',
   `updated_by` varchar(64) DEFAULT NULL,
   `updated_date` datetime DEFAULT NULL,
   PRIMARY KEY (`consumerlog_gid`)
 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
 
 
 alter table adm_mst_tconsumer add column active_status char(1) default 'Y';
  alter table adm_mst_tconsumer add column remarks longtext;
alter table vcxcontroller.crm_mst_tcompanyregister modify column company_code varchar(45) default null;

CREATE TABLE `adm_mst_tcountry` (
   `country_gid` varchar(64) NOT NULL,
   `country_code` varchar(32) DEFAULT NULL,
   `country_name` varchar(64) DEFAULT NULL,
   `display_order` int(11) DEFAULT NULL,
   `cou_code` varchar(45) DEFAULT NULL,
   `created_by` varchar(64) DEFAULT NULL,
   `created_date` datetime DEFAULT NULL,
   `updated_by` varchar(64) DEFAULT NULL,
   `updated_date` datetime DEFAULT NULL,
   KEY `ind_countrygid` (`country_gid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070002','CN02','Afghanistan',2,'93',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070003','CN03','Albania',3,'355',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070004','CN04','Algeria',4,'213',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070005','CN05','American Samoa',5,'1684',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070006','CN06','Andorra',6,'376',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070007','CN07','Angola',7,'244',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070008','CN08','Anguilla',8,'1264',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070009','CN09','Antarctica',9,'672',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070010','CN10','Antigua and Barbuda',10,'1268',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070011','CN11','Argentina',11,'54',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070012','CN12','Armenia',12,'374',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070013','CN13','Aruba',13,'297',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070014','CN14','Australia',14,'61',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070015','CN15','Austria',15,'43',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070016','CN16','Azerbaijan',16,'994',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070017','CN17','Bahamas',17,'1242',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070018','CN18','Bahrain',18,'973',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070019','CN19','Bangladesh',19,'880',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070020','CN20','Barbados',20,'1246',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070021','CN21','Belarus',21,'375',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070022','CN22','Belgium',22,'32',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070023','CN23','Belize',23,'501',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070024','CN24','Benin',24,'229',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070025','CN25','Bermuda',25,'1441',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070026','CN26','Bhutan',26,'975',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070027','CN27','Bolivia',27,'591',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070028','CN28','Bosnia Hercegovina',28,'387',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070029','CN29','Botswana',29,'267',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070030','CN30','Bouvet Island',30,'47',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070031','CN31','Brazil',31,'55',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070033','CN33','Brunei Darussalam',33,'673',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070034','CN34','Bulgaria',34,'359',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070035','CN35','Burkina Faso',35,'226',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070036','CN36','Burundi',36,'257',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070037','CN37','Cambodia',37,'855',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070038','CN38','Cameroon',38,'237',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070039','CN39','Canada',39,'1',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070040','CN40','Cape Verde',40,'238',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070041','CN41','Cayman Islands',41,'1345',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070042','CN42','Central African Republic',42,'236',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070043','CN43','Chad',43,'235',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070044','CN44','Chile',44,'56',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070045','CN45','China',45,'86',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070046','CN46','Christmas Island',46,'61',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070048','CN48','Colombia',48,'57',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070049','CN49','Comoros',49,'269',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070050','CN50','Congo',50,'242',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070051','CN51','Cook Islands',51,'682',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070052','CN52','Costa Rica',52,'506',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070054','CN54','Croatia',54,'385',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070055','CN55','Cuba',55,'53',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070056','CN56','Cyprus',56,'357',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070057','CN57','Czech Republic',57,'420',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070058','CN58','Denmark',58,'45',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070059','CN59','Djibouti',59,'253',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070060','CN60','Dominica',60,'1767',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070061','CN61','Dominican Republic',61,'1809',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070062','CN62','East Timor',62,'670',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070063','CN63','Ecuador',63,'593',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070064','CN64','Egypt',64,'20',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070065','CN65','EL Salvador',65,'503',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070066','CN66','Equatorial Guinea',66,'240',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070067','CN67','Eritrea',67,'291',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070068','CN68','Estonia',68,'372',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070069','CN69','Ethiopia',69,'251',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070071','CN71','Faroe Islands',71,'298',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070072','CN72','Fiji',72,'679',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070073','CN73','Finland',73,'358',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070074','CN74','France',74,'33',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070075','CN75','French Guiana',75,'594',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070076','CN76','French Polynesia',76,'689',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070078','CN78','Gabon',78,'241',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070079','CN79','Gambia',79,'220',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070080','CN80','Georgia',80,'995',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070081','CN81','Germany',81,'49',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070082','CN82','Ghana',82,'233',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070083','CN83','Gibraltar',83,'350',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070084','CN84','Greece',84,'30',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070085','CN85','Greenland',85,'299',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070086','CN86','Grenada',86,'1473',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070087','CN87','Guadeloupe',87,'590',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070088','CN88','Guam',88,'1671',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070089','CN89','Guatemala',89,'502',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070090','CN90','Guinea',90,'224',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070091','CN91','Guinea-Bissau',91,'245',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070092','CN92','Guyana',92,'592',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070093','CN93','Haiti',93,'509',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070095','CN95','Honduras',95,'504',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070096','CN96','Hong Kong',96,'852',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070097','CN97','Hungary',97,'36',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070098','CN98','Iceland',98,'354',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070099','CN99','India',99,'91',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070100','CN100','Indonesia',100,'62',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070101','CN101','Iran',101,'98',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070102','CN102','Iraq',102,'964',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070103','CN103','Ireland',103,'353',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070104','CN104','Israel',104,'972',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070105','CN105','Italy',105,'39',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070106','CN106','Jamaica',106,'1876',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070107','CN107','Japan',107,'81',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070108','CN108','Jordan',108,'962',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070109','CN109','Kazakhstan',109,'7',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070110','CN110','Kenya',110,'254',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070111','CN111','Kiribati',111,'686',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070114','CN114','Kuwait',114,'965',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070115','CN115','Kyrgyzstan',115,'996',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070116','CN116','Laos',116,'856',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070117','CN117','Latvia',117,'371',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070118','CN118','Lebanon',118,'961',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070119','CN119','Lesotho',119,'266',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070120','CN120','Liberia',120,'231',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070122','CN122','Liechtenstein',122,'423',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070123','CN123','Lithuania',123,'370',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070124','CN124','Luxembourg',124,'352',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070125','CN125','Macau',125,'853',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070126','CN126','Macedonia',126,'389',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070127','CN127','Madagascar',127,'261',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070128','CN128','Malawi',128,'265',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070129','CN129','Malaysia',129,'60',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070130','CN130','Maldives',130,'960',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070131','CN131','Mali',131,'223',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070132','CN132','Malta',132,'356',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070133','CN133','Marshall Islands',133,'492',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070134','CN134','Martinique',134,'596',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070135','CN135','Mauritania',135,'222',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070136','CN136','Mauritius',136,'230',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070137','CN137','Mayotte',137,'262',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070138','CN138','Mexico',138,'52',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070139','CN139','Micronesia',139,'691',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070140','CN140','Monaco',140,'377',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070141','CN141','Mongolia',141,'976',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070142','CN142','Montserrat',142,'1664',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070143','CN143','Morocco',143,'212',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070144','CN144','Mozambique',144,'258',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070145','CN145','Myanmar',145,'95',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070146','CN146','Nambia',146,'264',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070147','CN147','Nauru',147,'674',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070148','CN148','Nepal',148,'977',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070149','CN149','Netherlands',149,'31',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070150','CN150','Netherlands Antilles',150,'599',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070151','CN151','New Caledonia',151,'687',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070152','CN152','New Zealand',152,'64',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070153','CN153','Nicaragua',153,'505',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070154','CN154','Niger',154,'227',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070155','CN155','Nigeria',155,'237',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070156','CN156','Niue',156,'683',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070157','CN157','Norfolk Island',157,'672',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070159','CN159','Norway',159,'47',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070160','CN160','Oman',160,'968',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070161','CN161','Others',161,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070162','CN162','Pakistan',162,'92',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070163','CN163','Palau',163,'680',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070165','CN165','Panama',165,'507',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070166','CN166','Papua New Guinea',166,'675',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070167','CN167','Paraguay',167,'595',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070168','CN168','Peru',168,'51',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070169','CN169','Philippines',169,'63',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070170','CN170','Pitcairn',170,'870',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070171','CN171','Poland',171,'48',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070172','CN172','Portugal',172,'351',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070173','CN173','Puerto Rico',173,'1',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070174','CN174','Qatar',174,'972',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070175','CN175','Republic Of Moldova',175,'373',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070176','CN176','Reunion',176,'262',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070177','CN177','Romania',177,'40',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070178','CN178','Russia',178,'7',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070179','CN179','Rwanda',179,'250',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070180','CN180','Saint Kitts And Nevis',180,'1869',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070181','CN181','Saint Lucia',181,'1758',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070183','CN183','Samoa',183,'685',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070184','CN184','San Marino',184,'378',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070185','CN185','Sao Tome and Principe',185,'239',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070186','CN186','Saudi Arabia',186,'966',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070187','CN187','Senegal',187,'221',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070188','CN188','Seychelles',188,'248',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070189','CN189','Sierra Leone',189,'232',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070190','CN190','Singapore',190,'65',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070191','CN191','Slovakia',191,'421',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070192','CN192','Slovenia',192,'386',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070193','CN193','Solomon Islands',193,'677',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070194','CN194','Somalia',194,'252',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070195','CN195','South Africa',195,'227',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070197','CN197','Spain',197,'34',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070198','CN198','Sri Lanka',198,'94',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070199','CN199','St. Helena',199,'290',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070201','CN201','Sudan',201,'249',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070202','CN202','Suriname',202,'597',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070204','CN204','Swaziland',204,'268',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070205','CN205','Sweden',205,'46',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070206','CN206','Switzerland',206,'41',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070207','CN207','Syrian Arab Republic',207,'963',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070208','CN208','Taiwan',208,'886',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070209','CN209','Tajikistan',209,'992',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070210','CN210','Tanzania',210,'255',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070211','CN211','Thailand',211,'66',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070212','CN212','TOGO',212,'228',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070213','CN213','Tokelau',213,'690',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070214','CN214','Tonga',214,'676',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070215','CN215','Trinidad and Tobago',215,'1868',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070216','CN216','Tunisia',216,'216',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070217','CN217','Turkey',217,'90',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070218','CN218','Turkmenistan',218,'993',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070220','CN220','Tuvalu',220,'688',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070221','CN221','Uganda',221,'256',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070222','CN222','Ukraine',222,'380',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070223','CN223','United Arab Emirates',223,'971',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070224','CN224','United Kingdom',224,'44',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070225','CN225','United States',225,'1',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070227','CN227','Uruguay',227,'598',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070228','CN228','Uzbekistan',228,'998',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070229','CN229','Vanuatu',229,'678',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070231','CN231','Venezuela',231,'58',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070232','CN232','Vietnam',232,'84',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070236','CN236','Western Sahara',236,'212',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070237','CN237','Yemen',237,'967',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070238','CN238','Yugoslavia',238,'38',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070239','CN239','Zaire',239,'243',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070240','CN240','Zambia',240,'260',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070241','CN241','Zimbabwe',241,'263',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070242','CN242','Europe',242,'3166',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tcountry` (`country_gid`,`country_code`,`country_name`,`display_order`,`cou_code`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('CN06070243','CN243','England',243,'264',NULL,NULL,NULL,NULL);


alter table adm_mst_tserver add column country_name varchar(126) default null;
alter table vcxcontroller.crm_mst_tcompanyregister modify column company_code varchar(45) default null;
alter table adm_mst_tserver modify column server_gid int(11) auto_increment;


USE `vcxcontroller`;
DROP procedure IF EXISTS `adm_mst_spGetMenuDataangular`;

DELIMITER $$
USE `vcxcontroller`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `adm_mst_spGetMenuDataangular`(user_gid varchar(100))
 BEGIN
 
   SET @ExecuteSQL = CONCAT( 'SELECT a.module_gid, b.module_name,b.lw_flag, b.sref, b.icon, ', 'b.menu_level, b.module_gid_parent, b.display_order ', 'FROM adm_mst_tprivilegeangular a ', 'LEFT JOIN adm_mst_tmoduleangular b ON a.module_gid = b.module_gid ', 'WHERE user_gid = ''', user_gid, ''' AND ', 'b.lw_flag = ''Y'' ', 'GROUP BY a.module_gid ', 'ORDER BY b.display_order ASC' );
 
     PREPARE stmt FROM @ExecuteSQL;
 
     EXECUTE stmt;
 
     DEALLOCATE PREPARE stmt;
 
     END$$

DELIMITER ;

alter table adm_mst_tcompany add column company_address1 varchar(128) default null;
alter table adm_mst_tcompany add column company_state varchar(128) default null;
alter table adm_mst_tcompany add column contact_person_phone varchar(128) default null;


CREATE TABLE `adm_mst_tmodule` (
   `module_gid` varchar(64) NOT NULL,
   `module_gid_parent` varchar(64) DEFAULT NULL,
   `module_code` varchar(32) DEFAULT NULL,
   `display_order` int(11) DEFAULT NULL,
   `module_link` varchar(128) DEFAULT NULL,
   `menu_level` int(11) DEFAULT NULL,
   `max_menulevel` int(11) DEFAULT NULL,
   `module_name` varchar(64) DEFAULT NULL,
   `status` char(1) DEFAULT NULL,
   `image_url` text,
   `group_type` varchar(45) DEFAULT NULL,
   `modulemanager_gid` varchar(64) DEFAULT NULL,
   `breadcrumb_name` varchar(64) DEFAULT NULL,
   `approval_flag` char(1) DEFAULT NULL,
   `approval_tablename` varchar(45) DEFAULT NULL,
   `approval_type` varchar(64) DEFAULT NULL,
   `approval_limit` char(1) DEFAULT 'N',
   `module_flag` char(1) DEFAULT 'N',
   `created_by` varchar(64) DEFAULT NULL,
   `created_date` datetime DEFAULT NULL,
   `updated_by` varchar(64) DEFAULT NULL,
   `updated_date` datetime DEFAULT NULL,
   `lw_flag` char(1) DEFAULT 'N',
   `sref` varchar(64) DEFAULT NULL,
   `icon` varchar(64) DEFAULT NULL,
   `shopify_flag` varchar(64) DEFAULT NULL,
   `k_sref` varchar(120) DEFAULT NULL,
   PRIMARY KEY (`module_gid`),
   KEY `ind_modulegidparent` (`module_gid_parent`),
   KEY `ind_modulemanagergid` (`modulemanager_gid`),
   KEY `ind_modulecode` (`module_code`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;


alter table hrm_mst_temployee add column otp_value varchar(10) default null;
alter table hrm_mst_temployee add column otpexpiry_date datetime default null;

CREATE TABLE `adm_mst_totplogin` (
   `otplogin_gid` int(11) NOT NULL AUTO_INCREMENT,
   `otp_value` varchar(64) DEFAULT NULL,
   `employee_gid` varchar(64) DEFAULT NULL,
   `user_gid` varchar(64) DEFAULT NULL,
   `employee_emailid` varchar(128) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
   `expiry_time` datetime DEFAULT NULL,
   PRIMARY KEY (`otplogin_gid`)
 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;



CREATE TABLE `adm_mst_tmoduleangular` (
  `module_gid` varchar(64) NOT NULL,
  `module_gid_parent` varchar(64) DEFAULT NULL,
  `module_code` varchar(32) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `module_link` varchar(128) DEFAULT NULL,
  `menu_level` int(11) DEFAULT NULL,
  `max_menulevel` int(11) DEFAULT NULL,
  `module_name` varchar(64) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `image_url` text,
  `group_type` varchar(45) DEFAULT NULL,
  `modulemanager_gid` varchar(64) DEFAULT NULL,
  `breadcrumb_name` varchar(64) DEFAULT NULL,
  `approval_flag` char(1) DEFAULT NULL,
  `approval_tablename` varchar(45) DEFAULT NULL,
  `approval_type` varchar(64) DEFAULT NULL,
  `approval_limit` char(1) DEFAULT 'N',
  `module_flag` char(1) DEFAULT 'N',
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `lw_flag` char(1) DEFAULT 'N',
  `sref` varchar(64) DEFAULT NULL,
  `icon` varchar(64) DEFAULT NULL,
  `shopify_flag` varchar(1) DEFAULT NULL,
  `icon_name` varchar(64) DEFAULT NULL,
  `k_sref` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`module_gid`),
  KEY `ind_modulegidparent` (`module_gid_parent`),
  KEY `ind_modulemanagergid` (`modulemanager_gid`),
  KEY `ind_modulecode` (`module_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_mst_tpageprivilege` (
  `pageprivilege_gid` varchar(64) NOT NULL,
  `module_gid` varchar(64) DEFAULT NULL,
  `pageprivilege_code` varchar(32) DEFAULT NULL,
  `pageprivilege_name` varchar(64) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`pageprivilege_gid`),
  KEY `ind_modulegid` (`module_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_mst_tprivilegeangular` (
  `privilege_gid` varchar(64) NOT NULL,
  `usergroup_gid` varchar(64) DEFAULT NULL,
  `module_gid` varchar(64) DEFAULT NULL,
  `isallow` char(1) DEFAULT NULL,
  `user_gid` varchar(64) DEFAULT NULL,
  `module_parent_gid` varchar(64) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`privilege_gid`),
  KEY `ind_usergroupgid` (`usergroup_gid`),
  KEY `ind_modulegid` (`module_gid`),
  KEY `ind_usergid` (`user_gid`),
  KEY `ind_moduleparentgid` (`module_parent_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_mst_tsequence` (
  `sequence_gid` varchar(64) NOT NULL,
  `sequence_code` varchar(45) DEFAULT NULL,
  `sequence_name` varchar(45) DEFAULT NULL,
  `sequence_format` varchar(45) DEFAULT NULL,
  `sequence_curval` varchar(45) DEFAULT NULL,
  `sequence_flag` varchar(45) DEFAULT 'N',
  `branch_flag` varchar(45) DEFAULT 'N',
  `department_flag` varchar(45) DEFAULT 'N',
  `year_flag` varchar(45) DEFAULT 'N',
  `month_flag` varchar(45) DEFAULT NULL,
  `location_flag` varchar(45) DEFAULT 'N',
  `company_code` varchar(45) DEFAULT NULL,
  `delimeter` varchar(45) DEFAULT NULL,
  `runningno_prefix` varchar(45) DEFAULT NULL,
  `finyear` varchar(64) DEFAULT NULL,
  `carry_forward` varchar(64) DEFAULT 'N',
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `adm_mst_ttoken` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` text,
  `employee_gid` varchar(45) DEFAULT NULL,
  `user_gid` varchar(45) DEFAULT NULL,
  `company_code` varchar(45) NOT NULL,
  `department_gid` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `lawyer_gid` varchar(45) DEFAULT NULL,
  `external_usergid` varchar(45) DEFAULT NULL,
  `login_from` varchar(10) DEFAULT 'Web',
  `web_token` text,
  `customer_gid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=860 DEFAULT CHARSET=latin1;
CREATE TABLE `adm_mst_tuser` (
  `user_gid` varchar(64) NOT NULL,
  `usergroup_gid` varchar(64) DEFAULT NULL,
  `user_code` varchar(32) DEFAULT NULL,
  `user_firstname` varchar(64) DEFAULT NULL,
  `user_lastname` varchar(64) DEFAULT NULL,
  `user_password` varchar(128) DEFAULT NULL,
  `user_status` varchar(64) DEFAULT NULL,
  `password_suspend` char(1) DEFAULT NULL,
  `password_changedate` datetime DEFAULT NULL,
  `user_password1` varchar(16) DEFAULT NULL,
  `user_password2` varchar(16) DEFAULT NULL,
  `user_password3` varchar(16) DEFAULT NULL,
  `user_password4` varchar(16) DEFAULT NULL,
  `user_password5` varchar(16) DEFAULT NULL,
  `login_attempt` int(11) DEFAULT NULL,
  `emailpassword` varchar(35) DEFAULT NULL,
  `incoming_server` varchar(64) DEFAULT NULL,
  `incoming_port` varchar(10) DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` date DEFAULT NULL,
  `regional_username` longtext,
  `super_authorizer` char(2) NOT NULL DEFAULT 'N',
  `ticket_admin` varchar(45) NOT NULL DEFAULT 'N',
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `dashboard_flag` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`user_gid`),
  KEY `Index_2` (`user_firstname`),
  KEY `Index_3` (`user_lastname`),
  KEY `Index_4` (`usergroup_gid`),
  KEY `Index_5` (`user_password`),
  KEY `Index_6` (`user_status`),
  KEY `ind_usergroupgid` (`usergroup_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `adm_trn_tconsumertoken` (
  `consumertoken_gid` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(1024) NOT NULL,
  `company_code` varchar(25) NOT NULL,
  `user_code` varchar(25) NOT NULL,
  `connection_string` varchar(1024) NOT NULL,
  PRIMARY KEY (`consumertoken_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `hrm_mst_temployee` (
  `employee_gid` varchar(256) NOT NULL,
  `user_gid` varchar(256) DEFAULT NULL,
  `branch_gid` varchar(256) DEFAULT NULL,
  `employee_joiningdate` date DEFAULT NULL,
  `jobtype_gid` varchar(256) DEFAULT NULL,
  `employee_qualification` varchar(256) DEFAULT NULL,
  `designation_gid` varchar(256) DEFAULT NULL,
  `role_gid` varchar(64) DEFAULT NULL,
  `useraccess` varchar(64) DEFAULT NULL,
  `employee_phoneno` bigint(20) unsigned DEFAULT NULL,
  `employee_mobileno` varchar(45) DEFAULT NULL,
  `employee_personalno` varchar(45) DEFAULT NULL,
  `employee_dob` date DEFAULT NULL,
  `employee_emailid` varchar(256) DEFAULT NULL,
  `employee_experience` varchar(256) DEFAULT NULL,
  `employee_experiencedtl` varchar(256) DEFAULT NULL,
  `employee_documents` varchar(256) DEFAULT NULL,
  `employee_gender` varchar(256) DEFAULT NULL,
  `department_gid` varchar(256) DEFAULT NULL,
  `employment_type` varchar(256) DEFAULT NULL,
  `employeereporting_to` varchar(256) DEFAULT NULL,
  `employee_image` blob,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `mail_access` char(16) DEFAULT 'Yes',
  `email_password` varchar(256) DEFAULT NULL,
  `incoming_server` varchar(256) DEFAULT NULL,
  `incoming_port` varchar(10) DEFAULT NULL,
  `hierarchy_level` int(11) DEFAULT '-1',
  `active_flag` char(4) DEFAULT 'Y',
  `leavecredit_flag` char(4) DEFAULT 'N',
  `employee_sign` varchar(256) DEFAULT NULL,
  `emp_sign` longblob,
  `gl_code` varchar(64) DEFAULT NULL,
  `gl_code_flag` varchar(64) DEFAULT 'Not Assigned',
  `grade_gid` varchar(256) DEFAULT NULL,
  `basic_salary` double(13,2) DEFAULT NULL,
  `bank` varchar(256) DEFAULT NULL,
  `bank_code` varchar(256) DEFAULT NULL,
  `ac_no` varchar(256) DEFAULT NULL,
  `bank_branch` varchar(256) DEFAULT NULL,
  `pan_no` varchar(256) DEFAULT NULL,
  `uan_no` varchar(64) DEFAULT NULL,
  `pf_no` varchar(256) DEFAULT NULL,
  `esi_no` varchar(256) DEFAULT NULL,
  `bank_gid` varchar(256) DEFAULT NULL,
  `external_gl_code` varchar(256) DEFAULT NULL,
  `account_gid` varchar(256) DEFAULT NULL,
  `bloodgroup` varchar(256) DEFAULT NULL,
  `biometric_id` int(11) DEFAULT NULL,
  `default_screen` varchar(256) DEFAULT NULL,
  `default_module` varchar(256) DEFAULT NULL,
  `account_name` varchar(256) DEFAULT NULL,
  `account_password` varchar(256) DEFAULT NULL,
  `google_name` varchar(256) DEFAULT NULL,
  `google_password` varchar(256) DEFAULT NULL,
  `transfer_date` datetime DEFAULT NULL,
  `transfer_remarks` text,
  `attendance_flag` char(1) DEFAULT 'Y',
  `employeetype_gid` varchar(256) DEFAULT NULL,
  `rolltype_gid` varchar(256) DEFAULT NULL,
  `section_gid` varchar(256) DEFAULT NULL,
  `identity_no` varchar(256) DEFAULT NULL,
  `engagement_type` varchar(64) DEFAULT NULL,
  `remarks` longtext,
  `update_flag` varchar(2) DEFAULT 'N',
  `employee_tagid` varchar(64) DEFAULT NULL,
  `employee_hideattendance` varchar(64) DEFAULT NULL,
  `passport_no` varchar(64) DEFAULT NULL,
  `fin_no` varchar(64) DEFAULT NULL,
  `workpermit_no` varchar(64) DEFAULT NULL,
  `passport_expiredate` date DEFAULT NULL,
  `workpermit_expiredate` date DEFAULT NULL,
  `finno_expiredate` date DEFAULT NULL,
  `employeepreviouscompany_gid` varchar(64) DEFAULT NULL,
  `exit_date` datetime DEFAULT NULL,
  `alternative_mobile` varchar(64) DEFAULT NULL,
  `nationality` varchar(64) DEFAULT NULL,
  `nric_no` varchar(64) DEFAULT NULL,
  `employee_photo` varchar(256) DEFAULT NULL,
  `skill_set` varchar(128) DEFAULT NULL,
  `employee_diffabled` varchar(45) DEFAULT NULL,
  `age` varchar(45) DEFAULT NULL,
  `bloodgroup_name` varchar(64) DEFAULT NULL,
  `probation_flag` varchar(4) DEFAULT NULL,
  `probationary_until` date DEFAULT NULL,
  `father_name` varchar(64) DEFAULT NULL,
  `entity_gid` varchar(45) DEFAULT NULL,
  `entity_name` varchar(128) DEFAULT NULL,
  `employee_companyemailid` varchar(255) DEFAULT NULL,
  `mailbox` varchar(45) DEFAULT NULL,
  `level` varchar(64) DEFAULT NULL,
  `employee_skypeid` varchar(64) DEFAULT NULL,
  `emergency__mobileno` varchar(64) DEFAULT NULL,
  `employee_level` varchar(64) DEFAULT NULL,
  `integrated_gmail` varchar(1020) DEFAULT NULL,
  `file_name` varchar(64) DEFAULT NULL,
  `otp_value` varchar(10) DEFAULT NULL,
  `otpexpiry_date` datetime DEFAULT NULL,
  PRIMARY KEY (`employee_gid`),
  KEY `Index_2` (`user_gid`),
  KEY `idn_branchgid` (`branch_gid`),
  KEY `idn_jobtypegid` (`jobtype_gid`),
  KEY `idn_designationgid` (`designation_gid`),
  KEY `idn_departmentgid` (`department_gid`),
  KEY `idn_gradegid` (`grade_gid`),
  KEY `idn_bankgid` (`bank_gid`),
  KEY `idn_accountgid` (`account_gid`),
  KEY `biometric_id` (`biometric_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `hrm_mst_tdepartment` (
  `department_gid` varchar(64) NOT NULL,
  `department_code` varchar(64) DEFAULT NULL,
  `department_name` varchar(64) DEFAULT NULL,
  `department_remarks` longtext,
  `department_manager` varchar(45) DEFAULT NULL,
  `department_prefix` varchar(45) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `update_flag` varchar(2) DEFAULT 'N',
  `regional_departmentname` longtext,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`department_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



alter table adm_mst_tserver add column server_status varchar(45) default null;
alter table adm_mst_tserver add column created_by varchar(45) default null;
alter table adm_mst_tserver add column created_date datetime default null;


 CREATE TABLE `adm_mst_twhatsappotplogin` (
  `whatsappotplogin_gid` int(11) NOT NULL AUTO_INCREMENT,
  `otp_value` varchar(64) DEFAULT NULL,
  `company_name` varchar(500) DEFAULT NULL,
  `company_code` varchar(64) DEFAULT NULL,
  `customermail_id` varchar(128) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `expiry_time` datetime DEFAULT NULL,
  PRIMARY KEY (`whatsappotplogin_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

alter table crm_mst_tcompanysignup add column otp_value varchar(64) default null;
alter table crm_mst_tcompanysignup add column otpexpiry_time datetime default null;

alter table crm_mst_tcompanysignup add column otpverify_flag char(1) default 'N';
alter table crm_mst_tcompanysignup add column otpcreate_flag char(1) default 'N';

27/08/2024-prithika

INSERT INTO `vcxcontroller`.`adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SBCMSTSCP', 'SBCMST', 'SBCMSTSCP', '3', 'sbc/SbcMstScriptManagement', '3', 'Script Management', '1', 'Script Management', 'N', 'N', 'Y', '/sbc/SbcMstScriptManagement');
INSERT INTO `vcxcontroller`.`adm_mst_tprivilegeangular` (`privilege_gid`, `module_gid`, `user_gid`, `module_parent_gid`) VALUES ('SPGM24081411007', 'SBCMSTSCP', 'SUSM2405140013', 'SBCMST');

30/08/2024-prithika

INSERT INTO `vcxcontroller`.`adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SBCMSTDYB', 'SBCMST', 'SBCMSTDYB', '6', 'sbc/SbcMstDynamicdbcreation', '3', 'DynaicDB', '1', 'DynaicDB', 'N', 'N', 'Y', '/sbc/SbcMstDynamicdbcreation');

INSERT INTO `vcxcontroller`.`adm_mst_tprivilegeangular` (`privilege_gid`, `module_gid`, `user_gid`, `module_parent_gid`) VALUES ('SPGM24083011011', 'SBCMSTDYB', 'SUSM1709250001', 'SBCMST');