rendered paste bodymysql> describe dtv_multiplex;
+-------------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+-------------------+----------------+
| mplexid | smallint(6) | NO | PRI | NULL | auto_increment |
| sourceid | smallint(6) | YES | | NULL | |
| transportid | int(11) | YES | | NULL | |
| networkid | int(11) | YES | | NULL | |
| frequency | int(11) | YES | | NULL | |
| inversion | char(1) | YES | | a | |
| symbolrate | int(11) | YES | | NULL | |
| fec | varchar(10) | YES | | auto | |
| polarity | char(1) | YES | | NULL | |
| modulation | varchar(10) | YES | | auto | |
| bandwidth | char(1) | YES | | a | |
| lp_code_rate | varchar(10) | YES | | auto | |
| transmission_mode | char(1) | YES | | a | |
| guard_interval | varchar(10) | YES | | auto | |
| visible | smallint(1) | NO | | 0 | |
| constellation | varchar(10) | YES | | auto | |
| hierarchy | varchar(10) | YES | | auto | |
| hp_code_rate | varchar(10) | YES | | auto | |
| sistandard | varchar(10) | YES | | dvb | |
| serviceversion | smallint(6) | YES | | 33 | |
| updatetimestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
+-------------------+-------------+------+-----+-------------------+----------------+
mysql> describe channel;
+---------------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------+-------+
| chanid | int(10) unsigned | NO | PRI | 0 | |
| channum | varchar(10) | NO | MUL | NULL | |
| freqid | varchar(10) | YES | | NULL | |
| sourceid | int(10) unsigned | YES | | NULL | |
| callsign | varchar(20) | NO | | NULL | |
| name | varchar(64) | NO | | NULL | |
| icon | varchar(255) | NO | | none | |
| finetune | int(11) | YES | | NULL | |
| videofilters | varchar(255) | NO | | NULL | |
| xmltvid | varchar(64) | NO | | NULL | |
| recpriority | int(10) | NO | | 0 | |
| contrast | int(11) | YES | | 32768 | |
| brightness | int(11) | YES | | 32768 | |
| colour | int(11) | YES | | 32768 | |
| hue | int(11) | YES | | 32768 | |
| tvformat | varchar(10) | NO | | Default | |
| commfree | tinyint(4) | NO | | 0 | |
| visible | tinyint(1) | NO | | 1 | |
| outputfilters | varchar(255) | NO | | NULL | |
| useonairguide | tinyint(1) | YES | | 0 | |
| mplexid | smallint(6) | YES | | NULL | |
| serviceid | mediumint(8) unsigned | YES | | NULL | |
| atscsrcid | int(11) | YES | | NULL | |
+---------------+-----------------------+------+-----+---------+-------+
23 rows in set (0.01 sec)