[mythtv-users] You should have gotten a channel lock...

[Marcel Janssen]

Hi,

> Please go into mysql  and post the results from these commands:
>
> use mythconverg;
> describe channel;
>

These are the results.

+-----------------+-----------------------+------+-----+---------+-------+
| Field           | Type                  | Null | Key | Default | Extra |
+-----------------+-----------------------+------+-----+---------+-------+
| chanid          | int(10) unsigned      | NO   | PRI | 0       |       |
| channum         | varchar(10)           | NO   | MUL |         |       |
| freqid          | varchar(10)           | YES  |     | NULL    |       |
| sourceid        | int(10) unsigned      | YES  |     | NULL    |       |
| callsign        | varchar(20)           | NO   |     |         |       |
| name            | varchar(64)           | NO   |     |         |       |
| icon            | varchar(255)          | NO   |     | none    |       |
| finetune        | int(11)               | YES  |     | NULL    |       |
| videofilters    | varchar(255)          | NO   |     |         |       |
| xmltvid         | varchar(64)           | NO   |     |         |       |
| 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   |     |         |       |
| useonairguide   | tinyint(1)            | YES  |     | 0       |       |
| mplexid         | smallint(6)           | YES  |     | NULL    |       |
| serviceid       | mediumint(8) unsigned | YES  |     | NULL    |       |
| atscsrcid       | int(11)               | YES  |     | NULL    |       |
| tmoffset        | int(11)               | NO   |     | 0       |       |
| atsc_major_chan | int(10) unsigned      | NO   |     | 0       |       |
| atsc_minor_chan | int(10) unsigned      | NO   |     | 0       |       |
+-----------------+-----------------------+------+-----+---------+-------+

Regards,
Marcel