bbgo/migrations/sqlite3/20210118163847_fix_unique_index.sql

10 lines
180 B
SQL

-- +up
-- +begin
CREATE UNIQUE INDEX `trade_unique_id` ON `trades` (`exchange`,`symbol`, `side`, `id`);
-- +end
-- +down
-- +begin
DROP INDEX IF EXISTS `trade_unique_id`;
-- +end