buff3.0/backend-admin/migrations/20260423_add_cards_revoke_fields.sql

-- 为 cards 与 cards_his 表增加“注销”字段：用于标记退回/作废的卡密不可再使用
ALTER TABLE cards
    ADD COLUMN is_revoked TINYINT NOT NULL DEFAULT 0 COMMENT '是否已注销：0-否，1-是' AFTER is_deleted,
    ADD COLUMN revoked_at DATETIME NULL COMMENT '注销时间' AFTER is_revoked,
    ADD COLUMN revoked_reason VARCHAR(500) NULL COMMENT '注销原因' AFTER revoked_at,
    ADD COLUMN revoked_admin_id INT NULL COMMENT '注销管理员ID' AFTER revoked_reason;

ALTER TABLE cards
    ADD INDEX idx_cards_is_revoked (is_revoked),
    ADD INDEX idx_cards_revoked_at (revoked_at),
    ADD INDEX idx_cards_revoked_admin_id (revoked_admin_id);

ALTER TABLE cards_his
    ADD COLUMN is_revoked TINYINT NOT NULL DEFAULT 0 COMMENT '是否已注销：0-否，1-是' AFTER is_deleted,
    ADD COLUMN revoked_at DATETIME NULL COMMENT '注销时间' AFTER is_revoked,
    ADD COLUMN revoked_reason VARCHAR(500) NULL COMMENT '注销原因' AFTER revoked_at,
    ADD COLUMN revoked_admin_id INT NULL COMMENT '注销管理员ID' AFTER revoked_reason;