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

[ccbs] / sql / ex-songlist.sql

diff --git a/sql/ex-songlist.sql b/sql/ex-songlist.sql
index 040b7aa380094d60521f0f3258278ae689678b08..24dd1f5616d1a9a5bdd5c07403f0cad53b116d6f 100644 (file)
--- a/sql/ex-songlist.sql
+++ b/sql/ex-songlist.sql
@@ -447,14 +447,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'WILD RUSH (FROM NON
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' );
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDYâ\98\85' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDYâ\98\85') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' );
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\85')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDYâ\98\86' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDYâ\98\86') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' );
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDYâ\98\86')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'COW GIRL' AS title, 'BAMBEE' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('COW GIRL') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('COW GIRL') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' );
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('COW GIRL')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);