Started on a bigscreen SQL schema.

[ccbs] / sql / ex-songlist.sql

diff --git a/sql/ex-songlist.sql b/sql/ex-songlist.sql
index d1c6c675b5a690a220930fa935102a8dfee90667..040b7aa380094d60521f0f3258278ae689678b08 100644 (file)
--- a/sql/ex-songlist.sql
+++ b/sql/ex-songlist.sql
@@ -96,16 +96,16 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'LOVE ♥ SHINE' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('LOVE ♥ SHINE') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE') ), ( 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('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(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('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',4);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'LOVE ❤ SHINE' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('LOVE ❤ SHINE') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE') ), ( 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('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(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('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MEMORIES' AS title, 'NAOKI feat. PAULA TERRY' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MEMORIES') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MEMORIES') ), ( 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('MEMORIES')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
@@ -217,14 +217,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'B4U (B4 ZA BEAT MIX
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('B4U (B4 ZA BEAT MIX)') ), ( 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('B4U (B4 ZA BEAT MIX)')),(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('B4U (B4 ZA BEAT MIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRE∀K DOWN!' AS title, 'Be For U' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRE∀K DOWN!') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!') ), ( 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('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRE∀K DOWN!' AS title, 'Be For U' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRE∀K DOWN!') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!') ), ( 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('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(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('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRILLIANT 2U (K.O.G. G3 MIX)' AS title, 'NAOKI' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRILLIANT 2U (K.O.G. G3 MIX)') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRILLIANT 2U (K.O.G. G3 MIX)') ), ( 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('BRILLIANT 2U (K.O.G. G3 MIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7);
@@ -233,14 +233,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BURNIN\' THE FLOOR
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BURNIN\' THE FLOOR (BLUE FIRE mix)') ), ( 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('BURNIN\' THE FLOOR (BLUE FIRE mix)')),(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('BURNIN\' THE FLOOR (BLUE FIRE mix)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY♥' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY♥') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥') ), ( 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♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(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♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY❤' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY❤') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤') ), ( 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❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(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❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CELEBRATE NITE (EURO TRANCE STYLE)' AS title, 'N.M.R.' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CELEBRATE NITE (EURO TRANCE STYLE)') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CELEBRATE NITE (EURO TRANCE STYLE)') ), ( 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('CELEBRATE NITE (EURO TRANCE STYLE)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8);
@@ -399,14 +399,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'SUPER STAR (FROM NO
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('SUPER STAR (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('SUPER STAR (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('SUPER STAR (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Sweet Sweet ♥ Magic' AS title, 'jun' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Sweet Sweet ♥ Magic') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic') ), ( 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('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(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('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Sweet Sweet ❤ Magic' AS title, 'jun' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Sweet Sweet ❤ Magic') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic') ), ( 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('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(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('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'THE REFLEX' AS title, 'DURAN DURAN' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('THE REFLEX') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('THE REFLEX') ), ( 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('THE REFLEX')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',2);
@@ -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★' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY★') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★') ), ( 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★')),(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★')),(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★')),(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★')),(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★')),(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★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY★' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY★') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★') ), ( 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★')),(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★')),(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★')),(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★')),(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★')),(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★')),(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);
@@ -1503,15 +1503,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Matsuri JAPAN')),(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('Matsuri JAPAN')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Matsuri JAPAN')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MOBO★MOGA' AS title, 'Orange Lounge' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MOBO★MOGA') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA') ), ( 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('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(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('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MOBO★MOGA' AS title, 'Orange Lounge' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MOBO★MOGA') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA') ), ( 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('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(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('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'STAY (Organic house Version)' AS title, 'emi' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('STAY (Organic house Version)') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('STAY (Organic house Version)') ), ( 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('STAY (Organic house Version)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
@@ -1595,15 +1595,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',5);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',8);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '&hearts;LOVE<sup>2</sup> SUGAR&hearts;' AS title, 'dj TAKA featuring Noria' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;') ), ( 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('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(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('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(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('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('&hearts;LOVE<sup>2</sup> SUGAR&hearts;')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '❤LOVE² SUGAR❤' AS title, 'dj TAKA featuring Noria' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('❤LOVE² SUGAR❤') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤') ), ( 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('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(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('❤LOVE² SUGAR❤')),(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('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Daikenkai' AS title, 'Des-ROW feat. TSUBOI for ALPHA' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Daikenkai') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Daikenkai') ), ( 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('Daikenkai')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
@@ -1845,15 +1845,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5);
 INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',6);
-INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'L\'amour et la libert&#233; (DDR ver.)' AS title, 'NAOKI underground' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('L\'amour et la libert&#233; (DDR ver.)') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la libert&#233; (DDR ver.)') ), ( 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('L\'amour et la libert&#233; (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la libert&#233; (DDR ver.)')),(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('L\'amour et la libert&#233; (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
-INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la libert&#233; (DDR ver.)')),(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('L\'amour et la libert&#233; (DDR ver.)')),(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('L\'amour et la libert&#233; (DDR ver.)')),(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('L\'amour et la libert&#233; (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
+INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'L\'amour et la liberté (DDR ver.)' AS title, 'NAOKI underground' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('L\'amour et la liberté (DDR ver.)') NOT IN ( SELECT LOWER(title) FROM songs );
+INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)') ), ( 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('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(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('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(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('L\'amour et la liberté (DDR ver.)')),(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('L\'amour et la liberté (DDR ver.)')),(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('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7);
 INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Last Message' AS title, 'good-cool feat. Meg' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Last Message') NOT IN ( SELECT LOWER(title) FROM songs );
 INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Last Message') ), ( 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('Last Message')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);