Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- final String CREATE_VIEW = "CREATE VIEW " + VideoEntry.VIEW_NAME + " ( " +
- VideoEntry.COLUMN_RECTYPE + " , " +
- VideoEntry.COLUMN_TITLE + " , " +
- VideoEntry.COLUMN_SUBTITLE + " , " +
- VideoEntry.COLUMN_VIDEO_URL + " , " +
- VideoEntry.COLUMN_FILENAME + " , " +
- VideoEntry.COLUMN_HOSTNAME + " , " +
- VideoEntry.COLUMN_DESC + " , " +
- VideoEntry.COLUMN_BG_IMAGE_URL + " , " +
- VideoEntry.COLUMN_CHANNEL + " , " +
- VideoEntry.COLUMN_CARD_IMG + " , " +
- VideoEntry.COLUMN_CONTENT_TYPE + " , " +
- VideoEntry.COLUMN_PRODUCTION_YEAR + " , " +
- VideoEntry.COLUMN_DURATION + " , " +
- VideoEntry.COLUMN_ACTION + " , " +
- VideoEntry.COLUMN_AIRDATE + " ," +
- VideoEntry.COLUMN_STARTTIME + " ," +
- VideoEntry.COLUMN_ENDTIME + " ," +
- VideoEntry.COLUMN_RECORDEDID + " ," +
- VideoEntry.COLUMN_STORAGEGROUP + " ," +
- VideoEntry.COLUMN_RECGROUP + " ," +
- VideoEntry.COLUMN_SEASON + " ," +
- VideoEntry.COLUMN_EPISODE + " ," +
- VideoEntry.COLUMN_PROGFLAGS + " ," +
- VideoEntry.COLUMN_CHANID + " ," +
- VideoEntry.COLUMN_CHANNUM + " ," +
- VideoEntry.COLUMN_CALLSIGN + " , " +
- StatusEntry.COLUMN_LAST_USED + " ) AS SELECT " +
- VideoEntry.COLUMN_RECTYPE + " , " +
- VideoEntry.COLUMN_TITLE + " , " +
- VideoEntry.COLUMN_SUBTITLE + " , " +
- VideoEntry.COLUMN_VIDEO_URL + " , " +
- VideoEntry.COLUMN_FILENAME + " , " +
- VideoEntry.COLUMN_HOSTNAME + " , " +
- VideoEntry.COLUMN_DESC + " , " +
- VideoEntry.COLUMN_BG_IMAGE_URL + " , " +
- VideoEntry.COLUMN_CHANNEL + " , " +
- VideoEntry.COLUMN_CARD_IMG + " , " +
- VideoEntry.COLUMN_CONTENT_TYPE + " , " +
- VideoEntry.COLUMN_PRODUCTION_YEAR + " , " +
- VideoEntry.COLUMN_DURATION + " , " +
- VideoEntry.COLUMN_ACTION + " , " +
- VideoEntry.COLUMN_AIRDATE + " ," +
- VideoEntry.COLUMN_STARTTIME + " ," +
- VideoEntry.COLUMN_ENDTIME + " ," +
- VideoEntry.COLUMN_RECORDEDID + " ," +
- VideoEntry.COLUMN_STORAGEGROUP + " ," +
- VideoEntry.COLUMN_RECGROUP + " ," +
- VideoEntry.COLUMN_SEASON + " ," +
- VideoEntry.COLUMN_EPISODE + " ," +
- VideoEntry.COLUMN_PROGFLAGS + " ," +
- VideoEntry.COLUMN_CHANID + " ," +
- VideoEntry.COLUMN_CHANNUM + " ," +
- VideoEntry.COLUMN_CALLSIGN + " , " +
- StatusEntry.COLUMN_LAST_USED + " FROM " +
- VideoEntry.TABLE_NAME + " LEFT OUTER JOIN " +
- StatusEntry.TABLE_NAME + " USING ( " +
- VideoEntry.COLUMN_VIDEO_URL + " ); ";
- db.execSQL(CREATE_VIEW);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement