Difference between revisions of "Recordedmarkup table"
From MythTV Official Wiki
m (Mirror the note about marktypes on the recordedseek table page) |
m (table style) |
||
| Line 1: | Line 1: | ||
The '''recordedmarkup table''' stores bookmarks, edit markup and commercial flagging markup for each recording in the [[recorded table]]. | The '''recordedmarkup table''' stores bookmarks, edit markup and commercial flagging markup for each recording in the [[recorded table]]. | ||
| − | {| | + | {| cellpadding="4" |
| + | |- bgcolor="#9999ff" | ||
| + | ! Field !! Type !! Null !! Key !! Default | ||
| + | |- bgcolor="#cccccc" | ||
| + | | chanid || int(10) unsigned || || PRI || 0 | ||
| + | |- bgcolor="#cccccc" | ||
| + | | starttime || datetime || || PRI || 0000-00-00 00:00:00 | ||
| + | |- bgcolor="#cccccc" | ||
| + | | mark || bigint(20) || || PRI || 0 | ||
| + | |- bgcolor="#cccccc" | ||
| + | | offset || varchar(32) || || || NULL | ||
| + | |- bgcolor="#cccccc" | ||
| + | | type || int(11) || || PRI || 0 | ||
|- | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Revision as of 19:35, 3 March 2007
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 | PRI | 0 | |
| starttime | datetime | PRI | 0000-00-00 00:00:00 | |
| mark | bigint(20) | PRI | 0 | |
| offset | varchar(32) | NULL | ||
| type | int(11) | 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;
