Files
salvium-telegram-tipbot/migrations/20260530_withdrawal_fee_assets.sql
2026-05-30 17:08:42 +00:00

6 lines
329 B
SQL

-- Store the fee policy used for each withdrawal request.
-- Back up the database before running this on an existing installation.
ALTER TABLE withdrawals ADD COLUMN fee_asset_type VARCHAR(16) NULL AFTER amount;
ALTER TABLE withdrawals ADD COLUMN fee_amount DECIMAL(20, 12) NOT NULL DEFAULT 0.000000000000 AFTER fee_asset_type;