fRS4NQ9V

1    override fun onCreate(db: SQLiteDatabase?) {
2        val createTable = "CREATE TABLE if not exists " + TABLE_NAME + " (" +
3                COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
4                COL_NAME + " VARCHAR(20)," + COL_AGE + " INTEGER);"
5        db?.execSQL(createTable)
6    }
7
8    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
9        db!!.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME)
10        onCreate(db)
11    }