DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/18/18de594699b28d95cd58e03165f42608cbfafc97.svn-base

<EFBFBD><EFBFBD>DECLARE @ObjectName NVARCHAR(100)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigX';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigY';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigZ';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigOn';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigBelow';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigAbove';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigBelow';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigAbove';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigBelow';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigAbove';
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)

ALTER TABLE dbo.TestSetups
	DROP COLUMN LowgLVLTrigOn, LowgLVLTrigOnX, LowgLVLTrigOnY, LowgLVLTrigOnZ, HighgLVLTrigOn, HighgLVLTrigOnX, HighgLVLTrigOnY, HighgLVLTrigOnZ, AngAccelLVLTrigOn, AngAccelLVLTrigOnX, AngAccelLVLTrigOnY, AngAccelLVLTrigOnZ, ARSLVLTrigOn, ARSLVLTrigOnX, ARSLVLTrigOnY, ARSLVLTrigOnZ, LowgLVLTrigX, LowgLVLTrigY, LowgLVLTrigZ, HighgLVLTrigX, HighgLVLTrigY, HighgLVLTrigZ, AngAccelLVLTrigX, AngAccelLVLTrigY, AngAccelLVLTrigZ, ARSLVLTrigX, ARSLVLTrigY, ARSLVLTrigZ, HumidityLVLTrigOn, PressureLVLTrigOn, TemperatureLVLTrigOn, HumidityLVLTrigBelow, HumidityLVLTrigAbove, PressureLVLTrigBelow, PressureLVLTrigAbove, TemperatureLVLTrigBelow, TemperatureLVLTrigAbove

ALTER TABLE dbo.TestSetups SET (LOCK_ESCALATION = TABLE)