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


SET @NAME=185;

USE mitsql;
DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
DELETE FROM DB WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
DELETE FROM DBOwner WHERE UserId = @NAME;
DELETE FROM UserGroup WHERE UserId = @NAME;
DELETE FROM UserQuota WHERE UserId = @NAME;
DELETE FROM UserStat WHERE UserId = @NAME;
DELETE FROM `User` WHERE UserId = @NAME;
Commit	Line	Data
78719756 JP	1
	2	SET @NAME=185;
	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;