USE [Configuration02_Def]
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=1)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (1, 1, N'Type', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=2)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (2, 2, N'Type', N'=', N'<Empty>', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=3)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (3, 3, N'Type', N'=', N'2', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=5)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (5, 5, N'Type', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=6)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (6, 6, N'Type', N'=', N'<Empty>', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=7)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (7, 7, N'Type', N'=', N'1', N'AND', 0, 0, 0, 0, 1, NULL, 14)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=8)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (8, 8, N'Show Advanced', N'=', N'', N'AND', 0, 0, 0, 0, 1, NULL, 928)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblRuleCondition] WHERE nID=9)
	INSERT [dbo].[tblRuleCondition] ([nID], [nRuleID], [tName], [tTest], [tValue], [tAndOr], [nLevel], [nParent], [nChild], [nBrother], [nRow], [tValuesSource], [nFieldID]) 
	VALUES (9, 9, N'Show Advanced', N'=', N'2', N'AND', 0, 0, 0, 0, 1, NULL, 928)
GO

