Add some common EM2 song titles.

[ccbs] / sql / shorttitles.sql

diff --git a/sql/shorttitles.sql b/sql/shorttitles.sql
new file mode 100644 (file)
index 0000000..9dd1e23
--- /dev/null
+++ b/sql/shorttitles.sql
@@ -0,0 +1,15 @@
+--- manually edited
+begin;
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='paranoia rebirth' ), 'Rebirth');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='paranoia kcet (clean mix)' ), 'KCET');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='can\'t stop fallin\' in love (speed mix)' ), 'CSFILSM');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='electro tuned (the subs mix)' ), 'ET');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='healing vision (angelic mix)' ), 'HVAM');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='so deep (perfect sphere mix)' ), 'So Deep');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='era (nostalmix)' ), 'era');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='exotic ethnic' ), 'EE');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='trip machine (luv mix)' ), 'Luv mix');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='afronova primeval' ), 'Primeval');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='jam jam reggae (am swing mix)' ), 'Jam jam');
+INSERT INTO songshorttitles VALUES ( ( SELECT song FROM songs WHERE lower(title)='my summer love' ), 'MSL');
+commit;