[DB] remove badges variants : script corrections + renaming

1 files changed, 0 insertions, 17 deletions

diff --git a/database.cleanup b/database.cleanup
deleted file mode 100644
index 1d3d918..0000000
--- a/database.cleanup
+++ /dev/null
@@ -1,17 +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 * FROM tmp WHERE count > 1 ;
-DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND tmp.count > 1 ;
-DROP TABLE tmp ;
-
-