CREATE TABLE [dbo].[Keys]
(
[MachineName] [nvarchar] (256) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[InstallationID] [uniqueidentifier] NOT NULL,
[InstanceName] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Client] [int] NOT NULL,
[PublicKey] [image] NULL,
[SymmetricKey] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Keys] ADD CONSTRAINT [PK_Keys] PRIMARY KEY CLUSTERED ([InstallationID], [Client]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[Keys] TO [RSExecRole]
GRANT SELECT ON [dbo].[Keys] TO [RSExecRole]
GRANT INSERT ON [dbo].[Keys] TO [RSExecRole]
GRANT DELETE ON [dbo].[Keys] TO [RSExecRole]
GRANT UPDATE ON [dbo].[Keys] TO [RSExecRole]
GO