DP44/DataPRO_sql/.svn/pristine/17/17f1d76972c33186083dc43736f33fc1136491d6.svn-base

<EFBFBD><EFBFBD>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