DBManager:

package com.sjaapper.launcher;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;

public class DBManager extends SQLiteOpenHelper {

	private static final String SJAAPPER_DB = "Sjaapper.db";
	private static final int SJAAPPER_DB_VERSION = 1;

	// USER table constants
	public static final String USER_TABLE = "USER";
	public static final String UT_USERID = "USERID";
	public static final String UT_FIRSTNAME = "FIRSTNAME";
	public static final String UT_LASTNAME = "LASTNAME";
	public static final String UT_USEREMAIL = "USEREMAIL";
	public static final String UT_PASSWORD = "PASSWORD";
	public static final String UT_GENDER = "GENDER";
	public static final String UT_BIRTHDAY = "BIRTHDAY";
	public static final String UT_STATUS = "STATUS";
	public static final String UT_ISFBUSER = "ISFBUSER";
	public static final String UT_CREATEDDATE = "CREATEDDATE";
	public static final String UT_MODIFIEDDATE = "MODIFIEDDATE";
	public static final String UT_USERIMAGE = "USERIMAGE";
	public static final String UT_SPPOINT = "SPPOINT";
	public static final String UT_XPPOINT = "XPPOINT";
	public static final String UT_TREND = "TREND";
	public static final String UT_CHARISMA = "CHARISMA";

	// PRODUCT table constants
	public static final String PRODUCT_TABLE = "PRODUCT";
	public static final String PT_PRODUCTID = "PRODUCTID";
	public static final String PT_PRODUCTNAME = "PRODUCTNAME";
	public static final String PT_BUSINESSID = "BUSINESSID";
	public static final String PT_BRANDID = "BRANDID";
	public static final String PT_PRODUCTCATEGORYID = "PRODUCTCATEGORYID";
	public static final String PT_MANUFACTUREITEMNO = "MANUFACTUREITEMNO";;
	public static final String PT_DESCRIPTION = "DESCRIPTION";
	public static final String PT_PRODUCTIMAGE = "PRODUCTIMAGE";
	public static final String PT_TREND = "TREND";
	public static final String PT_CHARISMA = "CHARISMA";
	public static final String PT_CREATEDBY = "CREATEDBY";
	public static final String PT_CREATEDDATE = "CREATEDDATE";
	public static final String PT_MODIFIEDBY = "MODIFIEDBY";
	public static final String PT_MODIFIEDDATE = "MODIFIEDDATE";
	public static final String PT_ORIGINALPRICE = "ORIGINALPRICE";
	public static final String PT_OFFERPRICE = "OFFERPRICE";
	public static final String PT_ISNOTIFYABLE = "ISNOTIFYABLE";
	public static final String PT_NOTIFYSTATUS = "NOTIFYSTATUS";
	public static final String PT_OFFERID = "OFFERID";
	public static final String PT_DATETIME = "DATETIME";
	public static final String PT_USERNAME = "USERNAME";
	public static final String PT_LOCATIONLATITUDE = "LOCATIONLATITUDE";
	public static final String PT_LOCATIONLONGITUDE = "LOCATIONLONGITUDE";
	public static final String PT_VALIDFROM = "VALIDFROM";
	public static final String PT_VALIDTO = "VALIDTO";
	public static final String PT_BRANDNAME = "BRANDNAME";
	public static final String PT_SYNCDATETIME = "SYNCDATETIME";
	public static final String PT_BUSINESSNAME = "BUSINESSNAME";
	public static final String PT_VALIDATIONCODE = "VALIDATIONCODE";
	public static final String PT_ATTRIBUTEDESC = "ATTRIBUTEDESC";
	public static final String PT_STATUS = "STATUS";

	// APPSTATS table constants
	public static final String APPSTATS_TABLE = "APPSTATS";
	public static final String AS_USERID = "USERID";
	public static final String AS_OFFERID = "OFFERID";
	public static final String AS_BUSINESSID = "BUSINESSID";
	public static final String AS_PRODUCTID = "PRODUCTID";
	public static final String AS_PRODUCTCATEGORYID = "PRODUCTCATEGORYID";
	public static final String AS_BRANDID = "BRANDID";
	public static final String AS_ACTION = "ACTION";
	public static final String AS_REVENUE = "REVENUE";
	public static final String AS_ATTRIBUTEKEY = "ATTRIBUTEKEY";
	public static final String AS_ATTRIBUTEVALUE = "ATTRIBUTEVALUE";
	public static final String AS_ACTIONLATITUDE = "ACTIONLATITUDE";
	public static final String AS_ACTIONLONGTITUDE = "ACTIONLONGTITUDE";
	public static final String AS_CREATEDDATE = "CREATEDDATE";
	public static final String AS_USERNAME = "USERNAME";
	public static final String AS_ISNOTIFYABLE = "ISNOTIFYABLE";
	public static final String AS_DATETIME = "DATETIME";


	// Device Key
	public static final String DEVICEDETAILS_TABLE = "DEVICEDETAILS";
	public static final String DD_DEVICEID = "DEVICEID";
	public static final String DD_DEVICEKEY = "DEVICEKEY";

	//Notification
	public static final String SETTINGS_TABLE="SETTINGS";
	public static final String S_NOTIFY="NOTIFY";

	//FACEBOOK
	public static final String FB_TABLE="FACEBOOK";
	public static final String FB_NOTIFY="FBNOTIFY";

