MNhMmjJT

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