Difference between revisions of "Cardinput table"

From MythTV Official Wiki
Jump to: navigation, search
m (→‎Table Description)
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Wrongtitle|cardinput table}}
 
The '''cardinput table''' contains a row for each input listed in the [[capturecard table]]. It uses the [[videosource table]] as a reference. For example, a [[video capture card]] can have an RF input, an S-Video input and a composite video input.  This table also stores the binding between a [[Video Source]] and an input -- if the RF input is direct analog cable and the S-video input is digital cable through a box, this is where that information will live.
 
The '''cardinput table''' contains a row for each input listed in the [[capturecard table]]. It uses the [[videosource table]] as a reference. For example, a [[video capture card]] can have an RF input, an S-Video input and a composite video input.  This table also stores the binding between a [[Video Source]] and an input -- if the RF input is direct analog cable and the S-video input is digital cable through a box, this is where that information will live.
  
−
{| border=1 style="background:#D6DFE7"
+
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  Field name !! Type        !! Null !! Key !! Default !! Extras !! Schema-Version
 
|-
 
|-
−
! Field || Type || NULL || Default
+
|| cardinputid    || int(10) unsigned ||      || PRI || NULL     || auto_increment
 
|-
 
|-
−
| cardinputid || int(10) || No ||
+
|| cardid          || int(10) unsigned ||      ||    || 0        || REFERENCES [[capturecard table| capturecard]](cardid)
 
|-
 
|-
−
| cardid || int(10) || No || 0
+
|| sourceid        || int(10) unsigned ||      ||     || 0       || REFERENCES [[videosource table|videosource]](sourceid)
 
|-
 
|-
−
| [[sourceid]] || int(10) || No || 0
+
|| inputname      || varchar(32)     ||      ||    ||         ||
 
|-
 
|-
−
| inputname || varchar(32) ||No ||
+
|| externalcommand || varchar(128)     || YES  ||    || NULL    ||
 
|-
 
|-
−
| externalcommand || varchar(128) || Yes || NULL
+
|| <del>preference</del>      || int(11)         ||      ||    || 0        ||
 
|-
 
|-
−
| preference || int(11) || Yes || NULL
+
|| <del>shareable</del>      || char(1)         || YES  ||    || N        || || -1254
 
|-
 
|-
−
| shareable || char(1) || Yes || N
+
|| changer_device  || varchar(128)     || YES ||    || NULL  || || +1282
 
|-
 
|-
−
| tunechan || varchar(5) || No ||
+
|| changer_model  || varchar(128)     || YES ||    || NULL  || || +1282
 
|-
 
|-
−
| startchan || varchar(5) || No ||
+
|| tunechan        || varchar(10)      || YES  ||    || NULL    ||
 +
|-
 +
|| startchan       || varchar(10)      || YES  ||    || NULL    || REFERENCES [[channel table|channel]](channum)
 +
|-
 +
|| <del>freetoaironly</del>  || tinyint(1)      || YES  ||    || 1        || || -1244
 +
|-
 +
|| <del>diseqc_port</del>    || smallint(6)      || YES  ||    || NULL    || || rowspan="5" | →[[diseqc_tree table|diseqc_tree]]
 +
|-
 +
|| <del>diseqc_pos</del>      || float            || YES  ||    || NULL    ||
 +
|-
 +
|| <del>lnb_lof_switch</del>  || int(11)         || YES  ||    || 11700000 ||
 +
|-
 +
|| <del>lnb_lof_hi</del>      || int(11)          || YES  ||    || 10600000 ||
 +
|-
 +
|| <del>lnb_lof_lo</del>      || int(11)          || YES  ||    || 9750000  ||
 +
|-
 +
|| displayname    || varchar(64)      ||      ||    ||          ||
 +
|-
 +
|| <del>radioservices</del>  || tinyint(1)      || YES  ||    || 1        || || -1244
 +
|-
 +
|| <del>childcardid</del>    || int(10)          ||      ||    || 0        ||
 +
|-
 +
|| dishnet_eit    || tinyint(1)      ||      ||    || 0        ||
 +
|-
 +
|| recpriority    || int(11)          ||      ||    || 0        ||
 +
|-
 +
|| quicktune      || tinyint(4)      ||      ||    || 0        ||
 +
|-
 +
|| schedorder      || int(10) unsigned ||      ||    || 0        || || +1293
 +
|-
 +
|| liveorder      || int(10) unsigned ||      ||    || 0        || || +1293
 
|}
 
|}
  
−
EXAMPLE SETUP: DIGITAL CABLE, ATSC QAM_256
+
==Fields==
−
 
