Difference between revisions of "Recordedmarkup table"
From MythTV Official Wiki
Goldfishbot (talk | contribs) (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;