CREATE TABLE artist_strings (
    artiststrid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
    artist VARCHAR(60) NOT NULL
);
CREATE UNIQUE INDEX idu_artist on artist_strings (artist);

CREATE TABLE album_sampler_strings (
    albumsamplerstrid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
    albumsampler VARCHAR(60) NOT NULL
);
CREATE UNIQUE INDEX idu_album on album_sampler_strings (albumsampler);

CREATE TABLE song_strings (
    songstrid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
    song VARCHAR(120) NOT NULL
);
CREATE UNIQUE INDEX idu_song on song_strings (song);

CREATE TABLE song2artist ( 
    songstrid INTEGER UNSIGNED NOT NULL,
    artiststrid INTEGER UNSIGNED NOT NULL    
);
ALTER TABLE song2artist ADD CONSTRAINT pk_song2artist PRIMARY KEY (songstrid,artiststrid);
ALTER TABLE song2artist ADD CONSTRAINT fk_s2a_songstrid FOREIGN KEY (songstrid) REFERENCES song_strings (songstrid);
ALTER TABLE song2artist ADD CONSTRAINT fk_s2a_artiststrid FOREIGN KEY (artiststrid) REFERENCES artist_strings (artiststrid);

CREATE TABLE song2artist2playtimevotes ( 
    songstrid INTEGER UNSIGNED NOT NULL,
    artiststrid INTEGER UNSIGNED NOT NULL,
    playtime INTEGER UNSIGNED NOT NULL,
    playtimevotes INTEGER UNSIGNED NOT NULL DEFAULT '1'
);
ALTER TABLE song2artist2playtimevotes ADD CONSTRAINT pk_s2a2pvotes PRIMARY KEY (songstrid,artiststrid,playtime);
ALTER TABLE song2artist2playtimevotes ADD CONSTRAINT fk_s2a2pvotes FOREIGN KEY (songstrid) REFERENCES song_strings (songstrid);
>>>>>> errno 121 - can't create table
ALTER TABLE song2artist2playtimevotes ADD CONSTRAINT fk_s2a2pvotes FOREIGN KEY (artiststrid) REFERENCES artist_strings (artiststrid);
ALTER TABLE song2artist2playtimevotes ADD CONSTRAINT fk_s2a2pvotes FOREIGN KEY (songstrid,artiststrid) REFERENCES song2artist2playtimevotes (songstrid,artiststrid);