#
# Table structure for table 'GenreMapping'
#

CREATE TABLE `GenreMapping` (
  `genreMappingId` int(10) unsigned NOT NULL auto_increment,
  `genreId` int(10) unsigned NOT NULL,
  `referenceType` enum("artist","album","track"),
  `referenceId` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned,

  INDEX genreId_ind (genreId),
  INDEX userId_ind (userId),

  PRIMARY KEY (`genreMappingId`),
  FOREIGN KEY (`genreId`) REFERENCES Genre(`genreId`),
  FOREIGN KEY (`userId`) REFERENCES Users(`userId`)
) TYPE=InnoDB;

INSERT INTO GenreMapping (genreId,referenceType,referenceId,userId) 
  SELECT genreId,'album' as referenceType,albumId,NULL as userId from AlbumGenre;
DROP TABLE AlbumGenre;

INSERT INTO GenreMapping (genreId,referenceType,referenceId,userId) 
  SELECT genreId,'artist' as referenceType,artistId,NULL as userId from ArtistGenre;
DROP TABLE ArtistGenre;

INSERT INTO GenreMapping (genreId,referenceType,referenceId,userId) 
  SELECT genreId,'track' as referenceType,trackId,NULL as userId from TrackGenre;
DROP TABLE TrackGenre;

insert into MjukDatabaseVersion (version_mysql) values (337);