Difference between revisions of "Capturecard table"

From MythTV Official Wiki
Jump to: navigation, search
m
Line 2: Line 2:
 
Contains an entry for each [[video capture card]] installed in master and slave [[backend]]s across the system.
 
Contains an entry for each [[video capture card]] installed in master and slave [[backend]]s across the system.
  
−
You can manually alter this table as long as you restart all [[backend]]s afterwards.
+
You can manually alter this table as long as you restart all [[backend]]s afterwards
−
 
+
==Table Description==
−
{| cellpadding="4"
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
−
|- bgcolor="#9999ff"
+
|- style="background: lightsteelblue"
−
!  Field                     !! Type         !! NULL !! Default
+
!  Field name                !! Type             !! Null !! Key !! Default   !! Extras
−
|- bgcolor="#cccccc"
+
|-
−
|| '''[[cardid]] '''        || int(10)      ||     ||
+
|| cardid                   || int(10) unsigned ||     || PRI || NULL      || auto_increment
−
|- bgcolor="#cccccc"
+
|-
−
|| '''[[videodevice]]'''    || varchar(128) || YES  || NULL
+
|| videodevice               || varchar(128)     || YES  ||    || NULL       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[audiodevice]]          || varchar(128) || YES  || NULL
+
|| audiodevice               || varchar(128)     || YES  ||    || NULL       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[vbidevice]]            || varchar(128) || YES  || NULL
+
|| vbidevice                 || varchar(128)     || YES  ||    || NULL       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[cardtype]]              || varchar(32) || YES  || V4L
+
|| cardtype                 || varchar(32)     || YES  ||    || V4L       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[defaultinput]]          || varchar(32) || YES  || Television
+
|| defaultinput             || varchar(32)     || YES  ||    || Television ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[audioratelimit]]        || int(11)     || YES  || NULL
+
|| audioratelimit           || int(11)         || YES  ||    || NULL       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[hostname]]              || varchar(255) || YES  || NULL
+
|| hostname                 || varchar(255)     || YES  ||    || NULL       ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_swfilter]]         || int(11)      || YES  || 0
+
|| dvb_swfilter             || int(11)          || YES  ||    || 0          ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_recordts]]         || int(11)      || YES  || 0
+
|| dvb_sat_type              || int(11)          ||      ||    || 0         ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_sat_type]]         || int(11)      ||      || 0
+
|| dvb_wait_for_seqstart    || int(11)         ||     ||    || 1          ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_wait_for_seqstart]] || int(11)      ||      || 1
+
|| skipbtaudio              || tinyint(1)      || YES  ||    || 0         ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_dmx_buf_size]]     || int(11)      ||      || 8192
+
|| dvb_on_demand            || tinyint(4)      ||      ||    || 0         ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_pkt_buf_size]]     || int(11)      ||      || 8192
+
|| dvb_diseqc_type          || smallint(6)      || YES  ||    || NULL      ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[skipbtaudio]]          || tinyint(1)   || YES  || 0
+
|| firewire_port            || int(10) unsigned ||      ||    || 0         ||
−
|- bgcolor="#cccccc"
+
|-
−
|| [[dvb_on_demand]]        || tinyint(4)   ||      || 0
+
|| firewire_node            || int(10) unsigned ||      ||    || 2         ||
 +
|-
 +
|| firewire_speed            || int(10) unsigned ||     ||     || 0          ||
 +
|-
 +
|| firewire_model            || varchar(32)     || YES  ||    || NULL      ||
 +
|-
 +
|| firewire_connection      || int(10) unsigned ||      ||    || 0         ||
 +
|-
 +
|| dbox2_port                || int(10) unsigned ||      ||    || 31338      ||
 +
|-
 +
|| dbox2_httpport            || int(10) unsigned ||     ||     || 80        ||
 +
|-
 +
|| dbox2_host                || varchar(32)     || YES  ||    || NULL      ||
 +
|-
 +
|| signal_timeout            || int(11)          ||     ||    || 1000      ||
 +
|-
 +
|| channel_timeout          || int(11)         ||     ||    || 3000      ||
 +
|-
 +
