DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/e1/e12982e4e9a8a5a216e54c7c606be08b8cc05a86.svn-base

<EFBFBD><EFBFBD>CREATE TABLE [dbo].[SensorChangeHistory](
	[RecordId] [bigint] IDENTITY(1,1) NOT NULL,
	[SensorId] [int] NOT NULL,
	[ChangeType] [int] NOT NULL,
	[UserName] [nvarchar](max) NOT NULL,
	[Timestamp] [datetime] NOT NULL,
	[Value1] [nvarchar](max) NOT NULL,
	[Value2] [nvarchar](max) NOT NULL,
	[Value3] [nvarchar](max) NOT NULL,
	[Value4] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_SensorChangeHistory] PRIMARY KEY CLUSTERED 
(
	[RecordId] ASC
)
) ON [PRIMARY];

ALTER TABLE [dbo].[SensorChangeHistory]  WITH CHECK ADD  CONSTRAINT [FK_SensorChangeHistory_SensorChangeType] FOREIGN KEY([ChangeType])
REFERENCES [dbo].[SensorChangeType] ([Id]);

ALTER TABLE [dbo].[SensorChangeHistory] CHECK CONSTRAINT [FK_SensorChangeHistory_SensorChangeType];

ALTER TABLE [dbo].[SensorChangeHistory]  WITH CHECK ADD  CONSTRAINT [FK_SensorChangeHistory_Sensors] FOREIGN KEY([SensorId])
REFERENCES [dbo].[Sensors] ([id]);

ALTER TABLE [dbo].[SensorChangeHistory] CHECK CONSTRAINT [FK_SensorChangeHistory_Sensors];