CREATE TABLE [dbo].[ICConfigNodes]
(
[ConfigNodeID] [int] NOT NULL IDENTITY(1, 1),
[ConfigID] [int] NOT NULL,
[ConfigNodeParentID] [int] NULL,
[ConfigNodeTypeID] [int] NOT NULL,
[ItemID] [int] NULL,
[ConfigTitleID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ordinal] [int] NOT NULL,
[DefaultValue] [tinyint] NULL,
[Exclusivity] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_Exclusivity] DEFAULT ((0)),
[Required] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_Required] DEFAULT ((0)),
[StartDate] [datetime] NULL,
[ExpDate] [datetime] NULL,
[EvenOnly] [bit] NULL,
[MaxValue] [tinyint] NULL,
[MinValue] [tinyint] NULL,
[OptionsText] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RelationRulesText] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AutoCost] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_AutoCost] DEFAULT ((1)),
[AutoPrice] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_AutoPrice] DEFAULT ((1)),
[RollUp] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_RollUp] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [PK__ICConfig__AE1433C32ED83E9C] PRIMARY KEY CLUSTERED ([ConfigNodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ConfigID_ICConfigs] FOREIGN KEY ([ConfigID]) REFERENCES [dbo].[ICConfigs] ([ConfigID])
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ConfigNodeParentID_ICConfigNodes] FOREIGN KEY ([ConfigNodeParentID]) REFERENCES [dbo].[ICConfigNodes] ([ConfigNodeID])
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO