X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc04%2Fcc3-04.sql;fp=sql%2Fcc04%2Fcc3-04.sql;h=b235ff4bfd24fe1546d53bfa3356ff4df595ace0;hp=606bbdd6ed393e7bc76a3e9e5ffe80878fd19772;hb=29b7d13a713879f6a1db0d2040fc37a558d9a330;hpb=7ef3ba3f1bf9b5114f60614458d9ae4cb0327bbb

diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql
index 606bbdd..b235ff4 100644
--- a/sql/cc04/cc3-04.sql
+++ b/sql/cc04/cc3-04.sql
@@ -64,17 +64,17 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    (SELECT song FROM songs WHERE lower(title)=lower('Crash!')),
    't',
    7032);
-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 3'),
    1, 1,
-   (SELECT player FROM players WHERE nick='Pål Andre'),
+   (SELECT player FROM players WHERE nick='PÃ¥l Andre'),
    2
 );
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'),
    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('B4U (B4 Za Beat Mix)')),
    'f',
@@ -82,7 +82,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 3'),
    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('Can\'t Stop Fallin\' in Love')),
    'f',
@@ -90,7 +90,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 3'),
    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('Dead End')),
    't',