From bef419a6add516ac7e4ea8ba21d2ca9c573e69a3 Mon Sep 17 00:00:00 2001
From: 648540858 <18010473990@163.com>
Date: 星期三, 04 八月 2021 18:12:13 +0800
Subject: [PATCH] 添加sql脚本
---
src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java
index 16ed401..2167c55 100644
--- a/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java
+++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java
@@ -94,6 +94,12 @@
@Select("DELETE FROM media_server WHERE id='${id}'")
void delOne(String id);
+ @Select("DELETE FROM media_server WHERE ip='${host}' and httpPort=${port}")
+ void delOneByIPAndPort(String host, int port);
+
+ @Select("DELETE FROM media_server WHERE defaultServer=1;")
+ void delDefault();
+
@Select("SELECT * FROM media_server WHERE ip='${host}' and httpPort=${port}")
MediaServerItem queryOneByHostAndPort(String host, int port);
}
--
Gitblit v1.8.0