USE `alloc`;

DROP procedure IF EXISTS `wiki_graphic_insert_temp_to_original`;



DELIMITER $$

USE `alloc`$$

CREATE  PROCEDURE `wiki_graphic_insert_temp_to_original`(







IN p_wiki_text_id  INT















)

BEGIN















INSERT INTO `alloc`.`wiki_graphic`















(















`file_name`,















`file_extension`,















`caption`,















`wiki_text_id`,















`physical_file_name`,







`file_format`















)







SELECT 







`file_name`,















`file_extension`,















`caption`,















`wiki_text_id`,















`physical_file_name`,







`file_format`











FROM `alloc`.`temp_wiki_graphic` 















       WHERE NOT EXISTS(SELECT `physical_file_name`,`wiki_text_id` FROM `alloc`.`wiki_graphic`

       WHERE `wiki_graphic`.`wiki_text_id`= p_wiki_text_id) AND wiki_text_id = p_wiki_text_id;























END

$$



DELIMITER ;