CREATE TABLE [dbo].[ICConfigIncludeRules]
(
[ConfigIncludeRuleID] [int] NOT NULL IDENTITY(1, 1),
[ConfigNodeID] [int] NOT NULL,
[ConfigID] [int] NOT NULL,
[LowQty] [decimal] (14, 4) NOT NULL,
[HighQty] [decimal] (14, 4) NOT NULL,
[PrevConfigIncludeRuleID] [int] NULL,
[PrevRuleCompareType] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigIncludeRules] ADD CONSTRAINT [PK__ICConfig__2CF0D03EC848C525] PRIMARY KEY CLUSTERED ([ConfigIncludeRuleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigIncludeRules] ADD CONSTRAINT [FK_ICConfigIncludeRules_PrevConfigIncludeRuleID_ICConfigIncludeRules] FOREIGN KEY ([PrevConfigIncludeRuleID]) REFERENCES [dbo].[ICConfigIncludeRules] ([ConfigIncludeRuleID])
GO