1 | mysql> select * from channel where callsign like 'ZDF' |
---|
2 | -> \G |
---|
3 | *************************** 1. row *************************** |
---|
4 | chanid: 5102 |
---|
5 | channum: 002 |
---|
6 | freqid: NULL |
---|
7 | sourceid: 5 |
---|
8 | callsign: ZDF |
---|
9 | name: ZDF |
---|
10 | icon: /home/mythtv/.mythtv//channels/zdf_de.jpg |
---|
11 | finetune: NULL |
---|
12 | videofilters: |
---|
13 | xmltvid: |
---|
14 | recpriority: 0 |
---|
15 | contrast: 32768 |
---|
16 | brightness: 32768 |
---|
17 | colour: 32768 |
---|
18 | hue: 32768 |
---|
19 | tvformat: Default |
---|
20 | commfree: 0 |
---|
21 | visible: 1 |
---|
22 | outputfilters: |
---|
23 | useonairguide: 1 |
---|
24 | mplexid: 43 |
---|
25 | serviceid: 28006 |
---|
26 | atscsrcid: NULL |
---|
27 | tmoffset: 0 |
---|
28 | atsc_major_chan: 0 |
---|
29 | atsc_minor_chan: 0 |
---|
30 | last_record: 0000-00-00 00:00:00 |
---|
31 | default_authority: |
---|
32 | commmethod: -1 |
---|
33 | 1 row in set (0.00 sec) |
---|
34 | |
---|
35 | mysql> SELECT * FROM `dtv_multiplex` WHERE `mplexid` = 43 |
---|
36 | -> \G |
---|
37 | *************************** 1. row *************************** |
---|
38 | mplexid: 43 |
---|
39 | sourceid: 5 |
---|
40 | transportid: 1079 |
---|
41 | networkid: 1 |
---|
42 | frequency: 394000000 |
---|
43 | inversion: a |
---|
44 | symbolrate: 6900000 |
---|
45 | fec: none |
---|
46 | polarity: NULL |
---|
47 | modulation: qam_256 |
---|
48 | bandwidth: NULL |
---|
49 | lp_code_rate: NULL |
---|
50 | transmission_mode: NULL |
---|
51 | guard_interval: NULL |
---|
52 | visible: 0 |
---|
53 | constellation: NULL |
---|
54 | hierarchy: NULL |
---|
55 | hp_code_rate: NULL |
---|
56 | sistandard: dvb |
---|
57 | serviceversion: 30 |
---|
58 | updatetimestamp: 2009-04-19 22:17:58 |
---|
59 | 1 row in set (0.00 sec) |
---|