bbgo/migrations/mysql/20210421095030_increase_decimal_length.sql

26 lines
841 B
SQL

-- +up
ALTER TABLE `klines`
MODIFY COLUMN `volume` decimal(20,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `okex_klines`
MODIFY COLUMN `volume` decimal(20,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `binance_klines`
MODIFY COLUMN `volume` decimal(20,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `max_klines`
MODIFY COLUMN `volume` decimal(20,8) unsigned NOT NULL DEFAULT '0.00000000';
-- +down
ALTER TABLE `klines`
MODIFY COLUMN `volume` decimal(16,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `okex_klines`
MODIFY COLUMN `volume` decimal(16,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `binance_klines`
MODIFY COLUMN `volume` decimal(16,8) unsigned NOT NULL DEFAULT '0.00000000';
ALTER TABLE `max_klines`
MODIFY COLUMN `volume` decimal(16,8) unsigned NOT NULL DEFAULT '0.00000000';