etrade / dili-xtrade · Files

DROP TABLE IF EXISTS `dili_etrade`.`setting_shop_common`;
CREATE TABLE `dili_etrade`.`setting_shop_common`
(
    `id`            bigint   NOT NULL AUTO_INCREMENT,
    `market_id`     bigint   NOT NULL COMMENT '市场id',
    `shop_id`       bigint   NOT NULL COMMENT '店铺id',
    `type`          int      NOT NULL COMMENT '1核销',
    `state`         int      NOT NULL COMMENT '1开启0关闭',
    `extra`         text     NULL COMMENT '额外的',
    `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_s_t_m` (`shop_id`, `type`, `market_id`) USING BTREE COMMENT '店铺唯一'
) ENGINE = InnoDB
  AUTO_INCREMENT = 1 COMMENT ='店铺公共设置';