Index: Custom Scripts/Pre-Deployment/PreScript.sql
===================================================================
diff -u
--- Custom Scripts/Pre-Deployment/PreScript.sql	(revision 0)
+++ Custom Scripts/Pre-Deployment/PreScript.sql	(revision a8ec9279e7313a29880c562d658b3627d4c1e422)
@@ -0,0 +1,81 @@
+/*
+* Use this Pre-Deployment script to perform tasks before the deployment of the project.
+* Read more at https://www.red-gate.com/SOC7/pre-deployment-script-help
+*/
+USE [Common]
+GO
+/*----- Region Codes ------------------*/
+INSERT INTO [Common].[dbo].[TypeXref] (
+			typeId,			type,			typeCode,	typeDescr,			typeDisplayName,	isActive
+		)
+VALUES		(39100,			'Region',		'US',		'UNITED STATES',	'UNITED STATES',	1)
+			, (39101,		'Region',		'EU',		'EUROPE',			'EUROPE',			1) 
+			, (39102,		'Region',		'CA',		'CANADA',			'CANADA',			1 )
+
+-- SELECT * FROM common.dbo.TypeXref WHERE type  like '%Region%'
+GO
+/*------ catalogCode -----------------*/ 
+INSERT INTO [Common].[dbo].[TypeXref] (
+			typeId,			type,				typeCode,		typeDescr,					typeDisplayName,	isActive
+		)
+VALUES		(39000,			'CatalogCode',		'V',	'DO NOT CATALOG',					'DO NOT CATALOG',	1)
+			, (39001,		'CatalogCode',		'X',	'DRAG BRANDED PRODUCTS CATALOG',	'DRAG BRANDED PRODUCTS CATALOG', 1) 
+			, (39002,		'CatalogCode',		'U',	'DRAG HARLEY CATALOG',				'DRAG HARLEY CATALOG', 1 )
+			, (39003,		'CatalogCode',		'R',	'DRAG NEW "OLDBOOK" CATALOG',		'DRAG NEW "OLDBOOK" CATALOG', 1)
+			, (39004,		'CatalogCode',		'I',   	'ICON - EUROPE ONLY',				'ICON - EUROPE ONLY', 1)
+		--	, (39005,		'CatalogCode',		'O',	'INDIAN CATALOG',					'INDIAN CATALOG', 1)
+			, (39006,		'CatalogCode',		'P',	'KIRK HARLEY CATALOG',				'KIRK HARLEY CATALOG', 1)
+			, (39007,		'CatalogCode',		'L',	'KIRK OFFROAD CATALOG',				'KIRK OFFROAD CATALOG', 1)
+			, (39008,		'CatalogCode',		'M',	'KIRK SNOW CATALOG',				'KIRK SNOW CATALOG', 1)
+			, (39009,		'CatalogCode',		'K',	'KIRK STREET CATALOG',				'KIRK STREET CATALOG', 1)
+			, (39010,		'CatalogCode',		'N',	'KIRK WATERCRAFT CATALOG',			'KIRK WATERCRAFT CATALOG', 1)
+			, (39011,		'CatalogCode',		'F',    'MOOSE RACING - EUROPE ONLY',		'MOOSE RACING - EUROPE ONLY', 1)
+			, (39012,		'CatalogCode',		'G',   	'MOOSE UTILITY - EUROPE ONLY',		'MOOSE UTILITY - EUROPE ONLY', 1)
+			, (39013,		'CatalogCode',		'J',   	'P.U. ADVENTURE - TOURING CATALOG',	'P.U. ADVENTURE - TOURING CATALOG', 1)
+			, (39014,		'CatalogCode',		'E',	'P.U. ATV CATALOG',					'P.U. ATV CATALOG', 1)
+			, (39015,		'CatalogCode',		'W',	'P.U. HELMET & APPAREL',			'P.U. HELMET & APPAREL', 1)
+			, (39016,		'CatalogCode',		'B',	'P.U. OFFROAD CATALOG',				'P.U. OFFROAD CATALOG', 1)
+			, (39017,		'CatalogCode',		'H',	'P.U. SCOOTER CATALOG',				'P.U. SCOOTER CATALOG', 1)
+			, (39018,		'CatalogCode',		'C',	'P.U. SNOW CATALOG',				'P.U. SNOW CATALOG', 1)
+			, (39019,		'CatalogCode',		'A',	'P.U. STREET CATALOG',				'P.U. STREET CATALOG', 1)
+			, (39020,		'CatalogCode',		'T',	'P.U. TIRE CATALOG',				'P.U. TIRE CATALOG', 1)
+			, (39021,		'CatalogCode',		'D',	'P.U. WATERCRAFT CATALOG',			'P.U. WATERCRAFT CATALOG', 1)
+			, (39022,		'CatalogCode',		'Z',	'RESERVED FOR DRAG USE (MISC)',		'RESERVED FOR DRAG USE (MISC)', 1)
+			, (39023,		'CatalogCode',		'Y',	'RESERVED FOR PU USE (MISC)',		'RESERVED FOR PU USE (MISC)', 1)
+			, (39024,		'CatalogCode',		'S',   	'STANDARD PARTS NOT TO BE CATALOGED', 'STANDARD PARTS NOT TO BE CATALOGED', 1)
+			, (39025,		'CatalogCode',		'Q',   	'THOR - EUROPE ONLY',				'THOR - EUROPE ONLY', 1)
+			, (39026,		'CatalogCode',		'O',	'VICTORY / INDIAN CATALOG',			'VICTORY / INDIAN CATALOG', 1)
+			, (39027,		'CatalogCode',		'1',	'WEB ONLY',							'WEB ONLY', 1 )
+GO
+--SELECT * FROM common.dbo.TypeXref WHERE type  like '%CatalogCode%'
+
+/********** Incase old catalog names are needed *****************/
+INSERT INTO [Common].[dbo].[TypeXref] (
+			typeId,					type,			 typeCode,					typeDescr,			typeDisplayName,		isActive
+			)
+SELECT		39200 + catalogId,		'CatalogType',	 catalogId,					catalogName,		catalogName,		1 
+FROM		PartsSource.dbo.Catalog 
+GO
+-- SELECT * FROM common.dbo.TypeXref WHERE type  like '%catalogType%'
+
+/********** Catalog status codes *****************/
+INSERT INTO [Common].[dbo].[TypeXref] (
+			typeId,					type,			 typeCode,		typeDescr,			typeDisplayName,		isActive
+			)
+VALUES		(39300,			'CatalogStatusCode',		'0',		'Initiated',		'Initiated',			1)
+			, (39301,		'CatalogStatusCode',		'1',		'In Design',		'In Design',			1) 
+			, (39302,		'CatalogStatusCode',		'2',		'Under Review',		'Under Review',			1)
+			, (39303,		'CatalogStatusCode',		'3',		'Finalized',		'Finalized',			1)
+			, (39304,		'CatalogStatusCode',		'4',		'Rolled Out',		'Rolled Out',			1)
+			, (39305,		'CatalogStatusCode',		'5',		'Not Started',		'Not Started',			1)
+GO
+/********** Revision Reason codes *****************/			
+INSERT INTO [Common].[dbo].[TypeXref] (
+			typeId,					type,			 typeCode,		typeDescr,			typeDisplayName,		isActive
+			)
+VALUES		(39400,			'RevisionReasonCode',		'0',		'Per Edge',			'Per Edge',				1)
+			, (39401,		'RevisionReasonCode',		'1',		'Pricing Change',	'Pricing Change', 		1) 
+			, (39402,		'RevisionReasonCode',		'2',		'Add Parts',		'Add Parts',			1)
+			, (39403,		'RevisionReasonCode',		'3',		'Remove Parts',		'Remove Parts',			1)
+GO
+-- SELECT * FROM common.dbo.TypeXref WHERE type  like '%CatalogStatusCode%'
\ No newline at end of file
Index: RedGateDatabaseInfo.xml
===================================================================
diff -u -rbb48ae6de08e887bc1dfcef944040def9567e853 -ra8ec9279e7313a29880c562d658b3627d4c1e422
--- RedGateDatabaseInfo.xml	(.../RedGateDatabaseInfo.xml)	(revision bb48ae6de08e887bc1dfcef944040def9567e853)
+++ RedGateDatabaseInfo.xml	(.../RedGateDatabaseInfo.xml)	(revision a8ec9279e7313a29880c562d658b3627d4c1e422)
@@ -1,11 +1,13 @@
 <?xml version="1.0" encoding="utf-8"?>
-<DatabaseInformation Version="2">
+<DatabaseInformation Version="3">
   <ScriptFileEncoding>UTF8</ScriptFileEncoding>
   <DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
   <DefaultSchema>dbo</DefaultSchema>
   <DefaultUser>dbo</DefaultUser>
   <DefaultFilegroup>PRIMARY</DefaultFilegroup>
   <DatabaseVersion>13</DatabaseVersion>
+  <CompatibilityLevel>130</CompatibilityLevel>
+  <EngineEdition>Unknown</EngineEdition>
   <IsAzure>False</IsAzure>
   <ScriptFolderType>Default</ScriptFolderType>
   <MaxDataFileSize>10485760</MaxDataFileSize>