"Candy" now has a white star by it; updated parsers and all relevant SQL.

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

diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql
index ddb4b5fd85fc62159a099fda1d904cfc976e9dea..94b715e4b20bbe15ae01b89b84d5d83ca66c3456 100644 (file)
--- a/sql/cc04/cc1-04.sql
+++ b/sql/cc04/cc1-04.sql
@@ -229,7 +229,7 @@ INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
 INSERT INTO roundrandomsongs (tournament, round, parallel, song) VALUES (
    (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'),
    1, 1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy'))
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆'))
 );
 UPDATE rounds SET randomsongs=2 WHERE 
   tournament=(SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004') AND 
@@ -256,7 +256,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 1,
    (SELECT player FROM players WHERE nick='Haggar'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    7204);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -286,7 +286,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 1,
    (SELECT player FROM players WHERE nick='Ylini'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    6302);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -316,7 +316,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 1,
    (SELECT player FROM players WHERE nick='Mulefisk'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    7205);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -346,7 +346,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 1,
    (SELECT player FROM players WHERE nick='Slusk'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    6465);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -376,7 +376,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    1, 1,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    'f',
    8480);
 INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chosen, score) VALUES (
@@ -2297,7 +2297,7 @@ INSERT INTO scores (tournament, round, parallel, player, songnumber, song, chose
    4, 0,
    (SELECT player FROM players WHERE nick='Tom'),
    1,
-   (SELECT song FROM songs WHERE lower(title)=lower('Candy')),
+   (SELECT song FROM songs WHERE lower(title)=lower('Candy☆')),
    't',
    8379);
 INSERT INTO roundparticipation (tournament, round, parallel, player, position) VALUES (