USE [master]
GO
/****** Object:  Database [Unify.IdentityBroker]    Script Date: 11/06/2015 1:40:07 PM ******/
CREATE DATABASE [Unify.IdentityBroker]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Unify.IdentityBroker', FILENAME = N'D:\SQL_Instance\MSSQL11.MSSQLSERVER\MSSQL\DATA\Unify.IdentityBroker.mdf' , SIZE = 10763328KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Unify.IdentityBroker_log', FILENAME = N'D:\SQL_Instance\MSSQL11.MSSQLSERVER\MSSQL\DATA\Unify.IdentityBroker_log.ldf' , SIZE = 15905920KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Unify.IdentityBroker] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Unify.IdentityBroker].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Unify.IdentityBroker] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET ARITHABORT OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [Unify.IdentityBroker] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Unify.IdentityBroker] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Unify.IdentityBroker] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET  ENABLE_BROKER 
GO
ALTER DATABASE [Unify.IdentityBroker] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Unify.IdentityBroker] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET RECOVERY FULL 
GO
ALTER DATABASE [Unify.IdentityBroker] SET  MULTI_USER 
GO
ALTER DATABASE [Unify.IdentityBroker] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Unify.IdentityBroker] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Unify.IdentityBroker] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Unify.IdentityBroker] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'Unify.IdentityBroker', N'ON'
GO
USE [Unify.IdentityBroker]
GO
/****** Object:  User [FIM-DEV5\svc-idmavt]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE USER [FIM-DEV5\svc-idmavt] FOR LOGIN [FIM-DEV5\svc-idmavt] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [fim-dev5\idm-us-dev-idb]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE USER [fim-dev5\idm-us-dev-idb] FOR LOGIN [fim-dev5\idm-us-dev-idb] WITH DEFAULT_SCHEMA=[dbo]
GO
ALTER ROLE [db_datareader] ADD MEMBER [FIM-DEV5\svc-idmavt]
GO
ALTER ROLE [db_owner] ADD MEMBER [fim-dev5\idm-us-dev-idb]
GO
ALTER ROLE [db_datareader] ADD MEMBER [fim-dev5\idm-us-dev-idb]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [fim-dev5\idm-us-dev-idb]
GO
/****** Object:  Table [dbo].[Changes_bak]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Changes_bak](
	[ChangesKey] [int] IDENTITY(1,1) NOT NULL,
	[EntityId] [uniqueidentifier] NOT NULL,
	[AdapterId] [uniqueidentifier] NOT NULL,
	[ChangeTimestamp] [bigint] NOT NULL,
 CONSTRAINT [PK_Changes_Identity] PRIMARY KEY CLUSTERED 
(
	[ChangesKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CollectionKey]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CollectionKey](
	[CollectionKeyId] [int] IDENTITY(1,1) NOT NULL,
	[Caption] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_CollectionKey] PRIMARY KEY CLUSTERED 
(
	[CollectionKeyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Container]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Container](
	[PartitionId] [uniqueidentifier] NOT NULL,
	[ContainerId] [uniqueidentifier] NOT NULL,
	[DistinguishedName] [nvarchar](400) NOT NULL,
 CONSTRAINT [PK_Container] PRIMARY KEY CLUSTERED 
(
	[ContainerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Entity]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Entity](
	[EntityKey] [bigint] IDENTITY(1,1) NOT NULL,
	[EntityId] [uniqueidentifier] NOT NULL,
	[PartitionId] [uniqueidentifier] NOT NULL,
	[ObjectClassId] [int] NULL,
	[DN] [nvarchar](400) NULL,
 CONSTRAINT [PK_Entity] PRIMARY KEY NONCLUSTERED 
(
	[EntityId] ASC,
	[PartitionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[EntityValue]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EntityValue](
	[EntityValueKey] [bigint] IDENTITY(1,1) NOT NULL,
	[EntityValueId] [uniqueidentifier] NOT NULL,
	[EntityId] [uniqueidentifier] NOT NULL,
	[ValueType] [int] NOT NULL,
	[BigIntValue] [bigint] NULL,
	[BitValue] [bit] NULL,
	[FloatValue] [float] NULL,
	[ImageValue] [varbinary](max) NULL,
	[IntValue] [int] NULL,
	[StringValue] [nvarchar](max) NULL,
	[StringHash] [int] NULL,
	[UniqueIdentifierValue] [uniqueidentifier] NULL,
	[PartitionId] [uniqueidentifier] NOT NULL,
	[CollectionKeyId] [int] NOT NULL,
	[ValueOrder] [int] NOT NULL CONSTRAINT [DF_EntityValue_ValueOrder]  DEFAULT ((0)),
	[DecimalValue] [decimal](38, 12) NULL,
 CONSTRAINT [PK_EntityValue] PRIMARY KEY NONCLUSTERED 
(
	[EntityValueId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[EntityValue_bak]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EntityValue_bak](
	[EntityValueKey] [bigint] IDENTITY(1,1) NOT NULL,
	[EntityValueId] [uniqueidentifier] NOT NULL,
	[EntityId] [uniqueidentifier] NOT NULL,
	[ValueType] [int] NOT NULL,
	[BigIntValue] [bigint] NULL,
	[BitValue] [bit] NULL,
	[FloatValue] [float] NULL,
	[ImageValue] [varbinary](max) NULL,
	[IntValue] [int] NULL,
	[StringValue] [nvarchar](max) NULL,
	[StringHash] [int] NULL,
	[UniqueIdentifierValue] [uniqueidentifier] NULL,
	[PartitionId] [uniqueidentifier] NOT NULL,
	[CollectionKeyId] [int] NOT NULL,
	[ValueOrder] [int] NOT NULL,
	[DecimalValue] [decimal](38, 12) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ObjectClass]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ObjectClass](
	[ObjectClassId] [int] IDENTITY(1,1) NOT NULL,
	[ClassName] [nvarchar](50) NOT NULL,
	[PartitionId] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_ObjectClass_1] PRIMARY KEY CLUSTERED 
(
	[ObjectClassId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Partition]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Partition](
	[PartitionId] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_Connector] PRIMARY KEY CLUSTERED 
(
	[PartitionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[StoredValueCollection]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoredValueCollection](
	[StoredValueCollectionKey] [bigint] IDENTITY(1,1) NOT NULL,
	[StoredValueCollectionId] [uniqueidentifier] NOT NULL,
	[Values] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_StoredValueCollection] PRIMARY KEY NONCLUSTERED 
(
	[StoredValueCollectionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[StoredValueCollection_bak]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoredValueCollection_bak](
	[StoredValueCollectionKey] [bigint] IDENTITY(1,1) NOT NULL,
	[StoredValueCollectionId] [uniqueidentifier] NOT NULL,
	[Values] [nvarchar](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  View [dbo].[AdapterEntityChanges]    Script Date: 11/06/2015 1:40:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[AdapterEntityChanges] AS
(SELECT     dbo.Entity.EntityKey, dbo.Entity.EntityId, C.AdapterId AS PartitionId, dbo.Entity.ObjectClassId, dbo.Entity.DN, C.ChangeTimestamp, 
                      dbo.Entity.PartitionId AS BaseReferenceId
FROM         dbo.Entity INNER JOIN
                      dbo.Changes AS C ON dbo.Entity.EntityId = C.EntityId
WHERE     (C.ChangesKey =
                          (SELECT     TOP (1) ChangesKey
                            FROM          dbo.Changes AS D
                            WHERE      (dbo.Entity.EntityId = EntityId)
                            ORDER BY ChangeTimestamp)) AND (dbo.Entity.ObjectClassId IS NULL) AND (dbo.Entity.DN IS NULL))
GO
/****** Object:  Index [IX_EntityKey]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE CLUSTERED INDEX [IX_EntityKey] ON [dbo].[Entity]
(
	[EntityKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_EntityValueKey]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE CLUSTERED INDEX [IX_EntityValueKey] ON [dbo].[EntityValue]
(
	[EntityValueKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_StoredValueCollectionKey]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE CLUSTERED INDEX [IX_StoredValueCollectionKey] ON [dbo].[StoredValueCollection]
(
	[StoredValueCollectionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_StoredValueCollectionKey]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE CLUSTERED INDEX [IX_StoredValueCollectionKey] ON [dbo].[StoredValueCollection_bak]
(
	[StoredValueCollectionKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Entity_PartitionId]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_Entity_PartitionId] ON [dbo].[Entity]
(
	[PartitionId] ASC,
	[EntityId] ASC
)
INCLUDE ( 	[ObjectClassId],
	[DN]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_EntityValue_EntityId_PartitionId]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_EntityId_PartitionId] ON [dbo].[EntityValue]
(
	[PartitionId] ASC,
	[EntityId] ASC
)
INCLUDE ( 	[CollectionKeyId]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_EntityValue_StringHash]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_StringHash] ON [dbo].[EntityValue]
(
	[StringHash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_EntityValue_ValueTypes]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_ValueTypes] ON [dbo].[EntityValue]
(
	[CollectionKeyId] ASC,
	[PartitionId] ASC,
	[EntityId] ASC,
	[EntityValueId] ASC
)
INCLUDE ( 	[ValueType],
	[BigIntValue],
	[BitValue],
	[FloatValue],
	[IntValue],
	[StringValue],
	[UniqueIdentifierValue],
	[ValueOrder],
	[DecimalValue]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_EntityValue_EntityId_PartitionId]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_EntityId_PartitionId] ON [dbo].[EntityValue_bak]
(
	[PartitionId] ASC,
	[EntityId] ASC
)
INCLUDE ( 	[CollectionKeyId]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_EntityValue_StringHash]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_StringHash] ON [dbo].[EntityValue_bak]
(
	[StringHash] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_EntityValue_ValueTypes]    Script Date: 11/06/2015 1:40:08 PM ******/
