bbgo_origin/migrations/mysql/20210421095030_increase_decimal_length.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';