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

-- 为 cards 与 cards_his 表增加发放信息字段（价格/对象/备注/时间/管理员）
ALTER TABLE cards
    ADD COLUMN issue_price DECIMAL(10,2) NULL COMMENT '发放价格' AFTER is_extracted,
    ADD COLUMN issued_to VARCHAR(200) NULL COMMENT '发放给谁（文本）' AFTER issue_price,
    ADD COLUMN issue_remark VARCHAR(500) NULL COMMENT '发放备注' AFTER issued_to,
    ADD COLUMN issued_at DATETIME NULL COMMENT '发放时间' AFTER issue_remark,
    ADD COLUMN issued_admin_id INT NULL COMMENT '发放管理员ID' AFTER issued_at;

ALTER TABLE cards
    ADD INDEX idx_cards_issued_at (issued_at),
    ADD INDEX idx_cards_issued_admin_id (issued_admin_id);

ALTER TABLE cards_his
    ADD COLUMN issue_price DECIMAL(10,2) NULL COMMENT '发放价格' AFTER is_extracted,
    ADD COLUMN issued_to VARCHAR(200) NULL COMMENT '发放给谁（文本）' AFTER issue_price,
    ADD COLUMN issue_remark VARCHAR(500) NULL COMMENT '发放备注' AFTER issued_to,
    ADD COLUMN issued_at DATETIME NULL COMMENT '发放时间' AFTER issue_remark,
    ADD COLUMN issued_admin_id INT NULL COMMENT '发放管理员ID' AFTER issued_at;