V1.02__addDataStatistic.sql

create table if not exists d_data_statistic
(
    id        BIGINT       NOT NULL PRIMARY KEY AUTO_INCREMENT,
    task_id   bigint       not null comment '任务ID',
    task_name varchar(128) not null comment '任务名称',
    date      date         not null default (current_date) comment '日期',
    hour      int          not null comment '小时',
    traffic   int          not null default 0 comment '交通数据量',
    behavior  int          not null default 0 comment '事件数据量',
    flow      int          not null default 0 comment '流量数据量',
    key `d_data_statistic_idx` (`date`, `task_id`)
);