USE [Resources02_Def]
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblSystemLayouts] WHERE nID=14)
BEGIN
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 15, N'', 2, 30);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, N'', 6, 918);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, NULL, 1, 1093);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, NULL, 11, 919);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, NULL, 13, 921);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, NULL, 17, 865);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID])
	VALUES (14, N'Left', 10, NULL, 19, 1082);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, NULL, 23, 882);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, N'', 27, 1);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, N'Check Out', 25, 7);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, N'', 30, 886);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, N'', 32, 898);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, N'', 33, 801);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, N'', 35, 806);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 10, N'Return Date', 26, 1078);

	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (14, N'Left', 0, NULL, 37, 1092);

END

IF NOT EXISTS(SELECT * FROM [dbo].[tblSystemLayouts] WHERE nID=15)
BEGIN
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 15, N'', 1, 30);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'', 5, 918);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, NULL, 16, 843);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'', 10, 921);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'', 12, 919);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, NULL, 18, 865);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'', 20, 11);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'Location', 24, 882);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 27, 1);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 29, 850);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 31, 886);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 32, 898);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 34, 801);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, N'', 35, 806);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'', 36, 29);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, NULL, 17, 69);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'Asset Type', 38, 1093);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, NULL, 40, 993);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 0, NULL, 42, 1092);
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (15, N'Left', 10, N'No. Repairs', 26, 68);
END

GO
IF NOT EXISTS(SELECT * FROM [dbo].[tblSystemLayouts] WHERE nID=16)
BEGIN
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 15, N'', 1, 30)

	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 10, N'', 9, 921)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 10, N'', 11, 919)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 10, N'Responsible', 16, 11)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 10, NULL, 20, 882)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 10, NULL, 25, 7)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, N'', 26, 1)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, N'', 28, 850)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, N'', 30, 886)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, N'', 32, 898)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, N'', 34, 801)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, NULL, 36, 993)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, NULL, 37, 1092)
	
	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, NULL, 38, 1093)

	INSERT [dbo].[tblSystemLayouts] ([nID], [tAlign], [nWidth], [tTitle], [nRow], [nDtsFieldID]) 
	VALUES (16, N'Left', 0, NULL, 39, 1004)
END
