TzEB16Bj

1@Override
2        public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) { 
3     
4public static void createuserTable(SQLiteDatabase db, String tableName) {
5
6    final String table = "CREATE TABLE IF NOT EXISTS "
7                    + tableName + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, user_name TEXT, addressTEXT, phone TEXT, phone2 TEXT)";
8
9     Cursor cursor = db.rawQuery(table , null); // grab cursor for all data
10            int deleteStateColumnIndex = cursor.getColumnIndex("email");  // see if the column is there
11            if (deleteStateColumnIndex < 0) {
12                // missing_column not there - add it
13                Log.d("value dont exist","value dont exist");
14            }
15        db.execSQL(table);
16
17      }