Recordedmarkup table
From MythTV Official Wiki
Note: The correct title of this article is recordedmarkup table. It appears incorrectly here due to technical restrictions.
The recordedmarkup table stores bookmarks, edit markup and commercial flagging markup for each recording in the recorded table.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| chanid | int(10) unsigned | PRI | 0 | REFERENCES recorded(chanid,starttime) | |
| starttime | datetime | PRI | 0000-00-00 00:00:00 | ||
| mark | mediumint(8) unsigned | PRI | 0 | unit: framenumber | |
| type | tinyint(4) | PRI | 0 | ||
| data | iny(11) unsigned | NULL | NULL |
Fields
- chanid along with starttime relate to unique entries in the recorded table.
- offset is redundant and remains for backwards compatibility.
- type shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for
typeare defined in theMarkTypesenum. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table instead.
| Value | Field |
|---|---|
| -10 | MARK_UNSET |
| -5 | MARK_TMP_CUT_END |
| -4 | MARK_TMP_CUT_START |
| -3 | MARK_UPDATED_CUT |
| -2 | MARK_PLACEHOLDER |
| 0 | MARK_CUT_END |
| 1 | MARK_CUT_START |
| 2 | MARK_BOOKMARK |
| 3 | MARK_BLANK_FRAME |
| 4 | MARK_COMM_START |
| 5 | MARK_COMM_END |
| 6 | MARK_GOP_START |
| 7 | MARK_KEYFRAME |
| 8 | MARK_SCENE_CHANGE |
| 9 | MARK_GOP_BYFRAME |
| 10 | MARK_ASPECT_1_1 //< deprecated, it is only 1:1 sample aspect ratio |
| 11 | MARK_ASPECT_4_3 |
| 12 | MARK_ASPECT_16_9 |
| 13 | MARK_ASPECT_2_21_1 |
| 14 | MARK_ASPECT_CUSTOM |
| 30 | MARK_VIDEO_WIDTH |
| 31 | MARK_VIDEO_HEIGHT |
| 32 | MARK_VIDEO_RATE |
| 33 | MARK_DURATION_MS |
| 34 | MARK_TOTAL_FRAMES |
| 40 | MARK_UTIL_PROGSTART |
| 41 | MARK_UTIL_LASTPLAYPOS |
