INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-000-000-001-department', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-department', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[' || '{\"fieldName\":\"code\",\"onlyForNew\":false},{\"fieldName\":\"created_time\",\"onlyForNew\":true},{\"fieldName\":\"display_order\",\"onlyForNew\":false},{\"fieldName\":\"organization_id\",\"fixedValue\":\"__UDa4uPMdcOYgP7HETaf\",\"onlyForNew\":true},{\"fieldName\":\"ID\",\"onlyForNew\":true},{\"fieldName\":\"index_tree\",\"onlyForNew\":false},{\"fieldName\":\"last_updated_time\",\"onlyForNew\":false},{\"fieldName\":\"level\",\"onlyForNew\":false},' || '{\"fieldName\":\"name\",\"onlyForNew\":false},{\"fieldName\":\"permission_config\",\"onlyForNew\":false},{\"fieldName\":\"permission_type\",\"onlyForNew\":false},{\"fieldName\":\"status\",\"onlyForNew\":false},{\"fieldName\":\"total_member\",\"onlyForNew\":false},{\"fieldName\":\"parent_id\",\"onlyForNew\":false}],\"tableName\":\"tenant_departments\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-t_department-002', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-department', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[' || '{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"name\",\"fixedValue\":\"#{name}\",\"onlyForNew\":false},' || '{\"fieldName\":\"superior\",\"fixedValue\":\"#{parent_id}\",\"onlyForNew\":false},{\"fieldName\":\"domain_id\",\"fixedValue\":\"__UDa4uPMdcOYgP7HETaf\",\"onlyForNew\":false},' || '{\"fieldName\":\"LEVELS\",\"fixedValue\":\"#{level}\",\"onlyForNew\":false}],\"tableName\":\"t_user\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-employee-identity-user', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"TL5_entProd_v5#202109erprise#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"tenant_user_id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"telephone\",\"fixedValue\":\"#{telephone}\",\"onlyForNew\":false},{\"fieldName\":\"name\",\"fixedValue\":\"#{name}\",\"onlyForNew\":false},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":false}],\"tableName\":\"identity_user\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-employee-identity_principals', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":true},{\"fieldName\":\"status\",\"fixedValue\":\"0\",\"onlyForNew\":true},{\"fieldName\":\"identity_user_id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true}],\"tableName\":\"identity_principals\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-employee-identity_usrpsd', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"algorithm_type\",\"fixedValue\":\"0\",\"onlyForNew\":true},{\"fieldName\":\"user_name\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"password\",\"fixedValue\":\"abacff92c43690f2e89e70013f5afe865989831d96d196c823d9fe94\",\"onlyForNew\":true}],\"tableName\":\"identity_userpassword\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-employee-tenant_users', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":true},{\"fieldName\":\"authenticated_status\",\"fixedValue\":\"3\",\"onlyForNew\":true},{\"fieldName\":\"checked_status\",\"fixedValue\":\"2\",\"onlyForNew\":true},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":true},{\"fieldName\":\"sex\",\"fixedValue\":\"#{sex}\",\"onlyForNew\":false},{\"fieldName\":\"user_type\",\"fixedValue\":\"0\",\"onlyForNew\":false}],\"tableName\":\"tenant_users\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-tenant-app-employee-tenant_emye_rens', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":true},{\"fieldName\":\"employee_id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"organization_id\",\"fixedValue\":\"__UDa4uPMdcOYgP7HETaf\",\"onlyForNew\":true},{\"fieldName\":\"tenant_user_id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":false},{\"fieldName\":\"user_type\",\"fixedValue\":\"0\",\"onlyForNew\":false}],\"tableName\":\"tenant_employee_relations\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-app-tenant_employees-001', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":true},{\"fieldName\":\"master_slave_type\",\"fixedValue\":\"2\",\"onlyForNew\":false},{\"fieldName\":\"occupation_type\",\"fixedValue\":\"2\",\"onlyForNew\":true},{\"fieldName\":\"status\",\"fixedValue\":\"0\",\"onlyForNew\":false},{\"fieldName\":\"tenant_user_id\",\"fixedValue\":\"#{tenant_user_id}\",\"onlyForNew\":false},{\"fieldName\":\"is_domain_admin\",\"fixedValue\":\"0\",\"onlyForNew\":false}],\"tableName\":\"tenant_employees\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-employee_relations-002', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"created_time\",\"fixedValue\":\"#{created_time}\",\"onlyForNew\":true},{\"fieldName\":\"master_slave_type\",\"fixedValue\":\"2\",\"onlyForNew\":false},{\"fieldName\":\"department_id\",\"fixedValue\":\"#{depart_id}\",\"onlyForNew\":false},{\"fieldName\":\"employee_id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":false}],\"tableName\":\"tenant_department_employee_relations\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-t_user-003', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"LOGINNO\",\"fixedValue\":\"#{telephone}\",\"onlyForNew\":false},{\"fieldName\":\"NAME\",\"fixedValue\":\"#{name}\",\"onlyForNew\":false},{\"fieldName\":\"LOGINPWD\",\"fixedValue\":\"xasasasaxxx@324321asasasass\",\"onlyForNew\":false},{\"fieldName\":\"domainid\",\"fixedValue\":\"#{domain_id}\",\"onlyForNew\":false},' || '{\"fieldName\":\"dimission\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"LEVELS\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"STATUS\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"LIAISON_OFFICER\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"TELEPHONEPUBLIC\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"TELEPHONEPUBLIC2\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"EMAILPUBLIC\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"USERINFOPUBLIC\",\"fixedValue\":\"1\",\"onlyForNew\":false},{\"fieldName\":\"PERMISSION_TYPE\",\"fixedValue\":\"public\",\"onlyForNew\":false},{\"fieldName\":\"DEFAULTDEPARTMENT\",\"fixedValue\":\"#{depart_id}\",\"onlyForNew\":false}],\"tableName\":\"t_user\"}}'); INSERT INTO `obpm2_security`.`sync_data_maps`(`id`, `created_time`, `last_updated_time`, `map_key`, `target_config`) VALUES ('map-instance-form-t_user_department_role_set-003', '2021-01-01 00:00:01', '2021-01-01 00:00:01', 'tenant-app-employee', '{\"jdbcConnection\":{\"driverClass\":\"com.mysql.jdbc.Driver\",\"password\":\"Prod_v5#202109\",\"poolSize\":\"200\",\"sqlParserBeanName\":\"MySql_SqlParser\",\"url\":\"jdbc:mysql://192.168.0.7:3368/obpm2?useUnicode=true&characterEncoding=utf8&useSSL=false\",\"username\":\"v5_enterprise2021\"},\"tableMap\":{\"autoMap\":false,\"columns\":[' || '{\"fieldName\":\"id\",\"fixedValue\":\"#{id}\",\"onlyForNew\":true},{\"fieldName\":\"DEPARTMENTID\",\"fixedValue\":\"#{depart_id}\",\"onlyForNew\":false},' || '{\"fieldName\":\"USERID\",\"fixedValue\":\"#{id}\",\"onlyForNew\":false}],\"tableName\":\"t_user_department_role_set\"}}');