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>