Difference between revisions of "Recordedmarkup table"
From MythTV Official Wiki
(Update table description for 0.20) |
m (Mirror the note about marktypes on the recordedseek table page) |
||
| Line 18: | Line 18: | ||
The <code>offset</code> field is redundant and remains for backwards compatibility. | The <code>offset</code> field is redundant and remains for backwards compatibility. | ||
| − | 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] | + | 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] N.B. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the [[recordedseek table]] instead. |
typedef enum { | typedef enum { | ||
Revision as of 12:16, 21 August 2006
The recordedmarkup table stores bookmarks, edit markup and commercial flagging markup for each recording in the recorded table.
| 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 offset field is redundant and remains for backwards compatibility.
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 N.B. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table instead.
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;
