USE [LicenseManager02_Def]
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=765)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (765, N'tblDts', 32, N'Allocation_Type', 1, 103, 50, N'Allocation Type', 0, 0, N'tblAllocationType', 64, 1, 1, 1, NULL, 1, 1, NULL, N'Allocation Type', NULL, N'cbo_765_Allocation_Type', 14, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=766)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (766, N'tblDts', 32, N'Allocate_to_User', 1, 104, 50, N'Allocate to Users', 0, 0, N'tblUser', 16, 1, 0, 0, NULL, 1, 1, NULL, N'Allocate to Users', NULL, N'lst_766_Allocate_to_User', 8, N'Where (((([nID] >= 0 And  [tName]  <> '''') Or [tName]  = ''<User>'') And (Security_Type = 1 Or Security_Type = 8) And nStateID=1) Or [tName] = ''<None>'')', 0, -1, 1, NULL, NULL, NULL, 3, NULL)
GO

IF NOT EXISTS(SELECT * FROM [dbo].[tblDtsFields] WHERE nID=767)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (767, N'tblDts', 32, N'Allocate_to_Device___Computer', 1, 104, 50, N'Allocate to Devices / Computers', 0, 0, N'Computer', 16, 1, 0, 0, NULL, 1, 1, NULL, N'Allocate to Devices / Computers', NULL, N'lst_767_Allocate_to_Device___Computer', 8, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

UPDATE tblDtsFields SET tFieldValuesTable='AssetType', nValueTableDSType=16, tValueTableIDFld=NULL, tValueTableNameFld=NULL WHERE nID=762 AND tFieldValuesTable='tblDts' AND tName='Asset_Type'
GO



