﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'ApiRequestLog')
begin
	CREATE TABLE dbo.ApiRequestLog
	(
		ID                  BIGINT IDENTITY(1,1) PRIMARY KEY,
		RequestId           UNIQUEIDENTIFIER NOT NULL, -- معادل Guid
		CreateDateTime          DATETIME2      NOT NULL,
		ApiKey_ID            INT            NULL,
		Scheme         NVARCHAR(200)  NULL,
		IP                  NVARCHAR(50)   NULL,
		Method              NVARCHAR(10)   NOT NULL,
		Url                 NVARCHAR(1000) NOT NULL,
		QueryString         NVARCHAR(MAX)  NULL,
		RequestBody         NVARCHAR(MAX)  NULL,
		StatusCode          INT            NOT NULL,
		Elapsed				BIGINT         NOT NULL, -- مدت زمان اجرای درخواست
		UserAgent           NVARCHAR(500)  NULL,
		ErrorMessage        NVARCHAR(MAX)  NULL
	);
end

-- CREATE INDEX IX_ApiRequestLog_CreateDate ON ApiRequestLog(CreateDateTime DESC);

-- CREATE INDEX IX_ApiRequestLog_ApiKeyId ON ApiRequestLog(ApiKey_ID);
