From 8db779331bf6cdeacaa95d61ac1c38cc3635791c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 17 八月 2021 17:05:23 +0800
Subject: [PATCH] .67 edit at date 2021-08-17 1.db_battinf.tb_battinf表新增视频链接地址字段'video_url'
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index b406f9f..71256ae 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -557,6 +557,7 @@
" `PublicKeyY` varchar(200) NOT NULL DEFAULT ''," +
" `KeyID` varchar(200) NOT NULL DEFAULT ''," +
" `SerialNumber` varchar(200) NOT NULL DEFAULT ''," +
+ " `video_url` varchar(200) DEFAULT NULL," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -812,6 +813,15 @@
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `SerialNumber` varchar(200) NOT NULL DEFAULT '';");
+ }
+ //添加SerialNumber
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='video_url'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `video_url` varchar(200) DEFAULT NULL;");
}
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1