USE [UnifyIdBroker]
GO
/****** Object:  Table [dbo].[CollectionKey]    Script Date: 09/15/2015 14:38:11 ******/
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 NONCLUSTERED 
(
	[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].[Changes]    Script Date: 09/15/2015 14:38:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Changes](
	[EntityId] [uniqueidentifier] NOT NULL,
	[AdapterId] [uniqueidentifier] NOT NULL,
	[ChangeTimestamp] [bigint] NOT NULL,
 CONSTRAINT [PK_Changes] PRIMARY KEY NONCLUSTERED 
(
	[EntityId] ASC,
	[AdapterId] ASC,
	[ChangeTimestamp] 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: 09/15/2015 14:38:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoredValueCollection](
	[StoredValueCollectionId] [uniqueidentifier] NOT NULL,
	[Values] [ntext] NOT NULL,
 CONSTRAINT [PK_StoredValueCollection] PRIMARY KEY CLUSTERED 
(
	[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].[Partition]    Script Date: 09/15/2015 14:38:11 ******/
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].[ObjectClass]    Script Date: 09/15/2015 14:38:11 ******/
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].[Container]    Script Date: 09/15/2015 14:38:11 ******/
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: 09/15/2015 14:38:11 ******/
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: 09/15/2015 14:38:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER 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] [image] NULL,
	[IntValue] [int] NULL,
	[StringValue] [nvarchar](450) NULL,
	[TextValue] [text] NULL,
	[UniqueIdentifierValue] [uniqueidentifier] NULL,
	[PartitionId] [uniqueidentifier] NOT NULL,
	[CollectionKeyId] [int] NOT NULL,
	[ValueOrder] [int] NOT NULL,
	[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
/****** Object:  Default [DF_EntityValue_ValueOrder]    Script Date: 09/15/2015 14:38:11 ******/
ALTER TABLE [dbo].[EntityValue] ADD  CONSTRAINT [DF_EntityValue_ValueOrder]  DEFAULT ((0)) FOR [ValueOrder]
GO
/****** Object:  ForeignKey [FK_Container_Container]    Script Date: 09/15/2015 14:38:11 ******/
ALTER TABLE [dbo].[Container]  WITH CHECK ADD  CONSTRAINT [FK_Container_Container] FOREIGN KEY([PartitionId])
REFERENCES [dbo].[Partition] ([PartitionId])
GO
ALTER TABLE [dbo].[Container] CHECK CONSTRAINT [FK_Container_Container]
GO
/****** Object:  ForeignKey [FK_Entity_ObjectClass]    Script Date: 09/15/2015 14:38:11 ******/
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
/****** Object:  ForeignKey [FK_Entity_Partition]    Script Date: 09/15/2015 14:38:11 ******/
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
/****** Object:  ForeignKey [FK_EntityValue_CollectionKey]    Script Date: 09/15/2015 14:38:11 ******/
ALTER TABLE [dbo].[EntityValue]  WITH NOCHECK ADD  CONSTRAINT [FK_EntityValue_CollectionKey] FOREIGN KEY([CollectionKeyId])
REFERENCES [dbo].[CollectionKey] ([CollectionKeyId])
GO
ALTER TABLE [dbo].[EntityValue] CHECK CONSTRAINT [FK_EntityValue_CollectionKey]
GO
/****** Object:  ForeignKey [FK_EntityValue_Entity]    Script Date: 09/15/2015 14:38:11 ******/
ALTER TABLE [dbo].[EntityValue]  WITH NOCHECK 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
/****** Object:  ForeignKey [FK_ObjectClass_Partition]    Script Date: 09/15/2015 14:38:11 ******/
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