HistoryDB.java

/*
   Quick Connect History Database
 
   Copyright 2013 Thincast Technologies GmbH, Author: Martin Fleisz
 
   This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
   If a copy of the MPL was not distributed with this file, You can obtain one at
   http://mozilla.org/MPL/2.0/.
*/
 
package com.freerdp.freerdpcore.services;
 
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
public class HistoryDB extends SQLiteOpenHelper
{
 
  public static final String QUICK_CONNECT_TABLE_NAME = "quick_connect_history";
  public static final String QUICK_CONNECT_TABLE_COL_ITEM = "item";
  public static final String QUICK_CONNECT_TABLE_COL_TIMESTAMP = "timestamp";
  private static final int DB_VERSION = 1;
  private static final String DB_NAME = "history.db";
 
  public HistoryDB(Context context)
  {
    super(context, DB_NAME, null, DB_VERSION);
  }
 
  @Override public void onCreate(SQLiteDatabase db)
  {
 
    String sqlQuickConnectHistory = "CREATE TABLE " + QUICK_CONNECT_TABLE_NAME + " (" +
                                    QUICK_CONNECT_TABLE_COL_ITEM + " TEXT PRIMARY KEY, " +
                                    QUICK_CONNECT_TABLE_COL_TIMESTAMP + " INTEGER"
                                    + ");";
 
    db.execSQL(sqlQuickConnectHistory);
  }
 
  @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  {
    // TODO Auto-generated method stub
  }
}
public class HistoryDB extends SQLiteOpenHelper {…};