| | |
| | | + " ADD COLUMN `screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '进入屏幕保护时间(不能小于10分钟)';"); |
| | | } |
| | | /****************************************************************/ |
| | | /****************************************************************/ |
| | | res = null; |
| | | //添加 moncap [标称容量] |
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" |
| | | + " WHERE table_schema='db_ram_db'" |
| | | + " AND table_name='tb_fbs9100_setparam'" |
| | | + " AND column_name='moncap'"); |
| | | if(false == res.next()) { |
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table |
| | | + " ADD COLUMN `moncap` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量';"); |
| | | } |
| | | /****************************************************************/ |
| | | } catch (SQLException e) { |
| | | e.printStackTrace(); |
| | | } finally { |