CREATE PROCEDURE [dbo].[up_create_item_sales]
	@character_id   [uniqueidentifier],
	@auth_id        [uniqueidentifier],
	@page_index     int,
	@slot_index     int,
	@code           int

as
set nocount on
set xact_abort on

begin
	begin tran
	
	insert 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,
	link_id		  ,
	is_seizure	  ,
	socket_1_color,
	socket_2_color,
	socket_3_color,
	deferment_time,
	rank,
	acquireroute,
	physical,
	magical,
	durabilitymax,
	weight
    )

	values(
	NEWID()       ,  --item_uid	  
	@character_id  , --character_id  
	@auth_id       , --auth_id	      
	@page_index    , --page_index	  
	@slot_index    , --slot_index	  
	@code          , --code		  
	1       ,		 --use_cnt	      
	0   ,			 --remain_time	  
	GetDate()      , --create_time	  
	GetDate()      , --update_time	  
	8989         ,	 --gcode	      
	5000    ,		 --durability	  
	0 ,				 --enhance_level 
	0 ,				 --option_1_code 
	0,				 --option_1_value
	0,				 --option_2_code 
	0,				 --option_2_value
	0,				 --option_3_code 
	0,				 --option_3_value
	0,				 --option_group  
	0,				 --ReconNum	  
	0,				 --ReconState	  
	0,				 --socket_count  
	0,				 --socket_1_code 
	0,				 --socket_1_value
	0,				 --socket_2_code 
	0,				 --socket_2_value
	0,				 --socket_3_code 
	0,				 --socket_3_value
    0,				 --expire_time	  
    '',				 --lock_pwd      
	0,			     --activity_value
	NULL,			 --link_id		  
	0,				 --is_seizure	  
	0,				 --socket_1_color
	0,				 --socket_2_color
	0,				 --socket_3_color
	0,				 --deferment_time
	1,				 --rank
	0,
	0,
	0,
	0,
	0
    )

	if(@@error <> 0)
	begin
		rollback
		return
	end

	commit

--select * from N_InventoryItem where item_uid = @item_id

end