X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc2-04.sql;fp=sql%2Fcc04%2Fcc2-04.sql;h=ee341ef031eec154bfc17e82ce5d1793412e724c;hp=0000000000000000000000000000000000000000;hb=e81c2d9126e54860c49eb224f44dc50467790e84;hpb=2ca0daa6916f97279a48669592e198f0d124cc59

diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql
new file mode 100644
index 0000000..ee341ef
--- /dev/null
+++ b/sql/cc04/cc2-04.sql
@@ -0,0 +1,923 @@
+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;