CREATE PROCEDURE [dbo].[up_add_character_title]
	@character_id	[uniqueidentifier],
	@new_id			[uniqueidentifier],
	@title_code     int,
	@remain_time	int,
	@expire_time	int
AS 
SET NOCOUNT ON

	INSERT INTO CharacterTitle 
		VALUES(
		 @new_id,
		 @character_id,
		 @title_code,
		 @remain_time,
		 @expire_time
		 );

RETURN @@ERROR