CREATE PROCEDURE [dbo].[up_reward_mail_item]
	@bcust_id		nvarchar(50)
AS
BEGIN

set nocount on
set xact_abort on

	declare @recvName		nvarchar(16)
	declare @recvCharID		uniqueidentifier
	declare @recvAuthID		uniqueidentifier
	declare @mailID			uniqueidentifier
	declare @rewardItemID	uniqueidentifier

SELECT top 1 @recvAuthID = [AuthID], @recvCharID = [character_id],@recvName = [Name] FROM [dbo].[CharacterTable] with (READUNCOMMITTED) where [bcust_id]=@bcust_id and Block_Type > 0 order by [level] desc

set @mailID		  = NewID()
set @rewardItemID = NewID()

INSERT INTO [dbo].[N_InventoryItem]
           ([item_uid]
           ,[character_id]
           ,[auth_id]
           ,[page_index]
           ,[slot_index]
           ,[code]
           ,[use_cnt]
           ,[remain_time]
           ,[create_time]
           ,[update_time]
           ,[gcode]
           ,[durability]
           ,[enhance_level]
           ,[option_1_code]
           ,[option_1_value]
           ,[option_2_code]
           ,[option_2_value]
           ,[option_3_code]
           ,[option_3_value]
           ,[option_group]
           ,[ReconNum]
           ,[ReconState]
           ,[socket_count]
           ,[socket_1_code]
           ,[socket_1_value]
           ,[socket_2_code]
           ,[socket_2_value]
           ,[socket_3_code]
           ,[socket_3_value]
           ,[expire_time]
           ,[lock_pwd]
           ,[activity_value]
           ,[socket_1_color]
           ,[socket_2_color]
           ,[socket_3_color] )
     VALUES
           ( @rewardItemID
           , @recvCharID
           , @recvAuthID
           , 10
           , 1
           , 70000007
           , 1
           , 0
           , GetDate()
           , GetDate()
           , 777
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0
           , 0 )

	exec dbo.up_insert_mail_item01 @recvCharID, 'GM', @recvName, '태초의 계약자 칭호 아이템', 0, 0, 0, @mailID, 777, @rewardItemID, 1 

end