4.表'web_site.tb_interface'修改字段长度(接口验证码长度扩增) interface_number varchar(255)...

DELL

2024-02-22 b727b332808dc9a3c9635009a64b752b9deb42e7

4.表'web_site.tb_interface'修改字段长度(接口验证码长度扩增)
		interface_number varchar(255) => varchar(1024)

 BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -25,7 +25,8 @@
          PRIMARY KEY (`num`),
          UNIQUE KEY `index_node_path` (`node_path`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout 实时状态信息表';
	
    4.表'web_site.tb_interface'修改字段长度(接口验证码长度扩增)
        interface_number varchar(255) => varchar(1024)
    
V1.95 edit at date 2024-01-24
    1.StationId int ->Long

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -213,21 +213,39 @@
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Interface_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Interface_Table+ " (" + 
                "  `num` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `interface_number` varchar(255) NOT NULL DEFAULT ''," + 
                "  `interface_number` varchar(1024) NOT NULL DEFAULT ''," + 
                "  `interface_name` varchar(255) NOT NULL DEFAULT ''," + 
                "  `enable`int NOT NULL DEFAULT '1'," + 
                "  PRIMARY KEY (`num`) " + 
                ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null;
        try {
            if(true == recreate) {            
                sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);    
            
            //修改字段env_temp    类型为float
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='web_site'"
                    + " AND table_name='tb_interface'"
                    + " AND column_name='interface_number' AND CHARACTER_MAXIMUM_LENGTH != '1024'");
            if(res.next()){				
                //修改字段env_temp    类型为float
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_Interface_Table 
                        + " CHANGE `interface_number` `interface_number` varchar(1024) NOT NULL DEFAULT '';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -25,7 +25,8 @@
          PRIMARY KEY (`num`),
          UNIQUE KEY `index_node_path` (`node_path`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout 实时状态信息表';
	
    4.表'web_site.tb_interface'修改字段长度(接口验证码长度扩增)
        interface_number varchar(255) => varchar(1024)
    
V1.95 edit at date 2024-01-24
    1.StationId int ->Long