Vz4ZyzCx

1package com.example.android.tabletoprpgexperiencetrackerapp;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class SessionDBHelper extends SQLiteOpenHelper{
8    public static final String DATABASE_NAME = "sessionlist.db";
9    public static final int DATABASE_VERSION = 1;
10
11    public SessionDBHelper(Context context) {
12        super(context, DATABASE_NAME, null, DATABASE_VERSION);
13    }
14
15    @Override
16    public void onCreate(SQLiteDatabase sqLiteDatabase) {
17        final String SQL_CREATE_SESSIONLIST_TABLE = "CREATE TABLE " +
18                SessionContract.SessionEntry.TABLE_NAME + "(" +
19                SessionContract.SessionEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
20                SessionContract.SessionEntry.COLUMN_SESSION_NUMBER + " INTEGER NOT NULL, " +
21                SessionContract.SessionEntry.COLUMN_CREATURE_NAME + " TEXT NOT NULL, " +
22                SessionContract.SessionEntry.COLUMN_CHALLENGE_RATING + " TEXT NOT NULL, " +
23                SessionContract.SessionEntry.COLUMN_EXPERIENCE + " INTEGER NOT NULL, " +
24                SessionContract.SessionEntry.COLUMN_QUANTITY + " INTEGER NOT NULL, " +
25                SessionContract.SessionEntry.COLUMN_TIMESTAMP + " TIMESTAMP DEFAULT CURRENT_TIMESTAMP" +
26                ");";
27
28        sqLiteDatabase.execSQL(SQL_CREATE_SESSIONLIST_TABLE);
29    }
30
31    @Override
32    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int il){
33        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + SessionContract.SessionEntry.TABLE_NAME);
34        onCreate(sqLiteDatabase);
35    }
36}