buff3.0/backend-admin/migrations/20260415_add_cards_is_extracted.sql

-- 为 cards 与 cards_his 表增加提取状态字段
ALTER TABLE cards
    ADD COLUMN is_extracted TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否已提取：0-未提取，1-已提取' AFTER is_gift;

ALTER TABLE cards
    ADD INDEX idx_cards_is_extracted (is_extracted);

ALTER TABLE cards_his
    ADD COLUMN is_extracted TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否已提取：0-未提取，1-已提取' AFTER is_gift;