|| parentid                  || int(10)          ||      ||     || 0          ||
 +
|-
 +
|| dvb_tuning_delay          || int(10) unsigned ||     ||    || 0          ||
 +
|-
 +
|| contrast                  || int(11)         ||     ||    || 0          ||
 +
|-
 +
|| brightness                || int(11)          ||      ||     || 0          ||
 +
|-
 +
|| colour                    || int(11)         ||     ||    || 0         ||
 +
|-
 +
|| hue                      || int(11)         ||      ||    || 0         ||
 +
|-
 +
|| diseqcid                  || int(10) unsigned || YES  ||    || NULL      ||
 
|-
 
|-
 
|}
 
|}
  
−
EXAMPLE SETUP: DIGITAL CABLE, ATSC QAM_256
+
==Example Entries==
−
 
+
A [[Hauppauge PVR-350]] card:
−
The following is a Mysql record entry for a DVB card (an HD3000) receiving QAM_256 encoded ATSC by cable (North America).
+
<pre>
−
 
+
              cardid: 1
−
mysql> select * from capturecard where cardid = 1;                                                                                                                                                        | cardid | videodevice | audiodevice | vbidevice | cardtype | defaultinput | audioratelimit | hostname | dvb_swfilter | dvb_recordts | dvb_sat_type | dvb_wait_for_seqstart | skipbtaudio | dvb_on_demand | dvb_diseqc_type | firewire_port | firewire_node | firewire_speed | firewire_model | firewire_connection | dvb_hw_decoder | dbox2_port | dbox2_httpport | dbox2_host | signal_timeout | channel_timeout | parentid | dvb_tuning_delay | contrast | brightness | colour | hue | diseqcid |                                                                                                                        
+
          videodevice: /dev/video0
−
 
+
          audiodevice: NULL
−
|      1 | 0          | NULL       | NULL     | DVB     | DVBInput     |          NULL | localhost   |            0 |            1 |            0 |                        1 |           0 |            1 |            NULL |            0 |            2 |              0 | NULL           |                  0 |              0 |      31338 |            80 | NULL      |          2000 |          10000 |        0 |                0 |        0 |          0 |      0 |  0 |        0 |   
+
            vbidevice: NULL
−
 
+
            cardtype: MPEG
−
 
+
        defaultinput: Tuner 1
−
(a/o CVS 204-05-16)
+
      audioratelimit: NULL
 +
            hostname: localhost.localdomain
 +
        dvb_swfilter: 0
 +
        dvb_sat_type: 0
 +
dvb_wait_for_seqstart: 1
 +
          skipbtaudio: 0
 +
        dvb_on_demand: 0
 +
      dvb_diseqc_type: NULL
 +
        firewire_port: 0
 +
        firewire_node: 2
 +
      firewire_speed: 0
 +
      firewire_model: NULL
 +
  firewire_connection: 0
 +
          dbox2_port: 31338
 +
      dbox2_httpport: 80
 +
          dbox2_host: NULL
 +
      signal_timeout: 1000
 +
      channel_timeout: 3000
 +
            parentid: 0
 +
    dvb_tuning_delay: 0
 +
            contrast: 0
 +
          brightness: 0
 +
              colour: 0
 +
                  hue: 0
 +
            diseqcid: NULL
 +
</pre>
 +
A DVB card (an [[pcHDTV HD-3000|HD3000]]) receiving QAM_256 encoded [[ATSC]] by cable (North America):
 +
<pre>
 +
              cardid: 1
 +
          videodevice: 0
 +
           audiodevice: NULL
 +
            vbidevice: NULL
 +
            cardtype: DVB
 +
        defaultinput: DVBInput
 +
      audioratelimit: NULL
 +
            hostname: localhost
 +
        dvb_swfilter: 0
 +
        dvb_recordts: 1
 +
        dvb_sat_type: 0
 +
