-- ---------------------------- -- 创建告警表 -- ---------------------------- DROP TABLE IF EXISTS `iot_alert`; CREATE TABLE `iot_alert` ( `alert_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '告警ID', `alert_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警名称', `alert_level` tinyint(11) NOT NULL COMMENT '告警级别（1=提醒通知，2=轻微问题，3=严重警告）', `product_id` bigint(20) NOT NULL COMMENT '产品ID', `product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品名称', `actions` json NOT NULL COMMENT '执行动作', `status` tinyint(1) NULL DEFAULT NULL COMMENT '告警状态（1-启动，2-停止）', `message_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息通知类型[1,2,3]，1=设备告警，2=短信通知，3=移动端推送', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`alert_id`) USING BTREE, INDEX `iot_alert_index_product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备告警' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建告警日志表 -- ---------------------------- DROP TABLE IF EXISTS `iot_alert_log`; CREATE TABLE `iot_alert_log` ( `alert_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '告警ID', `alert_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '告警名称', `alert_level` tinyint(11) NOT NULL COMMENT '告警级别（1=提醒通知，2=轻微问题，3=严重警告）', `status` tinyint(11) NOT NULL COMMENT '处理状态(1=不需要处理,2=未处理,3=已处理)', `serial_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备编号', `product_id` bigint(20) NOT NULL COMMENT '产品ID', `detail` json NULL COMMENT '告警详情（对应物模型）', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`alert_log_id`) USING BTREE, INDEX `iot_alert_log_index_serial_number`(`serial_number`) USING BTREE, INDEX `iot_alert_log_index_product_id`(`product_id`) USING BTREE, INDEX `iot_alert_log_index_create_time`(`create_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 149279 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备告警日志' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建告警触发器表 -- ---------------------------- DROP TABLE IF EXISTS `iot_alert_trigger`; CREATE TABLE `iot_alert_trigger` ( `alert_trigger_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '告警触发器ID', `alert_id` bigint(20) NOT NULL COMMENT '场景ID', `status` tinyint(1) NOT NULL COMMENT '告警状态（1-启动，2-停止）', `source` tinyint(1) NOT NULL COMMENT '触发源（1=设备触发，2=定时触发）', `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型标识符', `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型名称', `value` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型值', `operator` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作符', `type` tinyint(1) NULL DEFAULT NULL COMMENT '物模型类别（1=属性，2=功能，3=事件，4=设备升级，5=设备上线，6=设备下线）', `product_id` bigint(20) NULL DEFAULT NULL COMMENT '产品ID', `product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `job_id` bigint(20) NULL DEFAULT NULL COMMENT '任务ID', `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式', `is_advance` tinyint(1) NULL DEFAULT NULL COMMENT '是否详细corn表达式（1=是，0=否）', PRIMARY KEY (`alert_trigger_id`) USING BTREE, INDEX `iot_alert_trigger_index_alert_id`(`alert_id`) USING BTREE, INDEX `iot_alert_trigger_index_product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 193 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '告警触发器' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建场景联动表 -- ---------------------------- DROP TABLE IF EXISTS `iot_scene`; CREATE TABLE `iot_scene` ( `scene_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '场景ID', `scene_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '场景名称', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `user_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称', `actions` json NOT NULL COMMENT '执行动作', `status` tinyint(1) NULL DEFAULT NULL COMMENT '场景状态（1-启动，2-停止）', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`scene_id`) USING BTREE, INDEX `iot_scene_index_user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 70 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景联动' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建场景联动触发器表 -- ---------------------------- DROP TABLE IF EXISTS `iot_scene_trigger`; CREATE TABLE `iot_scene_trigger` ( `scene_trigger_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '场景触发器ID', `scene_id` bigint(20) NOT NULL COMMENT '所属场景ID', `status` tinyint(1) NOT NULL COMMENT '告警状态（1-启动，2-停止）', `source` tinyint(1) NOT NULL COMMENT '触发源（1=设备触发，2=定时触发）', `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型标识符', `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型名称', `value` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物模型值', `operator` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作符', `type` tinyint(1) NULL DEFAULT NULL COMMENT '物模型类别（1=属性，2=功能，3=事件，4=设备升级，5=设备上线，6=设备下线）', `device_id` bigint(20) NULL DEFAULT NULL COMMENT '设备ID', `device_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称', `serial_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号', `product_id` bigint(20) NULL DEFAULT NULL COMMENT '产品ID', `product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称', `job_id` bigint(20) NULL DEFAULT NULL COMMENT '任务ID', `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式', `is_advance` tinyint(1) NULL DEFAULT NULL COMMENT '是否详细corn表达式（1=是，0=否）', PRIMARY KEY (`scene_trigger_id`) USING BTREE, INDEX `iot_scene_trigger_index_scene_id`(`scene_id`) USING BTREE, INDEX `iot_scene_trigger_index_device_id`(`device_id`) USING BTREE, INDEX `iot_scene_trigger_index_serial_number`(`serial_number`) USING BTREE, INDEX `iot_scene_trigger_index_product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 213 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场景联动触发器' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建视频设备表 -- ---------------------------- DROP TABLE IF EXISTS `sip_device`; CREATE TABLE `sip_device`( `device_id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '设备ID', `device_sip_id` varchar(64) NOT NULL COMMENT '设备sip_id', `device_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '设备名称', `product_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '产品ID', `product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品名称', `manufacturer` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '厂商名称', `model` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品型号', `firmware` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '固件版本', `transport` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'UDP' COMMENT '传输模式', `streamMode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'UDP' COMMENT '流模式', `online` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '在线状态', `registerTimeMillis` bigint(20) NOT NULL COMMENT '注册时间', `ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备入网IP', `port` bigint(10) NULL DEFAULT NULL COMMENT '设备接入端口号', `hostAddress` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备地址', PRIMARY KEY(`device_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '监控设备' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建视频设备通道 -- ---------------------------- DROP TABLE IF EXISTS `sip_device_channel`; CREATE TABLE `sip_device_channel` ( `channel_id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '通道ID', `channel_sip_id` varchar(64) NOT NULL COMMENT '通道SipID', `device_sip_id` varchar(64) NOT NULL COMMENT '设备sip_id', `channel_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通道名称', `manufacture` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '厂商名称', `model` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品型号', `owner` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '设备归属', `civilCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行政区域', `block` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '警区', `address` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '安装地址', `parentId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '父级id', `ipAddress` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL DEFAULT '' COMMENT '设备入网IP', `port` bigint(10) NULL DEFAULT 0 COMMENT '设备接入端口号', `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码', `PTZType` bigint(20) NOT NULL DEFAULT 0 COMMENT 'PTZ类型', `PTZTypeText` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'PTZ类型描述字符串', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '设备状态（1-未激活，2-禁用，3-在线，4-离线）', `longitude` double(11, 6) NULL DEFAULT NULL COMMENT '设备经度', `latitude` double(11, 6) NULL DEFAULT NULL COMMENT '设备纬度', `streamId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '流媒体ID', `subCount` bigint(20) NOT NULL DEFAULT 0 COMMENT '子设备数', `parental` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否有子设备（1-有, 0-没有）', `hasAudio` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否含有音频（1-有, 0-没有）', PRIMARY KEY(`channel_id`,`device_sip_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '监控设备通道信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- 创建可视化项目表 -- ---------------------------- DROP TABLE IF EXISTS `iot_goview_project`; CREATE TABLE `iot_goview_project` ( `id` varchar(50) NOT NULL COMMENT '主键', `project_name` varchar(255) NOT NULL COMMENT '项目名称', `state` int(1) NOT NULL DEFAULT '0' COMMENT '项目状态[0未发布,1发布]', `index_image` varchar(255) DEFAULT NULL COMMENT '首页图片', `del_flag` int(11) NOT NULL DEFAULT '0' COMMENT '删除状态[1删除,-1未删除]', `create_time` datetime NOT NULL COMMENT '创建时间', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人id', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remarks` varchar(255) DEFAULT NULL COMMENT '项目介绍', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='项目表'; -- ---------------------------- -- 创建可视化项目数据表 -- ---------------------------- DROP TABLE IF EXISTS `iot_goview_project_data`; CREATE TABLE `iot_goview_project_data` ( `id` varchar(50) NOT NULL COMMENT '主键', `project_id` varchar(50) NOT NULL COMMENT '项目id', `content` longblob COMMENT '存储数据', `create_time` datetime NOT NULL COMMENT '创建时间', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人id', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='项目数据关联表'; -- ---------------------------- -- 更新设备定时任务表结构 -- ---------------------------- alter table `iot_device_job` modify column device_id bigint(20) NULL DEFAULT NULL COMMENT '设备ID'; alter table `iot_device_job` modify column product_id bigint(20) NULL DEFAULT NULL COMMENT '产品ID'; alter table `iot_device_job` modify column product_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称'; alter table `iot_device_job` add `alert_trigger` json NULL COMMENT '定时告警触发器'; -- ---------------------------- -- 更新设备日志表结构 -- ---------------------------- alter table `iot_device_log` modify column device_id bigint(20) NULL DEFAULT NULL COMMENT '设备ID'; alter table `iot_device_log` modify column device_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称'; alter table `iot_device_log` modify column user_id bigint(20) NULL DEFAULT NULL COMMENT '用户ID'; alter table `iot_device_log` modify column user_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户昵称'; alter table `iot_device_log` modify column tenant_id bigint(20) NULL DEFAULT NULL COMMENT '租户ID'; alter table `iot_device_log` modify column tenant_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租户名称'; -- ---------------------------- -- 更新通用物模型和产品模型表结构并设置默认值 -- ---------------------------- alter table `iot_things_model` add `model_order` int(10) NULL DEFAULT 0 COMMENT '排序，值越大，排序越靠前'; alter table `iot_things_model` add `is_readonly` tinyint(1) NULL DEFAULT 0 COMMENT '是否只读数据(0-否，1-是)'; alter table `iot_things_model_template` add `model_order` int(10) NULL DEFAULT 0 COMMENT '排序，值越大，排序越靠前'; alter table `iot_things_model_template` add `is_readonly` tinyint(1) NULL DEFAULT 0 COMMENT '是否只读数据(0-否，1-是)'; update `iot_things_model_template` set is_readonly=1 , model_order=1; update `iot_things_model` set is_readonly=1 , model_order=1; -- ---------------------------- -- 新增视频监控菜单 -- ---------------------------- INSERT INTO `sys_menu` VALUES (2150, '监控设备', 2000, 10, 'iot/sip/index', 'iot/sip/index', NULL, 1, 0, 'C', '0', '0', 'sip:device:list', 'channel', 'admin', '2022-10-24 16:36:07', 'admin', '2022-10-24 16:38:07', ''); INSERT INTO `sys_menu` VALUES (2151, '设备通道', 2000, 11, 'iot/sip/channel', 'iot/sip/channel', '', 1, 0, 'C', '0', '0', 'sip:channel:list', 'live', 'admin', '2022-10-24 16:39:05', 'admin', '2022-10-24 16:39:48', ''); -- ---------------------------- -- 创建外键索引 -- ---------------------------- alter table `iot_category` add INDEX `iot_category_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_category` add INDEX `iot_category_index_parent_id`(`parent_id`) USING BTREE; alter table `iot_device` add INDEX `iot_device_index_product_id`(`product_id`) USING BTREE; alter table `iot_device` add INDEX `iot_device_index_tanant_id`(`tenant_id`) USING BTREE; alter table `iot_device` add INDEX `iot_device_index_user_id`(`user_id`) USING BTREE; alter table `iot_device` add INDEX `iot_device_index_create_time`(`create_time`) USING BTREE; alter table `iot_device` add UNIQUE INDEX `iot_device_index_serial_number`(`serial_number`) USING BTREE; alter table `iot_device_job` add INDEX `iot_device_job_index_device_id`(`device_id`) USING BTREE; alter table `iot_device_job` add INDEX `iot_device_job_index_product_id`(`product_id`) USING BTREE; alter table `iot_device_job` add INDEX `iot_device_job_index_scene_id`(`scene_id`) USING BTREE; alter table `iot_device_job` add INDEX `iot_device_job_index_alert_id`(`alert_id`) USING BTREE; alter table `iot_device_job` add INDEX `iot_device_job_index_serial_number`(`serial_number`) USING BTREE; alter table `iot_device_log` add INDEX `iot_device_log_index_serial_number`(`serial_number`) USING BTREE; alter table `iot_device_log` add INDEX `iot_device_log_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_device_log` add INDEX `iot_device_log_index_user_id`(`user_id`) USING BTREE; alter table `iot_device_log` add INDEX `iot_device_log_index_device_id`(`device_id`) USING BTREE; alter table `iot_device_user` add INDEX `iot_device_user_index_user_id`(`user_id`) USING BTREE; alter table `iot_device_user` add INDEX `iot_device_user_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_firmware` add INDEX `iot_firmware_index_product_id`(`product_id`) USING BTREE; alter table `iot_firmware` add INDEX `iot_firmware_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_product` add INDEX `iot_product_index_category_id`(`category_id`) USING BTREE; alter table `iot_product` add INDEX `iot_product_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_product_authorize` add INDEX `iot_product_authorize_index_product_id`(`product_id`) USING BTREE; alter table `iot_product_authorize` add INDEX `iot_product_authorize_index_device_id`(`device_id`) USING BTREE; alter table `iot_product_authorize` add INDEX `iot_product_authorize_index_serial_number`(`serial_number`) USING BTREE; alter table `iot_product_authorize` add INDEX `iot_product_authorize_index_user_id`(`user_id`) USING BTREE; alter table `iot_things_model` add INDEX `iot_things_model_index_product_id`(`product_id`) USING BTREE; alter table `iot_things_model` add INDEX `iot_things_model_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_things_model` add INDEX `iot_things_model_index_model_order`(`model_order`) USING BTREE; alter table `iot_things_model_template` add INDEX `iot_things_model_template_index_tenant_id`(`tenant_id`) USING BTREE; alter table `iot_things_model_template` add INDEX `iot_things_model_template_index_model_order`(`model_order`) USING BTREE; alter table `news` add INDEX `news_index_category_id`(`category_id`) USING BTREE; alter table `iot_group` add INDEX `iot_group_index_user_id`(`user_id`) USING BTREE;