+
;cardinputid: is a unique identifier for the entries in the table.
−
mysql> select * from cardinput where cardid = 1;
+
;cardid: maps directly to entries in the [[capturecard table]].
−
 
+
;sourceid: maps directly to entries in the [[videosource table]].
−
| cardinputid | cardid | sourceid | inputname | externalcommand | preference | shareable | tunechan | startchan | freetoaironly | diseqc_port | diseqc_pos | lnb_lof_switch | lnb_lof_hi | lnb_lof_lo | displayname    | radioservices | childcardid | dishnet_eit | recpriority |
+
;inputname: Example values: ''DVBInput'', ''Tuner 1''
−
 
+
;externalcommand:
−
|          1 |      1 |        2 | DVBInput | NULL            |          0 | N        | NULL    | 108      |            0 |        NULL |      NULL |      11700000 |  10600000 |    9750000 | HD3000 Digital |            0 |          0 |          0 |          0 |
+
;changer_device:
−
 
+
;changer_model:
−
Only the 'displayname' field (in this case 'HD3000 Digital') is user supplied freeform text. The 'startchan' is also the last channel tuned on this card. If the card gets set to a channel it cannot actually tune, this field may have to be re-set in Mysql to a usable channel number.
+
;tunechan:
−
 
+
;startchan: contains the last channel tuned on this card.
−
 
+
;displayname: is user supplied free form text.
−
 
+
:*Example values: ''HD3000 Digital''
−
 
+
;dishnet_eit:
−
 
+
;recpriority:
−
 
+
;quicktune:
 +
;schedorder: priority to find the next free input card for scheduled recordings. lower numer=higher priority. 0=do not use.
 +
;livetvorder: priority to find the next free input card for live TV. lower numer=higher priority. 0=do not use.
  
 +
==Tricks==
 +
The following command will re-set the channel number.
 +
Set the startchannel to something which works on your system and select the correct cardinputid for your DVB card.
  
 +
<pre>
 +
mysql -u mythtv -pmythtv mythconverg -e "UPDATE cardinput SET startchan=108 WHERE cardinputid=1;"
 +
</pre>
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 09:41, 16 February 2014

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

The cardinput table contains a row for each input listed in the capturecard table. It uses the videosource table as a reference. For example, a video capture card can have an RF input, an S-Video input and a composite video input. This table also stores the binding between a Video Source and an input -- if the RF input is direct analog cable and the S-video input is digital cable through a box, this is where that information will live.

Table Description

Field name Type Null Key Default Extras Schema-Version
cardinputid int(10) unsigned PRI NULL auto_increment
cardid int(10) unsigned 0 REFERENCES capturecard(cardid)
sourceid int(10) unsigned 0 REFERENCES videosource(sourceid)
inputname varchar(32)
externalcommand varchar(128) YES NULL
preference int(11) 0
shareable char(1) YES N -1254
changer_device varchar(128) YES NULL +1282
changer_model varchar(128) YES NULL +1282
tunechan varchar(10) YES NULL
startchan varchar(10) YES NULL REFERENCES channel(channum)
freetoaironly tinyint(1) YES 1 -1244
diseqc_port smallint(6) YES NULL →diseqc_tree
diseqc_pos float YES NULL
lnb_lof_switch int(11) YES 11700000
lnb_lof_hi int(11) YES 10600000
lnb_lof_lo int(11) YES 9750000
displayname varchar(64)
radioservices tinyint(1) YES 1 -1244
childcardid int(10) 0
dishnet_eit tinyint(1) 0
recpriority int(11) 0
quicktune tinyint(4) 0
schedorder int(10) unsigned 0 +1293
liveorder int(10) unsigned 0 +1293

Fields

cardinputid
is a unique identifier for the entries in the table.
cardid
maps directly to entries in the capturecard table.
sourceid
maps directly to entries in the videosource table.
inputname
Example values: DVBInput, Tuner 1
externalcommand
changer_device
changer_model
tunechan
startchan
contains the last channel tuned on this card.
displayname
is user supplied free form text.
  • Example values: HD3000 Digital
dishnet_eit
recpriority
quicktune
schedorder
priority to find the next free input card for scheduled recordings. lower numer=higher priority. 0=do not use.
livetvorder
priority to find the next free input card for live TV. lower numer=higher priority. 0=do not use.

Tricks

The following command will re-set the channel number. Set the startchannel to something which works on your system and select the correct cardinputid for your DVB card. 

mysql -u mythtv -pmythtv mythconverg -e "UPDATE cardinput SET startchan=108 WHERE cardinputid=1;"
Retrieved from "http://www.mythtv.org/wiki?title=Cardinput_table&oldid=59855"