// Path: app/src/main/java/com/ghostflying/portalwaitinglist/dao/dbinfo/PortalEventDbInfo.java
// public class PortalEventDbInfo implements BaseColumns {
//     public static final int ID = 0;
//     public static final String TABLE_NAME = "event";
//     public static final String COLUMN_NAME_PORTAL_NAME = "portalname";
//     public static final String COLUMN_NAME_OPERATION_TYPE = "operationtype";
//     public static final String COLUMN_NAME_OPERATION_RESULT = "operationresult";
//     public static final String COLUMN_NAME_MESSAGE_ID = "messageid";
//     public static final String COLUMN_NAME_DATE = "date";
//     public static final String COLUMN_NAME_IMAGE_URL = "imageurl";
//     public static final String COLUMN_NAME_ADDRESS = "address";
//     public static final String COLUMN_NAME_ADDRESS_URL = "addressurl";
// }


import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.ghostflying.portalwaitinglist.dao.dbinfo.PortalEventDbInfo;
package com.ghostflying.portalwaitinglist.dao;



/**
 * Created by ghostflying on 1/14/15.
 */
public class DbHelper extends SQLiteOpenHelper{
    static final int DATABASE_VERSION = 3;
    static final String DATABASE_NAME = "PortalEvent.db";

    private static final String TEXT_TYPE = " TEXT";
    private static final String INTEGER_TYPE = " INTEGER";
    private static final String COMMA_SEP = ",";
    private static final String NOT_NULL = " NOT NULL";
    private static final String SQL_CREATE_EVENTS = "CREATE TABLE " + PortalEventDbInfo.TABLE_NAME
            + " (" + PortalEventDbInfo._ID + INTEGER_TYPE + " PRIMARY KEY, "
            + PortalEventDbInfo.COLUMN_NAME_PORTAL_NAME + TEXT_TYPE + NOT_NULL + COMMA_SEP
            + PortalEventDbInfo.COLUMN_NAME_OPERATION_TYPE + INTEGER_TYPE + NOT_NULL + COMMA_SEP
// Path: app/src/main/java/com/ghostflying/portalwaitinglist/dao/dbinfo/PortalEventDbInfo.java
// public class PortalEventDbInfo implements BaseColumns {
//     public static final int ID = 0;
//     public static final String TABLE_NAME = "event";
//     public static final String COLUMN_NAME_PORTAL_NAME = "portalname";
//     public static final String COLUMN_NAME_OPERATION_TYPE = "operationtype";
//     public static final String COLUMN_NAME_OPERATION_RESULT = "operationresult";
//     public static final String COLUMN_NAME_MESSAGE_ID = "messageid";
//     public static final String COLUMN_NAME_DATE = "date";
//     public static final String COLUMN_NAME_IMAGE_URL = "imageurl";
//     public static final String COLUMN_NAME_ADDRESS = "address";
//     public static final String COLUMN_NAME_ADDRESS_URL = "addressurl";
// }


// Path: app/src/main/java/com/ghostflying/portalwaitinglist/dao/DbHelper.java
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.ghostflying.portalwaitinglist.dao.dbinfo.PortalEventDbInfo;

package com.ghostflying.portalwaitinglist.dao;



/**
 * Created by ghostflying on 1/14/15.
 */
public class DbHelper extends SQLiteOpenHelper{
    static final int DATABASE_VERSION = 3;
    static final String DATABASE_NAME = "PortalEvent.db";

    private static final String TEXT_TYPE = " TEXT";
    private static final String INTEGER_TYPE = " INTEGER";
    private static final String COMMA_SEP = ",";
    private static final String NOT_NULL = " NOT NULL";
    private static final String SQL_CREATE_EVENTS = "CREATE TABLE " + PortalEventDbInfo.TABLE_NAME
            + " (" + PortalEventDbInfo._ID + INTEGER_TYPE + " PRIMARY KEY, "
            + PortalEventDbInfo.COLUMN_NAME_PORTAL_NAME + TEXT_TYPE + NOT_NULL + COMMA_SEP
            + PortalEventDbInfo.COLUMN_NAME_OPERATION_TYPE + INTEGER_TYPE + NOT_NULL + COMMA_SEP
            + PortalEventDbInfo.COLUMN_NAME_OPERATION_RESULT + INTEGER_TYPE + NOT_NULL + COMMA_SEP