#
# Table structure for table 'UserArtistRate'
#

CREATE TABLE `UserArtistRate` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userId` int(10) unsigned NOT NULL,
  `artistId` int(10) unsigned NOT NULL,
  `rate` tinyint(4) default NULL,

  INDEX userId_ind (userId),
  INDEX artistId_ind (artistId),

  PRIMARY KEY  (`id`),
  FOREIGN KEY (`userId`) REFERENCES Users(`userId`),
  FOREIGN KEY (`artistId`) REFERENCES Artist(`artistId`)
) TYPE=InnoDB;

#
# Table structure for table 'UserAlbumRate'
#

CREATE TABLE `UserAlbumRate` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userId` int(10) unsigned NOT NULL,
  `albumId` int(10) unsigned NOT NULL,
  `rate` tinyint(4) default NULL,

  INDEX userId_ind (userId),
  INDEX albumId_ind (albumId),

  PRIMARY KEY  (`id`),
  FOREIGN KEY (`userId`) REFERENCES Users(`userId`),
  FOREIGN KEY (`albumId`) REFERENCES Album(`albumId`)
) TYPE=InnoDB;



insert into MjukDatabaseVersion (version_mysql) values (263);