github.com/polarismesh/polaris@v1.17.8/store/mysql/scripts/delta/v1_8_0-v1_11_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  
    21  USE `polaris_server`;
    22  
    23  ALTER TABLE `ratelimit_config` ADD COLUMN `name` varchar(64) NOT NULL;
    24  ALTER TABLE `ratelimit_config` ADD COLUMN `disable` tinyint(4)  NOT NULL DEFAULT '0';
    25  ALTER TABLE `ratelimit_config` ADD COLUMN `etime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
    26  ALTER TABLE `ratelimit_config` ADD COLUMN `method` varchar(512)   NOT NULL;
    27  ALTER TABLE `ratelimit_config` MODIFY COLUMN `cluster_id` varchar(32) DEFAULT '' comment 'Cluster ID, no use';
    28  
    29  
    30  CREATE TABLE `config_file_template` (
    31      `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
    32      `name` varchar(128) COLLATE utf8_bin NOT NULL COMMENT '配置文件模板名称',
    33      `content` longtext COLLATE utf8_bin NOT NULL COMMENT '配置文件模板内容',
    34      `format` varchar(16) COLLATE utf8_bin DEFAULT 'text' COMMENT '模板文件格式',
    35      `comment` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT '模板描述信息',
    36      `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    37      `create_by` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
    38      `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
    39      `modify_by` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '最后更新人',
    40      PRIMARY KEY (`id`),
    41      UNIQUE KEY `uk_name` (`name`)
    42  ) ENGINE=InnoDB COMMENT='配置文件模板表';
    43  
    44  INSERT INTO `config_file_template` (`id`,`name`,`content`,`format`,`comment`,`create_time`,`create_by`,`modify_time`,`modify_by`) VALUES (2,'spring-cloud-gateway-braining','{\n \"rules\":[\n {\n \"conditions\":[\n {\n \"key\":\"${http.query.uid}\",\n \"values\":[\n \"10000\"\n ],\n \"operation\":\"EQUALS\"\n }\n ],\n \"labels\":[\n {\n \"key\":\"env\",\n \"value\":\"green\"\n }\n ]\n }\n ]\n}','json','Spring Cloud Gateway 染色规则','2022-08-18 10:54:46','polaris','2022-08-18 10:55:22','polaris');
    45