X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc4-04.sql;h=292a5620302a54a32d5e35d9154fe29e2a80fb05;hp=e3f985037f1762cb0a13dfceaf98856fc7b68ecd;hb=29b7d13a713879f6a1db0d2040fc37a558d9a330;hpb=7ef3ba3f1bf9b5114f60614458d9ae4cb0327bbb

diff --git a/sql/cc04/cc4-04.sql b/sql/cc04/cc4-04.sql
index e3f9850..292a562 100644
--- a/sql/cc04/cc4-04.sql
+++ b/sql/cc04/cc4-04.sql
@@ -33,17 +33,17 @@ UPDATE rounds SET randomsongs=2 WHERE
 UPDATE rounds SET chosensongs=1 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4') AND 
   round=1;
-INSERT INTO players SELECT nextval('players_player_seq') AS player, 'Pål Andre' AS nick WHERE 'Pål Andre' NOT IN ( SELECT nick FROM players );
+INSERT INTO players SELECT nextval('players_player_seq') AS player, 'PÃ¥l Andre' AS nick WHERE 'PÃ¥l Andre' NOT IN ( SELECT nick FROM players );
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
    1, 1,
-   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT player FROM players WHERE nick='PÃ¥l Andre'),
    1
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
    1, 1,
-   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT player FROM players WHERE nick='PÃ¥l Andre'),
    0,
    (SELECT song FROM songs WHERE lower(title)=lower('Nori Nori Nori')),
    'f',
@@ -51,7 +51,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
    1, 1,
-   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT player FROM players WHERE nick='PÃ¥l Andre'),
    1,
    (SELECT song FROM songs WHERE lower(title)=lower('PARANOiA Rebirth')),
    'f',
@@ -59,7 +59,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'),
    1, 1,
-   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT player FROM players WHERE nick='PÃ¥l Andre'),
    2,
    (SELECT song FROM songs WHERE lower(title)=lower('Paranoia KCET (Clean Mix)')),
    't',