From 84587e5a0375562c6753a3f4217bfdadea1e3ef5 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 22 十月 2026 14:40:32 +0800
Subject: [PATCH] chore(环保门禁): 补 env_device_command 建表与设备远程监控菜单脚本

---
 doc/sql/hbmjxt_device_command.sql |   32 ++++++++++++++++++++++++++++++++
 1 files changed, 32 insertions(+), 0 deletions(-)

diff --git a/doc/sql/hbmjxt_device_command.sql b/doc/sql/hbmjxt_device_command.sql
new file mode 100644
index 0000000..c536af9
--- /dev/null
+++ b/doc/sql/hbmjxt_device_command.sql
@@ -0,0 +1,32 @@
+-- ============================================================
+-- 鐮侀紟-鐜繚闂ㄧ绯荤粺锛�10.136.62.71 / mis-ruoyi锛�
+-- 璁惧杩滅▼鐩戞帶锛氳繙绋嬪惎鍋滄寚浠よ褰曡〃锛堝疄浣撳凡鏈夛紝搴撲腑缂鸿〃锛�
+-- 鎵ц锛歮ysql -uroot -p'***' mis-ruoyi < hbmjxt_device_command.sql
+-- ============================================================
+CREATE TABLE IF NOT EXISTS `env_device_command` (
+  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+  `device_ledger_id` bigint DEFAULT NULL COMMENT '璁惧鍙拌处id',
+  `device_name` varchar(255) DEFAULT NULL COMMENT '璁惧鍚嶇О',
+  `command_type` varchar(32) DEFAULT NULL COMMENT '鎸囦护绫诲瀷 start=鍚姩 stop=鍋滄',
+  `command_status` varchar(32) DEFAULT NULL COMMENT '鎸囦护鐘舵�� pending=涓嬪彂涓� success=鎴愬姛 failed=澶辫触',
+  `operator` varchar(64) DEFAULT NULL COMMENT '鎿嶄綔浜�',
+  `command_time` datetime DEFAULT NULL COMMENT '涓嬪彂鏃堕棿',
+  `result_msg` varchar(500) DEFAULT NULL COMMENT '鎵ц缁撴灉',
+  `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+  `tenant_id` bigint DEFAULT NULL COMMENT '绉熸埛ID',
+  `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�',
+  `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�',
+  `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+  PRIMARY KEY (`id`),
+  KEY `idx_env_cmd_tenant` (`tenant_id`),
+  KEY `idx_env_cmd_device` (`device_ledger_id`),
+  KEY `idx_env_cmd_time` (`command_time`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鐜繚闂ㄧ-璁惧杩滅▼鎺у埗鎸囦护';
+
+-- 鑿滃崟锛氳澶囪繙绋嬬洃鎺� 鐢便�岃澶囧彴璐﹂〉闈€�嶆敼涓恒�岃繙绋嬬洃鎺ч〉闈€�嶏紙鍚彴璐�/杩滅▼鎺у埗/寮傚父鎶ヨ涓変釜 tab锛�
+UPDATE `sys_menu`
+SET `path` = 'remoteMonitor',
+    `component` = 'environmentAccess/remoteMonitor/index',
+    `menu_name` = '璁惧杩滅▼鐩戞帶'
+WHERE `menu_id` = 2079;

--
Gitblit v1.9.3