V1.89 edit at date 2023-10-24 1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(...

Administrator

2023-10-24 f69289f63800a255bc9d5ae818ba639694f2ae7e

V1.89 edit at date 2023-10-24
	1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)

 BattMonitor_DB_Builder/bin/com/database_util/DB_db_user.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,5 +1,8 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
	
V1.89 edit at date 2023-10-24
    1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)

V1.88 edit at date 2023-10-09
    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复

 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java

@@ -1298,10 +1298,10 @@
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='upassword'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable 
                                + " ADD COLUMN `upassword` varchar(200) NOT NULL DEFAULT ''");
            }else{
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable 
                        + " MODIFY COLUMN `upassword` varchar(200) NOT NULL DEFAULT '';");
            }
            
@@ -1311,9 +1311,10 @@
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='uPubKeyX'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable 
                                + " ADD COLUMN `uPubKeyX` varchar(200) NOT NULL DEFAULT ''");
            }
			
            
            //添加公钥Y
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -1321,7 +1322,7 @@
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='uPubKeyY'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable 
                                + " ADD COLUMN `uPubKeyY` varchar(200) NOT NULL DEFAULT ''");
            }
            
@@ -1374,14 +1375,14 @@
            }
            
            
            //修改usnid的长度改成varchar(200)
            //修改usnid的长度改成varchar(1000)
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='uSnId'");
            if(res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                                + " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(200) NOT NULL DEFAULT '123456';");
                                + " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(1000) NOT NULL DEFAULT '123456';");
            }
            //修改password的长度改成varchar(200)
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -1478,15 +1479,6 @@
                        + " ADD COLUMN `visit_ip` VARCHAR(255) NULL DEFAULT '*' COMMENT '允许访问ip' AFTER `visit_time`;");
            }
            
            //修改uSnId长度位200
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"
                    + " AND table_name='tb_user_inf'"
                    + " AND column_name='uSnId'");
            if(res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf 
                        + " MODIFY COLUMN `uSnId` VARCHAR(200) NOT NULL DEFAULT '123456';");
            }
            
            //123456--------
            String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,5 +1,8 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
	
V1.89 edit at date 2023-10-24
    1.'db_user.tb_user_inf'表修改'UsnId'长度 varchar(200)->varchar(1000)

V1.88 edit at date 2023-10-09
    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -32,7 +32,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.88;
    public final static float m_VersionNum = (float) 1.89;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/