DELIMITER $$

DROP PROCEDURE IF EXISTS `alpmsdb`.`db_updateBoardArticle` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `db_updateBoardArticle`( OUT v_res INT,
                                     IN v_id VARCHAR(255),
                                     IN v_editor INT,
                                     IN v_editor_name VARCHAR(255),
                                     IN v_body TEXT,
                                     IN v_accessibility INT )
BEGIN

	DECLARE	v_author INT;
	DECLARE v_thread INT ;
	DECLARE v_session VARCHAR(255);
	
	SELECT article_author,
		   article_session
	INTO   v_author,v_session
	FROM   db_article_table
	WHERE  article_id=v_id ;
	
	SET v_res = 0 ;

	
	SELECT article_thread_id
	INTO   v_thread
	FROM   db_article_table
	WHERE  article_id=v_id ;


	UPDATE db_article_table
	SET    article_body=v_body,
		   article_accessibility=v_accessibility,
	       article_session=null
	WHERE  article_id=v_id ;

	IF ROW_COUNT()=0 THEN
		SET v_res = -1 ;
	ELSE

		UPDATE db_attach_table
		SET    attach_session=null
		WHERE  attach_article_id=v_id ;

		UPDATE db_thread_table
		SET    record_update=NOW()
		WHERE  thread_id=v_thread ;
	END IF;


	If v_session is null Then
		
		
			INSERT db_update_table
				   (
				     update_article_id,
				     update_author,
				     update_author_name
				   )
			VALUES (
				     v_id,
				     v_editor,
				     v_editor_name
				   ) ;
		
	End If;
END $$

DELIMITER ;