Codex
8 lines
417 B
SQL
8 lines
417 B
SQL
ALTER TABLE qipai_cleaning_settlements
|
|
ADD COLUMN payout_state VARCHAR(32) NOT NULL DEFAULT '' AFTER payout_reference,
|
|
ADD COLUMN payout_package_info VARCHAR(1024) NOT NULL DEFAULT '' AFTER payout_state,
|
|
ADD KEY idx_qipai_cleaning_settlement_transfer_state (tenant_id, payout_state, updated_at);
|
|
|
|
INSERT IGNORE INTO qipai_schema_migrations (version, name)
|
|
VALUES ('2026062729', 'm08b_cleaning_transfer_state');
|