1 package pl.org.nowoczesnapolska;
2 import android.content.Context;
3 import android.database.sqlite.SQLiteDatabase;
4 import android.database.sqlite.SQLiteDatabase.CursorFactory;
5 import android.database.sqlite.SQLiteOpenHelper;
7 public class CatalogueDbHelper extends SQLiteOpenHelper {
9 public CatalogueDbHelper(Context context, String name,
10 CursorFactory factory, int version) {
11 super(context, name, factory, version);
12 // TODO Auto-generated constructor stub
15 private static final int DATABASE_VERSION = 2;
16 private static final String TAGS_TABLE = "tags";
17 private static final String BOOKS_TABLE = "books";
19 private static final String TAGS_TABLE_CREATE =
20 "CREATE TABLE " + TAGS_TABLE + " (" +
29 private static final String BOOKS_TABLE_CREATE =
30 "CREATE TABLE " + BOOKS_TABLE + " (" +
38 private static final String DATABASE_NAME = "wl-mobile";
40 CatalogueDbHelper(Context context) {
41 super(context, DATABASE_NAME, null, DATABASE_VERSION);
45 public void onCreate(SQLiteDatabase db) {
46 db.execSQL(BOOKS_TABLE_CREATE);
47 db.execSQL(TAGS_TABLE_CREATE);
51 public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
52 // TODO Auto-generated method stub