Exemplo de alteração de banco de dados SQLite com Kotlin .. rastreamento de filhos

esquema-chamada.kt

private const val SQL_CREATE_ENTRIES =
        "CREATE TABLE ${ChamadaEntry.TABLE_NAME} (" +
                "${BaseColumns._ID} INTEGER PRIMARY KEY," +
                "${ChamadaEntry.COLUMN_NAME_DATA_HORA} TEXT," +
                "${ChamadaEntry.COLUMN_NAME_FILHO} TEXT)" +
                "${ChamadaEntry.COLUMN_NAME_DIRECAO} TEXT)" +
                "${ChamadaEntry.COLUMN_NAME_TELEFONE} TEXT)" +

object LocalizacaoContract {
    object LocalizacaoEntry : BaseColumns {
        const val TABLE_NAME = "localizacao"
        const val COLUMN_NAME_DATA_HORA = "datahora"
        const val COLUMN_NAME_FILHO = "filho"
        const val COLUMN_NAME_LATITUDE = "latitude"
        const val COLUMN_NAME_LONGITUDE = "longitude"
    }
}

object ChamadaContract {
    object ChamadaEntry : BaseColumns {
        const val TABLE_NAME = "chamada"
        const val COLUMN_NAME_DATA_HORA = "datahora"
        const val COLUMN_NAME_FILHO = "filho"
        const val COLUMN_NAME_DIRECAO = "direcao"
        const val COLUMN_NAME_TELEFONE = "telefone"
    }
}

migrate.kt

class MonitoramentoDbHelper(context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {
    override fun onCreate(db: SQLiteDatabase) {
        db.execSQL(SQL_CREATE_ENTRIES)
    }
    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
        onCreate(db)
    }
    companion object {
        const val DATABASE_VERSION = 2
        const val DATABASE_NAME = "Monitoramento.db"
    }
}