[DataBase] little cleanup

1 files changed, 0 insertions, 32 deletions

diff --git a/remove-badges-variants.mysql b/remove-badges-variants.mysql
deleted file mode 100644
index 3f29d2a..0000000
--- a/remove-badges-variants.mysql
+++ /dev/null
@@ -1,32 +0,0 @@
-
-USE lastfm
-
-
-/**
- * Deletes all entries in badges
- * for each unique username + type
- * where more than one style or color exists
- */
-
-DROP TABLE IF EXISTS tmp ;
-CREATE TEMPORARY TABLE tmp (SELECT username, type, COUNT(username) AS count FROM badges GROUP BY username, type ) ;
-
-SELECT badges.png
-	FROM badges, tmp
-	WHERE badges.username = tmp.username
-	AND ( (badges.type = tmp.type AND tmp.count > 1)
-	   OR ( (badges.type LIKE concat(tmp.type,"%") OR tmp.type LIKE concat(badges.type,"%"))
-		 AND badges.type != tmp.type )
-	   ) ;
-
-DELETE badges.*
-	FROM badges, tmp
-	WHERE badges.username = tmp.username
-	AND ( (badges.type = tmp.type AND tmp.count > 1)
-	   OR ( (badges.type LIKE concat(tmp.type,"%") OR tmp.type LIKE concat(badges.type,"%"))
-		 AND badges.type != tmp.type )
-	   ) ;
-
-
-DROP TABLE tmp ;
-