Difference between revisions of "Music playlists table"
From MythTV Official Wiki
m |
|||
| Line 1: | Line 1: | ||
{{Wrongtitle|music_playlists table}} | {{Wrongtitle|music_playlists table}} | ||
The '''music_playlists table''' is used by [[MythMusic]]. | The '''music_playlists 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 6: | Line 9: | ||
! Field name !! Type !! Null !! Key !! Default !! Extras | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
|- | |- | ||
| − | || playlist_id || int(11) unsigned || NO | + | || playlist_id || int(11) unsigned || {{NO}} || PRI || NULL || auto_increment |
|- | |- | ||
| − | || playlist_name || varchar(255) || NO | + | || playlist_name || varchar(255) || {{NO}} || || || |
|- | |- | ||
| − | || playlist_songs || text || NO | + | || playlist_songs || text || {{NO}} || || || |
|- | |- | ||
| − | || last_accessed || timestamp || NO | + | || last_accessed || timestamp || {{NO}} || || CURRENT_TIMESTAMP || |
|- | |- | ||
| − | || length || int(11) unsigned || NO | + | || length || int(11) unsigned || {{NO}} || || 0 || |
|- | |- | ||
| − | || songcount || smallint(8) unsigned || NO | + | || songcount || smallint(8) unsigned || {{NO}} || || 0 || |
|- | |- | ||
| − | || hostname || varchar( | + | || hostname || varchar(64) || {{NO}} || || || |
|- | |- | ||
|} | |} | ||
| Line 25: | Line 28: | ||
'''hostname''' Set to ''null'' if access is required from all clients, otherwise enter the hostname of the client | '''hostname''' Set to ''null'' if access is required from all clients, otherwise enter the hostname of the client | ||
| − | + | ||
| − | [[Category:DB Table]] | + | [[Category:MythMusic DB Table]] |
Latest revision as of 03:19, 26 September 2010
Note: The correct title of this article is music_playlists table. It appears incorrectly here due to technical restrictions.
The music_playlists table is used by MythMusic.
Table is current as of schema version 1017.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| playlist_id | int(11) unsigned | No | PRI | NULL | auto_increment |
| playlist_name | varchar(255) | No | |||
| playlist_songs | text | No | |||
| last_accessed | timestamp | No | CURRENT_TIMESTAMP | ||
| length | int(11) unsigned | No | 0 | ||
| songcount | smallint(8) unsigned | No | 0 | ||
| hostname | varchar(64) | No |
Fields
hostname Set to null if access is required from all clients, otherwise enter the hostname of the client
