more old code

[sql-web.git] / contrib / deleteuser.sql

diff --git a/contrib/deleteuser.sql b/contrib/deleteuser.sql
index c208ad825dd957534542a6969695aa65f5ffe57f..ed550d48a2c72bad2edc76f5f489181f342e9d45 100644 (file)
--- a/contrib/deleteuser.sql
+++ b/contrib/deleteuser.sql
@@ -1,5 +1,5 @@
 
-SET @NAME=1340;
+SET @NAME=1341;
 
 USE mitsql;
 DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
@@ -9,3 +9,5 @@ DELETE FROM UserGroup WHERE UserId = @NAME;
 DELETE FROM UserQuota WHERE UserId = @NAME;
 DELETE FROM UserStat WHERE UserId = @NAME;
 DELETE FROM `User` WHERE UserId = @NAME;
+
+ALTER TABLE `User` AUTO_INCREMENT =1340;