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

[ccbs] / sql / em2-songlist.sql

diff --git a/sql/em2-songlist.sql b/sql/em2-songlist.sql
index a5bacd8b684e0d5af57b3e3e37be5d504c45ffa0..bda7fab78187d588b641a1987556fa1b4f50d5a6 100644 (file)
--- a/sql/em2-songlist.sql
+++ b/sql/em2-songlist.sql
@@ -319,14 +319,14 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8);
-INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Candy','Luv UNLIMITED',192,192);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9);
+INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Candy☆','Luv UNLIMITED',192,192);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy☆'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9);
 INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Crash!','mr. Brian & The Final Band',200,200);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4);