From 690f171908a15508049251d7489f8ce519b54a8f Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期四, 12 十二月 2024 09:35:20 +0800
Subject: [PATCH] 乌东德建表调整
---
BattMonitor_DB_Builder/src/com/sql/util/Db_Param.java | 3 ---
1 files changed, 0 insertions(+), 3 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/util/Db_Param.java b/BattMonitor_DB_Builder/src/com/sql/util/Db_Param.java
index b9f63b3..2a262d9 100644
--- a/BattMonitor_DB_Builder/src/com/sql/util/Db_Param.java
+++ b/BattMonitor_DB_Builder/src/com/sql/util/Db_Param.java
@@ -29,7 +29,6 @@
String sql_str = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.PowerAlarm_param_Table + " "
+ "(num bigint NOT NULL DEFAULT nextval('" + Sql_Mysql.PowerAlarm_param_Table + "_auto'::regclass)," +
- " power_id integer NOT NULL DEFAULT 1," +
" alm_id integer NOT NULL DEFAULT 1," +
" alm_level integer NOT NULL DEFAULT 1," +
" alm_en integer NOT NULL DEFAULT 1," +
@@ -37,9 +36,7 @@
")";
sql.sqlMysqlExecute(sql_str);
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.PowerAlarm_param_Table + " OWNER TO sysdba;");
- sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".alm_id IS '告警id';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".num IS '自增主键';");
- sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".power_id IS '电源ID';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".alm_id IS '电源告警ID';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".alm_level IS '告警等级';");
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.PowerAlarm_param_Table + ".alm_en IS '告警使能[0-禁用 1-启用]';");
--
Gitblit v1.9.1