From 8dcb0edcc2ceaa244501e7ed0c4f363ab4f3a428 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期五, 03 四月 2026 15:29:04 +0800
Subject: [PATCH] Merge branch '2.0.1' of http://139.186.142.91:10010/r/productDev/funingyunwei into 2.0.1

---
 server/db/yw_gateway.sql |   19 +++++++++++++++++++
 1 files changed, 19 insertions(+), 0 deletions(-)

diff --git a/server/db/yw_gateway.sql b/server/db/yw_gateway.sql
new file mode 100644
index 0000000..6f40915
--- /dev/null
+++ b/server/db/yw_gateway.sql
@@ -0,0 +1,19 @@
+CREATE TABLE `yw_gateway` (
+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+  `creator` int(11) DEFAULT NULL COMMENT '鍒涘缓浜虹紪鐮�',
+  `create_date` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  `editor` int(11) DEFAULT NULL COMMENT '鏇存柊浜虹紪鐮�',
+  `edit_date` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+  `isdeleted` int(1) DEFAULT '0' COMMENT '鏄惁鍒犻櫎 0鍚� 1鏄�',
+  `name` varchar(100) DEFAULT NULL COMMENT '缃戝叧鍚嶇О',
+  `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+  `status` int(1) DEFAULT '0' COMMENT '鐘舵�� 0鍚敤 1绂佺敤',
+  `sortnum` int(11) DEFAULT NULL COMMENT '鎺掑簭鐮�',
+  `gateway_model` varchar(100) DEFAULT NULL COMMENT '缃戝叧鍨嬪彿',
+  `gateway_code` varchar(100) DEFAULT NULL COMMENT '缃戝叧璁惧鍙�',
+  `last_heartbeat_time` datetime DEFAULT NULL COMMENT '鏈�鍚庡績璺虫椂闂�',
+  `project_id` int(11) DEFAULT NULL COMMENT '鎵�灞為」鐩紪鐮侊紙鍏宠仈yw_project锛�',
+  PRIMARY KEY (`id`),
+  KEY `idx_gateway_code` (`gateway_code`),
+  KEY `idx_project_id` (`project_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='缃戝叧绠＄悊';

--
Gitblit v1.9.3