Difference between revisions of "Dtv privatetypes table"

From MythTV Official Wiki
Jump to: navigation, search
 
m (Corrected wrongtitle)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
<TABLE border=1>
+
{{Wrongtitle|dtv_privatetypes table}}
−
  <TR bgColor=#9999ff>
+
== Table Description ==
−
    <TD><B>Field name</B></TD>
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
−
     <TD><B>Type</B></TD>
+
|- style="background: lightsteelblue"
−
    <TD><B>Allow nulls?</B></TD>
+
!  Field name    !! Type             !! Null !! Key !! Default             !! Extras
−
    <TD><B>Key</B></TD>
+
|-
−
    <TD><B>Default value</B></TD>
+
|| sitype       || varchar(4)   ||      ||     ||        ||
−
    <TD><B>Extras</B></TD></TR>
+
|-
−
  <TR bgColor=#cccccc>
+
|| networkid     || int(11)      ||      ||     || 0      ||
−
    <TD>sitype</TD>
+
|-
−
    <TD>varchar(4)</TD>
+
|| private_type  || varchar(20)  ||      ||     ||        ||
−
     <TD>No</TD>
+
|-
−
    <TD>None</TD>
+
|| private_value || varchar(100) ||      ||    ||        ||
−
     <TD>&nbsp;</TD>
+
|-
−
     <TD>&nbsp;</TD></TR>
+
|}
−
  <TR bgColor=#cccccc>
+
 
−
     <TD>networkid</TD>
+
== Example Entries ==
−
    <TD>int(11)</TD>
+
<pre>
−
    <TD>No</TD>
+
      sitype: dvb
−
    <TD>None</TD>
+
     networkid: 40999
−
    <TD>0&nbsp;</TD>
+
private_type: parse_subtitle_list
−
    <TD>&nbsp;</TD></TR>
+
private_value: 1070,1308,1041,1306,1307,1030,1016,1131,1068,1069
−
  <TR bgColor=#cccccc>
+
</pre>
−
     <TD>private_type</TD>
+
<pre>
−
    <TD>varchar(20)</TD>
+
      sitype: atsc
−
    <TD>No</TD>
+
     networkid: 1793
−
    <TD>None</TD>
+
private_type: guide_fixup
−
    <TD>&nbsp;</TD>
+
private_value: 3
−
     <TD>&nbsp;</TD></TR>
+
</pre>
−
  <TR bgColor=#cccccc>
+
<pre>
−
    <TD>private_value</TD>
+
      sitype: dvb
−
    <TD>varchar(100)</TD>
+
     networkid: 70
−
     <TD>No</TD>
+
private_type: force_guide_present
−
    <TD>None</TD>
+
private_value: yes
−
    <TD>&nbsp;</TD>
+
</pre>
−
    <TD>&nbsp;</TD></TR></TABLE>
+
 
 +
{{stub}}
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 15:43, 15 April 2007

Important.png Note: The correct title of this article is dtv_privatetypes table. It appears incorrectly here due to technical restrictions.

Table Description

Field name Type Null Key Default Extras
sitype varchar(4)
networkid int(11) 0
private_type varchar(20)
private_value varchar(100)

Example Entries

       sitype: dvb
    networkid: 40999
 private_type: parse_subtitle_list
private_value: 1070,1308,1041,1306,1307,1030,1016,1131,1068,1069 

       sitype: atsc
    networkid: 1793
 private_type: guide_fixup
private_value: 3

       sitype: dvb
    networkid: 70
 private_type: force_guide_present
private_value: yes
This article is a stub. You can help by expanding it.
Retrieved from "http://www.mythtv.org/wiki?title=Dtv_privatetypes_table&oldid=22153"