Make sure players are created before adding them to the rankings. Update test SQL.

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

diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql
index 8c6fcdf6d8273dfc109a30cc2d8336fad2f034f7..07f07c08391807cc87881a0c659b7fae3b9a347b 100644 (file)
--- a/sql/cc04/cc6-04.sql
+++ b/sql/cc04/cc6-04.sql
@@ -9,126 +9,246 @@ 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 6'),
-   1, 'Snute', 0);
+   1,
+   (SELECT player FROM players WHERE nick='Snute'),
+   0);
+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 6'),
-   2, 'DufF', 0);
+   2,
+   (SELECT player FROM players WHERE nick='DufF'),
+   0);
+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 6'),
-   3, 'OJK', 81);
+   3,
+   (SELECT player FROM players WHERE nick='OJK'),
+   81);
+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 6'),
-   4, 'Snofox', 73);
+   4,
+   (SELECT player FROM players WHERE nick='Snofox'),
+   73);
+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 6'),
-   5, 'Oliyzia', 66);
+   5,
+   (SELECT player FROM players WHERE nick='Oliyzia'),
+   66);
+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 6'),
-   6, 'Haggar', 60);
+   6,
+   (SELECT player FROM players WHERE nick='Haggar'),
+   60);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   7, 'Nameless', 55);
+   7,
+   (SELECT player FROM players WHERE nick='Nameless'),
+   55);
+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 6'),
-   8, 'Ylini', 51);
+   8,
+   (SELECT player FROM players WHERE nick='Ylini'),
+   51);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   9, 'Bonzo', 48);
+   9,
+   (SELECT player FROM players WHERE nick='Bonzo'),
+   48);
+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 6'),
-   10, 'T|na', 46);
+   10,
+   (SELECT player FROM players WHERE nick='T|na'),
+   46);
+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 6'),
-   11, 'Daniil', 45);
+   11,
+   (SELECT player FROM players WHERE nick='Daniil'),
+   45);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   12, 'Pingo', 44);
+   12,
+   (SELECT player FROM players WHERE nick='Pingo'),
+   44);
+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 6'),
-   13, 'RiChY', 0);
+   13,
+   (SELECT player FROM players WHERE nick='RiChY'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   14, 'ViD', 42);
+   14,
+   (SELECT player FROM players WHERE nick='ViD'),
+   42);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   15, 'Felz', 41);
+   15,
+   (SELECT player FROM players WHERE nick='Felz'),
+   41);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   16, 'Gogo', 40);
+   16,
+   (SELECT player FROM players WHERE nick='Gogo'),
+   40);
+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 6'),
-   17, 'Smiph', 39);
+   17,
+   (SELECT player FROM players WHERE nick='Smiph'),
+   39);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   18, 'Mync', 38);
+   18,
+   (SELECT player FROM players WHERE nick='Mync'),
+   38);
+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 6'),
-   19, 'Duckling', 0);
+   19,
+   (SELECT player FROM players WHERE nick='Duckling'),
+   0);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   20, 'Goku', 36);
+   20,
+   (SELECT player FROM players WHERE nick='Goku'),
+   36);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   21, 'Th0rny', 35);
+   21,
+   (SELECT player FROM players WHERE nick='Th0rny'),
+   35);
+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 6'),
-   22, 'Matsi', 34);
+   22,
+   (SELECT player FROM players WHERE nick='Matsi'),
+   34);
+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 6'),
-   23, 'Draconia', 33);
+   23,
+   (SELECT player FROM players WHERE nick='Draconia'),
+   33);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   24, 'Ozon', 32);
+   24,
+   (SELECT player FROM players WHERE nick='Ozon'),
+   32);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   25, 'Andeplane', 31);
+   25,
+   (SELECT player FROM players WHERE nick='Andeplane'),
+   31);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   26, 'Alexxz', 30);
+   26,
+   (SELECT player FROM players WHERE nick='Alexxz'),
+   30);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   27, 'Electron', 29);
+   27,
+   (SELECT player FROM players WHERE nick='Electron'),
+   29);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   28, 'Pyro', 28);
+   28,
+   (SELECT player FROM players WHERE nick='Pyro'),
+   28);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   29, 'Matti', 27);
+   29,
+   (SELECT player FROM players WHERE nick='Matti'),
+   27);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   30, 'Athena', 26);
+   30,
+   (SELECT player FROM players WHERE nick='Athena'),
+   26);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   31, 'Hyper', 25);
+   31,
+   (SELECT player FROM players WHERE nick='Hyper'),
+   25);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   32, 'Zackie', 24);
+   32,
+   (SELECT player FROM players WHERE nick='Zackie'),
+   24);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   33, 'Montana', 23);
+   33,
+   (SELECT player FROM players WHERE nick='Montana'),
+   23);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   34, 'Annkakri', 22);
+   34,
+   (SELECT player FROM players WHERE nick='Annkakri'),
+   22);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   35, 'Glukko', 21);
+   35,
+   (SELECT player FROM players WHERE nick='Glukko'),
+   21);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   36, 'Glock', 20);
+   36,
+   (SELECT player FROM players WHERE nick='Glock'),
+   20);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   37, 'v|per', 19);
+   37,
+   (SELECT player FROM players WHERE nick='v|per'),
+   19);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   38, 'Ifrit', 18);
+   38,
+   (SELECT player FROM players WHERE nick='Ifrit'),
+   18);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   39, 'JonAnders', 17);
+   39,
+   (SELECT player FROM players WHERE nick='JonAnders'),
+   17);
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
 INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
