CREATE PROCEDURE [dbo].[up_read_pet_inventory]
	@pet_id	[uniqueidentifier]

as
set nocount on
 set transaction isolation level read uncommitted

	select	
	item_uid,
	page_index,
	slot_index,
	code,
	use_cnt,
	remain_time,
	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,
    --기간제 관련 추가 20100519 jojo
    expire_time,
	lock_pwd,
	activity_value, --활성석 20100928 jojo
	socket_1_color,
	socket_2_color,
	socket_3_color,
	rank,
	acquireroute,
	physical,
	magical,
	durabilitymax,
	weight

	from dbo.tbl_Pet_Inventory with (nolock) where pet_id = @pet_id and slot_index >= 0 and use_cnt > 0;

return @@error