using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Nuuru.Server.Migrations.PostgreSQL
{
    /// <inheritdoc />
    public partial class AddForumQueryIndexes : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropIndex(
                name: "IX_ForumPosts_ThreadId_CreatedAt",
                table: "ForumPosts");

            migrationBuilder.CreateIndex(
                name: "IX_Reactions_EntityType_EntityId_EmoteName",
                table: "Reactions",
                columns: new[] { "EntityType", "EntityId", "EmoteName" });

            migrationBuilder.CreateIndex(
                name: "IX_ForumThreads_LastPostAt",
                table: "ForumThreads",
                column: "LastPostAt");

            migrationBuilder.CreateIndex(
                name: "IX_ForumPosts_ThreadId_CreatedAt_Id",
                table: "ForumPosts",
                columns: new[] { "ThreadId", "CreatedAt", "Id" });
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropIndex(
                name: "IX_Reactions_EntityType_EntityId_EmoteName",
                table: "Reactions");

            migrationBuilder.DropIndex(
                name: "IX_ForumThreads_LastPostAt",
                table: "ForumThreads");

            migrationBuilder.DropIndex(
                name: "IX_ForumPosts_ThreadId_CreatedAt_Id",
                table: "ForumPosts");

            migrationBuilder.CreateIndex(
                name: "IX_ForumPosts_ThreadId_CreatedAt",
                table: "ForumPosts",
                columns: new[] { "ThreadId", "CreatedAt" });
        }
    }
}