CleanupUserLockout

BEGIN

    DROP TEMPORARY TABLE IF EXISTS `TempUserLockout`;

    CREATE TEMPORARY TABLE `TempUserLockout` SELECT uals.* FROM `userauthenticationlockoutstats` uals, `users` u WHERE uals.UserID = u.UserId;

    TRUNCATE TABLE `userauthenticationlockoutstats`;

    INSERT INTO `userauthenticationlockoutstats` SELECT * FROM `TempUserLockout`;

    DROP TEMPORARY TABLE `TempUserLockout`;

END