From fe3ac75a50fbbb044dd642dc4aad38456381ac2f Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 12 五月 2022 17:02:43 +0800
Subject: [PATCH] `dev_num` varchar(255) NOT NULL DEFAULT '' ==>`dev_num` varchar(255) NOT NULL DEFAULT '0'
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 5 ++++-
1 files changed, 4 insertions(+), 1 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 cf36ad3..85ef8ae 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -1032,7 +1032,10 @@
+ " AND column_name='dev_num'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
- + " ADD COLUMN `dev_num` varchar(255) NOT NULL DEFAULT '' COMMENT '设备编号[a059用于标识设备]';");
+ + " ADD COLUMN `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]';");
+ }else{
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " CHANGE `dev_num` `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]';");
}
//设置column 去掉默认NOT NULL
--
Gitblit v1.9.1