Difference between revisions of "Music playlists table"

From MythTV Official Wiki
Jump to: navigation, search
(added music_playlists table definition)
 
m
 
(One intermediate revision by one other user not shown)
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}} ||     ||                  ||
 
|-
 
|-
 
|}
 
|}
  
 +
== Fields ==
 +
 +
'''hostname''' Set to ''null'' if access is required from all clients, otherwise enter the hostname of the client
  
{{stub}}
+
[[Category:MythMusic DB Table]]
[[Category: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