[mythtv-users] mfd problem

[Steven]

Can you
> do
> a:
>
> 		show columns from musicmetadata;
> +-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| intid     | int(10) unsigned |      | PRI | NULL    | auto_increment |
| artist    | varchar(128)     |      | MUL |         |                |
| album     | varchar(128)     |      | MUL |         |                |
| title     | varchar(128)     |      | MUL |         |                |
| genre     | varchar(128)     |      | MUL |         |                |
| year      | int(10) unsigned |      |     | 0       |                |
| tracknum  | int(10) unsigned |      |     | 0       |                |
| length    | int(10) unsigned |      |     | 0       |                |
| filename  | text             |      |     |         |                |
| rating    | int(10) unsigned |      |     | 5       |                |
| lastplay  | timestamp(14)    | YES  |     | NULL    |                |
| playcount | int(10) unsigned |      |     | 0       |                |
+-----------+------------------+------+-----+---------+----------------+
12 rows in set (0.02 sec)



> 	and a:
>
> 		select * from settings where value = "MusicDBSchemaVer" ;
>
 MusicDBSchemaVer | 1002