xZymDcCg

1Database not created using SQLite3 in Android
2package FinalProj.com;
3
4import android.content.Context;
5import android.database.sqlite.SQLiteDatabase;
6import android.database.sqlite.SQLiteOpenHelper;
7
8public class DatabaseHelper extends SQLiteOpenHelper {
9
10    private static final String DATABASE_NAME="test.db";
11    public static final String TIME="time";
12    //public static final String STATUS="status";
13    //public static final String MINES="loadmines";
14    //public static final String OPENTILE="openTile";
15
16    public DatabaseHelper(Context context)
17    {
18        super(context,DATABASE_NAME,null,1);
19    }
20    @Override
21    public void onCreate(SQLiteDatabase arg0) {
22        // TODO Auto-generated method stub
23        //CREATE TABLE minesweeper(_id INTEGER PRIMARY KEY AUTOINCREMENT,userId TEXT
24        arg0.execSQL("CREATE TABLE finalP(_id INTEGER PRIMARY KEY AUTOINCREMENT,time TEXT);");
25
26    }
27
28    @Override
29    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
30        // TODO Auto-generated method stub
31        db.execSQL("DROP TABLE IF EXISTS finalP");
32        onCreate(db);
33    }
34
35}