USE [EnVisage]
GO
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PeopleResourceActuals
	DROP CONSTRAINT FK_PeopleResourceActuals_PeopleResource
GO
ALTER TABLE dbo.PeopleResource SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PeopleResourceActuals ADD CONSTRAINT
	FK_PeopleResourceActuals_PeopleResource FOREIGN KEY
	(
	PeopleResourceId
	) REFERENCES dbo.PeopleResource
	(
	Id
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	
GO
ALTER TABLE dbo.PeopleResourceActuals SET (LOCK_ESCALATION = TABLE)
GO
COMMIT