AudioFerret/v1/sql/Playlist Tracks
< AudioFerret | v1 | sql
Jump to navigation
Jump to search
About
- Subsystem: stored playlist management
- Purpose: list of tracks inside each playlist
SQL
<mysql>CREATE TABLE `Playlist_Tracks` (
`id_playlist` int(11) NOT NULL, `id_track` int(11) NOT NULL, `sort` double default NULL, PRIMARY KEY (`id_playlist`,`id_track`)
) ENGINE=MyISAM;</mysql>