Files
monisuo/sql/patch_order_trade_cost_price.sql
2026-04-21 08:12:17 +08:00

3 lines
227 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- 给交易订单表添加成本价字段卖出时记录当时的avgPrice
ALTER TABLE order_trade ADD COLUMN `cost_price` decimal(20,8) DEFAULT NULL COMMENT '卖出时的成本价(买入加权平均价)' AFTER `amount`;