---
apiVersion: v1
data:
  MYSQL_HOST: xxx
  MYSQL_PORT: "3306"
  MYSQL_DATABASE: nacos-sync
  MYSQL_USER: root
  MYSQL_PASSWORD: root
kind: ConfigMap
metadata:
  name: nacos-sync-config
  namespace: tools
---
apiVersion: v1
data:
  init.sql: >-
    /******************************************/

    /*   DB name = nacos_sync   */

    /*   Table name = cluster   */

    /******************************************/

    CREATE TABLE `cluster` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `cluster_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `cluster_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `cluster_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `connect_key_list` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `user_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `password` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4
    COLLATE=utf8mb4_bin;

    /******************************************/

    /*   DB name = nacos_sync   */

    /*   Table name = system_config   */

    /******************************************/

    CREATE TABLE `system_config` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `config_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `config_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `config_value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

    /******************************************/

    /*   DB name = nacos_sync   */

    /*   Table name = task   */

    /******************************************/

    CREATE TABLE `task` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `dest_cluster_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `group_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `name_space` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `operation_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `service_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `source_cluster_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `task_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `task_status` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `version` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      `worker_ip` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4
    COLLATE=utf8mb4_bin;
kind: ConfigMap
metadata:
  name: nacos-sync-init-sql
  namespace: tools