From f82d9021329b42ae0e2620cc64ea9efcdf99f989 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期五, 10 十二月 2021 17:11:39 +0800
Subject: [PATCH] V1.98 edit at date 2021-12-10 1：修改`db_battinf`.`tb_battinf` 表下检测新增字段sort_id
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 9 +++++++++
1 files changed, 9 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 97d4501..83bfa19 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -947,6 +947,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `price_factor` float DEFAULT '1' COMMENT '电价系数';");
}
+ //添加sort_id
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='sort_id'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `sort_id` float DEFAULT '1' COMMENT '电价系数';");
+ }
//设置column 去掉默认NOT NULL
{
--
Gitblit v1.9.1