emmental

Table of Contents

Columns
Triggers

The playlist_properties table holds variables and state that all Playlists have. The playlists_active_trigger is used to enforce only one active playlist at a time.

Columns

Name	Type	Default	Description
propertyid	INTEGER		The unique id of a single playlist
active	BOOLEAN	FALSE	The current active status of the playlist
loop	STRING	"None"	The current loop status of the playlist ("None", "Track", or "Playlist")
shuffle	BOOLEAN	FALSE	The current shuffle status of the playlist
sort_order	STRING	""	The current sort order of the playlist
current_trackid	INTEGER	NULL	The trackid of the playlist's current track

Triggers

Name	When	Description
playlists_active_trigger	After update of `active`	Set playlist_properties.active = False for all other rows