CREATE TABLE [dbo].[RequestLog] (
    [Id]              INT            IDENTITY (1, 1) NOT NULL,
    [RequestType]     NVARCHAR (50)  NOT NULL,
    [Timestamp]       DATETIME       NOT NULL,
    [RequestXML]      XML            NOT NULL,
    [ResponseCode]    NVARCHAR (50)  NULL,
    [ResponseMessage] NVARCHAR (500) NULL,
    [ResponseXML]     XML            NULL,
    CONSTRAINT [PK_RequestLog] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_RequestLog_RequestType]
    ON [dbo].[RequestLog]([RequestType] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_RequestLog_Timestamp]
    ON [dbo].[RequestLog]([Timestamp] ASC);