-   40, 'Guru', 16);
+   40,
+   (SELECT player FROM players WHERE nick='Guru'),
+   16);
 INSERT INTO rounds (tournament, round, randomsongs, chosensongs) 
   VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
@@ -153,7 +273,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pyro' AS nick WHERE 'Pyro' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 1,
@@ -184,7 +303,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7419);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Th0rny' AS nick WHERE 'Th0rny' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 1,
@@ -215,7 +333,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dead End')),
    't',
    8128);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glukko' AS nick WHERE 'Glukko' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 1,
@@ -246,7 +363,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Never Let You Down')),
    't',
    6217);
-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 6'),
    1, 1,
@@ -277,7 +393,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    7682);
-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 6'),
    1, 1,
@@ -308,7 +423,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    7879);
-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 6'),
    1, 1,
@@ -358,7 +472,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Glock' AS nick WHERE 'Glock' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 2,
@@ -389,7 +502,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('My Summer Love')),
    't',
    6209);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Athena' AS nick WHERE 'Athena' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 2,
@@ -420,7 +532,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6770);
-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 6'),
    1, 2,
@@ -451,7 +562,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8000);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 2,
@@ -482,7 +592,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Dynamite Rave')),
    't',
    8087);
-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 6'),
    1, 2,
@@ -513,7 +622,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',
    8164);
-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 6'),
    1, 2,
@@ -563,7 +671,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ifrit' AS nick WHERE 'Ifrit' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 3,
@@ -594,7 +701,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',
    6459);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 3,
@@ -625,7 +731,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',
    8600);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Hyper' AS nick WHERE 'Hyper' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 3,
@@ -656,7 +761,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',
    7931);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Andeplane' AS nick WHERE 'Andeplane' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 3,
@@ -687,7 +791,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8175);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 3,
@@ -718,7 +821,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7759);
-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 6'),
    1, 3,
@@ -749,7 +851,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',
    7904);
-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 6'),
    1, 3,
@@ -799,7 +900,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Electron' AS nick WHERE 'Electron' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 4,
@@ -830,7 +930,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',
    7443);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Guru' AS nick WHERE 'Guru' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 4,
@@ -861,7 +960,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    4905);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Annkakri' AS nick WHERE 'Annkakri' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 4,
@@ -892,7 +990,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',
    6245);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 4,
@@ -923,7 +1020,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8080);
-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 6'),
    1, 4,
@@ -954,7 +1050,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',
    7977);
-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 6'),
    1, 4,
@@ -985,7 +1080,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',
    7425);
-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 6'),
    1, 4,
@@ -1035,7 +1129,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Goku' AS nick WHERE 'Goku' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1066,7 +1159,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',
    8359);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Montana' AS nick WHERE 'Montana' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1097,7 +1189,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    6637);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'JonAnders' AS nick WHERE 'JonAnders' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1128,7 +1219,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Don\'t Try to Stop It')),
    't',
    5502);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Alexxz' AS nick WHERE 'Alexxz' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1159,7 +1249,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7984);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1190,7 +1279,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8393);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 5,
@@ -1221,7 +1309,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8218);
-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 6'),
    1, 5,
@@ -1271,7 +1358,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Matti' AS nick WHERE 'Matti' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 6,
@@ -1302,7 +1388,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    6848);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'v|per' AS nick WHERE 'v|per' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 6,
@@ -1333,7 +1418,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',
    6587);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Zackie' AS nick WHERE 'Zackie' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 6,
@@ -1364,7 +1448,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    7930);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 6,
@@ -1395,7 +1478,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8405);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Ozon' AS nick WHERE 'Ozon' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    1, 6,
@@ -1426,7 +1508,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7400);
-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 6'),
    1, 6,
@@ -1457,7 +1538,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',
    8174);
