From db1e917af9ba9d5a0561984d1a1a30d905d4a7b9 Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.11>
Date: 星期二, 16 十月 2018 16:50:32 +0800
Subject: [PATCH] 见表语句中添加基站号码列
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 12 +++++++++++-
1 files changed, 11 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 0c5880c..e39ded0 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -492,7 +492,17 @@
sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ " ADD COLUMN `disCurrMax` float NOT NULL DEFAULT 0");
}
-
+
+ //-------------------------------- 2018-10-16 by lijun ( binf表中添加 station_phone->基站手机号 )------------------------------------//
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='station_phone'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `station_phone` varchar(32) DEFAULT ''");
+ }
+
//---------------------------------------------------------------------------------------------//
--
Gitblit v1.9.1