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.
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
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 |