Skip to content

v8.63.0

Latest

Choose a tag to compare

@cleftheris cleftheris released this 02 Nov 17:41
· 7 commits to develop since this release
d631447

What's Changed

  • πŸ”[update] MaxMind GeoIP databases and disposable lists by @github-actions[bot] in #1264
  • πŸ’Ž [ftpserver] Give each FTP connection its own idle check by @Gregapos in #1266
  • 🌐[spa] Product UI enhancements by @cleftheris in #1267

New Contributors

Risk

SQL Server: run this migration script to update the database.

Caution! Update the table schema if it is not the default [dbo]. Building the indexes on large tables takes time and blocks writes to them, so run it off-peak (or add WITH (ONLINE = ON) where the edition supports it: Enterprise, Developer or Azure SQL).

IF NOT EXISTS (
    SELECT 1
    FROM sys.indexes
    WHERE object_id = OBJECT_ID(N'[dbo].[RiskEvent]')
      AND name = N'IX_RiskEvent_CreatedAt'
)
BEGIN
    CREATE NONCLUSTERED INDEX [IX_RiskEvent_CreatedAt]
        ON [dbo].[RiskEvent]([CreatedAt] ASC);
END;
GO

IF NOT EXISTS (
    SELECT 1
    FROM sys.indexes
    WHERE object_id = OBJECT_ID(N'[dbo].[RiskResult]')
      AND name = N'IX_RiskResult_CreatedAt'
)
BEGIN
    CREATE NONCLUSTERED INDEX [IX_RiskResult_CreatedAt]
        ON [dbo].[RiskResult]([CreatedAt] ASC)
        INCLUDE ([RiskLevel]);
END;
GO

Full Changelog: v8.62.0...v8.63.0