-- 注入攻击细分规则扩展字段（用于“细分规则管理”编辑页）
-- 执行日期：2026-03-06

-- PostgreSQL
ALTER TABLE d_attack_rule
    ADD COLUMN IF NOT EXISTS rule_name VARCHAR(200) DEFAULT '',
    ADD COLUMN IF NOT EXISTS rule_desc TEXT,
    ADD COLUMN IF NOT EXISTS risk_level VARCHAR(20) DEFAULT 'MEDIUM',
    ADD COLUMN IF NOT EXISTS version_no VARCHAR(32) DEFAULT '',
    ADD COLUMN IF NOT EXISTS expire_at timestamp;

COMMENT ON COLUMN d_attack_rule.rule_name IS '规则名称';
COMMENT ON COLUMN d_attack_rule.rule_desc IS '规则描述';
COMMENT ON COLUMN d_attack_rule.risk_level IS '风险等级';
COMMENT ON COLUMN d_attack_rule.version_no IS '版本号';
COMMENT ON COLUMN d_attack_rule.expire_at IS '到期时间';

-- MySQL 8+
ALTER TABLE d_attack_rule
    ADD COLUMN IF NOT EXISTS rule_name VARCHAR(200) NOT NULL DEFAULT '' COMMENT '规则名称',
    ADD COLUMN IF NOT EXISTS rule_desc TEXT COMMENT '规则描述',
    ADD COLUMN IF NOT EXISTS risk_level VARCHAR(20) NOT NULL DEFAULT 'MEDIUM' COMMENT '风险等级',
    ADD COLUMN IF NOT EXISTS version_no VARCHAR(32) NOT NULL DEFAULT '' COMMENT '版本号',
    ADD COLUMN IF NOT EXISTS expire_at DATETIME NULL COMMENT '到期时间';