mysql> \n PAGER set to stdout mysql> select * from dtv_multiplex; +---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+-----------------+ | mplexid | sourceid | transportid | networkid | frequency | inversion | symbolrate | fec | polarity | modulation | bandwidth | lp_code_rate | transmission_mode | guard_interval | visible | constellation | hierarchy | hp_code_rate | sistandard | serviceversion | updatetimestamp | +---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+-----------------+ | 1 | 1 | 1113 | 0 | 695000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 1 | 20050702040415 | | 2 | 1 | 1009 | 0 | 515000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 0 | 20050702040416 | | 3 | 1 | NULL | NULL | 671000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 33 | 20050702040240 | | 4 | 1 | NULL | NULL | 701000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 33 | 20050702040246 | | 5 | 1 | 1001 | 0 | 563000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 2 | 20050702040537 | | 6 | 1 | NULL | NULL | 605000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 33 | 20050702040259 | | 7 | 1 | 987 | 0 | 707000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 1 | 20050702040546 | | 8 | 1 | 1005 | 0 | 503000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 30 | 20050702040548 | | 9 | 1 | 1031 | 0 | 743000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 1 | 20050702040549 | | 10 | 1 | 1013 | 0 | 575000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 1 | 20050702040603 | | 11 | 1 | 1011 | 0 | 551000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 3 | 20050702040604 | | 12 | 1 | 1015 | 0 | 647000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 5 | 20050702040620 | | 13 | 1 | NULL | NULL | 630000000 | a | NULL | auto | NULL | 8vsb | a | auto | a | auto | 0 | auto | auto | auto | atsc | 33 | 20050702040343 | +---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+------------+----------------+-----------------+ 13 rows in set (0.00 sec) mysql> select * from channel; +--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+ | chanid | channum | freqid | sourceid | callsign | name | icon | finetune | videofilters | xmltvid | recpriority | contrast | brightness | colour | hue | tvformat | commfree | visible | outputfilters | useonairguide | mplexid | serviceid | atscsrcid | +--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+ | 1000 | 501 | NULL | 1 | WPWR-DT | WPWR-DT | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 1 | 3 | 1 | | 1001 | 201 | NULL | 1 | WYCC-1 | WYCC-1 | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 2 | 3 | 1 | | 1002 | 51 | NULL | 1 | NBC5-DT | NBC5-DT | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 5 | 5 | 1 | | 1003 | 52 | NULL | 1 | NBC5-WX | NBC5-WX | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 5 | 6 | 2 | | 1004 | 21 | NULL | 1 | WGBO-DT | WGBO-DT | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 7 | 4 | 1 | | 1005 | 91 | NULL | 1 | WGN-D1 | WGN-D1 | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 8 | 3 | 3 | | 1006 | 92 | NULL | 1 | WGN-D2 | WGN-D2 | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 8 | 4 | 4 | | 1007 | 601 | NULL | 1 | WXFT-DT | WXFT-DT | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 9 | 3 | 1 | | 1008 | 321 | NULL | 1 | WFLD-DT | WFLD-DT | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 10 | 3 | 1 | | 1009 | 261 | NULL | 1 | The U! | The U! | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 11 | 3 | 1 | | 1010 | 262 | NULL | 1 | MeTV | MeTV | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 11 | 4 | 2 | | 1011 | 381 | NULL | 1 | PAX-38 | PAX-38 | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 3 | 49 | | 1012 | 382 | NULL | 1 | PAX MTN | PAX MTN | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 4 | 65 | | 1013 | 383 | NULL | 1 | PAX W | PAX W | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 5 | 81 | | 1014 | 384 | NULL | 1 | WORSHIP | WORSHIP | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 6 | 97 | | 1015 | 385 | NULL | 1 | FAITH | FAITH | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 7 | 113 | | 1016 | 386 | NULL | 1 | TLN | TLN | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 12 | 8 | 129 | +--------+---------+--------+----------+----------+---------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+ 17 rows in set (0.00 sec) mysql> select * from videosource; +----------+-----------------------+--------------+--------+-----------+----------+----------+ | sourceid | name | xmltvgrabber | userid | freqtable | lineupid | password | +----------+-----------------------+--------------+--------+-----------+----------+----------+ | 1 | Chicago DTV Broadcast | datadirect | | default | NULL | NULL | +----------+-----------------------+--------------+--------+-----------+----------+----------+ 1 row in set (0.00 sec) mysql> select * from capturecard; +--------+-------------+-------------+-----------+----------+--------------+----------------+-----------+--------------+--------------+--------------+-----------------------+------------------+------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+----------------+ | cardid | videodevice | audiodevice | vbidevice | cardtype | defaultinput | audioratelimit | hostname | dvb_swfilter | dvb_recordts | dvb_sat_type | dvb_wait_for_seqstart | dvb_dmx_buf_size | dvb_pkt_buf_size | skipbtaudio | dvb_on_demand | dvb_diseqc_type | firewire_port | firewire_node | firewire_speed | firewire_model | firewire_connection | dvb_hw_decoder | +--------+-------------+-------------+-----------+----------+--------------+----------------+-----------+--------------+--------------+--------------+-----------------------+------------------+------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+----------------+ | 1 | 0 | | | DVB | DVBInput | NULL | bitbucket | 0 | 1 | 0 | 1 | 8192 | 8192 | 0 | 1 | 0 | 0 | 2 | 0 | NULL | 0 | 0 | +--------+-------------+-------------+-----------+----------+--------------+----------------+-----------+--------------+--------------+--------------+-----------------------+------------------+------------------+-------------+---------------+-----------------+---------------+---------------+----------------+----------------+---------------------+----------------+ 1 row in set (0.00 sec) mysql> select * from cardinput; +-------------+--------+----------+-----------+-----------------+------------+-----------+----------+-----------+---------------+-------------+------------+----------------+------------+------------+ | cardinputid | cardid | sourceid | inputname | externalcommand | preference | shareable | tunechan | startchan | freetoaironly | diseqc_port | diseqc_pos | lnb_lof_switch | lnb_lof_hi | lnb_lof_lo | +-------------+--------+----------+-----------+-----------------+------------+-----------+----------+-----------+---------------+-------------+------------+----------------+------------+------------+ | 1 | 1 | 1 | DVBInput | NULL | 0 | N | | | 0 | NULL | 0 | 11700000 | 10600000 | 9750000 | +-------------+--------+----------+-----------+-----------------+------------+-----------+----------+-----------+---------------+-------------+------------+----------------+------------+------------+ 1 row in set (0.00 sec)