DELIMITER $$

DROP PROCEDURE IF EXISTS `zencart_import_dev`.`addProductToDumpTable`$$
CREATE DEFINER=`zencart`@`%` PROCEDURE `addProductToDumpTable`( 
	IN p_ID INT UNSIGNED
	,IN p_UPC VARCHAR(16)
	,IN p_Name VARCHAR(255)
	,IN p_DescTemplate TEXT
	,IN p_Storage TEXT
	,IN p_Preparation TEXT
	,IN p_IngrSimple TEXT
	,IN p_IngrComp TEXT
	,IN p_SiteSpecific TEXT
	,IN p_Blurb TEXT
	,IN p_InLineWarning TEXT
	,IN p_SepparateWarning TEXT
	,IN p_ImagePath VARCHAR(255)
	,IN p_Price FLOAT
	,IN p_Brand VARCHAR(255)
	,IN p_Taxable BIT(1)
	,IN p_Status BIT(1)
	,IN p_CategoryID  INT UNSIGNED
	,IN p_DateAdded DATE
)
BEGIN

# Add product to dump table. Note that Status below is hardwired to 1 at the moment

INSERT INTO products_dump
	SET 
		ID=p_ID
		,UPC=p_UPC
		,Name=p_Name
		,DescTemplate=p_DescTemplate
		,Storage=p_Storage
		,Preparation=p_Preparation
		,IngrSimple=p_IngrSimple
		,IngrComp=p_IngrComp
		,SiteSpecific=p_SiteSpecific
		,Blurb=p_Blurb
		,InLineWarning=p_InLineWarning
		,SepparateWarning=p_SepparateWarning
		,ImagePath=CONCAT( "product/", p_UPC, ".jpg" )
		,Price=p_Price
		,Brand=p_Brand
		,Taxable=p_Taxable
		,Status=1
		,CategoryID=p_CategoryID
		,DateAdded=p_DateAdded;

# add categorization to categorization dump table
INSERT INTO categorization_dump
	SET
		ProductID = p_ID
		,CategoryID = p_CategoryID
		,Type='primary';

END$$

DELIMITER ;