DP44/DataPRO_sql/dbo.TestSetupSettings.Table.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_CheckListMustPass]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_CheckListMustPass]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_EW]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_EW]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_TriggerStartCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_TriggerStartCheck]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_SensorIDCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_SensorIDCheck]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_SquibResistanceCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_SquibResistanceCheck]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_BatteryVoltageCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_BatteryVoltageCheck]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_InputVoltageCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_InputVoltageCheck]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_ArmCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] DROP CONSTRAINT [DF_TestSetupSettings_ArmCheck]
END

GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSetupSettings]') AND type in (N'U'))
DROP TABLE [dbo].[TestSetupSettings]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestSetupSettings]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TestSetupSettings](
	[TestSetupId] [int] NOT NULL,
	[ArmCheck] [bit] NOT NULL,
	[InputVoltageCheck] [bit] NOT NULL,
	[BatteryVoltageCheck] [bit] NOT NULL,
	[SquibResistanceCheck] [bit] NOT NULL,
	[SensorIDCheck] [bit] NOT NULL,
	[TriggerStartCheck] [bit] NOT NULL,
	[EW] [bit] NOT NULL,
	[CheckListMustPass] [bit] NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_ArmCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_ArmCheck]  DEFAULT ((0)) FOR [ArmCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_InputVoltageCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_InputVoltageCheck]  DEFAULT ((0)) FOR [InputVoltageCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_BatteryVoltageCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_BatteryVoltageCheck]  DEFAULT ((0)) FOR [BatteryVoltageCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_SquibResistanceCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_SquibResistanceCheck]  DEFAULT ((0)) FOR [SquibResistanceCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_SensorIDCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_SensorIDCheck]  DEFAULT ((0)) FOR [SensorIDCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_TriggerStartCheck]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_TriggerStartCheck]  DEFAULT ((0)) FOR [TriggerStartCheck]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_EW]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_EW]  DEFAULT ((0)) FOR [EW]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_TestSetupSettings_CheckListMustPass]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[TestSetupSettings] ADD  CONSTRAINT [DF_TestSetupSettings_CheckListMustPass]  DEFAULT ((0)) FOR [CheckListMustPass]
END

GO