bbgo_origin/migrations/sqlite3/20210215203111_add_pnl_column.sql
2021-02-15 20:35:27 +08:00

19 lines
321 B
SQL

-- +up
-- +begin
ALTER TABLE `trades` ADD COLUMN `pnl` DECIMAL NULL;
-- +end
-- +begin
ALTER TABLE `trades` ADD COLUMN `strategy` TEXT;
-- +end
-- +down
-- +begin
ALTER TABLE `trades` RENAME COLUMN `pnl` TO `pnl_deleted`;
-- +end
-- +begin
ALTER TABLE `trades` RENAME COLUMN `strategy` TO `strategy_deleted`;
-- +end