Difference between revisions of "Musicmetadata table"
From MythTV Official Wiki
(Fixed link) |
(added table description) |
||
Line 1: | Line 1: | ||
+ | {{Wrongtitle|musicmetadata table}} | ||
The '''musicmetadata table''' contains information about all of the songs managed by the [[MythMusic]] plugin. | The '''musicmetadata table''' contains information about all of the songs managed by the [[MythMusic]] plugin. | ||
+ | |||
+ | {| cellpadding="4" | ||
+ | |- bgcolor="#9999ff" | ||
+ | ! Field !! Type !! Null !! Key !! Default !! Extra | ||
+ | |- bgcolor="#cccccc" | ||
+ | | intid || int(10) unsigned || || PRI || NULL || auto_increment | ||
+ | |- bgcolor="#cccccc" | ||
+ | | artist || varchar(128) || || MUL || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | compilation_artist || varchar(128) || || MUL || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | album || varchar(128) || || MUL || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | title || varchar(128) || || MUL || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | genre || varchar(128) || || MUL || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | year || int(10) unsigned || || || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | tracknum || int(10) unsigned || || || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | length || int(10) unsigned || || || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | filename || text || || || || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | rating || int(10) unsigned || || || 5 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | lastplay || timestamp || || || CURRENT_TIMESTAMP || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | playcount || int(10) unsigned || || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | mythdigest || varchar(255) || YES || MUL || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | size || bigint(20) unsigned || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | date_added || datetime || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | date_modified || datetime || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | format || varchar(4) || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | description || varchar(255) || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | comment || varchar(255) || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | compilation || tinyint(4) || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | composer || varchar(255) || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | disc_count || smallint(5) unsigned || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | disc_number || smallint(5) unsigned || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | track_count || smallint(5) unsigned || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | start_time || int(10) unsigned || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | stop_time || int(10) unsigned || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | eq_preset || varchar(255) || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | relative_volume || tinyint(4) || YES || || 0 || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | sample_rate || int(10) unsigned || YES || || NULL || | ||
+ | |- bgcolor="#cccccc" | ||
+ | | bpm || smallint(5) unsigned || YES || || NULL || | ||
+ | |- | ||
+ | |} | ||
[[Category:DB Table]] | [[Category:DB Table]] |
Revision as of 04:15, 7 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.
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 |