CREATE PROCEDURE [dbo].[up_insert_rearing_info]
	@table_id 	tinyint,
	@group_id 	tinyint,
	@reating_id 	[uniqueidentifier],
	@char_id 	[uniqueidentifier],
	@type 		tinyint,
	@name 		nvarchar(16),
	@job  		tinyint,
	@level 		int,
	@index 		tinyint,
	@actionpoint 	int,
	@usedturn 	int,
	@endingid 	int,
	@rewarditem 	int,
	@createtime 	bigint,
	@vital		int,
	@intelligence	int,
	@strength	int,
	@temper		int,
	@charm		int,
	@exhaust	int,
	@angry		int,
	@normal		int,
	@good		int,
	@sadness	int,
	@height		int,
	@weight		int,
	@resilent int = 0,
	@eloquence  int = 0

as 
set nocount on
set xact_abort on


begin
	BEGIN TRAN
		insert dbo.RearingTable
	    (
		[table_id],
		[group_id],	
		[rearing_id], 
		[char_id],
		[type], 
		[name], 
		[job], 
		[level], 
		[index], 
		[actionpoint],
		[usedturn], 
		[endingid],
		[rewarditem],
		[createtime],
		[vital], 
		[intelligence], 
		[strength], 
		[temper], 
		[charm], 
		[exhaust], 
		[angry], 
		[normal],
		[good], 
		[sadness], 
		[height], 
		[weight],
		[resilent],
		[eloquence]
		)
		values( 
		@table_id,
		@group_id,
		@reating_id,
		@char_id,
		@type,
		@name,
		@job,
		@level,
		@index,
		@actionpoint,
		@usedturn,
		@endingid,
		@rewarditem,
		@createtime,
		@vital,
		@intelligence,
		@strength,
		@temper,
		@charm,
		@exhaust,
		@angry,
		@normal,
		@good,
		@sadness,
		@height,
		@weight,
		@resilent,
		@eloquence
		)


	if(@@error <> 0 )
	begin
	     ROLLBACK TRAN
	     return

	end
	
	COMMIT TRAN
end