ANTOOZA-BACKEND/Infrastructure/Persistence/Migrations/20260618080342_SeedGameLanguages.cs

using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Migrations.AppDb
{
    /// <inheritdoc />
    public partial class SeedGameLanguages : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"
INSERT INTO [GameLanguage] ([KorName], [EngName], [Order], [IsActive], [CreatedAt])
SELECT v.[KorName], v.[EngName], v.[Order], 1, SYSUTCDATETIME()
FROM (VALUES
    (N'한국어',        N'Korean',              1),
    (N'영어',          N'English',             2),
    (N'일본어',        N'Japanese',            3),
    (N'중국어(간체)',  N'Simplified Chinese',  4),
    (N'중국어(번체)',  N'Traditional Chinese', 5),
    (N'스페인어',      N'Spanish',             6),
    (N'프랑스어',      N'French',              7),
    (N'독일어',        N'German',              8),
    (N'이탈리아어',    N'Italian',             9),
    (N'포르투갈어',    N'Portuguese',         10),
    (N'러시아어',      N'Russian',            11),
    (N'태국어',        N'Thai',               12),
    (N'베트남어',      N'Vietnamese',         13),
    (N'인도네시아어',  N'Indonesian',         14)
) AS v([KorName], [EngName], [Order])
WHERE NOT EXISTS (SELECT 1 FROM [GameLanguage] g WHERE g.[KorName] = v.[KorName]);
");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"
DELETE g
FROM [GameLanguage] g
WHERE g.[KorName] IN (
    N'한국어', N'영어', N'일본어', N'중국어(간체)', N'중국어(번체)',
    N'스페인어', N'프랑스어', N'독일어', N'이탈리아어', N'포르투갈어',
    N'러시아어', N'태국어', N'베트남어', N'인도네시아어'
)
AND NOT EXISTS (SELECT 1 FROM [GameLanguageSupport] s WHERE s.[GameLanguageID] = g.[ID]);
");
        }
    }
}