CREATE OR ALTER PROCEDURE [MIG_ANZ_CREATE_ENTRIES_IN_MIG_ANZ_COMPONENTS_Sp]
AS BEGIN

	DELETE FROM MIG_ANZ_COMPONENTS

	INSERT INTO MIG_ANZ_COMPONENTS
	( 
		[ID], 
		[TYPE], 
		[NAME], 
		[DIRECTORY], 
		[FILE_NAME], 
		[DESCRIPTION] 
	)
	VALUES
    (	
		'1', 
		'Table', 
		'MIG_ANZ_COMPONENTS',
		'Tables', 
		'MIG_ANZ_COMPONENTS.sql',
		'Table to maintain list of components.' 
	),
    (	
		'2', 
		'Table', 
		'MIG_ANZ_SOURCE_LIST',
		'Tables', 
		'MIG_ANZ_SOURCE_LIST.sql',
		'Table to maintain List Types for Data Analysis.' 
	),
    (  
		'3', 
		'Table', 
		'MIG_ANZ_SOURCE_LIST_VALUES',	
		'Tables', 
		'MIG_ANZ_SOURCE_LIST_VALUES.sql',		
		'Table to maintain List Type Values for Data Analysis.' 
	),
    (  
		'4', 
		'Table', 
		'MIG_ANZ_SOURCE_TABLE',		
		'Tables', 
		'MIG_ANZ_SOURCE_TABLE.sql',			
		'Table to maintain Tables detail for Data Analysis.' 
	),
    (  
		'5', 
		'Table', 
		'MIG_ANZ_SOURCE_TABLE_FIELD',	
		'Tables', 
		'MIG_ANZ_SOURCE_TABLE_FIELD.sql',		
		'Table to maintain Table Fields detail for Data Analysis.' 
	),
    (  
		'6', 
		'Table', 
		'MIG_ANZ_COMPLEXITIES',		
		'Tables', 
		'MIG_ANZ_COMPLEXITIES.sql',			
		'Table to generate details of complex topics.' 
	),
    (  
		'7', 
		'Table', 
		'MIG_ANZ_PRECHECKS',		
		'Tables', 
		'MIG_ANZ_PRECHECKS.sql',			
		'Table to maintain details of prechecks.' 
	),
    (  
		'8', 
		'Table', 
		'MIG_ANZ_HIGH_ASCII_CHARS',		
		'Tables', 
		'MIG_ANZ_HIGH_ASCII_CHARS.sql',			
		'Table to generate details of standrd columns with high-ascii characters.' 
	),
    (  
		'9', 
		'Function', 
		'MIG_ANZ_GET_FIELDS_BY_UDTP_TYPE_NAME_Fn',		
		'Functions', 
		'MIG_ANZ_GET_FIELDS_BY_UDTP_TYPE_NAME_Fn.sql',			
		'Function to build details of fields using a given list Type Name.' 
	),
    (  
		'10', 
		'Function', 
		'MIG_ANZ_CONTAINS_HIGH_ASCII_CHARS_Fn',		
		'Functions', 
		'MIG_ANZ_CONTAINS_HIGH_ASCII_CHARS_Fn.sql',			
		'Function to check if a given columns contains high-ascii characters.' 
	),
    (  
		'11', 
		'Stored Procedure', 
		'MIG_ANZ_CREATE_ENTRIES_IN_MIG_ANZ_COMPONENTS_Sp',		
		'StoredProcedures', 
		'MIG_ANZ_CREATE_ENTRIES_IN_MIG_ANZ_COMPONENTS_Sp.sql',								
		'Stored Procedure to generate list of components to be created.' 
	),
    (  
		'12', 
		'Stored Procedure', 
		'MIG_ANZ_CREATE_ENTRIES_IN_MIG_TABLES_FOR_ANALYSIS_Sp',	
		'StoredProcedures', 
		'MIG_ANZ_CREATE_ENTRIES_IN_MIG_TABLES_FOR_ANALYSIS_Sp.sql',		
		'Stored Procedure to generate report of Metadata Analysis.'
	),
    (  
		'13', 
		'Stored Procedure', 
		'MIG_ANZ_METADATA_ANALYSIS_Sp',
		'StoredProcedures', 
		'MIG_ANZ_METADATA_ANALYSIS_Sp.sql',								
		'Stored Procedure to get reports of Metadata Analysis.' 
	),
    (  
		'14', 
		'Stored Procedure', 
		'MIG_ANZ_GENERATE_ENTRIES_IN_MIG_ANZ_COMPLEXITIES_Sp',
		'StoredProcedures', 
		'MIG_ANZ_GENERATE_ENTRIES_IN_MIG_ANZ_COMPLEXITIES_Sp.sql',		
		'Stored Procedure to generate report on complexity analysis.' 
	),
    (  
		'15', 
		'Stored Procedure', 
		'MIG_ANZ_PRE_CHECKS_ALL_Sp',
		'StoredProcedures', 
		'MIG_ANZ_PRE_CHECKS_ALL_Sp.sql',						
		'Stored Procedure to generate report on data verification checks.' 
	),
    (  
		'16', 
		'Stored Procedure', 
		'MIG_ANZ_EO_RT_SYSTEM_COMMANDS_Sp',
		'StoredProcedures', 
		'MIG_ANZ_EO_RT_SYSTEM_COMMANDS_Sp.sql',						
		'Stored Procedure to generate report on system steps commmands available in Workflows/Business Processes.' 
	),
    (  
		'17', 
		'Stored Procedure', 
		'MIG_ANZ_VALIDATE_HIGH_ASCII_CHARS_Sp',
		'StoredProcedures', 
		'MIG_ANZ_VALIDATE_HIGH_ASCII_CHARS_Sp.sql',						
		'Stored Procedure to generate report on standard fields containing high-ascii characters.' 
	)

END

-- exec MIG_ANZ_CREATE_ENTRIES_IN_MIG_ANZ_COMPONENTS_Sp
-- SELECT * FROM MIG_ANZ_COMPONENTS ORDER BY ID
