119 lines
9.5 KiB
Plaintext
119 lines
9.5 KiB
Plaintext
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
|