Song Fields

From Musik

The help included doesn't seem to list all the available fields that can be used in Dynamic Playlists. Here is additional info directly from SQLLite on the schema of Songs Table.

Songs Fields

 songid INTEGER PRIMARY KEY,
 format  * mp3, ogg, ...  
 vbr 
 filename varchar(255),    
 artist varchar(255),    
 title varchar(255),
 album varchar(255),    
 tracknum number(3),    
 year number(4),    
 genre varchar(255),    
 rating * -1, 0 , 1 - 5
 bitrate * in kbs    
 lastplayed timestamp,    
 notes varchar(255),    
 timesplayed number(5),    
 duration * in ms
 timeadded timestamp
 filesize number(10) * in kb?    
 dirty number(10),    
 equalizer number(10),    
 totplaytime number(10),    
 userplayed number(5), * number of time the user initiated the play from the ui?    
 autoadvanced number(5) * number of time played by playlist (dynamic of otherwise)?

Songs Indexes

Anywhere one of these fields is used in selection, it will be faster, but who knows if that really matters considering the size of the database.

 album
 artist
 genre
 filename
 title
 artist, album, tracknum (together; composite index)