package com.weikou.beibeivideo.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.yeshi.ddysvideo.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)");
|
}
|
}
|
