dotnet/sql/20261022_add_tk_override_rules_response.sql

SET @column_exists := (
    SELECT COUNT(*)
    FROM information_schema.columns
    WHERE table_schema = DATABASE()
      AND table_name = 'tk_override_rules'
      AND column_name = 'response_success'
);

SET @sql := IF(
    @column_exists = 0,
    'ALTER TABLE tk_override_rules ADD COLUMN response_success TINYINT(1) NOT NULL DEFAULT 1 COMMENT ''命中规则后覆写的响应结果 success：1成功 0失败''',
    'SELECT 1'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @column_exists := (
    SELECT COUNT(*)
    FROM information_schema.columns
    WHERE table_schema = DATABASE()
      AND table_name = 'tk_override_rules'
      AND column_name = 'response_message'
);

SET @sql := IF(
    @column_exists = 0,
    'ALTER TABLE tk_override_rules ADD COLUMN response_message VARCHAR(255) NOT NULL DEFAULT '''' COMMENT ''命中规则后覆写的 message，为空沿用默认值''',
    'SELECT 1'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @column_exists := (
    SELECT COUNT(*)
    FROM information_schema.columns
    WHERE table_schema = DATABASE()
      AND table_name = 'tk_override_rules'
      AND column_name = 'response_reason'
);

SET @sql := IF(
    @column_exists = 0,
    'ALTER TABLE tk_override_rules ADD COLUMN response_reason VARCHAR(255) NOT NULL DEFAULT '''' COMMENT ''命中规则后覆写的 reason/sub_message，为空沿用默认值''',
    'SELECT 1'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;