| | |
|---|
| | | " `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]'," + |
|---|
| | | " `NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '节点站标识:0:不是节点站[默认] 1:节点站'," + |
|---|
| | | " `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 '拓扑图类型'," + |
|---|
| | | " PRIMARY KEY (`num`)," + |
|---|
| | | " UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," + |
|---|
| | | " KEY `index_station_id` (`StationId`)," + |
|---|
| | |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table |
|---|
| | | + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';"); |
|---|
| | | } |
|---|
| | | res = null; |
|---|
| | | //添加topology_map_type ---- 拓扑图类型 |
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" |
|---|
| | | + " WHERE table_schema='db_battinf'" |
|---|
| | | + " AND table_name='tb_battinf'" |
|---|
| | | + " AND column_name='topology_map_type'"); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table |
|---|
| | | + " ADD COLUMN `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型';"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
