create log table

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Logs]
    (
      [Id] [int] IDENTITY(1, 1) NOT NULL ,
      [Message] [nvarchar](MAX) NULL ,
      [MessageTemplate] [nvarchar](MAX) NULL ,
      [Level] [nvarchar](128) NULL ,
      [TimeStamp] [datetime2] NOT NULL CONSTRAINT [DF_Logs_TimeStamp] DEFAULT SYSDATETIME() ,
      [Exception] [nvarchar](MAX) NULL ,
      [Properties] [xml] NULL ,
      CONSTRAINT [PK_Logs] PRIMARY KEY CLUSTERED ( [Id] ASC )
        WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
    )
ON  [PRIMARY]
GO