Difference between revisions of "Cardinput table"

From MythTV Official Wiki
Jump to: navigation, search
m (more grammer)
(Mark table unused beginning with 0.28)
 
(15 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
= table cardinput =
+
{{Note box|As of 0.28, this table is no longer used.}}
 +
{{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.
  
−
This table contains one row for each input. For example, a [[Tuner 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 ==
−
 
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
−
{| border=1 style="background:#D6DFE7"
+
|- style="background: lightsteelblue"
 +
!  Field name !! Type        !! Null !! Key !! Default !! Extras !! Schema-Version
 +
|-
 +
|| cardinputid    || int(10) unsigned ||      || PRI || NULL    || auto_increment
 +
|-
 +
|| cardid          || int(10) unsigned ||      ||    || 0        || REFERENCES [[capturecard table| capturecard]](cardid)
 +
|-
 +
|| sourceid        || int(10) unsigned ||      ||    || 0        || REFERENCES [[videosource table|videosource]](sourceid)
 +
|-
 +
|| inputname      || varchar(32)      ||      ||    ||          ||
 +
|-
 +
|| externalcommand || varchar(128)    || YES  ||    || NULL    ||
 +
|-
 +
|| <del>preference</del>      || int(11)          ||      ||    || 0        ||
 +
|-
 +
|| <del>shareable</del>      || 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 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 ||
 
|-
 
|-
−
! Field || Type || NULL || Default
+
|| <del>lnb_lof_hi</del>      || int(11)          || YES  ||    || 10600000 ||
 
|-
 
|-
−
| cardinputid || int(10) || No ||
+
|| <del>lnb_lof_lo</del>      || int(11)         || YES  ||    || 9750000  ||
 
|-
 
|-
−
| cardid || int(10) || No || 0
+
|| displayname    || varchar(64)     ||      ||    ||         ||
 
|-
 
|-
−
| [[sourceid]] || int(10) || No || 0
+
|| <del>radioservices</del>  || tinyint(1)       || YES  ||    || 1        || || -1244
 
|-
 
|-
−
| inputname || varchar(32) ||No ||
+
|| <del>childcardid</del>    || int(10)         ||      ||    || 0        ||
 
|-
 
|-
−
| externalcommand || varchar(128) || Yes || NULL
+
|| dishnet_eit    || tinyint(1)       ||      ||    || 0        ||
 
|-
 
|-
−
| preference || int(11) || Yes || NULL
+
|| recpriority    || int(11)         ||      ||    || 0        ||
 
|-
 
|-
−
| shareable || char(1) || Yes || N
+
|| quicktune      || tinyint(4)       ||      ||    || 0        ||
 
|-
 
|-
−
| tunechan || varchar(5) || No ||
+
|| schedorder      || int(10) unsigned ||      ||    || 0        || || +1293
 
|-
 
|-
−
| startchan || varchar(5) || No ||
+
|| 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.
 +
 +
<pre>
 +
mysql -u mythtv -pmythtv mythconverg -e "UPDATE cardinput SET startchan=108 WHERE cardinputid=1;"
 +
</pre>
 +
 +
[[Category:DB Table]]

Latest revision as of 18:47, 30 April 2016

Important.png Note: As of 0.28, this table is no longer used.

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=63643"