CREATE PROCEDURE MIG_CREATE_ENTRIES_IN_MIG_STANDARD_FOLDER_TYPE_MAPPING_Sp
AS
BEGIN

	DELETE from MIG_STANDARD_FOLDER_TYPE_MAPPING

	INSERT INTO MIG_STANDARD_FOLDER_TYPE_MAPPING
	(
		VALUE_ID, SHORT_DESCR, LN_FOLDER_TYPE, LN_DESC
	)
	VALUES
	('0', 'ASSEMBLY DRAWING', 'ASSEMBLY_DRAWING', 'Assembly Drawing'),
	('1', 'CONTRACT', 'CONTRACT', 'Contract'),
	('2', 'EDA ASSEMBLY', 'EDA_ASSEMBLY', 'EDA Assembly'),
	('3', 'EDA FABRICATION', 'EDA_FABRICATION', 'EDA Fabrication'),
	('4', 'EDA INNOVATION', 'EDA_INNOVATION', 'EDA Innovation')
END




-- exec MIG_CREATE_ENTRIES_IN_MIG_STANDARD_FOLDER_TYPE_MAPPING_Sp
-- SELECT * FROM MIG_STANDARD_FOLDER_TYPE_MAPPING ORDER BY VALUE_ID
