Int) { try { db.beginTransaction() if (oldVersion <= 1 && newVersion >= 2) { val table = TABLE_TRAVEL db.execSQL("ALTER TABLE $table RENAME TO tmp_$table") onCreate(db) db.execSQL( """INSERT INTO $table ( $COLUMN_SHOP_ID, $COLUMN_DATETIME, $COLUMN_SIZE, $COLUMN_TOPPING, $COLUMN_COMMENT ) SELECT $COLUMN_SHOP_ID, datetime( substr($COLUMN_DATE, 0, 5)||'-'|| substr($COLUMN_DATE, 6, 2)||'-'|| substr($COLUMN_DATE, 9, 2)||' '|| substr($COLUMN_TIME, 0, 3)||':'|| substr($COLUMN_TIME, 4, 2), 'utc' ), $COLUMN_SIZE, $COLUMN_TOPPING, $COLUMN_COMMENT FROM tmp_$table """.trimIndent(), ) db.execSQL("DROP TABLE tmp_$table") db.setTransactionSuccessful() } } finally { db.endTransaction() } }