CREATE PROCEDURE [dbo].[spUpdateUserProfile] 
	@prf_username	varchar(50),
	@prf_email		varchar(255),
	@prf_birthday	datetime,
	@prf_hide_birthday	int,
	@prf_address	varchar(255),
	@prf_address2	varchar(255),
	@prf_city		varchar(50),
	@prf_state		varchar(50),
	@prf_zip		varchar(20),
	@prf_country	varchar(50),
	@prf_signature	Text
AS
BEGIN
	UPDATE tblUserProfile SET
		profile_email = @prf_email,
		profile_birthday = @prf_birthday,
		profile_hide_birthday = @prf_hide_birthday,
		profile_address = @prf_address,
		profile_address2 = @prf_address2,
		profile_city = @prf_city,
		profile_state = @prf_state,
		profile_zip = @prf_zip,
		profile_country = @prf_country,
		profile_signature = @prf_signature
	WHERE profile_username = @prf_username;
END
