USE [l3dev2]
GO
/****** Object:  StoredProcedure [dbo].[usp_profileUserSaveCouple]    Script Date: 11/30/2015 3:09:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_profileUserSaveCouple]
(
    @UserId INT,
    @CoupleType INT,
    @CoupleGender nvarchar(2),
    @CoupleOrientation INT,
    @DOB nvarchar(10),
    @Gender nvarchar(1),
    @Height INT,
    @Ethnicity INT,
    @HairColour INT,
    @BodyType INT,
    @EyeColour INT,
    @SexualOrientation INT,
    @Occupation INT,
    @Personality INT,
    @Interests nvarchar(255)
)
AS
BEGIN

    SET NOCOUNT ON;

        UPDATE
            [dbo].[user_couple]
        SET
            [user_id] = @UserId,
            [couple_type] = @CoupleType,
            [couple_gender] = @CoupleGender,
            [couple_orientation] = @CoupleOrientation,
            [dob] = @DOB,
            [gender] = @Gender,
            [height] = @Height,
            [ethnicity] = @Ethnicity,
            [hair_colour] = @HairColour,
            [body_type] = @BodyType,
            [eye_colour] = @EyeColour,
            [sexual_orientation] = @SexualOrientation,
            [occupation] = @Occupation,
            [personality] = @Personality,
            [interests] = @interests
        WHERE [user_id] = @UserId

END