9 lines
503 B
SQL
9 lines
503 B
SQL
CREATE TABLE `health`.`ufutx_orders_extend` (
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT ,
|
|
`dma_id` BIGINT NOT NULL ,
|
|
`commissions_status` TINYINT NOT NULL DEFAULT '1' COMMENT '1=未知,2=不可分润,3=可分润未分,4=可分润已分' ,
|
|
`commissions_count` INT NOT NULL DEFAULT '0' COMMENT '分润数量' ,
|
|
`commissions_withdraw_count` INT NOT NULL DEFAULT '0' COMMENT '提现数量' ,
|
|
PRIMARY KEY (`id`),
|
|
INDEX (`dma_id`)
|
|
) ENGINE = InnoDB COMMENT = 'dma订单扩展表'; |