Difference between revisions of "Recordedseek table"
From MythTV Official Wiki
m (table style) |
|||
| Line 1: | Line 1: | ||
| + | {{Wrongtitle|recordedseek table}} | ||
The '''recordedseek table''' stores a time vs. byte offset mapping (seektable) for each recording in the [[recorded table]] to enable accurate forward and backward time skipping. | The '''recordedseek table''' stores a time vs. byte offset mapping (seektable) for each recording in the [[recorded table]] to enable accurate forward and backward time skipping. | ||
| − | + | == Table Description == | |
| − | {| cellpadding=" | + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" |
| − | |- | + | |- style="background: lightsteelblue" |
| − | ! Field | + | ! Field name !! Type !! Null !! Key !! Default !! Extras |
| − | |- | + | |- |
| chanid || int(10) unsigned || || PRI || 0 | | chanid || int(10) unsigned || || PRI || 0 | ||
| − | |- | + | |- |
| starttime || datetime || || PRI || 0000-00-00 00:00:00 | | starttime || datetime || || PRI || 0000-00-00 00:00:00 | ||
| − | |- | + | |- |
| mark || bigint(20) || || PRI || 0 | | mark || bigint(20) || || PRI || 0 | ||
| − | |- | + | |- |
| offset || varchar(32) || YES || || NULL | | offset || varchar(32) || YES || || NULL | ||
| − | |- | + | |- |
| type || int(11) || || PRI || 0 | | type || int(11) || || PRI || 0 | ||
|- | |- | ||
|} | |} | ||
| − | + | == Fields == | |
| − | + | *'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]]. | |
| + | *'''type''' shows what kind of marker it is, such as a keyframe. Possible values are defined in the [http://www.cuymedia.net/doxygen-dev-docs/html/programinfo_8h.html#a59 <code>MarkTypes</code> enum]. Not all of the following marktypes apply to the recordedseek table, they may be used in the [[recordedmarkup table]] instead. | ||
| + | **''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 | ||
| + | |||
| − | + | {{stub}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category:DB Table]] | [[Category:DB Table]] | ||
Revision as of 22:02, 14 March 2007
Note: The correct title of this article is recordedseek table. It appears incorrectly here due to technical restrictions.
The recordedseek table stores a time vs. byte offset mapping (seektable) for each recording in the recorded table to enable accurate forward and backward time skipping.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| chanid | int(10) unsigned | PRI | 0 | ||
| starttime | datetime | PRI | 0000-00-00 00:00:00 | ||
| mark | bigint(20) | PRI | 0 | ||
| offset | varchar(32) | YES | NULL | ||
| type | int(11) | PRI | 0 |
Fields
- chanid along with starttime relate to unique entries in the recorded table.
- type shows what kind of marker it is, such as a keyframe. Possible values are defined in the
MarkTypesenum. Not all of the following marktypes apply to the recordedseek table, they may be used in the recordedmarkup table instead.- 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
