| | |
|---|
| | | " `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]'," + |
|---|
| | | " `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]'," + |
|---|
| | | " `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型'," + |
|---|
| | | " `acdc_secuity_flag` int(11) NOT NULL DEFAULT '0' COMMENT '交直流屏柜启用状态'," + |
|---|
| | | " `comm_port` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型'," + |
|---|
| | | " PRIMARY KEY (`num`)," + |
|---|
| | | " UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," + |
|---|
| | | " KEY `index_station_id` (`StationId`)," + |
|---|
| | |
|---|
| | | + " ADD COLUMN `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型';"); |
|---|
| | | } |
|---|
| | | res = null; |
|---|
| | | //添加acdc_secuity_flag ---- 拓扑图类型 |
|---|
| | | //添加acdc_secuity_flag ---- 是否包含交直流监控屏 |
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" |
|---|
| | | + " WHERE table_schema='db_battinf'" |
|---|
| | | + " AND table_name='tb_battinf'" |
|---|
| | |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table |
|---|
| | | + " ADD COLUMN `acdc_secuity_flag` int(11) NOT NULL DEFAULT '0' COMMENT '是否包含交直流监控屏[0-不包含 1-包含]';"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | res = null; |
|---|
| | | //添加comm_port ---- 通信端口 |
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" |
|---|
| | | + " WHERE table_schema='db_battinf'" |
|---|
| | | + " AND table_name='tb_battinf'" |
|---|
| | | + " AND column_name='comm_port'"); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table |
|---|
| | | + " ADD COLUMN `comm_port` int(11) NOT NULL DEFAULT '102' COMMENT '通信端口[0-使用默认端口]';"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
