Skip to content
Snippets Groups Projects

New: Index on Log table

Merged Petar Hristov requested to merge Issue/2284-dbLogIndex into master
Files
2
using FluentMigrator;
namespace Coscine.Migrations.Migrations
{
//yyyymmddhhmm
[Migration(202211040919)]
public class Migration202211040919LogDbIndex : Migration
{
public override void Down()
{
Delete.Index("log_idx_userid_loglevel_servertime").OnTable("Log");
}
public override void Up()
{
Create.Index("log_idx_userid_loglevel_servertime").OnTable("Log")
.OnColumn("UserId").Ascending()
.OnColumn("LogLevel").Ascending()
.OnColumn("ServerTimestamp").Ascending();
}
}
}
\ No newline at end of file
Loading