ALTER TABLE Genre DROP COLUMN `rate`;
ALTER TABLE Genre DROP COLUMN `lastUpdate`;
ALTER TABLE Genre DROP COLUMN `updateFrequency`;
ALTER TABLE Genre DROP COLUMN `lambdaFunction`;

#
# Table structure for table 'GenreFunction'
#

CREATE TABLE `GenreFunction` (
  `genreFunctionId` int(10) unsigned NOT NULL auto_increment,
  `genreId` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  `lambdaFunction` text,
  `updateFrequency` time, 
  `lastUpdate` timestamp,
  `rate` tinyint(4),

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

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


insert into MjukDatabaseVersion (version_mysql) values (328);