40 lines
14 KiB
SQL
40 lines
14 KiB
SQL
/*
|
||
SQLyog Community v13.1.6 (64 bit)
|
||
MySQL - 8.1.0
|
||
*********************************************************************
|
||
*/
|
||
/*!40101 SET NAMES utf8 */;
|
||
use `cmii_sky_converge`;
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300002', '300001', '300002', '300002', 'count', '车辆识别', '检测无人机航拍场景中，出现的车辆', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:44:25', '2026-04-20 13:59:26', 'sky_ai_load', '{"aiCode":"peopleVehicle","withVideo":true,"warnTextFormatter":"const{bus, truck, car}=data;const range=[{value:10, text:\'轻度拥堵\'},{value:40, text:\'中度拥堵\'},{value:100, text:\'重度拥堵\'}];const total=bus+truck+car;for(let i=range.length-1;i>=0;i--){if(total>=range[i].value){return range[i].text;}}return \'\';","isMe":"return data.model===AI_MODE.peopleVehicle"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300003', '300001', '300003', '300003', 'count', '周界入侵', '检测无人机航拍场景中，某一小型区域内出现的目标。', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:44:47', '2026-04-20 13:59:26', 'sky_ai_load', '{"aiCode":"compass","withVideo":true,"warnTextFormatter":"const obj={people:\'人\',car:\'汽车\',truck:\'卡车\',bus:\'公交车\'};return Object.entries(obj).reduce((str, [k,v]) =>str+v+\'：\'+Number(data[k])+\' \', \'\');","isMe":"return data.model===AI_MODE.compass"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300004', '300001', '300004', '300004', 'count', '车辆跨线', '检测无人机航拍场景中，经过某一路口的车辆（轿车、卡车、公交、面包车、吉普车等）总数量。该功能可以累计一次统计中过往所有车辆的总数量', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:45:17', '2026-04-20 13:59:26', 'sky_ai_load', '{"aiCode":"vehicleCrosslineDetection","withVideo":true,"warnTextFormatter":"const obj={car:\'汽车\',truck:\'卡车\',bus:\'公交车\'};return Object.entries(obj).reduce((str, [k,v]) =>str+v+\'：\'+Number(data[k])+\' \', \'\');","isMe":"return data.model===AI_MODE.vehicleCrosslineDetection"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300005', '300001', '300005', '300005', 'count', '车牌识别', '检测无人机航拍场景中，车辆的车牌号', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:45:49', '2026-04-20 13:59:26', 'sky_ai_load', '{"aiCode":"plate","withVideo":true,"warnText":"发现车牌","isMe":"return data.model===AI_MODE.plate"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300007', '300001', '300007', '300007', 'count', '消防通道占用', '检测无人机航拍场景中被车辆占用的消防通道', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:46:35', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"fireExit","withVideo":true,"warnText":"发现消防通道占用","isMe":"return data.model===AI_MODE.fireExit"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300012', '300001', '300012', '300012', 'count', '红外人体', '检测无人机航拍视角下的红外人体目标，夜间巡逻安保', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:47:16', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"infraredPerson","withVideo":true,"warnText":"发现人员","isMe":"return data.model===AI_MODE.infraredPerson"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300013', '300001', '300013', '300013', 'count', '船只检测', '检测无人机航拍视角下，海面中的船只', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:47:50', '2026-04-20 13:59:26', 'sky_ai_water_ecology', '{"aiCode":"boat","withVideo":true,"warnTextFormatter":"const{ship, flag}=data;if(Number(ship)||Number(flag)){const a=Number(ship)?\'发现船只\':\'\';const b=Number(flag)?\'发现旗帜\':\'\';return (a?a+\' \':a)+b;}else{return \'--\'}","isMe":"return data.model===AI_MODE.boat"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300014', '300001', '300014', '300014', 'count', '溺水检测', '检测无人机航拍视角下，海面中的人员', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:48:29', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"peopleWater","withVideo":true,"warnText":"发现溺水人员","isMe":"return data.model===AI_MODE.peopleWater"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300015', '300001', '300015', '300015', 'count', '泥石流检测', '检测无人机航拍场景中出现的滑坡泥石流', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:49:01', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"landslide","withVideo":true,"warnText":"发现山体存在滑坡风险","isMe":"return data.model===AI_MODE.landslide"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300018', '300001', '300018', '300018', 'count', '烟火检测', '识别无人机航拍场景图像中的火焰及烟雾，并画框', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:49:28', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"fireDetection","withVideo":true,"warnTextFormatter":"const{fire, smoke}=data;if(Number(fire)||Number(smoke)){const a=Number(fire)?\'发现火\':\'\';const b=Number(smoke)?\'发现烟\':\'\';return (a?a+\' \':a)+b;}else{return \'--\'}","isMe":"return data.model===AI_MODE.fireDetection"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300019', '300001', '300019', '300019', 'count', '空中目标检测', '检测指定一片空域中，是否有无人机、鸟出现', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:49:57', '2026-04-20 13:59:26', 'sky_ai_city_management', '{"aiCode":"uavBird","withVideo":true,"warnTextFormatter":"const{drone, bird}=data;if(Number(drone)||Number(bird)){const a=Number(drone)?\'发现无人机\':\'\';const b=Number(bird)?\'发现鸟\':\'\';return (a?a+\' \':a)+b;}else{return \'--\'}","isMe":"return data.model===AI_MODE.uavBird"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300020', '300001', '300020', '300020', 'count', '旗帜检测', '检测无人机航拍视角下，海面中的船只上是否有国旗', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:50:33', '2026-04-20 13:59:26', 'sky_ai_water_ecology', '{"aiCode":"flagDetection","withVideo":true,"warnTextFormatter":"const{ship, flag}=data;if(Number(ship)||Number(flag)){const a=Number(ship)?\'发现船只\':\'\';const b=Number(flag)?\'发现旗帜\':\'\';return (a?a+\' \':a)+b;}else{return \'--\'}","isMe":"return data.model===AI_MODE.flagDetection"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300021', '300001', '300021', '300021', 'count', '井盖检测', '检测无人机航拍视角下，公路上井盖是否破损', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:51:06', '2026-04-20 13:59:26', 'sky_ai_city_maintenance', '{"aiCode":"manholeCover","withVideo":true,"warnTextFormatter":"const{cover, defect}=data;return Number(defect)?\'发现井盖异常\':\'发现井盖正常\'","isMe":"return data.model===AI_MODE.manholeCover"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300022', '300001', '300022', '300022', 'count', '地标检测', '检测无人机航拍视角下，桥梁、房屋检测', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:51:32', '2026-04-20 13:59:26', 'sky_ai_city_maintenance', '{"aiCode":"landmark","withVideo":true,"warnTextFormatter":"const{house, bridge}=data;if(Number(house)||Number(bridge)){const a=Number(house)?\'发现房屋\':\'\';const b=Number(bridge)?\'发现桥梁\':\'\';return (a?a+\' \':a)+b;}else{return \'--\'}","isMe":"return data.model===AI_MODE.landmark"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300023', '300001', '300023', '300023', 'count', '安全帽检测', '检测无人机航拍视角下，工地工人有无穿戴安全帽', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:52:13', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"helmetDetection","withVideo":true,"warnText":"发现违规安全帽佩戴行为","isMe":"return data.model===AI_MODE.helmetDetection"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300024', '300001', '300024', '300024', 'count', '反光衣检测', '检测无人机航拍视角下，工地工人有无穿戴反光背心', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-14 09:52:38', '2026-04-20 13:59:26', 'sky_ai_public_safety', '{"aiCode":"reflectiveVest","withVideo":true,"warnText":"发现违规反光衣穿戴行为","isMe":"return data.model===AI_MODE.reflectiveVest"}', null, 'LEVEL_1', 0, '实时识别', 1, 1);
|
||
|
||
INSERT INTO ai_model_info (ai_key, provider_code, model_code, model_name, direction_type, display_name, description, prompt, call_count, call_type, call_url, callback_url, ai_icon, deleted, create_time, update_time, model_type_code, formatter, formatter_code, alert_level, result_display_type, data_process_type, has_realtime_video, enabled) VALUES ('CYY_300001', '300001', '300001', '300001', 'count', '人员识别', '检测无人机航拍场景中，识别地面的人员', '', 0, 'mq', null, null, 'cmii-AI1', 0, '2026-04-15 15:25:22', '2026-04-15 15:25:22', 'sky_ai_public_safety', '{"aiCode":"person","withVideo":true,"warnText":"发现人员","isMe":"return data.model===AI_MODE.person"}', null, 'LEVEL_1', 0, '实时识别', 1, 1); |