| | |
| | | + "ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
| | |
|
| | | String table_12_0 = "DROP TABLE IF EXISTS " + PWRDEV_RT_INFO_TABLE;
|
| | | //清空数据库表记录,并重置自增
|
| | | String table_12_1 = "TRUNCATE TABLE " + PWRDEV_RT_INFO_TABLE;
|
| | | String table_12 = "CREATE TABLE IF NOT EXISTS " + PWRDEV_RT_INFO_TABLE
|
| | | + "( `num` bigint NOT NULL AUTO_INCREMENT ,"
|
| | | + "`PowerDeviceId` bigint NOT NULL DEFAULT 0 ,"
|
| | |
| | | //sqlMysqlExecute(table_2_0);
|
| | | //sqlMysqlExecute(table_3_0);
|
| | | //sqlMysqlExecute(table_4_0);
|
| | | sqlMysqlExecute(table_12_0);
|
| | | try {
|
| | | sqlMysqlExecute(table_12_1);
|
| | | } catch (Exception e) {
|
| | | e.printStackTrace();
|
| | | }
|
| | | sqlMysqlExecute(table_14_0);
|
| | | sqlMysqlExecute(table_15_0);
|
| | |
|