]>
Commit | Line | Data |
---|---|---|
1 | ||
2 | SET @NAME=1341; | |
3 | ||
4 | USE mitsql; | |
5 | DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME); | |
6 | DELETE FROM DB WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME); | |
7 | DELETE FROM DBOwner WHERE UserId = @NAME; | |
8 | DELETE FROM UserGroup WHERE UserId = @NAME; | |
9 | DELETE FROM UserQuota WHERE UserId = @NAME; | |
10 | DELETE FROM UserStat WHERE UserId = @NAME; | |
11 | DELETE FROM `User` WHERE UserId = @NAME; | |
12 | ||
13 | ALTER TABLE `User` AUTO_INCREMENT =1340; |