CREATE NONCLUSTERED INDEX [IX_EntityValue_ValueTypes] ON [dbo].[EntityValue_bak]
(
	[CollectionKeyId] ASC,
	[PartitionId] ASC,
	[EntityId] ASC,
	[EntityValueId] ASC
)
INCLUDE ( 	[ValueType],
	[BigIntValue],
	[BitValue],
	[FloatValue],
	[IntValue],
	[StringValue],
	[UniqueIdentifierValue],
	[ValueOrder],
	[DecimalValue]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Container]  WITH NOCHECK ADD  CONSTRAINT [FK_Container_Container] FOREIGN KEY([PartitionId])
REFERENCES [dbo].[Partition] ([PartitionId])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Container] CHECK CONSTRAINT [FK_Container_Container]
GO
ALTER TABLE [dbo].[Entity]  WITH NOCHECK ADD  CONSTRAINT [FK_Entity_ObjectClass] FOREIGN KEY([ObjectClassId])
REFERENCES [dbo].[ObjectClass] ([ObjectClassId])
GO
ALTER TABLE [dbo].[Entity] CHECK CONSTRAINT [FK_Entity_ObjectClass]
GO
ALTER TABLE [dbo].[Entity]  WITH NOCHECK ADD  CONSTRAINT [FK_Entity_Partition] FOREIGN KEY([PartitionId])
REFERENCES [dbo].[Partition] ([PartitionId])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Entity] CHECK CONSTRAINT [FK_Entity_Partition]
GO
ALTER TABLE [dbo].[EntityValue]  WITH CHECK ADD  CONSTRAINT [FK_EntityValue_CollectionKey] FOREIGN KEY([CollectionKeyId])
REFERENCES [dbo].[CollectionKey] ([CollectionKeyId])
GO
ALTER TABLE [dbo].[EntityValue] CHECK CONSTRAINT [FK_EntityValue_CollectionKey]
GO
ALTER TABLE [dbo].[EntityValue]  WITH CHECK ADD  CONSTRAINT [FK_EntityValue_Entity] FOREIGN KEY([EntityId], [PartitionId])
REFERENCES [dbo].[Entity] ([EntityId], [PartitionId])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[EntityValue] CHECK CONSTRAINT [FK_EntityValue_Entity]
GO
ALTER TABLE [dbo].[ObjectClass]  WITH CHECK ADD  CONSTRAINT [FK_ObjectClass_Partition] FOREIGN KEY([PartitionId])
REFERENCES [dbo].[Partition] ([PartitionId])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ObjectClass] CHECK CONSTRAINT [FK_ObjectClass_Partition]
GO
USE [master]
GO
ALTER DATABASE [Unify.IdentityBroker] SET  READ_WRITE 
GO