bbgo_origin/migrations/mysql/20241115165059_add_net_profit_column.sql

-- +up
-- +begin
ALTER TABLE `positions`
    ADD COLUMN `net_profit` DECIMAL(16, 8) DEFAULT 0.00000000 NOT NULL
;
-- +end
-- +begin
UPDATE positions SET net_profit = profit WHERE net_profit = 0.0;
-- +end

-- +down

-- +begin
ALTER TABLE `positions`
DROP COLUMN `net_profit`
;
-- +end