USE [censusweb_mdb]
GO

IF NOT EXISTS(SELECT * FROM [TblViewFrameSettings] WHERE nViewID=72)
BEGIN
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 1, 1, 0)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 2, 1, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 3, 1, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 4, 1, 20)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 5, 1, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 6, 1, 30)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 7, 1, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 1, 2, 0)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 2, 2, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 3, 2, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 4, 2, 20)
	
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 5, 2, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 6, 2, 30)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 7, 2, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 1, 3, 0)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 2, 3, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 3, 3, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 4, 3, 20)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 5, 3, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 6, 3, 30)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 7, 3, 10)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 1, 4, 0)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 2, 4, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 3, 4, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 4, 4, 32)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 5, 4, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 6, 4, 50)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 7, 4, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 1, 5, 0)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 2, 5, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 3, 5, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 4, 5, 32)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 5, 5, 5)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 6, 5, 50)

	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) 
	VALUES (72, 7, 5, 5)
END

IF NOT EXISTS(SELECT * FROM [TblViewFrameSettings] WHERE nViewID=86)
BEGIN
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 1, 1, 0)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 2, 1, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 3, 1, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 4, 1, 20)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 5, 1, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 6, 1, 30)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 7, 1, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 1, 2, 0)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 2, 2, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 3, 2, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 4, 2, 20)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 5, 2, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 6, 2, 30)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 7, 2, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 1, 3, 0)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 2, 3, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 3, 3, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 4, 3, 20)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 5, 3, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 6, 3, 30)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 7, 3, 10)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 1, 4, 0)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 2, 4, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 3, 4, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 4, 4, 32)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 5, 4, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 6, 4, 50)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 7, 4, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 1, 5, 0)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 2, 5, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 3, 5, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 4, 5, 32)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 5, 5, 5)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 6, 5, 50)
	INSERT [dbo].[TblViewFrameSettings] ([nViewID], [nFrameID], [nResID], [nFrameSize]) VALUES (86, 7, 5, 5)
END

