From f68b1474d1c63060dc56b8f826074432cde168bc Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期五, 28 三月 2025 09:37:58 +0800
Subject: [PATCH] 更新
---
BattMonitor_DB_Builder/src/com/sql/util/Db_Batt.java | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/util/Db_Batt.java b/BattMonitor_DB_Builder/src/com/sql/util/Db_Batt.java
index 9f539c7..b9a3bd3 100644
--- a/BattMonitor_DB_Builder/src/com/sql/util/Db_Batt.java
+++ b/BattMonitor_DB_Builder/src/com/sql/util/Db_Batt.java
@@ -62,7 +62,7 @@
sql.sqlMysqlExecute(sql_str_auto);
String sql_str = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Sinf_Pinf_Table + " "
- + "(num integer NOT NULL DEFAULT nextval('" + Sql_Mysql.Sinf_Pinf_Table + "db_batt.sinf_pinf_auto'::regclass)," +
+ + "(num integer NOT NULL DEFAULT nextval('" + Sql_Mysql.Sinf_Pinf_Table + "_auto'::regclass)," +
" sinf_id integer NOT NULL," +
" pinf_id integer NOT NULL," +
" PRIMARY KEY (num)" +
@@ -104,6 +104,12 @@
" mon_cap integer NOT NULL DEFAULT 150," +
" mon_res double precision NOT NULL DEFAULT '0.4'::double precision," +
" load_curr double precision NOT NULL DEFAULT '0'::double precision," +
+
+ " sip_num character(32) NOT NULL COLLATE pg_catalog.\"default\" DEFAULT '127.0.0.1'::character varying," +
+ " channel_count integer NOT NULL DEFAULT 1," +
+ " create_time timestamp without time zone NOT NULL DEFAULT '2000-01-01 00:00:00'::timestamp without time zone," +
+ " update_time timestamp without time zone NOT NULL DEFAULT '2000-01-01 00:00:00'::timestamp without time zone," +
+
" PRIMARY KEY (power_id)" +
")";
sql.sqlMysqlExecute(sql_str);
@@ -122,6 +128,14 @@
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".mon_cap IS '标称容量';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".mon_res IS '标称内阻';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".load_curr IS '负载电流';");
+
+ sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".sip_num IS 'sip编号';");
+ sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".channel_count IS '视频流频道数';");
+ sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".create_time IS '创建时间';");
+ sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Power_Inf_Table + ".update_time IS '更新时间';");
+
+
+
--
Gitblit v1.9.1