github.com/polarismesh/polaris@v1.17.8/store/mysql/scripts/delta/v1_17_0-v1_17_3.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  /* 配置分组表变更操作 */
    23  ALTER TABLE `config_file_group`
    24  ADD COLUMN `flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否被删除';
    25  
    26  ALTER TABLE `config_file_group`
    27  ADD COLUMN `business` varchar(64) DEFAULT NULL comment 'Service business information';
    28  
    29  ALTER TABLE `config_file_group`
    30  ADD COLUMN `department` varchar(1024) DEFAULT NULL comment 'Service department information';
    31  
    32  ALTER TABLE `config_file_group`
    33  ADD COLUMN `metadata` text COMMENT '配置分组标签';
    34  
    35  /* 配置发布表变更操作 */
    36  ALTER TABLE `config_file_release`
    37  ADD COLUMN `tags` text COMMENT '文件标签';
    38  
    39  ALTER TABLE `config_file_release`
    40  ADD COLUMN `active` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否处于使用中';
    41  
    42  ALTER TABLE `config_file_release`
    43  ADD COLUMN `format` varchar(16) DEFAULT 'text' COMMENT '文件格式，枚举值';
    44  
    45  ALTER TABLE `config_file_release`
    46  ADD COLUMN `description` varchar(512) DEFAULT '' COMMENT '发布描述';
    47  
    48  ALTER TABLE `config_file_release`
    49  ADD UNIQUE KEY `uk_file_release` (`namespace`, `group`, `file_name`, `name`);
    50  
    51  ALTER TABLE `config_file_release`
    52  DROP KEY `uk_file`;
    53  
    54  /* 配置历史表变更操作 */
    55  ALTER TABLE `config_file_release_history`
    56  ADD COLUMN `reason` varchar(3000) DEFAULT '' COMMENT '发布原因';
    57  
    58  ALTER TABLE `config_file_release_history`
    59  MODIFY COLUMN `tags` text COMMENT '文件标签';
    60  
    61  ALTER TABLE `config_file_release_history`
    62  ADD COLUMN `version` bigint(11) COMMENT '版本号, 每次发布自增1';
    63  
    64  ALTER TABLE `config_file_release_history`
    65  ADD COLUMN `description` varchar(512) DEFAULT NULL COMMENT '发布描述';