767 lines
62 KiB
Transact-SQL
767 lines
62 KiB
Transact-SQL
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_TestEngineerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [FK_TestSetups_TestEngineerDetails]
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_LabratoryDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [FK_TestSetups_LabratoryDetails]
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_CustomerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [FK_TestSetups_CustomerDetails]
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SuppressMissingSensorsWarning]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_SuppressMissingSensorsWarning]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_NotAllChannelsViewer]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_NotAllChannelsViewer]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_NotAllChannelsRealTime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_NotAllChannelsRealTime]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_QuitTestWithoutWarning]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_QuitTestWithoutWarning]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ISFFile]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ISFFile]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CheckoutMode]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_CheckoutMode]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DoAutoArm]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_DoAutoArm]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UseTestEngineerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_UseTestEngineerDetails]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestEngineerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TestEngineerDetails]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ErrorMessage]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ErrorMessage]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Complete]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_Complete]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Dirty]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_Dirty]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_WarnOnBatteryFail]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_WarnOnBatteryFail]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Settings]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_Settings]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UploadDataFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_UploadDataFolder]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UploadData]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_UploadData]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SameAsDownloadFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_SameAsDownloadFolder]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CommonStatusLine]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_CommonStatusLine]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DownloadFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_DownloadFolder]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ExportFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ExportFolder]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_PostTestDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_PostTestDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TriggerCheckStep]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TriggerCheckStep]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TriggerCheckRealtime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TriggerCheckRealtime]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TurnOffExcitation]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TurnOffExcitation]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LastModifiedBy]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_LastModifiedBy]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LocalOnly]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_LocalOnly]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AllowSensorIdToBlankChannel]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_AllowSensorIdToBlankChannel]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AllowMissingSensors]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_AllowMissingSensors]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UseCustomerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_UseCustomerDetails]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CustomerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_CustomerDetails]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestEngineerId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TestEngineerId]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LabratoryId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_LabratoryId]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CustomerId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_CustomerId]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LabDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_LabDetails]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Export]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_Export]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewDownloadAll]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ViewDownloadAll]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RealtimePlotCount]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_RealtimePlotCount]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewRealtime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ViewRealtime]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DownloadAll]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_DownloadAll]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewROIDownload]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ViewROIDownload]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ROIDownload]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ROIDownload]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RequireConfirmationOnErrors]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_RequireConfirmationOnErrors]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_StrictDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_StrictDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RecordingMode]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_RecordingMode]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_VerifyChannelsDelayMS]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_VerifyChannelsDelayMS]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutoVerifyChannels]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_AutoVerifyChannels]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_VerifyChannels]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_VerifyChannels]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_ViewDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_InvertStart]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_InvertStart]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_InvertTrigger]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_InvertTrigger]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutomaticProgressionDelayMS]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_AutomaticProgressionDelayMS]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutomaticTestProgression]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_AutomaticTestProgression]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SetupDescription]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_SetupDescription]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestSetupName]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT [DF_TestSetups_TestSetupName]
|
||
END
|
||
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSetups]') AND type in (N'U'))
|
||
DROP TABLE [dbo].[TestSetups]
|
||
GO
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
SET ANSI_PADDING ON
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSetups]') AND type in (N'U'))
|
||
BEGIN
|
||
CREATE TABLE [dbo].[TestSetups](
|
||
[TestSetupId] [int] IDENTITY(1,1) NOT NULL,
|
||
[TestSetupName] [nvarchar](50) NOT NULL,
|
||
[SetupDescription] [nvarchar](50) NOT NULL,
|
||
[AutomaticTestProgression] [bit] NOT NULL,
|
||
[AutomaticProgressionDelayMS] [int] NOT NULL,
|
||
[InvertTrigger] [bit] NOT NULL,
|
||
[InvertStart] [bit] NOT NULL,
|
||
[ViewDiagnostics] [bit] NOT NULL,
|
||
[VerifyChannels] [bit] NOT NULL,
|
||
[AutoVerifyChannels] [bit] NOT NULL,
|
||
[VerifyChannelsDelayMS] [int] NOT NULL,
|
||
[RecordingMode] [smallint] NOT NULL,
|
||
[SamplesPerSecond] [float] NOT NULL,
|
||
[PreTriggerSeconds] [float] NOT NULL,
|
||
[PostTriggerSeconds] [float] NOT NULL,
|
||
[StrictDiagnostics] [bit] NOT NULL,
|
||
[RequireConfirmationOnErrors] [bit] NOT NULL,
|
||
[ROIDownload] [bit] NOT NULL,
|
||
[ViewROIDownload] [bit] NOT NULL,
|
||
[DownloadAll] [bit] NOT NULL,
|
||
[ViewRealtime] [bit] NOT NULL,
|
||
[RealtimePlotCount] [smallint] NOT NULL,
|
||
[ROIStart] [float] NOT NULL,
|
||
[ROIEnd] [float] NOT NULL,
|
||
[ViewDownloadAll] [bit] NOT NULL,
|
||
[Export] [bit] NOT NULL,
|
||
[ExportFormat] [bigint] NOT NULL,
|
||
[LabDetails] [nvarchar](50) NULL,
|
||
[UseLabDetails] [bit] NOT NULL,
|
||
[CustomerId] [int] NOT NULL,
|
||
[LabratoryId] [int] NOT NULL,
|
||
[TestEngineerId] [int] NOT NULL,
|
||
[CustomerDetails] [nvarchar](50) NULL,
|
||
[UseCustomerDetails] [bit] NOT NULL,
|
||
[AllowMissingSensors] [bit] NOT NULL,
|
||
[AllowSensorIdToBlankChannel] [bit] NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[TurnOffExcitation] [bit] NOT NULL,
|
||
[TriggerCheckRealtime] [bit] NOT NULL,
|
||
[TriggerCheckStep] [bit] NOT NULL,
|
||
[PostTestDiagnostics] [int] NOT NULL,
|
||
[ExportFolder] [nvarchar](150) NOT NULL,
|
||
[DownloadFolder] [nvarchar](150) NOT NULL,
|
||
[CommonStatusLine] [bit] NULL,
|
||
[SameAsDownloadFolder] [bit] NULL,
|
||
[UploadData] [bit] NULL,
|
||
[UploadDataFolder] [nvarchar](150) NOT NULL,
|
||
[Settings] [nvarchar](255) NOT NULL,
|
||
[WarnOnBatteryFail] [bit] NOT NULL,
|
||
[Dirty] [bit] NOT NULL,
|
||
[Complete] [bit] NOT NULL,
|
||
[ErrorMessage] [nvarchar](255) NULL,
|
||
[TestEngineerDetails] [nvarchar](50) NULL,
|
||
[UseTestEngineerDetails] [bit] NOT NULL,
|
||
[UserTags] [varbinary](max) NULL,
|
||
[DoAutoArm] [bit] NULL,
|
||
[CheckoutMode] [bit] NULL,
|
||
[ISFFile] [nvarchar](4000) NULL,
|
||
[QuitTestWithoutWarning] [bit] NULL,
|
||
[NotAllChannelsRealTime] [bit] NULL,
|
||
[NotAllChannelsViewer] [bit] NULL,
|
||
[SuppressMissingSensorsWarning] [bit] NULL,
|
||
CONSTRAINT [PK_TestSetups] PRIMARY KEY CLUSTERED
|
||
(
|
||
[TestSetupId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
||
END
|
||
GO
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestSetupName]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TestSetupName] DEFAULT (space((0))) FOR [TestSetupName]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SetupDescription]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_SetupDescription] DEFAULT (space((0))) FOR [SetupDescription]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutomaticTestProgression]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_AutomaticTestProgression] DEFAULT ((0)) FOR [AutomaticTestProgression]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutomaticProgressionDelayMS]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_AutomaticProgressionDelayMS] DEFAULT ((0)) FOR [AutomaticProgressionDelayMS]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_InvertTrigger]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_InvertTrigger] DEFAULT ((0)) FOR [InvertTrigger]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_InvertStart]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_InvertStart] DEFAULT ((0)) FOR [InvertStart]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ViewDiagnostics] DEFAULT ((0)) FOR [ViewDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_VerifyChannels]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_VerifyChannels] DEFAULT ((0)) FOR [VerifyChannels]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AutoVerifyChannels]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_AutoVerifyChannels] DEFAULT ((0)) FOR [AutoVerifyChannels]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_VerifyChannelsDelayMS]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_VerifyChannelsDelayMS] DEFAULT ((0)) FOR [VerifyChannelsDelayMS]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RecordingMode]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_RecordingMode] DEFAULT ((0)) FOR [RecordingMode]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_StrictDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_StrictDiagnostics] DEFAULT ((0)) FOR [StrictDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RequireConfirmationOnErrors]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_RequireConfirmationOnErrors] DEFAULT ((0)) FOR [RequireConfirmationOnErrors]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ROIDownload]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ROIDownload] DEFAULT ((0)) FOR [ROIDownload]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewROIDownload]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ViewROIDownload] DEFAULT ((0)) FOR [ViewROIDownload]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DownloadAll]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_DownloadAll] DEFAULT ((0)) FOR [DownloadAll]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewRealtime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ViewRealtime] DEFAULT ((0)) FOR [ViewRealtime]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_RealtimePlotCount]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_RealtimePlotCount] DEFAULT ((0)) FOR [RealtimePlotCount]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ViewDownloadAll]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ViewDownloadAll] DEFAULT ((0)) FOR [ViewDownloadAll]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Export]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_Export] DEFAULT ((0)) FOR [Export]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LabDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_LabDetails] DEFAULT (space((0))) FOR [LabDetails]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CustomerId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_CustomerId] DEFAULT ((0)) FOR [CustomerId]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LabratoryId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_LabratoryId] DEFAULT ((0)) FOR [LabratoryId]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestEngineerId]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TestEngineerId] DEFAULT ((0)) FOR [TestEngineerId]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CustomerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_CustomerDetails] DEFAULT (space((0))) FOR [CustomerDetails]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UseCustomerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_UseCustomerDetails] DEFAULT ((0)) FOR [UseCustomerDetails]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AllowMissingSensors]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_AllowMissingSensors] DEFAULT ((0)) FOR [AllowMissingSensors]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_AllowSensorIdToBlankChannel]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_AllowSensorIdToBlankChannel] DEFAULT ((0)) FOR [AllowSensorIdToBlankChannel]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LocalOnly]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_LocalOnly] DEFAULT ((0)) FOR [LocalOnly]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_LastModifiedBy]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_LastModifiedBy] DEFAULT (space((0))) FOR [LastModifiedBy]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TurnOffExcitation]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TurnOffExcitation] DEFAULT ((0)) FOR [TurnOffExcitation]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TriggerCheckRealtime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TriggerCheckRealtime] DEFAULT ((0)) FOR [TriggerCheckRealtime]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TriggerCheckStep]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TriggerCheckStep] DEFAULT ((0)) FOR [TriggerCheckStep]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_PostTestDiagnostics]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_PostTestDiagnostics] DEFAULT ((0)) FOR [PostTestDiagnostics]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ExportFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ExportFolder] DEFAULT (space((0))) FOR [ExportFolder]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DownloadFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_DownloadFolder] DEFAULT (space((0))) FOR [DownloadFolder]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CommonStatusLine]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_CommonStatusLine] DEFAULT ((0)) FOR [CommonStatusLine]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SameAsDownloadFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_SameAsDownloadFolder] DEFAULT ((0)) FOR [SameAsDownloadFolder]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UploadData]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_UploadData] DEFAULT ((0)) FOR [UploadData]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UploadDataFolder]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_UploadDataFolder] DEFAULT (space((0))) FOR [UploadDataFolder]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Settings]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_Settings] DEFAULT (space((0))) FOR [Settings]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_WarnOnBatteryFail]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_WarnOnBatteryFail] DEFAULT ((0)) FOR [WarnOnBatteryFail]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Dirty]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_Dirty] DEFAULT ((0)) FOR [Dirty]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_Complete]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_Complete] DEFAULT ((0)) FOR [Complete]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ErrorMessage]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ErrorMessage] DEFAULT (space((0))) FOR [ErrorMessage]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_TestEngineerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_TestEngineerDetails] DEFAULT (space((0))) FOR [TestEngineerDetails]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_UseTestEngineerDetails]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_UseTestEngineerDetails] DEFAULT ((0)) FOR [UseTestEngineerDetails]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_DoAutoArm]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_DoAutoArm] DEFAULT ((0)) FOR [DoAutoArm]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_CheckoutMode]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_CheckoutMode] DEFAULT ((0)) FOR [CheckoutMode]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_ISFFile]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_ISFFile] DEFAULT (space((0))) FOR [ISFFile]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_QuitTestWithoutWarning]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_QuitTestWithoutWarning] DEFAULT ((0)) FOR [QuitTestWithoutWarning]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_NotAllChannelsRealTime]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_NotAllChannelsRealTime] DEFAULT ((0)) FOR [NotAllChannelsRealTime]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_NotAllChannelsViewer]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_NotAllChannelsViewer] DEFAULT ((0)) FOR [NotAllChannelsViewer]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetups_SuppressMissingSensorsWarning]') AND type = 'D')
|
||
BEGIN
|
||
ALTER TABLE [dbo].[TestSetups] ADD CONSTRAINT [DF_TestSetups_SuppressMissingSensorsWarning] DEFAULT ((0)) FOR [SuppressMissingSensorsWarning]
|
||
END
|
||
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_CustomerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] WITH NOCHECK ADD CONSTRAINT [FK_TestSetups_CustomerDetails] FOREIGN KEY([CustomerId])
|
||
REFERENCES [dbo].[CustomerDetails] ([CustomerId])
|
||
NOT FOR REPLICATION
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_CustomerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] NOCHECK CONSTRAINT [FK_TestSetups_CustomerDetails]
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_LabratoryDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] WITH NOCHECK ADD CONSTRAINT [FK_TestSetups_LabratoryDetails] FOREIGN KEY([LabratoryId])
|
||
REFERENCES [dbo].[LabratoryDetails] ([LabratoryId])
|
||
NOT FOR REPLICATION
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_LabratoryDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] NOCHECK CONSTRAINT [FK_TestSetups_LabratoryDetails]
|
||
GO
|
||
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_TestEngineerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] WITH NOCHECK ADD CONSTRAINT [FK_TestSetups_TestEngineerDetails] FOREIGN KEY([TestEngineerId])
|
||
REFERENCES [dbo].[TestEngineerDetails] ([TestEngineerId])
|
||
NOT FOR REPLICATION
|
||
GO
|
||
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestSetups_TestEngineerDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestSetups]'))
|
||
ALTER TABLE [dbo].[TestSetups] NOCHECK CONSTRAINT [FK_TestSetups_TestEngineerDetails]
|
||
GO
|