Recordedmarkup table

From MythTV Official Wiki
Revision as of 01:19, 20 September 2012 by Llib (Talk | contribs)

Jump to: navigation, search

Important.png Note: The correct title of this article is recordedmarkup table. It appears incorrectly here due to technical restrictions.

The recordedmarkup table stores bookmarks, edit markup and commercial flagging markup for each recording in the recorded table.

Table Description

Field name Type Null Key Default Extras
chanid int(10) unsigned PRI 0
starttime datetime PRI 0000-00-00 00:00:00
mark bigint(20) PRI 0 unit: framenumber
offset varchar(32) NULL
type int(11) PRI 0

Fields

  • chanid along with starttime relate to unique entries in the recorded table.
  • offset is redundant and remains for backwards compatibility.
  • type shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for type are defined in the MarkTypes enum. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table instead.
Value Field
-10 MARK_UNSET
-5 MARK_TMP_CUT_END
-4 MARK_TMP_CUT_START
-3 MARK_UPDATED_CUT
-2 MARK_PLACEHOLDER
0 MARK_CUT_END
1 MARK_CUT_START
2 MARK_BOOKMARK
3 MARK_BLANK_FRAME
4 MARK_COMM_START
5 MARK_COMM_END
6 MARK_GOP_START
7 MARK_KEYFRAME
8 MARK_SCENE_CHANGE
9 MARK_GOP_BYFRAME
10 MARK_ASPECT_1_1 //< deprecated, it is only 1:1 sample aspect ratio
11 MARK_ASPECT_4_3
12 MARK_ASPECT_16_9
13 MARK_ASPECT_2_21_1
14 MARK_ASPECT_CUSTOM
30 MARK_VIDEO_WIDTH
31 MARK_VIDEO_HEIGHT
32 MARK_VIDEO_RATE
33 MARK_DURATION_MS
34 MARK_TOTAL_FRAMES