-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 6'),
    1, 6,
@@ -1512,7 +1592,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=2;
-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 6'),
    2, 1,
@@ -1543,7 +1622,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8642);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'ViD' AS nick WHERE 'ViD' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 1,
@@ -1574,7 +1652,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8193);
-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 6'),
    2, 1,
@@ -1605,7 +1682,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',
    8246);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 1,
@@ -1636,7 +1712,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8578);
-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 6'),
    2, 1,
@@ -1667,7 +1742,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Spin the disc')),
    't',
    7791);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Gogo' AS nick WHERE 'Gogo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 1,
@@ -1717,7 +1791,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=2;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Felz' AS nick WHERE 'Felz' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 2,
@@ -1748,7 +1821,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    7990);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Mync' AS nick WHERE 'Mync' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 2,
@@ -1779,7 +1851,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Afronova')),
    't',
    7743);
-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 6'),
    2, 2,
@@ -1810,7 +1881,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8418);
-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 6'),
    2, 2,
@@ -1841,7 +1911,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8644);
-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 6'),
    2, 2,
@@ -1872,7 +1941,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine (Luv Mix)')),
    't',
    8377);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 2,
@@ -1922,7 +1990,6 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') 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 6'),
    2, 3,
@@ -1953,7 +2020,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8168);
-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 6'),
    2, 3,
@@ -1984,7 +2050,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    7971);
-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 6'),
    2, 3,
@@ -2015,7 +2080,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8686);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pingo' AS nick WHERE 'Pingo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    2, 3,
@@ -2046,7 +2110,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8544);
-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 6'),
    2, 3,
@@ -2077,7 +2140,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',
    8793);
-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 6'),
    2, 3,
@@ -2127,7 +2189,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=3;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    3, 0,
@@ -2150,7 +2211,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8627);
-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 6'),
    3, 0,
@@ -2173,7 +2233,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8550);
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Bonzo' AS nick WHERE 'Bonzo' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    3, 0,
@@ -2196,7 +2255,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8133);
-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 6'),
    3, 0,
@@ -2219,7 +2277,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8414);
-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 6'),
    3, 0,
@@ -2242,7 +2299,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',
    8635);
-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 6'),
    3, 0,
@@ -2265,7 +2321,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8459);
-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 6'),
    3, 0,
@@ -2288,7 +2343,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Trip Machine Climax')),
    't',
    8367);
-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 6'),
    3, 0,
@@ -2311,7 +2365,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('End of the Century')),
    't',
    8743);
-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 6'),
    3, 0,
@@ -2353,7 +2406,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') AND 
   round=4;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Nameless' AS nick WHERE 'Nameless' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'),
    4, 0,
@@ -2376,7 +2428,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8675);
-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 6'),
    4, 0,
@@ -2399,7 +2450,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    't',
    8557);
-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 6'),
    4, 0,
@@ -2422,7 +2472,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8753);
-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 6'),
    4, 0,
@@ -2445,7 +2494,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',
    8802);
-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 6'),
    4, 0,
@@ -2468,7 +2516,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Exotic Ethnic')),
    't',
    8826);
-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 6'),
    4, 0,
@@ -2491,7 +2538,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Tsugaru')),
    't',
    8493);
-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 6'),
    4, 0,
@@ -2533,7 +2579,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') 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 tournamentname='Challenge Cup 6'),
    5, 0,
@@ -2556,7 +2601,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8825);
-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 6'),
    5, 0,
@@ -2579,7 +2623,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',
    8636);
-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 6'),
    5, 0,
@@ -2602,7 +2645,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',
    8868);
-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 6'),
    5, 0,
@@ -2625,7 +2667,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',
    8169);
-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 6'),
    5, 0,
@@ -2667,7 +2708,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') 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 6'),
    6, 0,
@@ -2690,7 +2730,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    't',
    8499);
-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 6'),
    6, 0,
@@ -2713,7 +2752,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8241);
-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 6'),
    6, 0,
@@ -2736,7 +2774,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Healing Vision (Angelic Mix)')),
    't',
    8776);
-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 6'),
    6, 0,
@@ -2778,7 +2815,6 @@ UPDATE rounds SET randomsongs=1 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') 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 6'),
    7, 0,
@@ -2801,7 +2837,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
    't',
    8841);
-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 6'),
    7, 0,
@@ -2824,7 +2859,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    8803);
-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 6'),
    7, 0,
@@ -2868,7 +2902,6 @@ INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
 UPDATE rounds SET randomsongs=2 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6') 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 6'),
    8, 0,
@@ -2891,7 +2924,6 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Max 300')),
    'f',
    9140);
-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 6'),
    8, 0,