CREATE OR ALTER PROCEDURE [MIG_CREATE_ENTRIES_IN_MIG_SETTINGS_Sp]
AS BEGIN
	DELETE FROM MIG_SETTINGS

	--EO.IMPACT_ANALYSIS ==> pdwfl100.impa
	INSERT INTO MIG_SETTINGS([NAME], [VALUE], [COMMENTS])
	VALUES
	(
		'ITEM_CODE_SYSTEM', 'MIG', ''
	),
	(
		'PRODUCT_IN_USE', 'Yes', 'Indicates the parameter set in target application.'
	),
	(
		'MANAGE_FILES_USING_BASE_VERSIONING', 'Yes', 'Recommended value = Yes'
	),
	(
		'MANAGE_THUMBNAILS_USING_BASE_VERSIONING', 'Yes', 'Recommended value = Yes'
	),
	(
		'DOCUMENT_TYPES_CUSTOM_STORED_PROCEDURE', '', ''
	),
	(
		'FOLDER_TYPES_CUSTOM_STORED_PROCEDURE', '', ''
	),
	(
		'TT_TEXT_MAX_ID', '', 'Maintain the max TT_TEXT_ID from which the text id values get inserted.'
	)
	
END

-- exec MIG_CREATE_ENTRIES_IN_MIG_SETTINGS_Sp
-- SELECT * FROM MIG_SETTINGS
