-- EXEC MIG_PROPS_LIST_VALUES_MAPPING_Sp
CREATE OR ALTER PROCEDURE MIG_PROPS_LIST_VALUES_MAPPING_Sp
AS
BEGIN

	DELETE FROM MIG_PROPS_LIST_VALUES_MAPPING

	INSERT INTO MIG_PROPS_LIST_VALUES_MAPPING(AppName, LegacyPropName, SourcePropValue, TargetPropValue, IsDefault)
	VALUES
	 ('*',			'CHECK_IN_CLEANUP',								'Make Files Read-Only',				'10',	0)	--readonly.files
	,('*',			'CHECK_IN_CLEANUP',								'Delete File',						'20',	1)	--delete.files

	,('*',			'SAVE_AND_UNLOCK_CLEANUP',						'Make Files Read-Only',				'10',	0)	--readonly.files
	,('*',			'SAVE_AND_UNLOCK_CLEANUP',						'Delete File',						'20',	1)	--delete.files

	,('*',			'ACTION_FOR_OBJECTS_LOCKED_BY_BP',				'Attached as unlocked',				'10',	0)	--attach.as.unlok
	,('*',			'ACTION_FOR_OBJECTS_LOCKED_BY_BP',				'Do not attach',					'20',	0)	--do.not.attach
	,('*',			'ACTION_FOR_OBJECTS_LOCKED_BY_BP',				'Cancel action',					'30',	1)	--cancel.action
	,('*',			'ACTION_FOR_OBJECTS_LOCKED_BY_BP',				'Always attach as unlocked',		'40',	0)	--always.unlocked

	,('*',			'ATTACHED_TO_BP',								'Documents Only',					'10',	1)	--documents.only
	,('*',			'ATTACHED_TO_BP',								'Items Only',						'20',	0)	--items.only
	,('*',			'ATTACHED_TO_BP',								'Both',								'30',	0)	--both

	,('*',			'UNIQUE_FILE_NAMES',							'Unique across all projects',		'10',	0)	--uniq.all.proj
	,('*',			'UNIQUE_FILE_NAMES',							'Unique per project',				'20',	1)	--uniq.per.proj
	,('*',			'UNIQUE_FILE_NAMES',							'Duplicate file name is allowed',	'30',	0)	--dupl.allowed

	,('*',			'NEUTRAL_FILES_GENERATION',						'On All Actions',					'10',	1)	--all.actions
	,('*',			'NEUTRAL_FILES_GENERATION',						'On Save and Unlock',				'20',	0)	--save.unlock
	,('*',			'NEUTRAL_FILES_GENERATION',						'On Check-In',						'10',	0)	--check.in
	,('*',			'NEUTRAL_FILES_GENERATION',						'On Save and Unlock and Check-In',	'10',	0)	--save.unlk.chkin

	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Cancel Save',																'10',	1)	--cancel.save
	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Generate Auto ID',															'20',	0)	--gen.auto.id
	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Link to existing Item (If Item Already used - Cancel)',					'30',	0)	--lnk.itm.cancel
	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Link to existing Item (If Item Already used - Set Defining Manually)',		'40',	0)	--lnk.itm.manual
	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Link to existing Item (If Item Already used - Set Defining to No)',		'50',	0)	--lnk.itm.no
	,('*',			'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM',		'Link to existing Item (If Item Already used - Set Defining to Yes)',		'60',	0)	--lnk.itm.yes

	,('*',			'DUPLICATE_ITEM_IDS_ACTION',					'Cancel Save',									'10',	1)	--cancel.save
	,('*',			'DUPLICATE_ITEM_IDS_ACTION',					'Generate Auto ID',								'20',	0)	--gen.auto.id
	,('*',			'DUPLICATE_ITEM_IDS_ACTION',					'Allow Link to existing Item',					'30',	0)	--link.exit.item

	,('*',			'INITAL_SETTING_OF_ITEM_ID_TO_MATCH_FILENAME',	'None',											'10',	1)	--none
	,('*',			'INITAL_SETTING_OF_ITEM_ID_TO_MATCH_FILENAME',	'File Name',									'20',	0)	--file.name
	,('*',			'INITAL_SETTING_OF_ITEM_ID_TO_MATCH_FILENAME',	'Part Number',									'30',	0)	--part.number
	,('*',			'INITAL_SETTING_OF_ITEM_ID_TO_MATCH_FILENAME',	'Custom Property [Document Level]',				'40',	0)	--cust.property

	,('*',			'QUERY_SEARCH_DEFAULT',							'File',											'10',	1)	--file
	,('*',			'QUERY_SEARCH_DEFAULT',							'Doc',											'20',	0)	--doc
	,('*',			'QUERY_SEARCH_DEFAULT',							'Item',											'30',	0)	--item

	,('*',			'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'All Levels',									'10',	1)	--all.levels
	,('*',			'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Selected document only',						'20',	0)	--sel.documents
	,('*',			'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Prompt',										'30',	0)	--prompt

	,('*',			'THUMBNAIL_TYPE_FOR_GENERATION',				'JPG',											'10',	0)	--jpg
	,('*',			'THUMBNAIL_TYPE_FOR_GENERATION',				'PNG',											'20',	1)	--png

	,('WEBPLM',		'DEFAULT_ATTACH_TO_BP',							'DEFAULT_ATTACH_TO_BP_BP_ONLY_LOCKED',			'10',	1)	--attach.bp.lck
	,('WEBPLM',		'DEFAULT_ATTACH_TO_BP',							'DEFAULT_ATTACH_TO_BP_BP_ONLY_UNLOCKED',		'20',	0)	--attach.bp.unlk
	,('WEBPLM',		'DEFAULT_ATTACH_TO_BP',							'DEFAULT_ATTACH_TO_BP_ALL_STEPS_LOCKED',		'30',	0)	--attach.stp.lck
	,('WEBPLM',		'DEFAULT_ATTACH_TO_BP',							'DEFAULT_ATTACH_TO_BP_ALL_STEPS_UNLOCKED',		'40',	0)	--attach.stp.unlk

	,('WEBPLM',		'UNIQUE_FILE_NAMES',							'Unique across all projects',					'10',	0)	--uniq.all.proj
	,('WEBPLM',		'UNIQUE_FILE_NAMES',							'Unique per project',							'20',	0)	--uniq.per.proj
	,('WEBPLM',		'UNIQUE_FILE_NAMES',							'Duplicate of filename is allowed',				'30',	1)	--dupl.allowed

	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'All',											'10',	1)	--all
	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'Latest Released',								'20',	0)	--latest.released
	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'Current Released',								'30',	0)	--curr.released
	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'Work-In-Progress',								'40',	0)	--work.in.progres
	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'Latest-Created',								'50',	0)	--latest.created
	,('WEBPLM',		'DEFAULT_REVISION_OPTION',						'Last modified',								'60',	0)	--latest.modi

	,('WEBPLM',		'ERP_VERSION',									'Baan IV',										'10',	0)	--erp.baan4
	,('WEBPLM',		'ERP_VERSION',									'Baan 5',										'20',	0)	--erp.baan5
	,('WEBPLM',		'ERP_VERSION',									'SSA ERP LN',									'30',	0)	--erp.ln
	,('WEBPLM',		'ERP_VERSION',									'SyteLine',										'40',	0)	--erp.csi
	,('WEBPLM',		'ERP_VERSION',									'XA',											'50',	0)	--erp.xa
	,('WEBPLM',		'ERP_VERSION',									'COM ERP',										'60',	0)	--erp.com

	,('WEBPLM',		'REPEAT_TASK_REMINDER_UNIT',					'Hour',											'10',	0)	--none
	,('WEBPLM',		'REPEAT_TASK_REMINDER_UNIT',					'Day',											'20',	0)	--file.name

	,('AUTOCAD',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'All Levels',									'10',	1)	--all.levels
	,('AUTOCAD',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Selected document only',						'20',	0)	--sel.documents
	,('AUTOCAD',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Prompt',										'30',	0)	--prompt

	,('AUTOCAD',	'LAYOUTS_FOR_BMP_GENERATION',					'Model Space Layout Only',						'10',	1)	--model.space
	,('AUTOCAD',	'LAYOUTS_FOR_BMP_GENERATION',					'Active Layout Only',							'20',	0)	--active.layout
	,('AUTOCAD',	'LAYOUTS_FOR_BMP_GENERATION',					'All Layouts',									'30',	0)	--all.layouts

	,('AUTOCAD',	'LAYOUTS_FOR_PDF_GENERATION',					'Model Space Layout Only',						'10',	1)	--model.space
	,('AUTOCAD',	'LAYOUTS_FOR_PDF_GENERATION',					'Active Layout Only',							'20',	0)	--active.layout
	,('AUTOCAD',	'LAYOUTS_FOR_PDF_GENERATION',					'All Layouts (Single PDF)',						'30',	0)	--all.single.pdf
	,('AUTOCAD',	'LAYOUTS_FOR_PDF_GENERATION',					'All Layouts (Separate PDF)',					'40',	0)	--all.sep.pdf

	,('AUTOCAD',	'SET_FILE_NAME_FOR',							'None',											'10',	1)	--none
	,('AUTOCAD',	'SET_FILE_NAME_FOR',							'Main File',									'20',	0)	--main.file

	,('AUTOCAD',	'LAYOUT_FOR_THUMBNAIL_GENERATION',				'Model Space Layout',							'10',	1)	--model.space
	,('AUTOCAD',	'LAYOUT_FOR_THUMBNAIL_GENERATION',				'Active Layout',								'20',	0)	--active.layout


	,('DRAFTSIGHT',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'All Levels',									'10',	1)	--all.levels
	,('DRAFTSIGHT',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Selected document only',						'20',	0)	--sel.documents
	,('DRAFTSIGHT',	'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE',		'Prompt',										'30',	0)	--prompt

	,('DRAFTSIGHT',	'LAYOUTS_FOR_BMP_GENERATION',					'Model Space Layout Only',						'10',	1)	--model.space
	,('DRAFTSIGHT',	'LAYOUTS_FOR_BMP_GENERATION',					'Active Layout Only',							'20',	0)	--active.layout
	,('DRAFTSIGHT',	'LAYOUTS_FOR_BMP_GENERATION',					'All Layouts',									'30',	0)	--all.layouts

	,('DRAFTSIGHT',	'LAYOUTS_FOR_PDF_GENERATION',					'Model Space Layout Only',						'10',	1)	--model.space
	,('DRAFTSIGHT',	'LAYOUTS_FOR_PDF_GENERATION',					'Active Layout Only',							'20',	0)	--active.layout
	,('DRAFTSIGHT',	'LAYOUTS_FOR_PDF_GENERATION',					'All Layouts (Single PDF)',						'30',	0)	--all.single.pdf
	,('DRAFTSIGHT',	'LAYOUTS_FOR_PDF_GENERATION',					'All Layouts (Separate PDF)',					'40',	0)	--all.sep.pdf

	,('DRAFTSIGHT',	'SET_FILE_NAME_FOR',							'None',											'10',	1)	--none
	,('DRAFTSIGHT',	'SET_FILE_NAME_FOR',							'Main File',									'20',	0)	--main.file

	,('DRAFTSIGHT',	'LAYOUT_FOR_THUMBNAIL_GENERATION',				'Model Space Layout',							'10',	1)	--model.space
	,('DRAFTSIGHT',	'LAYOUT_FOR_THUMBNAIL_GENERATION',				'Active Layout',								'20',	0)	--active.layout


	,('PROE',		'ACTION_TO_TAKE_WHEN_MC_ERRORS_IS_NON_ZERO',	'Ignore',										'10',	1)	--ignore
	,('PROE',		'ACTION_TO_TAKE_WHEN_MC_ERRORS_IS_NON_ZERO',	'Allow SaveToPLM only',							'20',	0)	--allow.save
	,('PROE',		'ACTION_TO_TAKE_WHEN_MC_ERRORS_IS_NON_ZERO',	'Restrict all',									'30',	0)	--restrict.all

	,('PROE',		'FONT_FOR_PDF_GENERATION',						'Use True Type Fonts',							'10',	1)	--truetype
	,('PROE',		'FONT_FOR_PDF_GENERATION',						'Stroke All Fonts',								'20',	0)	--stroke.all

	,('PROE',		'EXPORT_LAYERS_PDF_GENERATION',					'All',											'10',	0)	--all
	,('PROE',		'EXPORT_LAYERS_PDF_GENERATION',					'Visible Only',									'20',	0)	--visible
	,('PROE',		'EXPORT_LAYERS_PDF_GENERATION',					'None',											'30',	0)	--none

	,('TOOLKIT',	'LOCAL_RELEASE_SYNC',							'YES',											'10',	0)	--yes
	,('TOOLKIT',	'LOCAL_RELEASE_SYNC',							'IGNORE',										'20',	1)	--ignore
	,('TOOLKIT',	'LOCAL_RELEASE_SYNC',							'AUTO_SELECT',									'30',	0)	--auto.select

	,('TOOLKIT',	'LOCAL_SINGLE_FILE_SYNC',						'No auto select',								'10',	1)	--no.auto.select
	,('TOOLKIT',	'LOCAL_SINGLE_FILE_SYNC',						'Auto select last effective released',			'20',	0)	--last.eff.rel
	,('TOOLKIT',	'LOCAL_SINGLE_FILE_SYNC',						'Auto select current effective released',		'30',	0)	--curr.eff.rel
	,('TOOLKIT',	'LOCAL_SINGLE_FILE_SYNC',						'Auto select work in progress',					'40',	0)	--work.in.progres
	,('TOOLKIT',	'LOCAL_SINGLE_FILE_SYNC',						'Auto select latest created',					'50',	0)	--lastc.created

	,('TOOLKIT',	'DEFAULT_TAB_FOR_SET_OBJECT_ATTRIBUTES_DIALOG',	'FILE',											'10',	1)	--file
	,('TOOLKIT',	'DEFAULT_TAB_FOR_SET_OBJECT_ATTRIBUTES_DIALOG',	'DOC',											'20',	0)	--doc
	,('TOOLKIT',	'DEFAULT_TAB_FOR_SET_OBJECT_ATTRIBUTES_DIALOG',	'ITEM',											'30',	0)	--item

END
