Difference between revisions of "Recordedseek table"

From MythTV Official Wiki
Jump to: navigation, search
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="4"
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
|- bgcolor="#9999ff"
+
|- style="background: lightsteelblue"
! Field     !! Type             !! Null !! Key !! Default
+
! Field name !! Type                 !! Null !! Key !! Default             !! Extras
|- bgcolor="#cccccc"
+
|-
 
| chanid    || int(10) unsigned ||      || PRI || 0
 
| chanid    || int(10) unsigned ||      || PRI || 0
|- bgcolor="#cccccc"
+
|-
 
| starttime || datetime        ||      || PRI || 0000-00-00 00:00:00
 
| starttime || datetime        ||      || PRI || 0000-00-00 00:00:00
|- bgcolor="#cccccc"
+
|-
 
| mark      || bigint(20)      ||      || PRI || 0
 
| mark      || bigint(20)      ||      || PRI || 0
|- bgcolor="#cccccc"
+
|-
 
| offset    || varchar(32)      || YES  ||    || NULL
 
| offset    || varchar(32)      || YES  ||    || NULL
|- bgcolor="#cccccc"
+
|-
 
| type      || int(11)          ||      || PRI || 0
 
| type      || int(11)          ||      || PRI || 0
 
|-
 
|-
 
|}
 
|}
  
The <code>type</code> field shows what kind of marker it is, such as a keyframe. 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]  
+
== Fields ==
'''N.B.''' Not all of the following marktypes apply to the recordedseek table, they may be used in the [[recordedmarkup table]] instead.
+
*'''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
 +
 
  
typedef enum {
+
{{stub}}
    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 22:02, 14 March 2007

Important.png 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 MarkTypes 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