52 lines
4.1 KiB
MySQL
52 lines
4.1 KiB
MySQL
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigOnX] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigOnY] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigOnZ] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigOnX] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigOnY] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigOnZ] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigOnX] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigOnY] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigOnZ] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigOnX] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigOnY] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigOnZ] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigX] FLOAT NOT NULL default 5.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigY] FLOAT NOT NULL default 5.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgLVLTrigZ] FLOAT NOT NULL default 5.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigX] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigY] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgLVLTrigZ] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigX] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigY] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngAccelLVLTrigZ] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigX] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigY] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [ARSLVLTrigZ] FLOAT NOT NULL default 100.0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HumidityLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [PressureLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TemperatureLVLTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HumidityLVLTrigBelow] FLOAT NOT NULL default 25;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HumidityLVLTrigAbove] FLOAT NOT NULL default 50;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [PressureLVLTrigBelow] FLOAT NOT NULL default 10;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [PressureLVLTrigAbove] FLOAT NOT NULL default 10;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TemperatureLVLTrigBelow] FLOAT NOT NULL default 25;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TemperatureLVLTrigAbove] FLOAT NOT NULL default 50;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [LowgRate] INT NOT NULL default 6400;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [HighgRate] INT NOT NULL default 5120;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [AngularRate] INT NOT NULL default 1600;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TempHumidPressRate] INT NOT NULL default 157;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [BatterySaverModeOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [WakeupAndTriggerOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [WakeupTrigger] SMALLINT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TimedIntervalTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TimedIntervalDuration] INT NOT NULL default 1000;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TimedIntervalEvents] INT NOT NULL default 100;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TimedIntervalFrequency] INT NOT NULL default 100;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [TimedIntervalUnits] SMALLINT NOT NULL default 1;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [RTCScheduleTrigOn] BIT NOT NULL default 0;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [RTCScheduleStartDateTime] DATETIME NOT NULL default CURRENT_TIMESTAMP;
|
||
|
|
ALTER TABLE [dbo].[TestSetups] ADD [RTCScheduleDuration] BIGINT NOT NULL default 0;
|