create table supplier_diff_allow
(
    id          int,
    org_id      int                  not null,
    cor_type_id int                  not null,
    diff_allow  boolean default true not null
)
    comment '差异配置';

create unique index supplier_diff_allow_id_uindex
    on supplier_diff_allow (id);

alter table supplier_diff_allow
    add constraint supplier_diff_allow_pk
        primary key (id);

alter table supplier_diff_allow
    modify id int auto_increment;

alter table supplier_matching_log
    add REASON VARCHAR(255) null;

create table concur_event_log
(
    id            bigint,
    entry_id      varchar(50)  null,
    filepath      varchar(255) null,
    original_path varchar(255) null,
    create_time   datetime     null
)
    comment 'concur event log';

create unique index concur_event_log_id_uindex
    on concur_event_log (id);

alter table concur_event_log
    add constraint concur_event_log_pk
        primary key (id);

alter table concur_event_log
    modify id bigint auto_increment;

CREATE TABLE `mileage`
(
    `id`                 bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`               varchar(255)        DEFAULT NULL,
    `money`              double              DEFAULT NULL COMMENT '金额',
    `currency`           varchar(50)         DEFAULT NULL COMMENT '币种',
    `mileage_sum`        double     NOT NULL DEFAULT '0' COMMENT '总里程',
    `mileage_date`       datetime            DEFAULT NULL COMMENT '里程日期',
    `mileage_date_sum`   varchar(255)        DEFAULT NULL COMMENT '耗时总计',
    `location_start`     varchar(255)        DEFAULT NULL COMMENT '起点',
    `location_end`       varchar(255)        DEFAULT NULL COMMENT '终点',
    `status`             tinyint(1) NOT NULL DEFAULT '0' COMMENT '0/未完成 1/已完成',
    `used_status`        tinyint(1) NOT NULL DEFAULT '0' COMMENT '0/未使用 1/已使用',
    `user_id`            int(11)    NOT NULL,
    `create_time`        datetime            DEFAULT NULL,
    `update_time`        datetime            DEFAULT NULL,
    `mileage_sum_affirm` double     NOT NULL DEFAULT '0' COMMENT '确认里程数',
    `remark`             varchar(255)        DEFAULT NULL,
    `image`              varchar(255)        DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1669
  DEFAULT CHARSET = utf8;

CREATE TABLE `mileage_detail`
(
    `id`          bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `mileage_id`  bigint(20) NOT NULL COMMENT '里程ID',
    `sort`        int        NOT NULL DEFAULT '0' COMMENT '里程顺序 0为起点',
    `title`       varchar(255)        DEFAULT NULL COMMENT '地点名称',
    `longitude`   double              DEFAULT NULL COMMENT '经度',
    `latitude`    double              DEFAULT NULL COMMENT '纬度',
    `distance`    double     NOT NULL DEFAULT '0' COMMENT '与上一个地点的距离',
    `arrive_time` datetime            DEFAULT NULL COMMENT '到达该地点时间',
    `create_time` datetime            DEFAULT NULL,
    `update_time` datetime            DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1669
  DEFAULT CHARSET = utf8 COMMENT ='里程途径地点细节';