using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace Codex.Dal.Migrations
{
///
public partial class AddPerformanceIndexes : Migration
{
///
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropIndex(
name: "IX_ConversationMessages_ConversationId_MessageIndex",
table: "ConversationMessages");
migrationBuilder.CreateIndex(
name: "IX_Conversations_Title",
table: "Conversations",
column: "Title");
migrationBuilder.CreateIndex(
name: "IX_ConversationMessages_CreatedAt",
table: "ConversationMessages",
column: "CreatedAt");
migrationBuilder.CreateIndex(
name: "IX_Agents_Name",
table: "Agents",
column: "Name");
migrationBuilder.CreateIndex(
name: "IX_AgentExecutions_CompletedAt",
table: "AgentExecutions",
column: "CompletedAt");
}
///
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropIndex(
name: "IX_Conversations_Title",
table: "Conversations");
migrationBuilder.DropIndex(
name: "IX_ConversationMessages_CreatedAt",
table: "ConversationMessages");
migrationBuilder.DropIndex(
name: "IX_Agents_Name",
table: "Agents");
migrationBuilder.DropIndex(
name: "IX_AgentExecutions_CompletedAt",
table: "AgentExecutions");
migrationBuilder.CreateIndex(
name: "IX_ConversationMessages_ConversationId_MessageIndex",
table: "ConversationMessages",
columns: new[] { "ConversationId", "MessageIndex" });
}
}
}