--- /dev/null
+begin;
+INSERT INTO tournaments
+ (season, name, country, location, "date", machine, scoringsystem) VALUES (
+ (SELECT season FROM seasons WHERE name='Challenge Cup 2004'),
+ 'Challenge Cup 2',
+ (SELECT country FROM countries WHERE name='Norway'),
+ 'Kino 1 Sandvika',
+ '2004-04-25',
+ (SELECT machine FROM machines WHERE name='Dancing Stage EuroMix 2'),
+ (SELECT scoringsystem FROM scoringsystems WHERE name='10K Machine score')
+);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bush' AS nick WHERE 'Bush' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Bush'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Bush'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 'f',
+ 4327);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Bush'),
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 'f',
+ 4251);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 'f',
+ 5476);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Ylini'),
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 'f',
+ 6242);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stream'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 'f',
+ 6224);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 'f',
+ 6659);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 'f',
+ 6530);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 'f',
+ 6702);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Memories')),
+ 'f',
+ 7561);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 1,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
+ 'f',
+ 7616);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dabi' AS nick WHERE 'Dabi' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Dabi'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Dabi'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 3973);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Dabi'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 'f',
+ 3845);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 7827);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 'f',
+ 6329);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 7830);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='Smiph'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 'f',
+ 6336);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8058);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 'f',
+ 7672);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8651);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 2,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Vanity Angel')),
+ 'f',
+ 8426);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R'))
+);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)'))
+);
+UPDATE rounds SET randomsongs=2 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=1;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 'f',
+ 5012);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 'f',
+ 4014);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 'f',
+ 5541);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Draconia'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 'f',
+ 0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Havok'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Havok'),
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 'f',
+ 4355);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Havok'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 'f',
+ 6284);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 'f',
+ 5953);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 'f',
+ 8076);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('D2R')),
+ 'f',
+ 6044);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 1, 3,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
+ 'f',
+ 8303);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=2;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=2;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Raazu' AS nick WHERE 'Raazu' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Raazu'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 7286);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 7814);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Olemann'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 7747);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8215);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8529);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8478);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8743);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 8
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8695);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 9
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 2, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
+ 'f',
+ 8798);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=3;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=3;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Stream'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 7698);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8241);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='RiChY'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8139);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8661);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8272);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 6
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8783);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 7
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 3, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
+ 'f',
+ 8633);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=4;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=4;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 'f',
+ 5706);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'T|na' AS nick WHERE 'T|na' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='T|na'),
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 'f',
+ 5726);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 'f',
+ 5553);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 'f',
+ 5822);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 5
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 4, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('5, 6, 7, 8')),
+ 'f',
+ 5922);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=5;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=5;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snofox'),
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 6450);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 6742);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 6605);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 4
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 5, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('www.blonde girl (MOMO Mix)')),
+ 'f',
+ 6689);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=6;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=6;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+ 'f',
+ 7343);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='DufF'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+ 'f',
+ 7152);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 3
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 6, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Make A Jam!')),
+ 'f',
+ 6908);
+INSERT INTO rounds (tournament, round, randomsongs, chosensongs)
+ VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7,
+ 0, 0);
+INSERT INTO groups (tournament, round, parallel) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0);
+INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave'))
+);
+UPDATE rounds SET randomsongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=7;
+UPDATE rounds SET chosensongs=1 WHERE
+ tournament=(SELECT tournament FROM tournaments WHERE name='Challenge Cup 2') AND
+ round=7;
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ 1
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='Snute'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 'f',
+ 8662);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ 2
+);
+INSERT INTO scores (tournament, round, parallel, player, song, chosen, score) VALUES (
+ (SELECT tournament FROM tournaments WHERE name='Challenge Cup 2'),
+ 7, 0,
+ (SELECT player FROM players WHERE nick='OJK'),
+ (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
+ 'f',
+ 8676);
+commit;
projects / ccbs / blobdiff