Difference between revisions of "Musicmetadata table"

From MythTV Official Wiki
Jump to: navigation, search
 
m (remove categories)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
The '''musicmetadata table''' contains information about all of the songs managed by the [[:Category:MythMusic|MythMusic]] plugin.
+
{{Wrongtitle|musicmetadata table}}
 +
The '''musicmetadata table''' contains information about all of the songs managed by the [[MythMusic]] plugin.
  
−
[[Category:DB Table]]
+
[[Image:Important.png]] '''Note:''' This table is deprecated as of [[Release_Notes_-_0.20|0.20]]. See the [[music_songs table]].
 +
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  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              ||
 +
|-
 +
|}

Latest revision as of 02:57, 26 September 2010

Important.png 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.

Important.png 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
Retrieved from "http://www.mythtv.org/wiki?title=Musicmetadata_table&oldid=48993"