-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------


-- Dumping structure for function auth_db.check_user_credentials
DELIMITER //
CREATE FUNCTION `check_user_credentials`(p_username VARCHAR(50),
    p_password VARCHAR(255)
) RETURNS tinyint(4)
    DETERMINISTIC
BEGIN
    DECLARE result TINYINT;

    RETURN result;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;

-- Dumping structure for function auth_db.is_user_logged_in
DELIMITER //
CREATE FUNCTION `is_user_logged_in`(p_username VARCHAR(50)) RETURNS tinyint(4)
    DETERMINISTIC
BEGIN
    DECLARE result TINYINT DEFAULT 0;

    RETURN result;
END//
DELIMITER ;
    END IF;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;
END//
DELIMITER ;

