From: Steinar H. Gunderson <sgunderson@bigfoot.com>
Date: Sat, 19 Feb 2005 19:31:34 +0000 (+0000)
Subject: Add some common EM2 song titles.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=013a49ad36808700c2c3a12445c7c713a1b0b8b8

Add some common EM2 song titles.
---

diff --git a/sql/shorttitles.sql b/sql/shorttitles.sql
new file mode 100644
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;