]>
Commit | Line | Data |
---|---|---|
78719756 | 1 | |
07e7fa78 | 2 | SET @NAME=1341; |
78719756 JP |
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; | |
07e7fa78 JP |
12 | |
13 | ALTER TABLE `User` AUTO_INCREMENT =1340; |