CREATE TABLE [dbo].[SuppliesHistory]
(
[DeviceID] [int] NOT NULL,
[ConsumableHashCode] [int] NOT NULL,
[ParameterType] [smallint] NULL,
[ConsumableType] [int] NULL,
[ConsumableName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConsumableColorantType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ColorantIndex] [smallint] NULL,
[UpdateDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SuppliesHistory] ADD CONSTRAINT [PK_SuppliesHistory] PRIMARY KEY CLUSTERED ([DeviceID], [ConsumableHashCode]) ON [PRIMARY]
GO