---
#
# Copyright (C) 2019-2022 vdaas.org vald team <vald@vdaas.org>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    https://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-config
data:
  ddl.sql: |
    DROP SCHEMA IF EXISTS `vald` ;
    CREATE SCHEMA IF NOT EXISTS `vald` DEFAULT CHARACTER SET utf8 ;

    USE `vald` ;

    CREATE TABLE IF NOT EXISTS `vald`.`backup_vector` (
        `uuid` VARCHAR(255) NOT NULL,
        `vector` BLOB NOT NULL,
        `id` int NOT NULL AUTO_INCREMENT,
        PRIMARY KEY (`uuid`),
        UNIQUE INDEX `id_unique` (`id` ASC)
    )
    ENGINE = InnoDB;

    CREATE TABLE IF NOT EXISTS `vald`.`pod_ip` (
        `id` int NOT NULL,
        `ip` VARCHAR(64) NOT NULL,
        PRIMARY KEY (`id`, `ip`),
        INDEX `ip_index` (`ip` ASC)
    )
    ENGINE = InnoDB;
