10 lines
594 B
SQL
10 lines
594 B
SQL
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
ALTER TABLE admin_finance_applications
|
|
ADD COLUMN wallet_command_id VARCHAR(128) NOT NULL DEFAULT '' AFTER audited_at_ms,
|
|
ADD COLUMN wallet_transaction_id VARCHAR(128) NOT NULL DEFAULT '' AFTER wallet_command_id,
|
|
ADD COLUMN wallet_asset_type VARCHAR(64) NOT NULL DEFAULT '' AFTER wallet_transaction_id,
|
|
ADD COLUMN wallet_amount_delta BIGINT NOT NULL DEFAULT 0 AFTER wallet_asset_type,
|
|
ADD COLUMN wallet_balance_after BIGINT NOT NULL DEFAULT 0 AFTER wallet_amount_delta,
|
|
ADD KEY idx_admin_finance_app_wallet_tx (wallet_transaction_id);
|