From 44e46e5c71af611784143a2ebf1a36042c3302ac Mon Sep 17 00:00:00 2001
From: Hugues Hiegel <hugues@hiegel.fr>
Date: Thu, 11 Dec 2008 14:12:11 +0100
Subject: [DB] remove badges variants : script corrections + renaming

---
 database.cleanup             | 17 -----------------
 remove-badges-variants.mysql | 16 ++++++++++++++++
 2 files changed, 16 insertions(+), 17 deletions(-)
 delete mode 100644 database.cleanup
 create mode 100644 remove-badges-variants.mysql

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 ;
-
-
diff --git a/remove-badges-variants.mysql b/remove-badges-variants.mysql
new file mode 100644
index 0000000..8108fad
--- /dev/null
+++ b/remove-badges-variants.mysql
@@ -0,0 +1,16 @@
+
+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.username, badges.type, badges.style, badges.color FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
+DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
+DROP TABLE tmp ;
+
-- 
cgit v1.2.3