1

Closed

Users in doodleUser table are not deleted

description

When deleting an event, the users arn't deleted..
Closed Mar 27, 2008 at 3:11 PM by runetk
CREATE TRIGGER deleteUser ON doodleVote
FOR DELETE AS
DELETE FROM doodleUser WHERE id = (SELECT userId FROM Deleted)

Changed to:

CREATE TRIGGER deleteUser ON doodleVote
FOR DELETE AS
DELETE FROM doodleUser WHERE id IN (SELECT userId FROM Deleted)

comments