X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/89905822275ff9062a8fefb007b088abee0b0b45..07e7fa78cd0a0483e7c88bd240d0ae06870a8d6c:/contrib/deleteuser.sql diff --git a/contrib/deleteuser.sql b/contrib/deleteuser.sql index c208ad8..ed550d4 100644 --- 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;