CREATE TABLE [dbo].[historyprocessdataitem] (
	[keystring] [varchar] (64) NOT NULL ,
	[valuestring] [varchar] (2000) NULL ,
	[parentid] [int] NOT NULL ,
	[valuedate] [datetime] NULL ,
	[valuetime] [datetime] NULL ,
	[valueboolean] [smallint] NULL ,
	[valueinteger] [int] NULL ,
	[valuedouble] [decimal](18, 2) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[historyprocessdataitem] WITH NOCHECK ADD 
	CONSTRAINT [PK_historyprocessdataitem] PRIMARY KEY  NONCLUSTERED 
	(
		[keystring],
		[parentid]
	)  ON [PRIMARY] 
GO

