rq9UsaN0

1package com.aziflaj.todolist.db;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class TaskDbHelper extends SQLiteOpenHelper {
8
9    public TaskDbHelper(Context context) {
10        super(context, TaskContract.DB_NAME, null, TaskContract.DB_VERSION);
11    }
12
13    @Override
14    public void onCreate(SQLiteDatabase db) {
15        String createTable = "CREATE TABLE " + TaskContract.TaskEntry.TABLE + " ( " +
16                TaskContract.TaskEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
17                TaskContract.TaskEntry.COL_TASK_TITLE + " TEXT NOT NULL);";
18
19        db.execSQL(createTable);
20    }
21
22    @Override
23    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
24        db.execSQL("DROP TABLE IF EXISTS " + TaskContract.TaskEntry.TABLE);
25        onCreate(db);
26    }
27}