ALTER TABLE TESISSEG.dbo.Corredurias ADD APITempClientID varchar(100) NULL;
ALTER TABLE TESISSEG.dbo.Corredurias ADD APITempClientSecret varchar(100) NULL;


CREATE TABLE TESISSEG.dbo.ApiTempRequestLog (
                               id INT IDENTITY(1,1) PRIMARY KEY,
                               method NVARCHAR(255) NOT NULL,
                               path NVARCHAR(255) NOT NULL,
                               status INT NOT NULL,
                               ip NVARCHAR(255) NULL,
                               requestBody NVARCHAR(MAX) NULL,
                               responseBody NVARCHAR(MAX) NULL,
                               requestDatetime DATETIME NULL,
);