Recordedmarkup table

From MythTV Official Wiki
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 REFERENCES recorded(chanid,starttime)
starttime datetime PRI 0000-00-00 00:00:00
mark mediumint(8) unsigned PRI 0 unit: framenumber
type tinyint(4) PRI 0
data iny(11) unsigned NULL NULL

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