forked from c9s/bbgo
-
Notifications
You must be signed in to change notification settings - Fork 0
/
20210531234123_add_kline_taker_buy_columns.sql
41 lines (38 loc) · 1.29 KB
/
20210531234123_add_kline_taker_buy_columns.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
-- +up
-- +begin
ALTER TABLE `binance_klines`
ADD COLUMN `quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_base_volume` DECIMAL(16, 8) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0;
-- +end
-- +begin
ALTER TABLE `max_klines`
ADD COLUMN `quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_base_volume` DECIMAL(16, 8) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0;
-- +end
-- +begin
ALTER TABLE `okex_klines`
ADD COLUMN `quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_base_volume` DECIMAL(16, 8) NOT NULL DEFAULT 0.0,
ADD COLUMN `taker_buy_quote_volume` DECIMAL(32, 4) NOT NULL DEFAULT 0.0;
-- +end
-- +down
-- +begin
ALTER TABLE `binance_klines`
DROP COLUMN `quote_volume`,
DROP COLUMN `taker_buy_base_volume`,
DROP COLUMN `taker_buy_quote_volume`;
-- +end
-- +begin
ALTER TABLE `max_klines`
DROP COLUMN `quote_volume`,
DROP COLUMN `taker_buy_base_volume`,
DROP COLUMN `taker_buy_quote_volume`;
-- +end
-- +begin
ALTER TABLE `okex_klines`
DROP COLUMN `quote_volume`,
DROP COLUMN `taker_buy_base_volume`,
DROP COLUMN `taker_buy_quote_volume`;
-- +end