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;
