Started on a bigscreen SQL schema.

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

diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql
index 66b85fb95c5564b53952e4e9b3ea2c4119bd368d..07f07c08391807cc87881a0c659b7fae3b9a347b 100644 (file)
--- a/sql/cc04/cc6-04.sql
+++ b/sql/cc04/cc6-04.sql
@@ -9,6 +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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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,
+   (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'),
@@ -33,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,
@@ -64,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,
@@ -95,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,
@@ -126,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,
@@ -157,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,
@@ -188,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,
@@ -238,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,
@@ -269,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,
@@ -300,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,
@@ -331,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,
@@ -362,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,
@@ -393,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,
@@ -443,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,
@@ -474,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,
@@ -505,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,
@@ -536,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,
@@ -567,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,
@@ -598,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,
@@ -629,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,
@@ -679,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,
@@ -710,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,
@@ -741,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,
@@ -772,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,
@@ -803,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,
@@ -834,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,
@@ -865,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,
@@ -915,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,
@@ -946,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,
@@ -977,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,
@@ -1008,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,
@@ -1039,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,
@@ -1070,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,
@@ -1101,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,
@@ -1151,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,
@@ -1182,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,
@@ -1213,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,
@@ -1244,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,
@@ -1275,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,
@@ -1306,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,
@@ -1337,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,
@@ -1392,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,
@@ -1423,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,
@@ -1454,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,
@@ -1485,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,
@@ -1516,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,
@@ -1547,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,
@@ -1597,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,
@@ -1628,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,
@@ -1659,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,
@@ -1690,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,
@@ -1721,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,
@@ -1752,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,
@@ -1802,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,
@@ -1833,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,
@@ -1864,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,
@@ -1895,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,
@@ -1926,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,
@@ -1957,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,
@@ -2007,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,
@@ -2030,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,
@@ -2053,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,
@@ -2076,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,
@@ -2099,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,
@@ -2122,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,
@@ -2145,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,
@@ -2168,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,
@@ -2191,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,
@@ -2233,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,
@@ -2256,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,
@@ -2279,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,
@@ -2302,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,
@@ -2325,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,
@@ -2348,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,
@@ -2371,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,
@@ -2413,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,
@@ -2436,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,
@@ -2459,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,
@@ -2482,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,
@@ -2505,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,
@@ -2547,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,
@@ -2570,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,
@@ -2593,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,
@@ -2616,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,
@@ -2658,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,
@@ -2681,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,
@@ -2704,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,
@@ -2748,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,
@@ -2771,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,