CREATE PROCEDURE [dbo].[up_update_character_block]
	@character_id [uniqueidentifier]
as begin
set nocount on
	update CharacterTable set
		[Block_Type] = 4,
		[Block_YN] = 'Y',
	    [IsTradeEnable] = 'N',
		[IsMoveEnable] = 'Y'
		where character_id = @character_id
end