AudioFerret/v1/sql/Playlist Tracks
< AudioFerret | v1 | sql
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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>