-- MySQL dump 10.13  Distrib 8.0.46, for Win64 (x86_64)
--
-- Host: 172.26.54.120    Database: spro_yamaha_report
-- ------------------------------------------------------
-- Server version	8.0.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;

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

SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '3d43248c-5272-11ef-9514-fa163e9ac45d:1-20315358';

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

DROP TABLE IF EXISTS `md_default_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `md_default_config` WRITE;
/*!40000 ALTER TABLE `md_default_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `md_default_config` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `md_diff_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `md_diff_config` WRITE;
/*!40000 ALTER TABLE `md_diff_config` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `md_diff_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `md_diff_config_mapping`
--

DROP TABLE IF EXISTS `md_diff_config_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `md_diff_config_mapping` (
  `ID` bigint NOT NULL AUTO_INCREMENT,
  `DELETED` tinyint(1) DEFAULT '0',
  `TENANT_ID` bigint DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `mechanism` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `md_diff_config_mapping`
--

LOCK TABLES `md_diff_config_mapping` WRITE;
/*!40000 ALTER TABLE `md_diff_config_mapping` DISABLE KEYS */;
INSERT INTO `md_diff_config_mapping` VALUES (1,0,1,'Ma_nhan_vien','Ma_nhan_vien',NULL,NULL,'MAPPING'),(2,0,1,'Account','Account',NULL,NULL,'MAPPING'),(3,0,1,'Account_HSNS','Account',NULL,NULL,'MAPPING'),(4,0,1,'Account_HSNS','HSNS','1','EQUALS','REQUIRED'),(5,0,1,'Ma_nhan_vien_HSNS','HSNS','1','EQUALS','REQUIRED'),(6,0,1,'Ma_nhan_vien_HSNS','Ma_nhan_vien',NULL,NULL,'MAPPING');
/*!40000 ALTER TABLE `md_diff_config_mapping` ENABLE KEYS */;
UNLOCK TABLES;
SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-19 19:50:29