Difference between revisions of "Music songs table"
From MythTV Official Wiki
(The relative_volume column is not yet used) |
m |
||
| Line 1: | Line 1: | ||
{{Wrongtitle|music_songs table}} | {{Wrongtitle|music_songs table}} | ||
The '''music_songs table''' is used by [[MythMusic]]. | The '''music_songs table''' is used by [[MythMusic]]. | ||
| + | |||
| + | Table is current as of schema version 1017. | ||
| + | |||
== 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" | ||
| Line 70: | Line 73: | ||
(The relative_volume column is not yet used.) | (The relative_volume column is not yet used.) | ||
| − | + | [[Category:MythMusic DB Table]] | |
| − | [[Category:DB Table]] | ||
Latest revision as of 03:27, 26 September 2010
Note: The correct title of this article is music_songs table. It appears incorrectly here due to technical restrictions.
The music_songs table is used by MythMusic.
Table is current as of schema version 1017.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| song_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| filename | text | NO | |||
| name | varchar(255) | NO | MUL | ||
| track | smallint(6) unsigned | NO | 0 | ||
| artist_id | int(11) unsigned | NO | MUL | 0 | |
| album_id | int(11) unsigned | NO | MUL | 0 | |
| genre_id | int(11) unsigned | NO | MUL | 0 | |
| year | smallint(6) | NO | 0 | ||
| length | int(11) unsigned | NO | 0 | ||
| numplays | int(11) unsigned | NO | 0 | ||
| rating | tinyint(4) unsigned | NO | 0 | ||
| lastplay | datetime | YES | NULL | ||
| date_entered | datetime | YES | NULL | ||
| date_modified | datetime | YES | NULL | ||
| format | varchar(4) | NO | 0 | ||
| mythdigest | varchar(255) | YES | MUL | NULL | |
| size | bigint(20) unsigned | YES | NULL | ||
| description | varchar(255) | YES | NULL | ||
| comment | 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 | 0 | ||
| bitrate | int(10) unsigned | YES | 0 | ||
| bpm | smallint(5) unsigned | YES | NULL | ||
| directory_id | int(20) | NO | MUL | 0 |
(The relative_volume column is not yet used.)
