| | |
|---|
| | | + " AND column_name='k1_st'"); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table |
|---|
| | | + " ADD COLUMN `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开 1-闭合）';"); |
|---|
| | | + " ADD COLUMN `k1_st` int(5) NOT NULL DEFAULT '0' COMMENT '组1接触器k状态（0-断开 1-闭合）';"); |
|---|
| | | } |
|---|
| | | res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns" |
|---|
| | | + " WHERE table_schema='db_ram_db'" |
|---|
| | | + " AND table_name='tb_fbs9100s_stemnode_state'" |
|---|
| | | + " AND column_name='k2_st'"); |
|---|
| | | if(false == res.next()) { |
|---|
| | | sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table |
|---|
| | | + " ADD COLUMN `k2_st` int(5) NOT NULL DEFAULT '0' COMMENT '组2接触器k状态（0-断开 1-闭合）';"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
