Add TTY as a device type to the database

Use ngdeliveryGo
    DECLARE @deviceType NVARCHAR(50),@ResourceType NVARCHAR(50)
    SELECT @deviceType='TTY'
    SELECT @ResourceType='CONCURRENT'
    IF NOT EXISTS (SELECT * FROM NGDeliveryAccount.dbo.DatacenterSiteDetail a
    INNER JOIN ProductInfo b 
    ON a.SiteId=b.SiteId 
    WHERE a.DeviceType=@deviceType) 
BEGIN
    INSERT INTO NGDeliveryAccount.dbo.DatacenterSiteDetail([DataCenterId],[SiteId],[DeviceType],[ResourceType],[CreatedOn])
    SELECT 1,siteid , @deviceType,@ResourceType ,GETUTCDATE()
    FROM ProductInfo
END

Insert into [ngdeliveryaccount].[dbo].[RscDeviceMap] ( [DeviceType] ,[ResourceId] ,[ResourceCount]) values ('TTY', 1, 1)