x7x6VCc9

1import android.content.Context;
2import android.database.sqlite.SQLiteDatabase;
3import android.database.sqlite.SQLiteOpenHelper;
4import android.util.Log;
5
6public class DBHelper extends SQLiteOpenHelper {
7
8	public static final int DB_VERSION = 1;
9	public static final String DB_NAME = "TestDB";
10
11	public static final String USER_ID = "user_id";
12	public static final String TABLE_FRIENDS = "friends";
13	public static final String FRIEND_USER_ID = "friend_user_id";
14	public static final String FRIEND_NAME = "friend_name";
15	public static final String FRIEND_BLOCKED = "friend_blocked";
16	public static final String FRIEND_PROFILE_PIC = "friend_profile_pic";
17	public static final String FRIEND_DISTANCE = "friend_distance";
18	
19	public static final String TAG = DBHelper.class.getSimpleName();
20
21	@SuppressWarnings("unused")
22	private Context mContext;
23
24	public DBHelper(Context context) {
25		super(context, DB_NAME, null, DB_VERSION);
26		this.mContext = context;
27	}
28
29	@Override
30	public void onCreate(SQLiteDatabase db) {
31		// TODO Auto-generated method stub
32		version1Create(db);
33		Log.e(TAG, "Database created successfully!");
34	}
35
36	private void version1Create(SQLiteDatabase db) {
37		String createFriends = "CREATE TABLE IF NOT EXISTS "
38				+ TABLE_FRIENDS + "("
39				+ FRIEND_USER_ID + " VARCHAR, "
40				+ FRIEND_NAME + " VARCHAR, "
41				+ FRIEND_BLOCKED + " INTEGER, "
42				+ FRIEND_PROFILE_PIC + " VARCHAR, "
43				+ FRIEND_DISTANCE + " REAL,"
44				+ USER_ID + " VARCHAR);";
45		
46		db.execSQL(createFriends);
47	}
48
49	@Override
50	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
51		// TODO Auto-generated method stub
52
53		switch (newVersion) {
54		case 1:
55			version1Create(db);
56			Log.e(DB_NAME + " UPGRADE", "Database updated to version " + 1);
57		}
58
59		Log.e(TAG, "Database updated successfully!");
60	}
61
62}