--- a/roundup/backends/back_mysql.py	Mon May 02 00:45:14 2005 +0000
+++ b/roundup/backends/back_mysql.py	Mon May 02 05:48:59 2005 +0000
@@ -465,6 +465,13 @@
         vals = (int(setid)+1, classname)
         self.sql(sql, vals)
 
+    def clear(self):
+        rdbms_common.Database.clear(self)
+
+        # set the id counters to 0 (setid adds one) so we start at 1
+        for cn in self.classes.keys():
+            self.setid(cn, 0)
+
     def create_class(self, spec):
         rdbms_common.Database.create_class(self, spec)
         sql = 'insert into ids (name, num) values (%s, %s)'