bradcook wrote: > I dont have the SQL schema to hand - but how are the genres stored for > each track ? like this:
> .schema genre_track > CREATE TABLE genre_track ( > genre int(10), > track int(10), > *PRIMARY KEY (genre,track),* > FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE, > FOREIGN KEY (`genre`) REFERENCES `genres` (`id`) ON DELETE CASCADE > ); > CREATE INDEX genre_trackGenreIndex ON genre_track (genre); > CREATE INDEX genre_trackTrackIndex ON genre_track (track); ------------------------------------------------------------------------ DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=109818 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
