alter table tbl_IMPORT_ProductDataProcessors add processUpdateSkuDesc char(1) not null default 0
alter table tbl_IMPORT_ProductDataProcessors add processSkuAdds char(1) not null default 1


insert into tbl_EAI_InboundFileProcessors(ownerId, ownerType, fileName, fileProcessor, fileFormat, clientProcessEmail, fseProcessEmail, allowUpload, autoProcess, config, batchName, batchSequence, 
                         processingWindowStartHr24, processingWindowLengthHr, PGPPassPhrase, PGPPrivateKeyFile, PGPPublicKeyFile, PGPKeyId, defaultUploadConfig, allowEmail, defaultFtpConfig, 
                         defaultBatchClass, repeating, allowFTP, repeatTime, repeatOptions, notifications)
	select 207, ownerType, fileName, fileProcessor, fileFormat, 'gerry@fsenablers.com,nkirst@fsenablers.com', fseProcessEmail, allowUpload, autoProcess, config, batchName, batchSequence, 
                         0, 24, PGPPassPhrase, PGPPrivateKeyFile, PGPPublicKeyFile, PGPKeyId, defaultUploadConfig, allowEmail, defaultFtpConfig, 
                         defaultBatchClass, repeating, allowFTP, repeatTime, repeatOptions, notifications
	from tbl_EAI_InboundFileProcessors
	where ownerType = 'MFR'
	and   ownerid = 18
	and fileformat = 'UNIVERSAL_PRODUCT_CATALOG'




insert into tbl_IMPORT_ProductDataProcessors(ownerid, ownerType, formatName, processProductLines, processCategory, processProducts, processSku, processMemo, processNutritional, 
                         processChildNutrition, processNutritionalClaims, processPackaging, processAllergens, processBrands, processDeletes, processSendEmail, processComments, processUpdateSkuDesc, processSkuAdds)
	values(207,'MFR','UNIVERSAL_PRODUCT_CATALOG',0,0,0,1,0,0,0,0,0,0,0,0,0,'',1,0)