ANTOOZA-BACKEND/Infrastructure/Persistence/Migrations/20260215093503_a7.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Persistence.Migrations;

/// <inheritdoc />
public partial class a7 : Migration
{
    /// <inheritdoc />
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        // 1. PopupPosition 테이블 생성
        migrationBuilder.CreateTable(
            name: "PopupPosition",
            columns: table => new
            {
                ID = table.Column<int>(type: "int", nullable: false, comment: "PK")
                    .Annotation("SqlServer:Identity", "1, 1"),
                Code = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false, comment: "위치 구분"),
                Subject = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "위치 명"),
                IsActive = table.Column<bool>(type: "bit", nullable: false, comment: "사용 여부"),
                UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "수정 일시"),
                CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "등록 일시")
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_PopupPosition", x => x.ID);
            },
            comment: "팝업 위치");

        migrationBuilder.CreateIndex(
            name: "IX_PopupPosition_Code",
            table: "PopupPosition",
            column: "Code",
            unique: true);

        migrationBuilder.CreateIndex(
            name: "IX_PopupPosition_Code_IsActive",
            table: "PopupPosition",
            columns: new[] { "Code", "IsActive" });

        migrationBuilder.CreateIndex(
            name: "IX_PopupPosition_IsActive",
            table: "PopupPosition",
            column: "IsActive");

        // 2. 기본 위치 생성
        migrationBuilder.Sql(
            "INSERT INTO PopupPosition (Code, Subject, IsActive, CreatedAt) VALUES ('default', N'기본', 1, GETUTCDATE())");

        // 3. Popup 테이블에 PositionID 컬럼 추가 (기본값 = 기본 위치 ID)
        migrationBuilder.Sql(
            "ALTER TABLE Popup ADD PositionID int NOT NULL DEFAULT 0");

        // 4. 기존 팝업 데이터를 기본 위치로 매핑
        migrationBuilder.Sql(
            "UPDATE Popup SET PositionID = (SELECT TOP 1 ID FROM PopupPosition WHERE Code = 'default')");

        // 5. DEFAULT 제약 조건 제거
        migrationBuilder.Sql(@"
                DECLARE @name NVARCHAR(256)
                SELECT @name = dc.name
                FROM sys.default_constraints dc
                JOIN sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id
                WHERE c.name = 'PositionID' AND dc.parent_object_id = OBJECT_ID('Popup')
                IF @name IS NOT NULL EXEC('ALTER TABLE Popup DROP CONSTRAINT ' + @name)");

        // 6. 인덱스 및 FK 추가
        migrationBuilder.CreateIndex(
            name: "IX_Popup_PositionID",
            table: "Popup",
            column: "PositionID");

        migrationBuilder.AddForeignKey(
            name: "FK_Popup_PopupPosition_PositionID",
            table: "Popup",
            column: "PositionID",
            principalTable: "PopupPosition",
            principalColumn: "ID",
            onDelete: ReferentialAction.Cascade);
    }

    /// <inheritdoc />
    protected override void Down(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.DropForeignKey(
            name: "FK_Popup_PopupPosition_PositionID",
            table: "Popup");

        migrationBuilder.DropTable(
            name: "PopupPosition");

        migrationBuilder.DropIndex(
            name: "IX_Popup_PositionID",
            table: "Popup");

        migrationBuilder.DropColumn(
            name: "PositionID",
            table: "Popup");
    }
}