sCd2L1kB

1package fr.epsi.arthur.todolist;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import fr.epsi.arthur.todolist.DatabaseInfo.*;
7
8
9public class Database extends SQLiteOpenHelper {
10    public static final String DATABASE_NAME = "TODOLIST.db";
11    public static final int DATABASE_VERSION = 1;
12
13    public Database(Context context) {
14        super(context, DATABASE_NAME, null, DATABASE_VERSION);
15    }
16
17    @Override
18    public void onCreate(SQLiteDatabase db) {
19        final String SQL_CREATE_GROCERYLIST_TABLE = "CREATE TABLE " +
20                DatabaseInfo.DBEntry.TABLE_NAME + " (" +
21                DatabaseInfo.DBEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
22                DatabaseInfo.DBEntry.COLUMN_NAME + " TEXT NOT NULL, " +
23                DatabaseInfo.DBEntry.COLUMN_TIMESTAMP + " TIMESTAMP DEFAULT CURRENT_TIMESTAMP" +
24                ");";
25
26        db.execSQL(SQL_CREATE_GROCERYLIST_TABLE);
27    }
28
29    @Override
30    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
31        db.execSQL("DROP TABLE IF EXISTS " + DatabaseInfo.DBEntry.TABLE_NAME);
32        onCreate(db);
33    }
34}