Started on a bigscreen SQL schema.

[ccbs] / sql / cc04 / cc1-04.sql

diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql
index d7fd99b4c2941ef139462f7720253010f2204a12..ddb4b5fd85fc62159a099fda1d904cfc976e9dea 100644 (file)
--- a/sql/cc04/cc1-04.sql
+++ b/sql/cc04/cc1-04.sql
@@ -9,6 +9,210 @@ INSERT INTO tournaments
     (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),
     (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score')
 );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snute' AS nick WHERE 'Snute' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   100);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'DufF' AS nick WHERE 'DufF' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   90);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'OJK' AS nick WHERE 'OJK' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   81);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   4,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   73);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   5,
+   (SELECT player FROM players WHERE nick='Tom'),
+   66);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Snofox' AS nick WHERE 'Snofox' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   6,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'RiChY' AS nick WHERE 'RiChY' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   7,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   8,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   9,
+   (SELECT player FROM players WHERE nick='Mulefisk'),
+   48);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   10,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   46);
+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 tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   11,
+   (SELECT player FROM players WHERE nick='T|na'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Stream' AS nick WHERE 'Stream' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   12,
+   (SELECT player FROM players WHERE nick='Stream'),
+   44);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   13,
+   (SELECT player FROM players WHERE nick='Purity'),
+   43);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   14,
+   (SELECT player FROM players WHERE nick='Spinnvill'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   15,
+   (SELECT player FROM players WHERE nick='Jallaman'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Smiph' AS nick WHERE 'Smiph' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   16,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   40);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   17,
+   (SELECT player FROM players WHERE nick='Electus'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Havok' AS nick WHERE 'Havok' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   18,
+   (SELECT player FROM players WHERE nick='Havok'),
+   38);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   19,
+   (SELECT player FROM players WHERE nick='Dexter'),
+   37);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Draconia' AS nick WHERE 'Draconia' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   20,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   21,
+   (SELECT player FROM players WHERE nick='Advena'),
+   35);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   22,
+   (SELECT player FROM players WHERE nick='Slusk'),
+   34);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   23,
+   (SELECT player FROM players WHERE nick='Telc'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   24,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Olemann' AS nick WHERE 'Olemann' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   25,
+   (SELECT player FROM players WHERE nick='Olemann'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   26,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ylini' AS nick WHERE 'Ylini' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   27,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   28,
+   (SELECT player FROM players WHERE nick='Golddragon'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   29,
+   (SELECT player FROM players WHERE nick='tombot'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   30,
+   (SELECT player FROM players WHERE nick='x3mnrj'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   31,
+   (SELECT player FROM players WHERE nick='Tha Dragon'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   32,
+   (SELECT player FROM players WHERE nick='Octu'),
+   24);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   33,
+   (SELECT player FROM players WHERE nick='Ink'),
+   23);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
+INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
+   (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
+   34,
+   (SELECT player FROM players WHERE nick='Auran'),
+   22);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
@@ -33,7 +237,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
@@ -64,7 +267,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7952);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
@@ -95,7 +297,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6940);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
@@ -126,7 +327,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7649);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Slusk' AS nick WHERE 'Slusk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
@@ -157,7 +357,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7619);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
@@ -207,7 +406,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Golddragon' AS nick WHERE 'Golddragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 2,
@@ -238,7 +436,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    6905);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 2,
@@ -269,7 +466,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8151);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 2,
@@ -300,7 +496,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8242);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matsi' AS nick WHERE 'Matsi' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 2,
@@ -331,7 +526,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7354);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 2,
@@ -381,7 +575,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'tombot' AS nick WHERE 'tombot' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -412,7 +605,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    6622);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ink' AS nick WHERE 'Ink' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -443,7 +635,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    5636);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -474,7 +665,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    7837);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -505,7 +695,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8031);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Telc' AS nick WHERE 'Telc' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -536,7 +725,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Hypnotic Crisis')),
    't',
    7467);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 3,
@@ -586,7 +774,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Duckling' AS nick WHERE 'Duckling' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -617,7 +804,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7172);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Auran' AS nick WHERE 'Auran' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -648,7 +834,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    4459);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Advena' AS nick WHERE 'Advena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -679,7 +864,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    7787);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -710,7 +894,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    7700);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -741,7 +924,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Jam Jam Reggae (AM Swing Mix)')),
    't',
    6668);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 4,
