github.com/polarismesh/polaris@v1.17.8/store/mysql/scripts/delta/v1_12_0-v1_14_0.sql (about)

     1  /*
     2   * Tencent is pleased to support the open source community by making Polaris available.
     3   *
     4   * Copyright (C) 2019 THL A29 Limited, a Tencent company. All rights reserved.
     5   *
     6   * Licensed under the BSD 3-Clause License (the "License");
     7   * you may not use this file except in compliance with the License.
     8   * You may obtain a copy of the License at
     9   *
    10   * https://opensource.org/licenses/BSD-3-Clause
    11   *
    12   * Unless required by applicable law or agreed to in writing, software distributed
    13   * under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
    14   * CONDITIONS OF ANY KIND, either express or implied. See the License for the
    15   * specific language governing permissions and limitations under the License.
    16   */
    17  --
    18  -- Database: `polaris_server`
    19  --
    20  USE `polaris_server`;
    21  
    22  CREATE TABLE `leader_election`
    23  (
    24      `elect_key` VARCHAR(128) NOT NULL,
    25      `version`   BIGINT NOT NULL DEFAULT 0,
    26      `leader`    VARCHAR(128) NOT NULL,
    27      `ctime`     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    28      `mtime`     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    29      PRIMARY KEY (`elect_key`),
    30  	KEY `version` (`version`)
    31  ) engine = innodb;
    32  
    33  -- v1.14.0
    34  CREATE TABLE `circuitbreaker_rule_v2`
    35  (
    36      `id`                VARCHAR(128) NOT NULL,
    37      `name`              VARCHAR(64)  NOT NULL,
    38      `namespace`         VARCHAR(64)  NOT NULL default '',
    39      `enable`            INT          NOT NULL DEFAULT 0,
    40      `revision`          VARCHAR(40)  NOT NULL,
    41      `description`       VARCHAR(1024) NOT NULL DEFAULT '',
    42      `level`             INT          NOT NULL,
    43      `src_service`        VARCHAR(128) NOT NULL,
    44      `src_namespace`      VARCHAR(64)  NOT NULL,
    45      `dst_service`        VARCHAR(128) NOT NULL,
    46      `dst_namespace`      VARCHAR(64)  NOT NULL,
    47      `dst_method`         VARCHAR(128) NOT NULL,
    48      `config`            TEXT,
    49      `flag`              TINYINT(4)   NOT NULL DEFAULT '0',
    50      `ctime`             TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    51      `mtime`             TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    52      `etime`             TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    53      PRIMARY KEY (`id`),
    54      KEY `name` (`name`),
    55      KEY `mtime` (`mtime`)
    56  ) engine = innodb;
    57  
    58  CREATE TABLE `fault_detect_rule`
    59  (
    60      `id`            VARCHAR(128) NOT NULL,
    61      `name`          VARCHAR(64)  NOT NULL,
    62      `namespace`     VARCHAR(64)  NOT NULL default 'default',
    63      `revision`      VARCHAR(40)  NOT NULL,
    64      `description`   VARCHAR(1024) NOT NULL DEFAULT '',
    65      `dst_service`    VARCHAR(128) NOT NULL,
    66      `dst_namespace`  VARCHAR(64)  NOT NULL,
    67      `dst_method`     VARCHAR(128) NOT NULL,
    68      `config`        TEXT,
    69      `flag`          TINYINT(4)   NOT NULL DEFAULT '0',
    70      `ctime`         TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    71      `mtime`         TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    72      PRIMARY KEY (`id`),
    73      KEY `name` (`name`),
    74      KEY `mtime` (`mtime`)
    75  ) engine = innodb;