-------------------
-- Menu and Route
-------------------
	declare @parent int, @result_routeId INT
	select @parent=id from [FrontEnd].[Menu] where [Name] = 'EAF' and Parent is null

	INSERT INTO [FrontEnd].[Routes]
			   ([Route]
			   ,[ModuleName]
			   ,[ModulePath]
			   ,[RequiredRole]
		   )
		 VALUES
			   (
			   '!/eaf-shift-report(/:productionDate)(/:shiftId)'
			   , 'eaf-shift-report'
			   , 'pages/eaf/eaf-shift-report/'
			   , 'shiftreport_readWrite'
			   )
			   SET @result_routeId = @@IDENTITY
	INSERT INTO [FrontEnd].[Menu]
			   ([Parent]
			   ,[Name]
			   ,[RouteID]
			   ,[SortOrder]
			   ,[Enabled]
			   ,[Visible]
			   ,[RequiredRole]
			   ,[Group]
			  )
		 VALUES
			   (
			   @parent
			   ,'EAF Shift Report'
			   ,@result_routeId
			   ,15
			   ,1
			   ,1
			   ,'shiftreport_readWrite'
			   ,NULL
			 )
	GO
