From 8bfc99d231cf771ce4b258845c15599a0570eff7 Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.12>
Date: 星期五, 26 十月 2018 17:11:38 +0800
Subject: [PATCH] tb_battinf表中添加机房是否安装列
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 5c30f65..3c865dd 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -525,6 +525,18 @@
}
//---------------------------------------------------------------------------------------------//
+ //-------------------------------- 2018-10-16 by lijun ( binf表中添加 station_install->标识机房是否已经安装 )------------------------------------//
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='station_install'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `station_install` BOOLEAN NOT NULL DEFAULT false");
+ }
+
+ //---------------------------------------------------------------------------------------------//
+
//---------------------------------------------------------------------------------------------//
--
Gitblit v1.9.1