27 lines
1.5 KiB
MySQL
27 lines
1.5 KiB
MySQL
|
-- 已上线
|
|||
|
|
-- 菜单 SQL
|
|||
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|||
|
|
values('数据补传任务', '3000', '1', 'task', 'iot/task/index', 1, 0, 'C', '0', '0', 'iot:task:list', 'date-range', 'admin', sysdate(), '', null, '数据补传任务菜单');
|
|||
|
|
|
|||
|
|
create table iot_data_push_task
|
|||
|
|
(
|
|||
|
|
id bigint auto_increment
|
|||
|
|
primary key,
|
|||
|
|
task_name varchar(60) not null comment '任务名称',
|
|||
|
|
start_time datetime not null comment '开始时间',
|
|||
|
|
end_time datetime null comment '结束时间',
|
|||
|
|
total_num bigint null comment '总条数',
|
|||
|
|
process_num bigint null comment '已执行条数',
|
|||
|
|
product_id bigint not null comment '产品id',
|
|||
|
|
product_name varchar(30) null comment '产品名称',
|
|||
|
|
event_id int null comment '事件id',
|
|||
|
|
event_name varchar(60) null comment '事件名称',
|
|||
|
|
process_params json null comment '执行参数',
|
|||
|
|
process_type int not null comment '执行类型（1-属性 2-事件）',
|
|||
|
|
task_status int not null comment '执行状态（-1执行失败 1-执行中 2-执行完成）',
|
|||
|
|
data_start_time datetime null comment '数据推送开始时间',
|
|||
|
|
data_end_time datetime null comment '数据推送结束时间'
|
|||
|
|
)
|
|||
|
|
comment '数据补传任务';
|
|||
|
|
|