package com.yeshi.base.entity.db;

import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.provider.BaseColumns;

public class WatchHistoryTable implements BaseColumns {

	public static final String AUTHORITY = "com.weikou.mgvideo.provider.watchhistory";

	public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY
			+ "/" + "watchhistories");
	/**
	 * The MIME type of {@link #CONTENT_URI}.
	 */
	public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.weikou.watchhistory";
	/**
	 * The MIME type of a {@link #CONTENT_URI} sub-directory of a single row.
	 */
	public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.weikou.watchhistory";

	public static final String TABLE_NAME = "WATCH_HISTORY";

	public static final String VIDEO_ID = "_VIDEO_ID";

	public static final String VIDEO_DETAIL_ID = "_VIDEO_DETAIL_ID";

	public static final String VIDEO_THIRD_TYPE = "_VIDEO_THIRD_TYPE";

	public static final String VIDEO_DETAIL = "_VIDEO_DETAIL";

	public static final String VIDEO_RESOURCE = "_VIDEO_RESOURCE";

	public static final String VIDEO_RESOURCE_ID = "_VIDEO_RESOURCE_ID";

	public static final String WATCH_TIME = "_WATCH_TIME";

	public static final String UPDATE_TIME = "_UPDATE_TIME";

	public static final String CREATE_TIME = "_CREATE_TIME";

	public static void createTables(SQLiteDatabase db) {
		db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " ("
				+ WatchHistoryTable._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
				+ WatchHistoryTable.VIDEO_ID + " TEXT,"
				+ WatchHistoryTable.VIDEO_DETAIL_ID + " TEXT,"
				+ WatchHistoryTable.VIDEO_THIRD_TYPE + " TEXT,"
				+ WatchHistoryTable.VIDEO_DETAIL + " TEXT,"
				+ WatchHistoryTable.WATCH_TIME + " INTEGER,"
				+ WatchHistoryTable.UPDATE_TIME + " INTEGER,"
				+ WatchHistoryTable.CREATE_TIME + " INTEGER,"
				+ WatchHistoryTable.VIDEO_RESOURCE + " TEXT,"
				+ WatchHistoryTable.VIDEO_RESOURCE_ID + " TEXT)");
	}
}