Radicade/Server/Migrations/20261008120000_AddPlayerEventBroadcastingRoomInstance.cs

using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using RadicadeServer.DB;

#nullable disable

namespace RadicadeServer.Migrations;

[DbContext(typeof(RecDBContext))]
[Migration("20261008120000_AddPlayerEventBroadcastingRoomInstance")]
public partial class AddPlayerEventBroadcastingRoomInstance : Migration
{
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.Sql(@"
IF OBJECT_ID(N'dbo.PlayerEvents', N'U') IS NOT NULL
BEGIN
    IF COL_LENGTH('dbo.PlayerEvents', 'BroadcastingRoomInstanceId') IS NULL ALTER TABLE [PlayerEvents] ADD [BroadcastingRoomInstanceId] bigint NULL;
END");
    }

    protected override void Down(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.Sql(@"
IF OBJECT_ID(N'dbo.PlayerEvents', N'U') IS NOT NULL
BEGIN
    IF COL_LENGTH('dbo.PlayerEvents', 'BroadcastingRoomInstanceId') IS NOT NULL ALTER TABLE [PlayerEvents] DROP COLUMN [BroadcastingRoomInstanceId];
END");
    }
}