create schema gilbert_sip;
USE gilbert_sip;

drop procedure if exists Validate_Login;
DELIMITER //
CREATE Procedure Validate_Login(IN passedUser VARCHAR(255), IN passedPassword VARCHAR(255), OUT success INT )
BEGIN
    DECLARE storedUser VARCHAR(255);
    DECLARE storedPass VARCHAR(255);

    SELECT userName INTO storedUser
    FROM gilbert_sip.login
    WHERE userName = passedUser;

    IF storedUser IS NOT NULL THEN
        SELECT password INTO storedPass
        FROM gilbert_sip.login
        WHERE userName = storedUser AND password = passedPassword;
    END IF; -- dont forget me

    IF storedPass IS NOT NULL THEN
        SET success = 1;
    ELSE
        SET success = 0;
    END IF; -- dont forget me
    -- RETURN success; -- ooops dont do this it is not a function
END//

DELIMITER ;