From 89e2b84a38d1c3ab19933a41c3a409be31c8ed5a Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.13>
Date: 星期四, 29 十一月 2018 11:09:14 +0800
Subject: [PATCH] tb_fbs9100s_dfu_state表中添加文件长度列
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 493a1bd..3bb7cfc 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -563,6 +563,7 @@
}
//---------------------------------------------------------------------------------------------//
+
//-------------------------------- 2018-10-16 by lijun ( binf表中添加 station_install->标识机房是否已经安装 )------------------------------------//
res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_battinf'"
@@ -574,7 +575,25 @@
}
//---------------------------------------------------------------------------------------------//
-
+ //-------------------------------- 2018-11-29 by lijun ( binf表中添加 StationId_ex->基站站址编号 install_user-->安装人)------------------------------------//
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='StationId_ex'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `StationId_ex` varchar(20) DEFAULT '' AFTER StationId");
+ }
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='install_user'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `install_user` varchar(64) DEFAULT ''");
+ }
+
+ //---------------------------------------------------------------------------------------------//
//---------------------------------------------------------------------------------------------//
--
Gitblit v1.9.1