--
-- Host: 172.26.54.120    Database: spro_yamaha_report
-- ------------------------------------------------------

SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;

--
-- GTID state at the beginning of the backup 
--


--
-- Table structure for table `md_default_config`
--

CREATE TABLE `md_default_config` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `DELETED` tinyint(1) DEFAULT '0',
  `TENANT_ID` bigint DEFAULT NULL,
  `inputColumn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `master_data_table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `output_column` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paramPrefixMail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paramRule` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `md_default_config`
--


--
-- Table structure for table `md_diff_config`
--

CREATE TABLE `md_diff_config` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `DELETED` tinyint(1) DEFAULT '0',
  `TENANT_ID` bigint DEFAULT NULL,
  `compare_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mapping_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mapping_mechanism` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_column` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suffix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_column` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'COPY',
  `expression_string` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `md_diff_config`
--

INSERT INTO `md_diff_config` VALUES (54,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Bo_phan','master_data_ymh_orgchart',NULL,'Bo_phan','master_data_mdit01_user','COPY',NULL),(55,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Phong_ban','master_data_ymh_orgchart',NULL,'Phong_ban','master_data_mdit01_user','COPY',NULL),(56,0,1,NULL,NULL,'Account_HSNS','update',NULL,'To','master_data_ymh_orgchart',NULL,'To','master_data_mdit01_user','COPY',NULL),(57,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Noi_lam_viec','master_data_ymh_orgchart',NULL,'Noi_lam_viec','master_data_mdit01_user','COPY',NULL),(58,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Ma_nhan_vien','master_data_ymh_orgchart',NULL,'Ma_nhan_vien','master_data_mdit01_user','COPY',NULL),(59,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Account','master_data_ymh_orgchart',NULL,'Account','master_data_mdit01_user','COPY',NULL),(60,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Ho_va_ten','master_data_ymh_orgchart',NULL,'Ho_va_ten','master_data_mdit01_user','COPY',NULL),(61,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Gender','master_data_ymh_orgchart',NULL,'Gender','master_data_mdit01_user','COPY',NULL),(62,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Bo_phan','master_data_ymh_orgchart',NULL,'Bo_phan','master_data_mdit01_user','COPY',NULL),(63,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Phong_ban','master_data_ymh_orgchart',NULL,'Phong_ban','master_data_mdit01_user','COPY',NULL),(64,0,1,NULL,NULL,'Account_HSNS','create',NULL,'To','master_data_ymh_orgchart',NULL,'To','master_data_mdit01_user','COPY',NULL),(65,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Noi_lam_viec','master_data_ymh_orgchart',NULL,'Noi_lam_viec','master_data_mdit01_user','COPY',NULL),(66,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Chuc_vu','master_data_ymh_orgchart',NULL,'Chuc_vu','master_data_mdit01_user','COPY',NULL),(67,0,1,'Sugesst_System_email','Ho_va_ten','Account_HSNS','create',NULL,'Suggest_System_fullname','master_data_ymh_orgchart','@yamaha-motor.com.vn','Suggest_System_fullname','master_data_mdit01_user','FULL_NAME_GENERATOR',NULL),(68,0,1,'Sugesst_System_email','Ho_va_ten','Account_HSNS','create','','Sugesst_System_email','master_data_ymh_orgchart','@yamaha-motor.com.vn','Sugesst_System_email','master_data_mdit01_user','EMAIL_GENERATOR',NULL),(69,0,1,NULL,NULL,'Account','update',NULL,'','master_data_mdit01_user',NULL,'Status_Acc','master_data_mdit01_user','EXPRESSION','Last_working_day != null && Last_working_day.length() > 0 && #ContextUtils.dateCompare(#ContextUtils.parseDate(Last_working_day, \'dd/MM/yyyy\'), #ContextUtils.currentDate()) < 0 ? \'Resigned\' : (Status_Acc != \'Closed\' ? \"Working\" : \"Closed\")'),(70,0,1,NULL,NULL,'Account','update',NULL,'','master_data_mdit01_user',NULL,'Resign_Date','master_data_mdit01_user','EXPRESSION','Last_working_day != null && Last_working_day.length() > 0 ? #ContextUtils.dateToString(#ContextUtils.parseDate(Last_working_day, \'dd/MM/yyyy\').plusDays(1), \'dd/MM/yyyy\') : Resign_Date'),(71,0,1,'','','Account_HSNS','create','','Ma_nhan_vien','master_data_ymh_orgchart','','Create_Date','master_data_mdit01_user','EXPRESSION','#ContextUtils.dateToString(#ContextUtils.currentDate(), \'dd/MM/yyyy\')'),(72,0,1,NULL,NULL,'Account','update',NULL,'Bo_phan','master_data_mdit01_user',NULL,'Bo_phan','master_data_mdit02_app','COPY',NULL),(73,0,1,NULL,NULL,'Account','update',NULL,'Phong_ban','master_data_mdit01_user',NULL,'Phong_ban','master_data_mdit02_app','COPY',NULL),(74,0,1,NULL,NULL,'Account','update',NULL,'To','master_data_mdit01_user',NULL,'To','master_data_mdit02_app','COPY',NULL),(75,0,1,NULL,NULL,'Account','update',NULL,'Noi_lam_viec','master_data_mdit01_user',NULL,'Noi_lam_viec','master_data_mdit02_app','COPY',NULL),(76,0,1,NULL,NULL,'Account','update',NULL,'Gender','master_data_mdit01_user',NULL,'Gender','master_data_mdit02_app','COPY',NULL),(77,0,1,NULL,NULL,'Account','update',NULL,'Chuc_vu','master_data_mdit01_user',NULL,'Chuc_vu','master_data_mdit02_app','COPY',NULL),(78,0,1,NULL,NULL,'Account','update',NULL,'System_Fullname','master_data_mdit01_user',NULL,'System_Fullname','master_data_mdit02_app','COPY',NULL),(79,0,1,NULL,NULL,'Account','update',NULL,'System_Email','master_data_mdit01_user',NULL,'System_Email','master_data_mdit02_app','COPY',NULL),(80,0,1,'Sugesst_System_email','Ho_va_ten','Account','update',NULL,'Suggest_System_fullname','master_data_mdit01_user','@yamaha-motor.com.vn','Suggest_System_fullname','master_data_mdit01_user','FULL_NAME_GENERATOR',NULL),(81,0,1,'Sugesst_System_email','Ho_va_ten','Account','update','','Sugesst_System_email','master_data_mdit01_user','@yamaha-motor.com.vn','Sugesst_System_email','master_data_mdit01_user','EMAIL_GENERATOR',NULL),(82,0,1,NULL,NULL,'Account','update',NULL,'Bo_phan','master_data_mdit04_special_account',NULL,'Bo_phan','master_data_mdit01_user','COPY',NULL),(83,0,1,NULL,NULL,'Account','update',NULL,'Phong_ban','master_data_mdit04_special_account',NULL,'Phong_ban','master_data_mdit01_user','COPY',NULL),(84,0,1,NULL,NULL,'Account','update',NULL,'To','master_data_mdit04_special_account',NULL,'To','master_data_mdit01_user','COPY',NULL),(85,0,1,NULL,NULL,'Account','update',NULL,'Noi_lam_viec','master_data_mdit04_special_account',NULL,'Noi_lam_viec','master_data_mdit01_user','COPY',NULL),(86,0,1,NULL,NULL,'Account','update',NULL,'Ho_va_ten','master_data_mdit04_special_account',NULL,'Ho_va_ten','master_data_mdit01_user','COPY',NULL),(87,0,1,NULL,NULL,'Account','update',NULL,'Gender','master_data_mdit04_special_account',NULL,'Gender','master_data_mdit01_user','COPY',NULL),(88,0,1,NULL,NULL,'Account','update',NULL,'Suggest_System_fullname','master_data_mdit04_special_account',NULL,'Suggest_System_fullname','master_data_mdit01_user','COPY',NULL),(89,0,1,NULL,NULL,'Account','update',NULL,'Sugesst_System_email','master_data_mdit04_special_account',NULL,'Sugesst_System_email','master_data_mdit01_user','COPY',NULL),(90,0,1,NULL,NULL,'Account','update',NULL,'System_Fullname','master_data_mdit04_special_account',NULL,'System_Fullname','master_data_mdit01_user','COPY',NULL),(91,0,1,NULL,NULL,'Account','update',NULL,'System_Email','master_data_mdit04_special_account',NULL,'System_Email','master_data_mdit01_user','COPY',NULL),(92,0,1,'','','Account_HSNS','create','','Ma_nhan_vien','master_data_ymh_orgchart','','Type_Of_User','master_data_mdit01_user','EXPRESSION','\"YMVN user\"'),(93,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Bo_phan','master_data_ymh_orgchart',NULL,'Bo_phan','master_data_mdit04_special_account','COPY',NULL),(94,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Phong_ban','master_data_ymh_orgchart',NULL,'Phong_ban','master_data_mdit04_special_account','COPY',NULL),(95,0,1,NULL,NULL,'Account_HSNS','update',NULL,'To','master_data_ymh_orgchart',NULL,'To','master_data_mdit04_special_account','COPY',NULL),(96,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Noi_lam_viec','master_data_ymh_orgchart',NULL,'Noi_lam_viec','master_data_mdit04_special_account','COPY',NULL),(97,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Ma_Khoi','master_data_ymh_orgchart',NULL,'Khoi','master_data_mdit01_user','COPY',NULL),(98,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Chuc_vu','master_data_ymh_orgchart',NULL,'Chuc_vu','master_data_mdit01_user','COPY',NULL),(99,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Chuc_danh','master_data_ymh_orgchart',NULL,'Chuc_danh','master_data_mdit01_user','COPY',NULL),(100,0,1,NULL,NULL,'Account_HSNS','update',NULL,'Gender','master_data_ymh_orgchart',NULL,'Gender','master_data_mdit01_user','COPY',NULL),(101,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Ma_Khoi','master_data_ymh_orgchart',NULL,'Khoi','master_data_mdit01_user','COPY',NULL),(103,0,1,NULL,NULL,'Account_HSNS','create',NULL,'Chuc_danh','master_data_ymh_orgchart',NULL,'Chuc_danh','master_data_mdit01_user','COPY',NULL),(104,0,1,NULL,NULL,'Account','update',NULL,'','master_data_mdit01_user',NULL,'Status_APP','master_data_mdit02_app','EXPRESSION','Last_working_day != null && Last_working_day.length() > 0 && #ContextUtils.dateCompare(#ContextUtils.parseDate(Last_working_day, \'dd/MM/yyyy\'), #ContextUtils.currentDate()) < 0 ? \'Deactivated\' : #targetDataItem.Status_APP');