@@ -791,7 +973,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'x3mnrj' AS nick WHERE 'x3mnrj' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -822,7 +1003,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    6712);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Octu' AS nick WHERE 'Octu' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -853,7 +1033,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    6321);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -884,7 +1063,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7992);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -915,7 +1093,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8079);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -946,7 +1123,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7576);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 5,
@@ -996,7 +1172,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Dexter' AS nick WHERE 'Dexter' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1027,7 +1202,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8433);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1058,7 +1232,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    7315);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tha Dragon' AS nick WHERE 'Tha Dragon' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1089,7 +1262,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7357);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1120,7 +1292,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8452);
-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 tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1151,7 +1322,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8529);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 6,
@@ -1206,7 +1376,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=2;
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1237,7 +1406,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8098);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Daniil' AS nick WHERE 'Daniil' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1268,7 +1436,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8489);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1299,7 +1466,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8445);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1330,7 +1496,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8425);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Purity' AS nick WHERE 'Purity' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1361,7 +1526,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8424);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 1,
@@ -1411,7 +1575,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=2;
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1442,7 +1605,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Hysteria 2001')),
    't',
    3161);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Jallaman' AS nick WHERE 'Jallaman' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1473,7 +1635,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    0);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1504,7 +1665,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8160);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1535,7 +1695,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8107);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1566,7 +1725,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8190);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 2,
@@ -1616,7 +1774,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1647,7 +1804,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8229);
-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 tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1678,7 +1834,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7874);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electus' AS nick WHERE 'Electus' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1709,7 +1864,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('era (nostalmix)')),
    't',
    7249);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Spinnvill' AS nick WHERE 'Spinnvill' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1740,7 +1894,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7821);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1771,7 +1924,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7733);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    2, 3,
@@ -1821,7 +1973,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=3;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1844,7 +1995,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8380);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Haggar' AS nick WHERE 'Haggar' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1867,7 +2017,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8316);
-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 tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1890,7 +2039,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8678);
-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 tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1913,7 +2061,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8680);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mulefisk' AS nick WHERE 'Mulefisk' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1936,7 +2083,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7815);
-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 tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1959,7 +2105,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8180);
-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 tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -1982,7 +2127,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8260);
-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 tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -2005,7 +2149,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8539);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    3, 0,
@@ -2047,7 +2190,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=4;
-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 tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2070,7 +2212,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8588);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2093,7 +2234,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8706);
-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 tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2116,7 +2256,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8693);
-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 tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2139,7 +2278,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7821);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2162,7 +2300,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    't',
    8379);
-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 tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2185,7 +2322,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Electro Tuned (the SubS Mix)')),
    't',
    8563);
-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 tournamentname='Challenge Cup 1 - 2004'),
    4, 0,
@@ -2227,7 +2363,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=5;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    5, 0,
@@ -2250,7 +2385,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8452);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Tom' AS nick WHERE 'Tom' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    5, 0,
@@ -2273,7 +2407,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8960);
-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 tournamentname='Challenge Cup 1 - 2004'),
    5, 0,
@@ -2296,7 +2429,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8615);
-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 tournamentname='Challenge Cup 1 - 2004'),
    5, 0,
@@ -2319,7 +2451,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8541);
-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 tournamentname='Challenge Cup 1 - 2004'),
    5, 0,
@@ -2361,7 +2492,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') 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 tournamentname='Challenge Cup 1 - 2004'),
    6, 0,
@@ -2384,7 +2514,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Can\'t Stop Fallin\' in Love (SPEED MIX)')),
    't',
    8637);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Oliyzia' AS nick WHERE 'Oliyzia' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    6, 0,
@@ -2407,7 +2536,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8044);
-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 tournamentname='Challenge Cup 1 - 2004'),
    6, 0,
@@ -2430,7 +2558,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova Primeval')),
    't',
    8506);
-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 tournamentname='Challenge Cup 1 - 2004'),
    6, 0,
@@ -2472,7 +2599,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=7;
-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 tournamentname='Challenge Cup 1 - 2004'),
    7, 0,
@@ -2495,7 +2621,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8130);
-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 tournamentname='Challenge Cup 1 - 2004'),
    7, 0,
@@ -2518,7 +2643,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('So Deep (Perfect Sphere Mix)')),
    't',
    8352);
-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 tournamentname='Challenge Cup 1 - 2004'),
    7, 0,
@@ -2560,7 +2684,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
   round=8;
-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 tournamentname='Challenge Cup 1 - 2004'),
    8, 0,
@@ -2583,7 +2706,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8781);
-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 tournamentname='Challenge Cup 1 - 2004'),
    8, 0,