V1.72 edit at date 2023-05-12 1.新增表'web_site.tb_fault_upload' ---故障隐患上传表 ...

Administrator

2023-05-12 7514f426c53f533740519e4e40d0132b53ab5692

V1.72 edit at date 2023-05-12
	1.新增表'web_site.tb_fault_upload' ---故障隐患上传表
		CREATE TABLE `tb_fault_upload` (
		  `id` int(11) NOT NULL AUTO_INCREMENT,
		  `station_name` varchar(500) DEFAULT NULL,
		  `type` int(11) DEFAULT NULL,
		  `description` varchar(500) DEFAULT NULL,
		  `upload_user_id` int(11) DEFAULT NULL,
		  `confirm_user_id` int(11) DEFAULT NULL,
		  `confirm_description` varchar(500) DEFAULT NULL,
		  `confirm_time` datetime DEFAULT NULL,
		  `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实',
		  `create_time` datetime DEFAULT NULL,
		  PRIMARY KEY (`id`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';

 BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,5 +1,21 @@
蓄电池监控平台建表程序

V1.72 edit at date 2023-05-12
    1.新增表'web_site.tb_fault_upload' ---故障隐患上传表
        CREATE TABLE `tb_fault_upload` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `station_name` varchar(500) DEFAULT NULL,
          `type` int(11) DEFAULT NULL,
          `description` varchar(500) DEFAULT NULL,
          `upload_user_id` int(11) DEFAULT NULL,
          `confirm_user_id` int(11) DEFAULT NULL,
          `confirm_description` varchar(500) DEFAULT NULL,
          `confirm_time` datetime DEFAULT NULL,
          `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实',
          `create_time` datetime DEFAULT NULL,
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';

V1.71 edit at date 2023-05-04
    1.表 'db_ram_db.tb_fbs9100_sysparam' 新增字段  配网电源新增系统参数
          `auto_captestperiod` int(11) NOT NULL DEFAULT '0' COMMENT '自动核容周期，单位：天(7~999)',

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -97,6 +97,8 @@
            
        createWorkflow_Main_Table(pool, recreate);                   //创建工作流主表
        
        createFault_Upload_Table(pool, recreate);                    //故障隐患上传表
		
        System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
    
@@ -5469,6 +5471,38 @@
            sql.close_con();
        }
    }
    /**
     *     故障隐患上传表
     * @param pool
     * @param recreate
     */
    public static void createFault_Upload_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Fault_Upload_Table;
        String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Fault_Upload_Table + " (" + 
                "  `id` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `station_name` varchar(500) DEFAULT NULL," + 
                "  `type` int(11) DEFAULT NULL," + 
                "  `description` varchar(500) DEFAULT NULL," + 
                "  `upload_user_id` int(11) DEFAULT NULL," + 
                "  `confirm_user_id` int(11) DEFAULT NULL," + 
                "  `confirm_description` varchar(500) DEFAULT NULL," + 
                "  `confirm_time` datetime DEFAULT NULL," + 
                "  `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实'," + 
                "  `create_time` datetime DEFAULT NULL," + 
                "  PRIMARY KEY (`id`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        try {
            if(recreate) {
                sql.sqlMysqlExecute(sql_str_del);
            }
            sql.sqlMysqlExecute(sql_str);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            sql.close_con();
        }
    }
    
    
    /**

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -244,6 +244,7 @@
    public static final String Tb_Workflow_Link_Table = WEB_Site +".`tb_workflow_link`";                        //工作流节点表
    public static final String Tb_Workflow_Main_Table = WEB_Site +".`tb_workflow_main`";                        //工作流主表
    
    public static final String Tb_Fault_Upload_Table = WEB_Site +".`tb_fault_upload`";                            //故障隐患上传表,用于故障隐患考核
    
    /***************************** db_battinf数据库  ***************************************/
    public final static String DeverrorRecord_Table = DB_BATT_INF + ".`tb_deverror_record`";                        //机房问题记录表

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,5 +1,21 @@
蓄电池监控平台建表程序

V1.72 edit at date 2023-05-12
    1.新增表'web_site.tb_fault_upload' ---故障隐患上传表
        CREATE TABLE `tb_fault_upload` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `station_name` varchar(500) DEFAULT NULL,
          `type` int(11) DEFAULT NULL,
          `description` varchar(500) DEFAULT NULL,
          `upload_user_id` int(11) DEFAULT NULL,
          `confirm_user_id` int(11) DEFAULT NULL,
          `confirm_description` varchar(500) DEFAULT NULL,
          `confirm_time` datetime DEFAULT NULL,
          `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实',
          `create_time` datetime DEFAULT NULL,
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';

V1.71 edit at date 2023-05-04
    1.表 'db_ram_db.tb_fbs9100_sysparam' 新增字段  配网电源新增系统参数
          `auto_captestperiod` int(11) NOT NULL DEFAULT '0' COMMENT '自动核容周期，单位：天(7~999)',