package com.xzjmyk.pm.activity.db;

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

/**
 * 不使用框架的数据库帮助类
 * Created by gongpm on 2016/6/7.
 */
public class OtherSqliteHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "other.db";
    private static final int DATABASE_VERSION = 2;

    public OtherSqliteHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        String sql = "CREATE TABLE SubscriptionMessage(id_ PRIMARY KEY,num_id_,instance_id_ ,createdate_,title_," +
                "son_title_,status_,EMP_ID_,RN_,SONTITLE_,SUMDATA_,name)";
        sqLiteDatabase.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS SubscriptionMessage");
        String sql = "CREATE TABLE SubscriptionMessage(id_ PRIMARY KEY,num_id_,instance_id_ ,createdate_,title_," +
                "son_title_,status_,EMP_ID_,RN_,SONTITLE_,SUMDATA_,name)";
        sqLiteDatabase.execSQL(sql);
    }
}