Difference between revisions of "Cardinput table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
Line 23: Line 23:
 
| startchan || varchar(5) || No ||
 
| startchan || varchar(5) || No ||
 
|}
 
|}
 +
 +
EXAMPLE SETUP: DIGITAL CABLE, ATSC QAM_256
 +
 +
mysql> select * from cardinput where cardid = 1;
 +
 +
| 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 |
 +
 +
|          1 |      1 |        2 | DVBInput  | NULL            |          0 | N        | NULL    | 108      |            0 |        NULL |      NULL |      11700000 |  10600000 |    9750000 | HD3000 Digital |            0 |          0 |          0 |          0 |
 +
 +
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.
 +
 +
 +
 +
 +
 +
 +
 +
 +
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 02:11, 2 January 2007

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.

Field Type NULL Default
cardinputid int(10) No
cardid int(10) No 0
sourceid int(10) No 0
inputname varchar(32) No
externalcommand varchar(128) Yes NULL
preference int(11) Yes NULL
shareable char(1) Yes N
tunechan varchar(5) No
startchan varchar(5) No

EXAMPLE SETUP: DIGITAL CABLE, ATSC QAM_256

mysql> select * from cardinput where cardid = 1;

| 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 |

| 1 | 1 | 2 | DVBInput | NULL | 0 | N | NULL | 108 | 0 | NULL | NULL | 11700000 | 10600000 | 9750000 | HD3000 Digital | 0 | 0 | 0 | 0 |

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.