 
 GO
 
-/****** Object:  Table [dbo].[Authority]    Script Date: 11/20/2013 17:42:53 ******/
+/****** Object:  Table [dbo].[Authority]    Script Date: 11/21/2013 10:16:51 ******/
 
 SET ANSI_NULLS ON
 


GO

/****** Object:  Default [DF_ActorRef_ActorRefId]    Script Date: 11/20/2013 17:42:53 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ActorRef_ActorRefId]') AND parent_object_id = OBJECT_ID(N'[dbo].[ActorRef]'))



GO

/****** Object:  Default [DF_ExtractPersonStaging_ExtractPersonStagingId]    Script Date: 11/21/2013 10:16:51 ******/

IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ExtractPersonStaging_ExtractPersonStagingId]') AND parent_object_id = OBJECT_ID(N'[dbo].[ExtractPersonStaging]'))

Begin

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ExtractPersonStaging_ExtractPersonStagingId]') AND type = 'D')

BEGIN

ALTER TABLE [dbo].[ExtractPersonStaging] ADD  CONSTRAINT [DF_ExtractPersonStaging_ExtractPersonStagingId]  DEFAULT (newid()) FOR [ExtractPersonStagingId]

END

