springboot-new/sql/其他/v1.2-upgrade-v1.3.sql

-- ----------------------------
-- 创建告警表
-- ----------------------------
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;