From 73d30f2ee9bdccc7fa983542658d66b27fb4a8cc Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 17 三月 2023 16:19:41 +0800
Subject: [PATCH] 3.'web_site.tb_battdischarge_plan'表新增字段'create_time' `create_time` datetime DEFAULT NULL COMMENT '创建时间'
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 8209173..b186c24 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -4587,6 +4587,7 @@
" `chargecurrset` float NOT NULL DEFAULT '0'," +
" `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]'," +
" `baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '包机组id'," +
+ " `create_time` datetime DEFAULT NULL COMMENT '创建时间'," +
" PRIMARY KEY (`num`)," +
" KEY `index_num` (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
@@ -4646,6 +4647,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattDischargePlan_Table
+ " ADD COLUMN `baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '包机组id';");
}
+ //添加create_time 创建时间
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='web_site'"
+ + " AND table_name='tb_battdischarge_plan'"
+ + " AND column_name='create_time'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattDischargePlan_Table
+ + " ADD COLUMN `create_time` datetime DEFAULT NULL COMMENT '创建时间';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1