/*

   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

	}

}