Stuff

ddt1:
---------------------------
create table song2artist2genrevotes (
    songstrid integer unsigned not null,
    artiststrid integer unsigned not null,
    genrestrid integer unsigned not null,
    genrevotes integer unsigned not null
);
alter table song2artist2genrevotes add constraint pk_song2artist2genrevotes primary key (songstrid,artiststrid,genrestrid);
alter table song2artist2genrevotes add constraint fk_s2a2gvotes_songstrid foreign key (songstrid) references song_strings (songstrid);
alter table song2artist2genrevotes add constraint fk_s2a2gvotes_artiststrid foreign key (artiststrid) references artist_strings (artiststrid);
alter table song2artist2genrevotes add constraint fk_s2a2gvotes_genrestrid foreign key (genrestrid) references genre_strings (genrestrid);

ddt2:
---------------------------
CREATE TABLE  `freedb`.`song2artist2genrevotes` (
  `songstrid` int(10) unsigned NOT NULL,
  `artiststrid` int(10) unsigned NOT NULL,
  `genrestrid` int(10) unsigned NOT NULL,
  `genrevotes` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`songstrid`,`artiststrid`,`genrestrid`),
  KEY `fk_s2a2gvotes_artiststrid` (`artiststrid`),
  KEY `fk_s2a2gvotes_genrestrid` (`genrestrid`),
  CONSTRAINT `fk_s2a2gvotes_artiststrid` FOREIGN KEY (`artiststrid`) REFERENCES `artist_strings` (`artiststrid`),
  CONSTRAINT `fk_s2a2gvotes_genrestrid` FOREIGN KEY (`genrestrid`) REFERENCES `genre_strings` (`genrestrid`),
  CONSTRAINT `fk_s2a2gvotes_songstrid` FOREIGN KEY (`songstrid`) REFERENCES `song_strings` (`songstrid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;