-- 20240405 添加是否业务员标志
|
ALTER TABLE `gear_finance`.`swx_user`
|
ADD COLUMN `salesman` tinyint(1) ZEROFILL NULL COMMENT '是否业务员（0否1是）' AFTER `bw`;
|
|
-- 20240514 新增字段分润类型,初始赋值
|
ALTER TABLE `gear_finance`.`swx_market_smart`
|
ADD COLUMN `profit_type` tinyint(1) ZEROFILL NULL COMMENT '分润类型 （0周期，1每日）' AFTER `smart_info`,
|
COMMENT = '智能交易产品表';
|
UPDATE swx_market_smart set profit_type = 0 where 1=1;
|
|
ALTER TABLE `gear_finance`.`swx_smart_order`
|
ADD COLUMN `profit_type` tinyint(1) ZEROFILL NULL COMMENT '分润类型 （0周期，1每日）' AFTER `current_profit`,
|
COMMENT = '智能交易订单表';
|
UPDATE swx_smart_order set profit_type = 0 where 1=1;
|
|
|
-- 20240514 新增提现类型
|
ALTER TABLE `gear_finance`.`swx_withdrawal_record`
|
ADD COLUMN `withdrawal_type` tinyint(1) NULL COMMENT '提现类型【1=BTC,2=ETH,3=USDT】' AFTER `status`;
|
