Difference between revisions of "Music playlists table"

From MythTV Official Wiki
Jump to: navigation, search
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 || PRI || NULL            || auto_increment
+
|| 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 ||   || CURRENT_TIMESTAMP ||
+
|| last_accessed  || timestamp            || {{NO}} ||     || CURRENT_TIMESTAMP ||
 
|-
 
|-
|| length        || int(11) unsigned    || NO ||   || 0                ||
+
|| length        || int(11) unsigned    || {{NO}} ||     || 0                ||
 
|-
 
|-
|| songcount      || smallint(8) unsigned || NO ||   || 0                ||
+
|| songcount      || smallint(8) unsigned || {{NO}} ||     || 0                ||
 
|-
 
|-
|| hostname      || varchar(255)         || NO ||   ||                  ||
+
|| 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
{{stub}}
+
 
[[Category:DB Table]]
+
[[Category:MythMusic DB Table]]

Latest revision as of 03:19, 26 September 2010

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