/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright (c) 2020-2030 郑庚伟 ZHENGGENGWEI (码匠君), <herodotus@aliyun.com> Licensed under the AGPL License
 *
 * This file is part of Herodotus ThingsBrain.
 *
 * Herodotus ThingsBrain is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published
 * by the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Herodotus ThingsBrain is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.herodotus.cn>.
 */

-- ----------------------------
-- Table data for sys_element
-- ----------------------------
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('d9cd164d-2d4f-4532-9bdb-53bc824b65bf', '2024-08-16 11:54:08.353', '2024-08-16 11:58:19.951', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/pages/iot/product/Content.vue', 't', 'MENU', 'f', 'f', 'mdi-cube-scan', 'f', 'APP', 'IotProductContent', 't', '017ca0e8-1f30-4230-8602-12b6e95b502d', '/iot/product/content', NULL, '产品详情');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('81c90743-f49a-44ff-bed8-f05f7d8ccde7', '2024-08-16 11:56:20.359', '2024-08-16 11:57:34.79', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/pages/iot/device/Content.vue', 't', 'MENU', 'f', 'f', 'mdi-folder-network', 'f', 'APP', 'IotDeviceContent', 't', 'b827346f-494d-4044-8bc9-0ef33f7e9d45', '/iot/device/content', NULL, '设备详情');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('22fd4a47-a12c-49a8-b041-3c5f4b6b788a', '2024-08-16 11:50:30.373', '2024-08-16 11:57:51.287', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/pages/iot/product-category/Index.vue', 'f', 'MENU', 't', 't', 'mdi-format-list-checks', 'f', 'APP', 'IotProductCategory', 't', '7f51cd60-3b17-4f0f-a46a-19028d0c2294', '/iot/product-category', NULL, '品类管理');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('f52e614a-b466-4958-889a-e037495d925c', '2024-08-16 11:51:49.706', '2024-08-16 11:58:06.262', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/pages/iot/product-category/Content.vue', 't', 'MENU', 'f', 'f', 'mdi-clipboard-list', 'f', 'APP', 'IotProductCategoryContent', 't', '22fd4a47-a12c-49a8-b041-3c5f4b6b788a', '/iot/product-category/content', NULL, '分类详情');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('017ca0e8-1f30-4230-8602-12b6e95b502d', '2024-08-16 11:53:08.993', '2024-08-16 12:01:27.068', 'system', 0, 'system', NULL, 2, 't', 0, 'WEB', 'views/pages/iot/product/Index.vue', 'f', 'MENU', 't', 't', 'mdi-cube', 'f', 'APP', 'IotProduct', 't', '7f51cd60-3b17-4f0f-a46a-19028d0c2294', '/iot/product', NULL, '产品管理');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('7f51cd60-3b17-4f0f-a46a-19028d0c2294', '2024-08-16 11:46:38.873', '2024-08-16 12:02:22.513', 'system', 0, 'system', NULL, 9, 't', 0, 'WEB', 'views/layouts/Index.vue', 'f', 'MENU', 't', 'f', 'mdi-drag-variant', 'f', 'APP', '', 't', NULL, '/iot', '/iot/product-category', '万物互联管理');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('52be4bb7-9d4c-42fd-8ae7-9efc4ce1c029', '2024-08-30 22:58:28.829', '2024-08-30 22:58:43.313', 'system', 0, 'system', NULL, 0, 't', 0, 'WEB', 'views/pages/iot/product/Info.vue', 't', 'MENU', 'f', 'f', 'mdi-cube-send', 'f', 'APP', 'IotProductInfo', 't', '017ca0e8-1f30-4230-8602-12b6e95b502d', '/iot/product/info', NULL, '产品信息');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('3e88d6e3-b97d-48eb-b4d4-c2ac1cf444b8', '2024-08-30 22:59:41.313', '2024-08-30 23:00:01.473', 'system', 0, 'system', NULL, 0, 't', 0, 'WEB', 'views/pages/iot/device/Info.vue', 't', 'MENU', 'f', 'f', 'mdi-network-pos', 'f', 'APP', 'IotDeviceInfo', 't', 'b827346f-494d-4044-8bc9-0ef33f7e9d45', '/iot/device/info', NULL, '设备信息');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('310a9900-400d-43cf-9e3b-e262c61a5cd5', '2024-11-12 22:13:21.626', '2024-11-12 22:17:00.299', 'system', 0, 'system', NULL, 3, 't', 0, 'WEB', 'views/pages/iot/device/Setup.vue', 't', 'MENU', 'f', 'f', 'mdi-cog-transfer-outline', 'f', 'APP', 'IotDeviceSetup', 't', 'b827346f-494d-4044-8bc9-0ef33f7e9d45', '/iot/device/setup', NULL, '设置属性');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('0ada5e0f-fc28-4bef-adf1-388629dc6aa7', '2024-11-12 22:14:54.955', '2024-11-12 22:27:53.897', 'system', 0, 'system', NULL, 0, 't', 0, 'WEB', 'views/pages/iot/device/Invoke.vue', 't', 'MENU', 'f', 'f', 'mdi-television-play', 'f', 'APP', 'IotDeviceInvoke', 't', 'b827346f-494d-4044-8bc9-0ef33f7e9d45', '/iot/device/invoke', NULL, '调用服务');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('b827346f-494d-4044-8bc9-0ef33f7e9d45', '2024-08-16 11:55:17.109', '2025-02-12 21:50:43.673', 'system', 0, 'system', NULL, 3, 't', 0, 'WEB', 'views/pages/iot/device/Index.vue', 'f', 'MENU', 't', 't', 'mdi-router-network', 'f', 'APP', 'IotDevice', 't', '7f51cd60-3b17-4f0f-a46a-19028d0c2294', '/iot/device', NULL, '设备管理');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('4559b892-75b0-4a3d-9f2e-28927fc77d63', '2026-04-21 15:56:08.784', '2026-04-21 15:57:31.32', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/layouts/Testing.vue', 'f', 'MENU', 't', 'f', 'mdi-shield-link-variant', 'f', 'TESTING', NULL, 't', NULL, '/iot-testing', '/iot-testing/oauth2-registration', '物联网认证测试');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('b5849c6c-8f5c-4664-b82d-80910ccf5748', '2026-04-21 16:01:09.812', '2026-04-21 16:01:22.393', 'system', 0, 'system', NULL, 2, 't', 0, 'WEB', 'views/testing/iot-testing/oauth2-activation/Index.vue', 'f', 'MENU', 't', 't', 'mdi-monitor-shimmer', 'f', 'TESTING', 'OAuth2Activation', 't', '4559b892-75b0-4a3d-9f2e-28927fc77d63', '/iot-testing/oauth2-activation', NULL, 'OAuth2设备认证测试');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('e90fede1-ab1d-4bcd-b508-8f03a99a8086', '2026-04-21 15:58:57.588', '2026-04-21 15:59:56.091', 'system', 0, 'system', NULL, 1, 't', 0, 'WEB', 'views/testing/iot-testing/oauth2-registration/Index.vue', 'f', 'MENU', 't', 't', 'mdi-monitor-lock', 'f', 'TESTING', 'OAuth2Registration', 't', '4559b892-75b0-4a3d-9f2e-28927fc77d63', '/iot-testing/oauth2-registration', NULL, 'OAuth2动态注册测试');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('6408e0e7-726f-48cf-ad0f-336a4ca6f955', '2026-04-21 16:04:22.551', '2026-04-21 16:14:01.467', 'system', 0, 'system', NULL, 3, 't', 0, 'WEB', 'views/testing/iot-testing/mqtt-registration/Index.vue', 'f', 'MENU', 't', 't', 'mdi-monitor-cellphone-star', 'f', 'TESTING', 'MqttRegistration', 't', '4559b892-75b0-4a3d-9f2e-28927fc77d63', '/iot-testing/mqtt-registration', NULL, 'Mqtt动态注册测试');
INSERT INTO "sys_element" ("element_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "application_type", "component", "detail_content", "element_category", "have_child", "hide_all_child", "icon", "ignore_auth", "menu_scenario", "name", "not_keep_alive", "parent_id", "path", "redirect", "title") VALUES ('bf8c4daf-4e0c-4e09-9e14-18fbc6643904', '2026-04-21 16:05:47.076', '2026-04-21 16:06:01.686', 'system', 0, 'system', NULL, 4, 't', 0, 'WEB', 'views/testing/iot-testing/mqtt-signature/Index.vue', 'f', 'MENU', 't', 't', 'mdi-monitor-edit', 'f', 'TESTING', 'MqttSignature', 't', '4559b892-75b0-4a3d-9f2e-28927fc77d63', '/iot-testing/mqtt-signature', NULL, 'Mqtt签名认证测试');

-- ----------------------------
-- Table data for sys_element_role
-- ----------------------------
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('d9cd164d-2d4f-4532-9bdb-53bc824b65bf', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('81c90743-f49a-44ff-bed8-f05f7d8ccde7', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('22fd4a47-a12c-49a8-b041-3c5f4b6b788a', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('f52e614a-b466-4958-889a-e037495d925c', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('017ca0e8-1f30-4230-8602-12b6e95b502d', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('7f51cd60-3b17-4f0f-a46a-19028d0c2294', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('52be4bb7-9d4c-42fd-8ae7-9efc4ce1c029', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('3e88d6e3-b97d-48eb-b4d4-c2ac1cf444b8', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('b827346f-494d-4044-8bc9-0ef33f7e9d45', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('310a9900-400d-43cf-9e3b-e262c61a5cd5', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('0ada5e0f-fc28-4bef-adf1-388629dc6aa7', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('4559b892-75b0-4a3d-9f2e-28927fc77d63', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('e90fede1-ab1d-4bcd-b508-8f03a99a8086', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('b5849c6c-8f5c-4664-b82d-80910ccf5748', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('6408e0e7-726f-48cf-ad0f-336a4ca6f955', '1');
INSERT INTO "sys_element_role" ("element_id", "role_id") VALUES ('bf8c4daf-4e0c-4e09-9e14-18fbc6643904', '1');

-- ----------------------------
-- Table data for iot_tsl_unit
-- ----------------------------
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('1', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '无', '无');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('2', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '升每分钟', 'L/min');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('3', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫克每千克', 'mg/kg');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('4', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '浊度', 'NTU');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('5', '2024-09-08 17:10:08', '2024-09-08 17:10:13', 'PH值', 'pH');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('6', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '土壤EC值', 'dS/m');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('7', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '太阳总辐射', 'W/㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('8', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '降雨量', 'mm/hour');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('9', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '乏', 'var');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('10', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '厘泊', 'cP');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('11', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '饱和度', 'aw');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('12', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微西每厘米', 'μS/cm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('13', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '牛顿每库仑', 'N/C');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('14', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '伏特每米', 'V/m');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('15', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '滴速', 'ml/min');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('16', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫米汞柱', 'mmHg');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('17', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '血糖', 'mmol/L');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('18', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫米每秒', 'mm/s');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('19', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '转每分钟', 'turn/m');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('20', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '次', 'count');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('21', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '档', 'gear');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('22', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '步', 'stepCount');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('23', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '标准立方米每小时', 'Nm³/h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('24', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千伏', 'kV');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('25', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千伏安', 'kVA');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('26', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千乏', 'kVar');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('27', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微瓦每平方厘米', 'uw/c㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('28', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '只', '只');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('29', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '相对湿度', '%RH');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('30', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方米每秒', 'm³/s');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('31', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '公斤每秒', 'kg/s');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('32', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '转每分钟', 'r/min');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('33', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '吨每小时', 't/h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('34', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千卡每小时', 'KCL/h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('35', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '升每秒', 'L/s');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('36', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '兆帕', 'Mpa');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('37', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方米每小时', 'm³/h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('38', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千乏时', 'kvarh');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('39', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微克每升', 'μg/L');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('40', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千卡路里', 'kcal');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('41', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '吉字节', 'GB');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('42', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '兆字节', 'MB');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('43', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千字节', 'KB');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('44', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '字节', 'B');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('45', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微克每平方分米每天', 'μg/(d㎡·d)');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('46', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '百万分率', 'ppm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('47', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '像素', 'pixel');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('48', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '照度', 'Lux');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('49', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '重力加速度', 'grav');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('50', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '分贝', 'dB');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('51', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '百分比', '%');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('52', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '流明', 'lm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('53', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '比特', 'bit');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('54', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '克每毫升', 'g/mL');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('55', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '克每升', 'g/L');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('56', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫克每升', 'mg/L');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('57', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微克每立方米', 'μg/m³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('58', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫克每立方米', 'mg/m³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('59', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '克每立方米', 'g/m³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('60', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千克每立方米', 'kg/m³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('61', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '纳法', 'nF');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('62', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '皮法', 'pF');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('63', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微法', 'μF');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('64', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '法拉', 'F');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('65', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '欧姆', 'Ω');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('66', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微安', 'μA');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('67', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千安', 'kA');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('68', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '安培', 'A');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('69', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫伏', 'mV');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('70', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '伏特', 'V');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('71', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫秒', 'ms');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('72', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '秒', 's');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('73', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '分钟', 'min');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('74', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '小时', 'h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('75', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '日', 'day');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('76', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '周', 'week');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('77', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '月', 'month');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('78', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '年', 'year');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('79', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '节', 'kn');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('80', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千米每小时', 'km/h');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('81', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '米每秒', 'm/s');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('82', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '秒', '″');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('83', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '分', '′');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('84', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '度', '°');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('85', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '弧度', 'rad');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('86', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '赫兹', 'Hz');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('87', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微瓦', 'μW');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('88', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫瓦', 'mW');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('89', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千瓦特', 'kW');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('90', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '瓦特', 'W');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('91', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '吨', 't');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('92', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '摄氏度', '℃');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('93', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '豪帕', 'mPa');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('94', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '百帕', 'hPa');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('95', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千帕', 'kPa');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('96', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '帕斯卡', 'Pa');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('97', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫克', 'mg');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('98', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '克', 'g');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('99', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千克', 'kg');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('100', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '牛', 'N');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('101', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫升', 'mL');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('102', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '升', 'L');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('103', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方毫米', 'mm³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('104', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方厘米', 'cm³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('105', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方千米', 'km³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('106', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '立方米', 'm³');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('107', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '公顷', 'h㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('108', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '平方厘米', 'c㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('109', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '平方毫米', 'm㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('110', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '平方千米', 'k㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('111', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '平方米', '㎡');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('112', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '纳米', 'nm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('113', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '微米', 'μm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('114', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '毫米', 'mm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('115', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '厘米', 'cm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('116', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '分米', 'dm');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('117', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '千米', 'km');
INSERT INTO "iot_tsl_unit" ("unit_id", "create_time", "update_time", "unit_name", "unit_symbol") VALUES ('118', '2024-09-08 17:10:08', '2024-09-08 17:10:13', '米', 'm');

-- ----------------------------
-- Table data for iot_product_category
-- ----------------------------
INSERT INTO "iot_product_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "category_name", "scene_id") VALUES ('2bfa5467-b9f5-46dd-acec-f05aaaa00522', '2025-04-24 16:16:11.724', '2025-04-24 16:17:04.647', 'system', 0, 'system', '物联网平台测试数据', 1, 't', 0, '测试品类', NULL);

-- ----------------------------
-- Table data for iot_product
-- ----------------------------
INSERT INTO "iot_product" ("product_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "authentication", "protocol", "networking", "node", "photo_url", "product_key", "product_name", "productsecret", "quantity", "registration", "is_release", "verification", "category_id") VALUES ('8452271e-e42e-4a59-af80-3ea3c83247ea', '2025-04-28 21:20:27.432', '2025-04-28 21:20:27.432', 'system', 0, 'system', NULL, 1, 't', 0, NULL, NULL, 2, 0, NULL, 'apktestadd', '测试物联网产品', '9f3026f4beddf8d29f3026f4beddf8d2', 0, 'f', 'f', 'f', NULL);

-- ----------------------------
-- Table data for iot_mqtt_account
-- ----------------------------
INSERT INTO "iot_mqtt_account" ("account_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "client_id", "password", "username", "is_superuser") VALUES ('thingsbrain-platform', '2025-10-07 22:42:29', '2025-10-07 22:42:32', 'system', 0, 'system', '物联网平台链接Mqtt默认账号', 0, 't', 0, 'thingsbrain-platform', '{bcrypt}$2a$10$/XF002c2EuL0NyaEZ8a0be8S2IxKjFDd8f1ryY6wHpRMuXCiF2x7K', 'herodotus', 't');

-- ----------------------------
-- Table data for iot_mqtt_account_category
-- ----------------------------
INSERT INTO "iot_mqtt_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "area", "category_name", "purpose") VALUES ('1', '2025-10-07 22:44:22', '2025-10-07 22:44:24', 'system', 0, 'system', '自定义Link协议平台端订阅主题分类', 0, 't', 0, 'subscribe', 'PLATFORM', '自定义Link协议平台端订阅主题分类', 'LINK');
INSERT INTO "iot_mqtt_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "area", "category_name", "purpose") VALUES ('2', '2025-10-07 22:45:42', '2025-10-07 22:45:44', 'system', 0, 'system', '自定义Link协议平台端发布主题分类', 0, 't', 0, 'publish', 'PLATFORM', '自定义Link协议平台端发布主题分类', 'LINK');
INSERT INTO "iot_mqtt_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "area", "category_name", "purpose") VALUES ('4', '2025-10-07 22:45:42', '2025-10-07 22:45:44', 'system', 0, 'system', '自定义Link协议设备端订阅主题分类', 0, 't', 0, 'subscribe', 'DEVICE', '自定义Link协议设备端订阅主题分类', 'LINK');
INSERT INTO "iot_mqtt_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "area", "category_name", "purpose") VALUES ('3', '2025-10-07 22:45:42', '2025-10-07 22:45:44', 'system', 0, 'system', '自定义Link协议设备端发布主题分类', 0, 't', 0, 'publish', 'DEVICE', '自定义Link协议设备端发布主题分类', 'LINK');
INSERT INTO "iot_mqtt_category" ("category_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "area", "category_name", "purpose") VALUES ('5', '2025-10-07 22:45:42', '2025-10-07 22:45:44', 'system', 0, 'system', '物联网平台核心订阅主题分类', 0, 't', 0, 'subscribe', 'PLATFORM', '物联网平台核心订阅主题分类', 'KERNEL');

-- ----------------------------
-- Table data for iot_mqtt_category
-- ----------------------------
INSERT INTO "iot_mqtt_account_category" ("account_id", "category_id") VALUES ('thingsbrain-platform', '1');
INSERT INTO "iot_mqtt_account_category" ("account_id", "category_id") VALUES ('thingsbrain-platform', '2');
INSERT INTO "iot_mqtt_account_category" ("account_id", "category_id") VALUES ('thingsbrain-platform', '5');
-- INSERT INTO "iot_mqtt_account_category" ("account_id", "category_id") VALUES ('83a59414-04b9-4e83-af8a-a756a2e8f01f', '4');
-- INSERT INTO "iot_mqtt_account_category" ("account_id", "category_id") VALUES ('83a59414-04b9-4e83-af8a-a756a2e8f01f', '3');

-- ----------------------------
-- Table data for iot_mqtt_authority
-- ----------------------------
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('1', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/sub/register');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('2', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/add');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('3', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('4', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('5', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/list/found');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('6', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/add/notify_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('7', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/login');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('8', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/batch_login');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('9', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/logout');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('10', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/batch_logout');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('12', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/service/property/set_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('13', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/+/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('14', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/service/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('15', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/pack/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('16', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/history/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('17', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/batch/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('18', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/property/desired/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('19', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/property/desired/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('20', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/disable_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('21', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/enable_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('22', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('23', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/update');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('24', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('25', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('26', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ota/device/inform/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('27', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ota/device/progress/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('28', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/ota/firmware/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('29', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/file/download');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('30', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('31', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/push_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('32', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/log/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('33', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/log/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('34', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/_thing/diag/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('35', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'shadow/update/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('36', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/bootstrap/notify_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('37', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/job/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('38', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/job/update');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('39', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/file/upload/mqtt/init');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('40', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/secure_tunnel/proxy/request');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('41', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/sub/register_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('42', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/add_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('43', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('44', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('45', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/list/found_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('46', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/add/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('47', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/change');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('48', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/login_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('49', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/batch_login_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('50', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/logout_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('51', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/batch_logout_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('53', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/service/property/set');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('54', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/+/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('55', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/service/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('56', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/pack/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('57', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/history/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('58', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/batch/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('59', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/property/desired/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('60', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/property/desired/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('61', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/disable');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('62', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/enable');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('63', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('64', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/update_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('65', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('66', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('67', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ota/device/upgrade/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('68', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/ota/firmware/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('69', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/file/download_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('70', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('71', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/push');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('72', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/log/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('73', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/log/push');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('74', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/log/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('75', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/_thing/diag/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('76', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'shadow/get/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('77', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/bootstrap/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('78', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/job/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('79', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/job/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('80', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/job/update_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('81', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/file/upload/mqtt/init_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('82', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/secure_tunnel/proxy/request_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('83', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/sub/register_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('84', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/add_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('85', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('86', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('87', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/list/found_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('88', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/add/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('89', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/topo/change');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('90', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/login_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('91', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/batch_login_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('92', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/logout_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('93', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ext/session/+/+/combine/batch_logout_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('95', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/service/property/set');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('96', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/+/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('97', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/service/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('98', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/pack/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('99', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/history/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('100', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/event/property/batch/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('101', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/property/desired/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('102', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/property/desired/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('103', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/disable');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('104', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/enable');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('105', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('106', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/update_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('107', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('108', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('109', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'ota/device/upgrade/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('110', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/ota/firmware/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('111', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/file/download_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('112', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('113', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/push');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('114', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/log/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('115', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/config/log/push');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('116', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/log/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('117', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/_thing/diag/post_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('118', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'shadow/get/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('119', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/bootstrap/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('120', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/job/notify');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('121', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/job/get_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('122', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/job/update_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('123', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/thing/file/upload/mqtt/init_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('124', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, 'sys/+/+/secure_tunnel/proxy/request_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('125', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/sub/register');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('126', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/add');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('127', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('128', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('129', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/list/found');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('130', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/topo/add/notify_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('131', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/login');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('132', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/batch_login');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('133', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/logout');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('134', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ext/session/+/+/combine/batch_logout');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('136', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/service/property/set_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('137', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/+/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('138', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/service/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('139', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/pack/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('140', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/history/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('141', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/event/property/batch/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('142', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/property/desired/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('143', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/property/desired/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('144', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/disable_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('145', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/enable_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('146', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/delete_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('147', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/update');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('148', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('149', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/deviceinfo/delete');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('150', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ota/device/inform/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('151', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'ota/device/progress/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('152', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/ota/firmware/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('153', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/file/download');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('154', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('155', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/push_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('156', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/config/log/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('157', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/log/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('158', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/_thing/diag/post');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('159', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'shadow/update/+/+');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('160', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/bootstrap/notify_reply');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('161', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/job/get');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('162', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/job/update');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('163', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/thing/file/upload/mqtt/init');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('164', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'publish', 'allow', 1, 0, 'sys/+/+/secure_tunnel/proxy/request');
INSERT INTO "iot_mqtt_authority" ("authority_id", "create_time", "update_time", "create_by", "reversion", "update_by", "description", "ranking", "is_reserved", "status", "action", "permission", "qos", "retain", "topic") VALUES ('165', '2025-10-13 15:22:00', '2025-10-13 15:22:03', 'system', 0, 'system', NULL, 0, 't', 0, 'subscribe', 'allow', 1, 0, '$SYS/brokers/+/clients/#');

-- ----------------------------
-- Table data for iot_mqtt_category_authority
-- ----------------------------
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '1');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '2');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '3');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '4');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '5');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '6');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '7');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '8');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '9');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '10');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '12');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '13');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '14');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '15');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '16');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '17');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '18');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '19');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '20');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '21');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '22');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '23');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '24');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '25');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '26');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '27');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '28');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '29');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '30');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '31');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '32');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '33');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '34');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '35');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '36');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '37');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '38');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '39');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('1', '40');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '41');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '42');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '43');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '44');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '45');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '46');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '47');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '48');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '49');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '50');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '51');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '53');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '54');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '55');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '56');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '57');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '58');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '59');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '60');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '61');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '62');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '63');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '64');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '65');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '66');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '67');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '68');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '69');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '70');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '71');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '72');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '73');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '74');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '75');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '76');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '77');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '78');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '79');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '80');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '81');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('2', '82');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '83');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '84');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '85');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '86');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '87');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '88');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '89');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '90');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '91');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '92');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '93');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '95');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '96');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '97');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '98');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '99');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '100');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '101');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '102');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '103');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '104');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '105');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '106');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '107');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '108');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '109');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '110');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '111');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '112');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '113');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '114');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '115');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '116');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '117');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '118');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '119');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '120');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '121');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '122');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '123');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('3', '124');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '125');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '126');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '127');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '128');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '129');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '130');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '131');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '132');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '133');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '134');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '136');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '137');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '138');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '139');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '140');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '141');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '142');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '143');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '144');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '145');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '146');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '147');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '148');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '149');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '150');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '151');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '152');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '153');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '154');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '155');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '156');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '157');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '158');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '159');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '160');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '161');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '162');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '163');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('4', '164');
INSERT INTO "iot_mqtt_category_authority" ("category_id", "authority_id") VALUES ('5', '165');

-- ----------------------------
-- Table data for sys_interface_authority
-- ----------------------------
INSERT INTO "sys_attribute_permission" ("attribute_id", "permission_id")
SELECT st.attribute_id, st.permission_id
FROM (SELECT '9' AS permission_id, sa.attribute_id FROM "sys_attribute" sa WHERE sa.url LIKE '%iot%') AS st;