Difference between revisions of "Recordedseek table"

From MythTV Official Wiki
Jump to: navigation, search
(Same add new MAKR_UTIL_)
(6 intermediate revisions by 4 users not shown)
Line 4: Line 4:
 
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 
|- style="background: lightsteelblue"
 
|- style="background: lightsteelblue"
! Field name !! Type                  !! Null !! Key !! Default            !! Extras
+
! Field name !! Type                  !! Null !! Key !! Default            !! Extras
 
|-
 
|-
| chanid   || int(10) unsigned ||      || PRI || 0
+
| chanid     || int(10) unsigned     ||      || PRI || 0                   || rowspan="2" |REFERENCES [[recorded table|recorded]](chanid,starttime)
 
|-
 
|-
| starttime || datetime         ||      || PRI || 0000-00-00 00:00:00
+
| starttime || datetime             ||      || PRI || 0000-00-00 00:00:00
 
|-
 
|-
| mark     || bigint(20)       ||      || PRI || 0
+
| mark       || mediumint(8) unsigned ||      || PRI || 0
 
|-
 
|-
| offset   || varchar(32)     || YES  ||    || NULL
+
| offset     || bigint(20) unsigned  ||     ||    || NULL
 
|-
 
|-
| type     || int(11)         ||      || PRI || 0
+
| type       || tinyint(4)           ||      || PRI || 0
 
|-
 
|-
 
|}
 
|}
Line 20: Line 20:
 
== Fields ==
 
== Fields ==
 
*'''chanid''' along with '''starttime''' relate to unique entries in the [[recorded table]].
 
*'''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.
+
*'''type''' shows what kind of marker it is, such as a keyframe. Possible values are defined in the [[https://code.mythtv.org/doxygen/programtypes_8h_source.html#l00050
**''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
+
<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''' 0-based frame number
 +
*'''offset''' 0-based offset into file
 +
 
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5; text-align:center"
 +
|- style="background: lightsteelblue"
 +
! '''Value''' !! '''Field'''  
 +
|-
 +
|-100 || MARK_ALL 
 +
|-
 +
| -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
 +
|-
 +
|}
  
  

Revision as of 06:55, 5 April 2018

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 REFERENCES recorded(chanid,starttime)
starttime datetime PRI 0000-00-00 00:00:00
mark mediumint(8) unsigned PRI 0
offset bigint(20) unsigned NULL
type tinyint(4) PRI 0

Fields

MarkTypes enum]. Not all of the following marktypes apply to the recordedseek table, they may be used in the recordedmarkup table instead.
  • mark 0-based frame number
  • offset 0-based offset into file
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