Difference between revisions of "Musicplaylist table"

From MythTV Official Wiki
Jump to: navigation, search
 
m (table style)
Line 1: Line 1:
<TABLE>
+
{{Wrongtitle|musicplaylist table}}
  <TR bgColor=#9999ff>
+
The '''musicplaylist table''' is used by [[MythMusic]].
    <TD><B>Field name</B></TD>
+
== Table Description ==
    <TD><B>Type</B></TD>
+
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
    <TD><B>Allow nulls?</B></TD>
+
|- style="background: lightsteelblue"
    <TD><B>Key</B></TD>
+
Field name !! Type                 !! Null !! Key !! Default             !! Extras
    <TD><B>Default value</B></TD>
+
|-
    <TD><B>Extras</B></TD></TR>
+
|| playlistid || int(10) unsigned ||      || PRI || NULL    || auto_increment
  <TR bgColor=#cccccc>
+
|-
    <TD>playlist_id</TD>
+
|| name      || varchar(128)    ||      ||     ||        ||
    <TD>int(11) unsigned</TD>
+
|-
    <TD>No</TD>
+
|| hostname   || varchar(255)    || YES  ||     || NULL    ||
    <TD>Primary</TD>
+
|-
    <TD>&nbsp;</TD>
+
|| songlist   || text            ||      ||     ||        ||
    <TD>auto_increment&nbsp;</TD></TR>
+
|-
  <TR bgColor=#cccccc>
+
|}
    <TD>playlist_name</TD>
+
 
    <TD>varchar(255)</TD>
+
 
     <TD>No</TD>
+
{{stub}}
     <TD>None</TD>
 
    <TD>&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR>
 
   <TR bgColor=#cccccc>
 
    <TD>playlist_songs</TD>
 
    <TD>text</TD>
 
    <TD>No</TD>
 
    <TD>None</TD>
 
    <TD>&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR>
 
  <TR bgColor=#cccccc>
 
    <TD>last_accessed</TD>
 
    <TD>timestamp(14)</TD>
 
     <TD>Yes</TD>
 
     <TD>None</TD>
 
    <TD>&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR>
 
   <TR bgColor=#cccccc>
 
     <TD>length</TD>
 
    <TD>int(11) unsigned</TD>
 
    <TD>No</TD>
 
    <TD>None</TD>
 
    <TD>0&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR>
 
  <TR bgColor=#cccccc>
 
    <TD>songcount</TD>
 
    <TD>smallint(8) unsigned</TD>
 
    <TD>No</TD>
 
    <TD>None</TD>
 
    <TD>0&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR>
 
  <TR bgColor=#cccccc>
 
    <TD>hostname</TD>
 
    <TD>varchar(255)</TD>
 
    <TD>No</TD>
 
    <TD>None</TD>
 
    <TD>&nbsp;</TD>
 
    <TD>&nbsp;</TD></TR></TABLE>
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 02:50, 16 March 2007

Important.png Note: The correct title of this article is musicplaylist table. It appears incorrectly here due to technical restrictions.

The musicplaylist table is used by MythMusic.

Table Description

Field name Type Null Key Default Extras
playlistid int(10) unsigned PRI NULL auto_increment
name varchar(128)
hostname varchar(255) YES NULL
songlist text