见表语句中添加基站号码列

LiJun

2018-10-16 db1e917af9ba9d5a0561984d1a1a30d905d4a7b9

见表语句中添加基站号码列

 BattMonitor_DB_Builder/bin/.gitignore

@@ -1,2 +1 @@
/com/
/main/

 BattMonitor_DB_Builder/bin/com/sql/Sql_Mysql.class

Binary files differ

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -492,7 +492,17 @@
                            sqlMysqlExecute("ALTER TABLE " + BattInf_Table 

                                            + " ADD COLUMN `disCurrMax` float NOT NULL DEFAULT 0");

                        }

				
						
                //-------------------------------- 2018-10-16 by lijun   (  binf表中添加   station_phone->基站手机号 )------------------------------------//		
                        res = sqlMysqlQuery("SELECT * FROM information_schema.columns"

                                + " WHERE table_schema='db_battinf'"

                                + " AND table_name='tb_battinf'"

                                + " AND column_name='station_phone'");

                        if(false == res.next()) {

                            sqlMysqlExecute("ALTER TABLE " + BattInf_Table 
                                            + " ADD COLUMN `station_phone` varchar(32) DEFAULT ''");

                        }

						
                //---------------------------------------------------------------------------------------------//