Difference between revisions of "Cardinput table"
m (→Fields) |
|||
| Line 55: | Line 55: | ||
*'''inputname''' | *'''inputname''' | ||
** Example values: ''DVBInput'', ''Tuner 1'' | ** Example values: ''DVBInput'', ''Tuner 1'' | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*'''startchan''' contains the last channel tuned on this card. | *'''startchan''' contains the last channel tuned on this card. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*'''displayname''' is user supplied free form text. | *'''displayname''' is user supplied free form text. | ||
**Example values: ''HD3000 Digital'' | **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. | 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. | ||
Revision as of 05:36, 12 March 2007
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
