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


SET @NAME=1341;

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;

ALTER TABLE `User` AUTO_INCREMENT =1340;
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
07e7fa78 JP	13	ALTER TABLE `User` AUTO_INCREMENT =1340;