USE [Licenses_mdb]
GO
INSERT [dbo].[tblProjectDS] ([nProjectId], [tName], [tLocation], [tAltLocation], [nDSType], [nProviderType], [nSecurityDB], [tSecurityAccess], [tAltConnString], [nAltConnStringOperation], [nOrder]) VALUES (28, N'Configuration01_Dat', N'DEV-SRVVZ01\VECTOR2022', N'DEV-SRVVZ01\VECTOR2022', 32, 2, 0, N'internal', N';', 1, 0)
INSERT [dbo].[tblProjectDS] ([nProjectId], [tName], [tLocation], [tAltLocation], [nDSType], [nProviderType], [nSecurityDB], [tSecurityAccess], [tAltConnString], [nAltConnStringOperation], [nOrder]) VALUES (28, N'Configuration02_Def', N'DEV-SRVVZ01\VECTOR2022', N'DEV-SRVVZ01\VECTOR2022', 64, 2, 0, N'internal', N';', 1, 0)
INSERT [dbo].[tblProjectDS] ([nProjectId], [tName], [tLocation], [tAltLocation], [nDSType], [nProviderType], [nSecurityDB], [tSecurityAccess], [tAltConnString], [nAltConnStringOperation], [nOrder]) VALUES (28, N'Configuration03.Usr', N'<Server>', N'<Server>', 128, 1, 512, N'internal', N';;', 1, 0)
GO
INSERT [dbo].[tblProjects] ([nID], [tName], [dCreateDate], [tDatName], [tDefName], [tUsrName], [tCenName], [nProjectVersion], [fFieldsChanged], [tProjectFilesLocation], [nWebTimeOut], [nTemplateID], [nBaseProjectID], [nProjectMinorVersion], [tShareDefName], [nDatProviderType], [tDatLocation], [tProjectFilesAltLocation]) VALUES (28, N'Configuration', NULL, NULL, NULL, NULL, N'Configuration.cen', 40, 0, N'<Server>', NULL, 28, -1, 0, N'Configuration', 2, N'<Server>\Configuration\Data', N'<Server>')
GO
/***
CReate fields on MAIL Integration 
***/
USE [HelpDesk02_Def]
GO
ALTER TABLE [dbo].[tblMailIntegration] ADD [tLastProcessedEmail] [nvarchar](255) NULL,	[nConfigurationItem] [int] NULL




INSERT INTO HelpDesk02_Def.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(986, N'tblDts', 32, N'CreatedFromExtEntity', 1, 10, 255, N'Created From External Entity', 0, 0, NULL, 0, 1, 1, 1, NULL, 1, 0, 0, N'Created From External Entity', NULL, N'986', 3, NULL, 0, -1, 0, 0, NULL, NULL, 1, N'Created From External Entity')