DROP   PROCEDURE Users_Delete;
DELIMITER //
CREATE PROCEDURE Users_Delete
(
  $Sid  CHAR(64),
  $USER INT(11)
)
BEGIN

DECLARE $email TEXT;

IF @@read_only THEN

    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'READ_ONLY';

ELSE

	IF "" != $Sid THEN
        CALL Base_Users_Authorise_Sessionid( $Sid, @email, @USER, @idtype );
        INSERT INTO users_deleted VALUES ( @USER, $USER );
	END IF;

	SELECT email INTO $email FROM users WHERE USER=$USER;

	DELETE FROM users_activations          WHERE USER=$USER;
	DELETE FROM users_alternate_emails     WHERE USER=$USER;
	DELETE FROM users_send_resets          WHERE USER=$USER;
	DELETE FROM users_sessions             WHERE email=$email;
	DELETE FROM users_uids                 WHERE USER=$USER;
	DELETE FROM users_termination_schedule WHERE USER=$USER;
	DELETE FROM users                      WHERE USER=$USER;

END IF;

END
//
DELIMITER ;