Make DDR Europe parser script convert from ISO8859-1 to UTF-8. Update test SQL accord...

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

diff --git a/sql/cc04/cc4-04.sql b/sql/cc04/cc4-04.sql
index e3f985037f1762cb0a13dfceaf98856fc7b68ecd..292a5620302a54a32d5e35d9154fe29e2a80fb05 100644 (file)
--- 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',