Pastetool #305

CREATE TABLE IF NOT EXISTS `music_rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `genre_id` int(3) NOT NULL,
  `country_id` int(2) NOT NULL,
  `weekplays` int(11) NOT NULL,
  `pos` int(8) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `genre_id` (`genre_id`),
  KEY `country_id` (`country_id`),
  KEY `weekplays` (`weekplays`)
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS `music_rating_tmp` (
  `pos` int(11) NOT NULL AUTO_INCREMENT,
  `weekplays` int(11) NOT NULL,
  PRIMARY KEY (`pos`)
) ENGINE=InnoDB;