Cardinput table

From MythTV Official Wiki
Revision as of 05:36, 12 March 2007 by Malban (Talk | contribs)

Jump to: navigation, search

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
cardinputid int(10) unsigned PRI NULL auto_increment
cardid int(10) unsigned 0
sourceid int(10) unsigned 0
inputname varchar(32)
externalcommand varchar(128) YES NULL
preference int(11) 0
shareable char(1) YES N
tunechan varchar(10) YES NULL
startchan varchar(10) YES NULL
freetoaironly tinyint(1) YES 1
diseqc_port smallint(6) YES NULL
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
childcardid int(10) 0
dishnet_eit tinyint(1) 0
recpriority int(11) 0

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
  • startchan contains the last channel tuned on this card.
  • displayname is user supplied free form text.
    • Example values: HD3000 Digital

The following will work as a command script to re-set the channel number. It's not pretty, but I cannot remember how to pipe command line input into mysql (which is possible but tricky). Remember to chmod to make it executable. Set the startchannel to something which works on your system and select the correct cardinputid for your DVB card.

#!/bin/bash
echo 'update cardinput set startchan = '108' where cardinputid = 1;' > /var/tmp/startchan-fix
mysql -u mythtv -pmythtv mythconverg < /var/tmp/startchan-fix