#
# Table structure for table 'UserRate'
#

CREATE TABLE `UserRate` (
  `userRateId` int(10) unsigned NOT NULL auto_increment,
  `userId` int(10) unsigned NOT NULL,
  `referenceType` enum("genre","artist","album","track"),
  `referenceId` int(10) unsigned NOT NULL,
  `rate` tinyint(4) default NULL,

  INDEX userId_ind (userId),

  PRIMARY KEY  (`userRateId`),
  FOREIGN KEY (`userId`) REFERENCES Users(`userId`)
) TYPE=InnoDB;


# move UserTrackRate info to new table
INSERT INTO UserRate (userId,referenceType,referenceId,rate)
  SELECT userId,"track",trackId,rate from UserTrackRate;

# move UserAlbumRate info to new table
INSERT INTO UserRate (userId,referenceType,referenceId,rate)
  SELECT userId,"album",albumId,rate from UserAlbumRate;

# move UserArtistRate info to new table
INSERT INTO UserRate (userId,referenceType,referenceId,rate)
  SELECT userId,"artist",artistId,rate from UserArtistRate;



insert into MjukDatabaseVersion (version_mysql) values (322);