workspace/TrainDelayed/src/com/td/db/SQLiteOpenHelperImpl.java

   1 package com.td.db;\r
   2 \r
   3 import android.content.Context;\r
   4 import android.database.sqlite.SQLiteDatabase;\r
   5 import android.database.sqlite.SQLiteOpenHelper;\r
   6 \r
   7 public class SQLiteOpenHelperImpl extends SQLiteOpenHelper {\r
   8         private static final String DATABASE_NAME = "history.db";\r
   9         private static final int DATABASE_VERSION = 1;\r
  10         \r
  11         public SQLiteOpenHelperImpl(Context context) {\r
  12                 super(context, DATABASE_NAME, null, DATABASE_VERSION);\r
  13         }\r
  14 \r
  15         @Override\r
  16         public void onCreate(SQLiteDatabase db) {\r
  17                 db.execSQL(\r
  18                                 "CREATE TABLE HISTORY ("\r
  19                                 + android.provider.BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"\r
  20                                 + "ROUTE_ID INTEGER,"\r
  21                                 + "YMD INTEGER,"\r
  22                                 + "HM INTEGER,"\r
  23                                 + "WEEK INTEGER,"\r
  24                                 + "PERIOD INTEGER,"\r
  25                                 + "NUM INTEGER,"\r
  26                                 + "STATUS INTEGER"\r
  27                                 + ");");\r
  28         }\r
  29 \r
  30         @Override\r
  31         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r
  32                 db.execSQL("DROP TABLE IF EXISTS HISTORY");\r
  33         }\r
  34 \r
  35 }\r