X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fex-songlist.sql;h=040b7aa380094d60521f0f3258278ae689678b08;hb=8963fce7337a09bdcfea051a81c0c3d9281acd6e;hp=d1c6c675b5a690a220930fa935102a8dfee90667;hpb=08596cd49fe5137da3e1a1a72b68a1311f85ff2d;p=ccbs
diff --git a/sql/ex-songlist.sql b/sql/ex-songlist.sql
index d1c6c67..040b7aa 100644
--- 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, '♥LOVE2 SUGAR♥' AS title, 'dj TAKA featuring Noria' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('♥LOVE2 SUGAR♥') NOT IN ( SELECT LOWER(title) FROM songs );
-INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 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('♥LOVE2 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('♥LOVE2 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('♥LOVE2 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('♥LOVE2 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('♥LOVE2 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('♥LOVE2 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('♥LOVE2 SUGAR♥')),(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é (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, '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);