| | |
|---|
| | | " `ModuleInUseCount` int(11) NOT NULL DEFAULT '0'," +
|
|---|
| | | " `ModuleCap` int(11) NOT NULL DEFAULT '0'," +
|
|---|
| | | " `ModuleSlotCount` int(11) NOT NULL DEFAULT '0'," +
|
|---|
| | | " `ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '高频开关柜交流模块是否启用'," + |
|---|
| | | " PRIMARY KEY (`num`)," +
|
|---|
| | | " KEY `index_pwrdev_id` (`PowerDeviceId`)" +
|
|---|
| | | ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;";
|
|---|
| | | Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
|---|
| | | ResultSet res = null;
|
|---|
| | | try {
|
|---|
| | | if(true == recreate) {
|
|---|
| | | sql.sqlMysqlExecute(sql_str01);
|
|---|
| | | }
|
|---|
| | | sql.sqlMysqlExecute(sql_str02);
|
|---|
| | | |
|---|
| | | |
|---|
| | | res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
|
|---|
| | | + " WHERE table_schema='db_pwrdev_inf'"
|
|---|
| | | + " AND table_name='tb_pwrapp_acdcinf'"
|
|---|
| | | + " AND column_name='ModuleSwitchStatus'");
|
|---|
| | | if(false == res.next()) {
|
|---|
| | | sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.Pwrapp_Acdcinf_Table |
|---|
| | | + " ADD COLUMN `ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '高频开关柜交流模块是否启用';");
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | } finally {
|
|---|
| | | if(null != res) {
|
|---|
| | | try {
|
|---|
| | | res.close();
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | sql.close_con();
|
|---|
| | | }
|
|---|
| | | }
|
|---|
