iot-server/sql/online/20240625.sql

11 lines
639 B
SQL

--已同步
alter table sip_device_channel
modify streamId varchar(200) default '' not null comment '流媒体ID';
--已同步
alter table iot_device_log
modify log_value varchar(200) not null comment '日志值';
-- 新增视频设备同步定时任务(已同步到测试环境)
INSERT INTO sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) VALUES (1, '同步视频设备', 'DEFAULT', 'SyncVideoDevice.sync', '0 1/10 * * * ? ', '1', '1', '0', 'admin', '2024-06-25 16:05:06', 'admin', '2024-06-25 16:30:55', '');