	//TWITTER
	public static final String TW_TABLE="TWITTER";
	public static final String TW_NOTIFY="TWNOTIFY";

	//Tab Control
	public static final String TAB_TABLE="TAB";
	public static final String TAB_CURRENTTAB="CURRENTTAB";

	String sql;

	public DBManager(Context Context) {
		super(Context, SJAAPPER_DB, null, SJAAPPER_DB_VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		createUserTable(db);
		createProductTable(db);
		createAppStatsTable(db);
		createDeviceTable(db);
		createSettingsTable(db);
		createFbTable(db);
		createTwTable(db);
		createTabTable(db);
	}

	private void createUserTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + USER_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + UT_FIRSTNAME + " TEXT, " + UT_LASTNAME + " TEXT, "
				+ UT_USEREMAIL + " TEXT, " + UT_PASSWORD + " TEXT, " + UT_GENDER + " TEXT, " + UT_BIRTHDAY + " TEXT, " + UT_STATUS + " TEXT, "
				+ UT_ISFBUSER + " TEXT, " + UT_CREATEDDATE + " TEXT, " + UT_MODIFIEDDATE + " TEXT, " + UT_USERIMAGE + " BLOB, "+ UT_SPPOINT + " TEXT, " + UT_XPPOINT + " TEXT, " + UT_TREND + " TEXT, " + UT_CHARISMA + " TEXT, "+ UT_USERID + " TEXT );";
		db.execSQL(sql);
	}

	private void createProductTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + PRODUCT_TABLE + "( " + PT_PRODUCTID + " TEXT, " + PT_PRODUCTNAME + " TEXT, " + PT_BUSINESSID
				+ " TEXT, " + PT_BRANDID + " TEXT, " + PT_PRODUCTCATEGORYID + " TEXT, " + PT_MANUFACTUREITEMNO + " TEXT, " + PT_DESCRIPTION
				+ " TEXT, " + PT_PRODUCTIMAGE + " TEXT, " + PT_TREND + " TEXT, " +  PT_CHARISMA + " TEXT, " + PT_CREATEDBY + " TEXT, "
				+ PT_CREATEDDATE + " TEXT, " + PT_MODIFIEDBY + " TEXT, " + PT_MODIFIEDDATE + " TEXT, " + PT_ORIGINALPRICE + " TEXT, " + PT_OFFERPRICE
				+ " TEXT, " + PT_ISNOTIFYABLE + " TEXT, " + PT_NOTIFYSTATUS + " TEXT, " + PT_OFFERID + " TEXT,"+ PT_DATETIME + " TEXT, "+ PT_USERNAME + " TEXT, "
				+ PT_LOCATIONLATITUDE + " TEXT, "+ PT_LOCATIONLONGITUDE + " TEXT, " + PT_VALIDFROM + " TEXT, "+ PT_VALIDTO + " TEXT, " + PT_BRANDNAME + " TEXT, "
				+ PT_SYNCDATETIME + " TEXT, " + PT_BUSINESSNAME + " TEXT, " + PT_VALIDATIONCODE + " TEXT, "+ PT_ATTRIBUTEDESC + " TEXT, "+ PT_STATUS + " TEXT);";
		db.execSQL(sql);
	}

	private void createAppStatsTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + APPSTATS_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + AS_USERID + " TEXT, " + AS_OFFERID
				+ " TEXT, " + AS_BUSINESSID + " TEXT, " + AS_PRODUCTID + " TEXT, " + AS_PRODUCTCATEGORYID + " TEXT, " + AS_BRANDID + " TEXT, "
				+ AS_ACTION + " TEXT, " + AS_REVENUE + " TEXT, " + AS_ATTRIBUTEKEY + " TEXT, " + AS_ATTRIBUTEVALUE + " TEXT, " + AS_ACTIONLATITUDE
				+ " TEXT, " + AS_ACTIONLONGTITUDE + " TEXT, " + AS_CREATEDDATE + " TEXT, " + AS_USERNAME + " TEXT, " + AS_ISNOTIFYABLE + " TEXT, " + AS_DATETIME + " TEXT); ";
		db.execSQL(sql);
	}

	private void createDeviceTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + DEVICEDETAILS_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + DD_DEVICEID + " TEXT, "
				+ DD_DEVICEKEY + " TEXT); ";
		db.execSQL(sql);
	}

	private void createSettingsTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + SETTINGS_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + S_NOTIFY + " TEXT); ";
		db.execSQL(sql);
	}

	private void createFbTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + FB_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + FB_NOTIFY + " TEXT); ";
		db.execSQL(sql);
	}

	private void createTwTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + TW_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + TW_NOTIFY + " TEXT); ";
		db.execSQL(sql);
	}

	private void createTabTable(SQLiteDatabase db) {
		sql = "CREATE TABLE " + TAB_TABLE + "( " + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + TAB_CURRENTTAB + " TEXT); ";
		db.execSQL(sql);
	}
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		db.execSQL("DROP TABLE IF EXISTS " + USER_TABLE);
		db.execSQL("DROP TABLE IF EXISTS " + PRODUCT_TABLE);
		db.execSQL("DROP TABLE IF EXISTS " + APPSTATS_TABLE);
		onCreate(db);
	}

}