]>
Commit | Line | Data |
---|---|---|
78719756 | 1 | |
f25fdd0a | 2 | SET @NAME=185; |
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; |