Musicmetadata table
From MythTV Official Wiki
Note: The correct title of this article is musicmetadata table. It appears incorrectly here due to technical restrictions.
The musicmetadata table contains information about all of the songs managed by the MythMusic plugin.
Note: This table is deprecated as of 0.20. See the music_songs table.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
intid | int(10) unsigned | PRI | NULL | auto_increment | |
artist | varchar(128) | MUL | |||
compilation_artist | varchar(128) | MUL | |||
album | varchar(128) | MUL | |||
title | varchar(128) | MUL | |||
genre | varchar(128) | MUL | |||
year | int(10) unsigned | ||||
tracknum | int(10) unsigned | ||||
length | int(10) unsigned | ||||
filename | text | ||||
rating | int(10) unsigned | 5 | |||
lastplay | timestamp | CURRENT_TIMESTAMP | |||
playcount | int(10) unsigned | 0 | |||
mythdigest | varchar(255) | YES | MUL | NULL | |
size | bigint(20) unsigned | YES | NULL | ||
date_added | datetime | YES | NULL | ||
date_modified | datetime | YES | NULL | ||
format | varchar(4) | YES | NULL | ||
description | varchar(255) | YES | NULL | ||
comment | varchar(255) | YES | NULL | ||
compilation | tinyint(4) | YES | 0 | ||
composer | varchar(255) | YES | NULL | ||
disc_count | smallint(5) unsigned | YES | 0 | ||
disc_number | smallint(5) unsigned | YES | 0 | ||
track_count | smallint(5) unsigned | YES | 0 | ||
start_time | int(10) unsigned | YES | 0 | ||
stop_time | int(10) unsigned | YES | NULL | ||
eq_preset | varchar(255) | YES | NULL | ||
relative_volume | tinyint(4) | YES | 0 | ||
sample_rate | int(10) unsigned | YES | NULL | ||
bpm | smallint(5) unsigned | YES | NULL |