etrade / dili-xtrade · Files

DROP TABLE IF EXISTS `dili_etrade`.`setting_price_be_modified`;
CREATE TABLE `dili_etrade`.`setting_price_be_modified`
(
    `id`            bigint       NOT NULL AUTO_INCREMENT,
    `market_id`     bigint       NOT NULL COMMENT '市场id',
    `market_name`   varchar(255) NOT NULL COMMENT '市场名称',
    `state`         int          NOT NULL COMMENT '1是0否',
    `created_time`  datetime     NOT NULL DEFAULT current_timestamp COMMENT '创建时间',
    `modified_time` datetime     NOT NULL DEFAULT current_timestamp on update current_timestamp COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `unq_m` (`market_id`) USING BTREE COMMENT '市场唯一'
) ENGINE = InnoDB
  AUTO_INCREMENT = 1 COMMENT ='下单单价能否修改设置';