USE [EnVisage]
GO

IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_PeopleResourceAllocation_PeopleResourceId')
BEGIN
	CREATE NONCLUSTERED INDEX IX_PeopleResourceAllocation_PeopleResourceId
	ON [dbo].[PeopleResourceAllocation] ([PeopleResourceId])
	INCLUDE ([ScenarioId])
END
GO