CREATE PROCEDURE [dbo].[up_guild_member_remove]
	@guild_id   	[uniqueidentifier],
	@character_id   [uniqueidentifier]
AS
BEGIN

SET NOCOUNT ON;
SET XACT_ABORT ON;

	DECLARE @result_code INT;
	
	SET @result_code = 1;	--1 : 성공 / -1 : 프로시저 오류 / -2 : INSERT 실패 / -3 : UPDATE 실패

	BEGIN TRY
	
		BEGIN TRAN;

			DELETE FROM dbo.GuildMemberTable WHERE guild_id = @guild_id and character_id = @character_id

			--탈퇴/삭제된 유저의 길드포인트는 0으로 변경 jojo
			UPDATE [dbo].[CharacterTable] SET [GuildID] = NULL, [GuildPoint] = 0 WHERE [character_id] = @character_id
		
		COMMIT TRAN;
		
		SELECT result_code = @result_code;	--결과 코드 전달
	
	END TRY
	BEGIN CATCH
	
		ROLLBACK TRAN;
		
		SELECT result_code = -1;
	
	END CATCH

END