Difference between revisions of "Recordedmarkup table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
(show table, add info about different mark types)
Line 1: Line 1:
 
The '''recordedmarkup table''' stores a time vs. byte offset mapping for each recording in the [[recorded table]] to enable accurate forward and backward time skipping.
 
The '''recordedmarkup table''' stores a time vs. byte offset mapping for each recording in the [[recorded table]] to enable accurate forward and backward time skipping.
 +
 +
{| border=1 style="background:#D6DFE7"
 +
|-
 +
! Field || Type || Null || Key || Default
 +
|-
 +
! chanid || int(10) unsigned || NO || PRI || 0
 +
|-
 +
! starttime || datetime || NO || PRI || 0000-00-00 00:00:00
 +
|-
 +
! mark || bigint(20) || NO || PRI || 0
 +
|-
 +
! offset || varchar(32) || YES || || NULL
 +
|-
 +
! type || int(11) || NO || PRI || 0
 +
|}
 +
 +
The <code>type</code> field shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for <code>type</code> are defined in the [http://www.cuymedia.net/doxygen-dev-docs/html/programinfo_8h.html#a59 <code>MarkTypes</code> enum]
 +
 +
typedef enum {
 +
    MARK_UNSET = -10,
 +
    MARK_UPDATED_CUT = -3,
 +
    MARK_EDIT_MODE = -2,
 +
    MARK_CUT_END = 0,
 +
    MARK_CUT_START = 1,
 +
    MARK_BOOKMARK = 2,
 +
    MARK_BLANK_FRAME = 3,
 +
    MARK_COMM_START = 4,
 +
    MARK_COMM_END = 5,
 +
    MARK_GOP_START = 6,
 +
    MARK_KEYFRAME = 7,
 +
    MARK_SCENE_CHANGE = 8,
 +
    MARK_GOP_BYFRAME = 9
 +
} MarkTypes;
 +
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 10:01, 4 March 2006

The recordedmarkup table stores a time vs. byte offset mapping for each recording in the recorded table to enable accurate forward and backward time skipping.

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

The type field 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

typedef enum {
   MARK_UNSET = -10,
   MARK_UPDATED_CUT = -3,
   MARK_EDIT_MODE = -2,
   MARK_CUT_END = 0,
   MARK_CUT_START = 1,
   MARK_BOOKMARK = 2,
   MARK_BLANK_FRAME = 3,
   MARK_COMM_START = 4,
   MARK_COMM_END = 5,
   MARK_GOP_START = 6,
   MARK_KEYFRAME = 7,
   MARK_SCENE_CHANGE = 8,
   MARK_GOP_BYFRAME = 9
} MarkTypes;