From bf78252476061e44f07070122909f16a6827b49a Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期五, 17 三月 2023 16:46:10 +0800 Subject: [PATCH] 3.'web_site.tb_battdischarge_plan'表新增字段'create_time' `create_time` datetime DEFAULT NULL COMMENT '创建时间' 4.创建放电计划临时表 'web_site.tb_battdischarge_plan_temp' CREATE TABLE `tb_battdischarge_plan_temp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `station_id` varchar(20) DEFAULT NULL COMMENT '机房id', `station_name` varchar(100) DEFAULT NULL COMMENT '机房名称', `batt_group_id` int(11) DEFAULT NULL COMMENT '包机组id', `batt_group_name` varchar(100) DEFAULT NULL COMMENT '电池组名称', `group_id` bigint(20) DEFAULT NULL COMMENT '班组id,与包机组一致', `group_name` varchar(200) DEFAULT NULL COMMENT '班组名称,与包机组一致', `node_station` tinyint(1) DEFAULT NULL COMMENT '是否节点站', `mon_cap_std` float DEFAULT NULL COMMENT '标称容量', `mon_vol_std` float DEFAULT NULL COMMENT '标称单体电压', `cap_percent` float DEFAULT NULL COMMENT '放电容量百分比', `discharge_start_time` datetime DEFAULT NULL COMMENT '放电开始时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放电计划临时表'; --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 78d046b..1010345 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -228,11 +228,12 @@ public static final String TB_Map_Outline_Table = WEB_Site +".`tb_map_outline`"; //首页轮廓图表 public static final String TB_Interface_Table = WEB_Site +".`tb_interface`"; //三方接口配置表 - public static final String TB_Worksheet_Alarm_Table = WEB_Site +".`tb_worksheet_alarm`"; //三方接口配置表 - public static final String TB_Worksheet_Link_Table = WEB_Site +".`tb_worksheet_link`"; //三方接口配置表 - public static final String TB_Worksheet_Main_Table = WEB_Site +".`tb_worksheet_main`"; //三方接口配置表 + public static final String TB_Worksheet_Alarm_Table = WEB_Site +".`tb_worksheet_alarm`"; //三方接口配置表 + public static final String TB_Worksheet_Link_Table = WEB_Site +".`tb_worksheet_link`"; //三方接口配置表 + public static final String TB_Worksheet_Main_Table = WEB_Site +".`tb_worksheet_main`"; //三方接口配置表 - public static final String Tb_Alarm_Voice_Set_Table = WEB_Site +".`tb_alarm_voice_set`"; //告警语音设置 + public static final String Tb_Alarm_Voice_Set_Table = WEB_Site +".`tb_alarm_voice_set`"; //告警语音设置 + public static final String Tb_Battdischarge_Plan_Temp_Table = WEB_Site +".`tb_battdischarge_plan_temp`"; //放电计划临时表 -- Gitblit v1.9.1