Difference between revisions of "Musicmetadata table"
From MythTV Official Wiki
m |
m |
||
Line 1: | Line 1: | ||
{{Wrongtitle|musicmetadata table}} | {{Wrongtitle|musicmetadata table}} | ||
− | + | The '''musicmetadata table''' contains information about all of the songs managed by the [[MythMusic]] plugin. | |
− | + | [[Image:Important.png]] '''Note:''' This table is deprecated as of [[Release_Notes_-_0.20|0.20]]. | |
== Table Description == | == Table Description == | ||
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" |
Revision as of 19:09, 26 March 2007
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.
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 |