--**********Check if UET field already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_fld] WHERE [fld_name] = 'Uf_ILC_Timesheet')

	--Create the UET field
	INSERT INTO [dbo].[user_fld] ([fld_name],[fld_data_type],[fld_initial],[fld_decimals],[fld_desc],[fld_UDT],[fld_prec])
	VALUES ('Uf_ILC_Timesheet','tinyint','0',NULL,'Boolean flag indicating if entry came via timesheet','ILC_BooleanType',NULL)
ELSE
	--Update the UET field
	UPDATE [dbo].[user_fld] SET [fld_data_type] = 'tinyint', [fld_initial] = '0', [fld_decimals] = NULL, [fld_desc] = 'Boolean flag indicating if entry came via timesheet'
	,[fld_UDT] = 'ILC_BooleanType', [fld_prec] = NULL WHERE [fld_name] = 'Uf_ILC_Timesheet'




--**********UET Classes

--Check if UET Class already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class] WHERE [class_name] = 'ILC_JobTran')

	--Create the UET class
	INSERT INTO [dbo].[user_class] ([class_name],[class_label],[class_desc])
	VALUES ('ILC_JobTran','ILC_JobTran',NULL)

ELSE
	PRINT('UET Class already exists')

--Check if UET Class already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class] WHERE [class_name] = 'ILC_Projlabr')

	--Create the UET class
	INSERT INTO [dbo].[user_class] ([class_name],[class_label],[class_desc])
	VALUES ('ILC_Projlabr','Projlabr','Projlabr')

ELSE
	PRINT('UET Class already exists')

--Check if UET Class already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class] WHERE [class_name] = 'ILC_Projtran')

	--Create the UET class
	INSERT INTO [dbo].[user_class] ([class_name],[class_label],[class_desc])
	VALUES ('ILC_Projtran','ILC_Projtran',NULL)

ELSE
	PRINT('UET Class already exists')




--**********UET Class Field Relationship

--Check if UET Class Field relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_JobTran' AND [fld_name] = 'Uf_ILC_Timesheet')

	--Create the UET Class Field relationship
	INSERT INTO [dbo].[user_class_fld] ([class_name],[fld_name])
	VALUES ('ILC_JobTran','Uf_ILC_Timesheet')

ELSE
	PRINT('UET Class-Field relationship already exists')

--Check if UET Class Field relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projlabr' AND [fld_name] = 'Uf_ILC_Timesheet')

	--Create the UET Class Field relationship
	INSERT INTO [dbo].[user_class_fld] ([class_name],[fld_name])
	VALUES ('ILC_Projlabr','Uf_ILC_Timesheet')

ELSE
	PRINT('UET Class-Field relationship already exists')

--Check if UET Class Field relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[user_class_fld] WHERE [class_name] = 'ILC_Projtran' AND [fld_name] = 'Uf_ILC_Timesheet')

	--Create the UET Class Field relationship
	INSERT INTO [dbo].[user_class_fld] ([class_name],[fld_name])
	VALUES ('ILC_Projtran','Uf_ILC_Timesheet')

ELSE
	PRINT('UET Class-Field relationship already exists')




--**********UET Table Class Relationship

--Check if UET Table Class relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [table_name] = 'jobtran' AND [class_name] = 'ILC_JobTran')

	--Create the UET Table Class relationship
	INSERT INTO [dbo].[table_class] ([table_name],[class_name],[table_rule],[extend_all_recs],[active])
	VALUES ('jobtran','ILC_JobTran',NULL,0,1)

ELSE
	PRINT('UET Table-Class relationship already exists')

--Check if UET Table Class relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [table_name] = 'projlabr' AND [class_name] = 'ILC_Projlabr')

	--Create the UET Table Class relationship
	INSERT INTO [dbo].[table_class] ([table_name],[class_name],[table_rule],[extend_all_recs],[active])
	VALUES ('projlabr','ILC_Projlabr',NULL,0,1)

ELSE
	PRINT('UET Table-Class relationship already exists')

--Check if UET Table Class relationship already exists
IF NOT EXISTS(SELECT TOP 1 1 FROM [dbo].[table_class] WHERE [table_name] = 'Projtran' AND [class_name] = 'ILC_Projtran')

	--Create the UET Table Class relationship
	INSERT INTO [dbo].[table_class] ([table_name],[class_name],[table_rule],[extend_all_recs],[active])
	VALUES ('Projtran','ILC_Projtran',NULL,0,1)

ELSE
	PRINT('UET Table-Class relationship already exists')



PRINT('Do NOT forget to Impact Schema via SyteLine form')