CREATE PROCEDURE [dbo].[spInsertUserRegistration] 
	@prf_username	varchar(50),
	@prf_password	varchar(50),
	@prf_permission	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
	INSERT INTO tblUsers
	(
		username,
		password,
		permission
	) 
	VALUES
	(
		@prf_username,
		@prf_password,
		@prf_permission
	);

	INSERT INTO tblUserProfile
	(
		profile_username,
		profile_email,
		profile_birthday,
		profile_hide_birthday,
		profile_address,
		profile_address2,
		profile_city,
		profile_state,
		profile_zip,
		profile_country,
		profile_signature
	)
	VALUES
	(
		@prf_username,
		@prf_email,
		@prf_birthday,
		@prf_hide_birthday,
		@prf_address,
		@prf_address2,
		@prf_city,
		@prf_state,
		@prf_zip,
		@prf_country,
		@prf_signature
	);
END
