CREATE PROCEDURE [dbo].[up_guild_leader_change]
	@guild_id   	[uniqueidentifier],
	@character_id   [uniqueidentifier]
as 

set nocount on

declare @oldMaster [uniqueidentifier]
	
    select @oldMaster = master_id from dbo.GuildTable with (READUNCOMMITTED) where guild_id = @guild_id --기존 마스터의 캐릭터 아이디를 구한다. jojo

	update dbo.GuildTable set master_id = @character_id where guild_id = @guild_id
	update dbo.GuildMemberTable set grade = 0 where guild_id = @guild_id and character_id = @character_id

	--기존 마스터의 등급을 신입으로 변경한다. jojo
	update dbo.GuildMemberTable set grade = 7 where guild_id = @guild_id and character_id = @oldMaster 

return @@error