dvb_wait_for_seqstart: 1
 +
           skipbtaudio: 0
 +
        dvb_on_demand: 1
 +
      dvb_diseqc_type: NULL
 +
        firewire_port: 0
 +
        firewire_node: 2
 +
      firewire_speed: 0
 +
      firewire_model: NULL
 +
  firewire_connection: 0
 +
      dvb_hw_decoder: 0
 +
          dbox2_port: 31338
 +
      dbox2_httpport: 80  
 +
          dbox2_host: NULL
 +
      signal_timeout: 2000
 +
       channel_timeout: 10000
 +
            parentid: 0
 +
    dvb_tuning_delay: 0
 +
            contrast: 0
 +
          brightness: 0
 +
              colour: 0
 +
                  hue: 0
 +
            diseqcid: 0                                                                                                                        
 +
</pre>
  
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 06:16, 12 March 2007

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

Contains an entry for each video capture card installed in master and slave backends across the system.

You can manually alter this table as long as you restart all backends afterwards

Table Description

Field name Type Null Key Default Extras
cardid int(10) unsigned PRI NULL auto_increment
videodevice varchar(128) YES NULL
audiodevice varchar(128) YES NULL
vbidevice varchar(128) YES NULL
cardtype varchar(32) YES V4L
defaultinput varchar(32) YES Television
audioratelimit int(11) YES NULL
hostname varchar(255) YES NULL
dvb_swfilter int(11) YES 0
dvb_sat_type int(11) 0
dvb_wait_for_seqstart int(11) 1
skipbtaudio tinyint(1) YES 0
dvb_on_demand tinyint(4) 0
dvb_diseqc_type smallint(6) YES NULL
firewire_port int(10) unsigned 0
firewire_node int(10) unsigned 2
firewire_speed int(10) unsigned 0
firewire_model varchar(32) YES NULL
firewire_connection int(10) unsigned 0
dbox2_port int(10) unsigned 31338
dbox2_httpport int(10) unsigned 80
dbox2_host varchar(32) YES NULL
signal_timeout int(11) 1000
channel_timeout int(11) 3000
parentid int(10) 0
dvb_tuning_delay int(10) unsigned 0
contrast int(11) 0
brightness int(11) 0
colour int(11) 0
hue int(11) 0
diseqcid int(10) unsigned YES NULL

Example Entries

A Hauppauge PVR-350 card: 

               cardid: 1
          videodevice: /dev/video0
          audiodevice: NULL
            vbidevice: NULL
             cardtype: MPEG
         defaultinput: Tuner 1 
       audioratelimit: NULL
             hostname: localhost.localdomain
         dvb_swfilter: 0
         dvb_sat_type: 0 
dvb_wait_for_seqstart: 1
          skipbtaudio: 0
        dvb_on_demand: 0 
      dvb_diseqc_type: NULL
        firewire_port: 0
        firewire_node: 2
       firewire_speed: 0
       firewire_model: NULL
  firewire_connection: 0
           dbox2_port: 31338
       dbox2_httpport: 80
           dbox2_host: NULL
       signal_timeout: 1000
      channel_timeout: 3000
             parentid: 0
     dvb_tuning_delay: 0
             contrast: 0
           brightness: 0
               colour: 0
                  hue: 0
             diseqcid: NULL

A DVB card (an HD3000) receiving QAM_256 encoded ATSC by cable (North America): 

               cardid: 1
          videodevice: 0
          audiodevice: NULL
            vbidevice: NULL
             cardtype: DVB
         defaultinput: DVBInput
       audioratelimit: NULL
             hostname: localhost
         dvb_swfilter: 0
         dvb_recordts: 1
         dvb_sat_type: 0
dvb_wait_for_seqstart: 1
          skipbtaudio: 0
        dvb_on_demand: 1
      dvb_diseqc_type: NULL
        firewire_port: 0
        firewire_node: 2
       firewire_speed: 0
       firewire_model: NULL
  firewire_connection: 0
       dvb_hw_decoder: 0
           dbox2_port: 31338
       dbox2_httpport: 80 
           dbox2_host: NULL
       signal_timeout: 2000
      channel_timeout: 10000
             parentid: 0
     dvb_tuning_delay: 0
             contrast: 0
           brightness: 0
               colour: 0
                  hue: 0
             diseqcid: 0
Retrieved from "http://www.mythtv.org/wiki?title=Capturecard_table&oldid=20240"