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