ANTOOZA-BACKEND/Infrastructure/Persistence/Migrations/20260524094845_AddMemberInventoryDeletedAt.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Migrations.AppDb
{
    /// <inheritdoc />
    public partial class AddMemberInventoryDeletedAt : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AlterTable(
                name: "MemberApprove",
                comment: "회원 알림 및 수신 동의",
                oldComment: "ȸ�� ���� �� ���� ����");

            migrationBuilder.AlterTable(
                name: "Channel",
                comment: "채널 정보",
                oldComment: "� ����");

            migrationBuilder.AddColumn<DateTime>(
                name: "DeletedAt",
                table: "MemberInventory",
                type: "datetime2",
                nullable: true,
                comment: "사용자 보관함 소프트 삭제 일시. NULL = 보관함 노출");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveSMSConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "SMS 수신 동의 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "SMS ���� ���� �Ͻ�");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveNoteConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "쪽지 수신 동의 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "���� ���� ���� �Ͻ�");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveEmailConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "E-MAIL 수신 동의 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "E-MAIL ���� ���� �Ͻ�");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveSMS",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "SMS 수신 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "SMS ���� ����");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveNote",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "쪽지 수신 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "���� ���� ����");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveEmail",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "E-MAIL 수신 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "E-MAIL ���� ����");

            migrationBuilder.AlterColumn<bool>(
                name: "IsDisclosureInvest",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "투자 현황 공개 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "���� ��Ȳ ���� ����");

            migrationBuilder.AlterColumn<DateTime>(
                name: "DisclosureInvestConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "투자 현황 공개 동의 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "���� ��Ȳ ���� ���� �Ͻ�");

            migrationBuilder.AlterColumn<int>(
                name: "MemberID",
                table: "MemberApprove",
                type: "int",
                nullable: false,
                comment: "회원 ID",
                oldClrType: typeof(int),
                oldType: "int",
                oldComment: "ȸ�� ID");

            migrationBuilder.AlterColumn<string>(
                name: "YouTubeUrl",
                table: "Channel",
                type: "nvarchar(255)",
                maxLength: 255,
                nullable: false,
                comment: "YouTube 채널 URL",
                oldClrType: typeof(string),
                oldType: "nvarchar(255)",
                oldMaxLength: 255,
                oldComment: "YouTube � URL");

            migrationBuilder.AlterColumn<DateTime>(
                name: "UpdatedAt",
                table: "Channel",
                type: "datetime2",
                nullable: true,
                comment: "수정 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "���� �Ͻ�");

            migrationBuilder.AlterColumn<string>(
                name: "SID",
                table: "Channel",
                type: "nvarchar(24)",
                maxLength: 24,
                nullable: false,
                comment: "채널 ID",
                oldClrType: typeof(string),
                oldType: "nvarchar(24)",
                oldMaxLength: 24,
                oldComment: "� ID");

            migrationBuilder.AlterColumn<string>(
                name: "Name",
                table: "Channel",
                type: "nvarchar(200)",
                maxLength: 200,
                nullable: false,
                comment: "채널 이름",
                oldClrType: typeof(string),
                oldType: "nvarchar(200)",
                oldMaxLength: 200,
                oldComment: "ä�� �̸�");

            migrationBuilder.AlterColumn<int>(
                name: "MemberID",
                table: "Channel",
                type: "int",
                nullable: false,
                comment: "회원 ID",
                oldClrType: typeof(int),
                oldType: "int",
                oldComment: "ȸ�� ID");

            migrationBuilder.AlterColumn<bool>(
                name: "IsVerified",
                table: "Channel",
                type: "bit",
                nullable: false,
                comment: "인증 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "���� ����");

            migrationBuilder.AlterColumn<bool>(
                name: "IsActive",
                table: "Channel",
                type: "bit",
                nullable: false,
                comment: "활성 여부",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "Ȱ�� ����");

            migrationBuilder.AlterColumn<string>(
                name: "Handle",
                table: "Channel",
                type: "nvarchar(30)",
                maxLength: 30,
                nullable: true,
                comment: "핸들",
                oldClrType: typeof(string),
                oldType: "nvarchar(30)",
                oldMaxLength: 30,
                oldNullable: true,
                oldComment: "�ڵ�");

            migrationBuilder.AlterColumn<DateTime>(
                name: "CreatedAt",
                table: "Channel",
                type: "datetime2",
                nullable: false,
                comment: "등록 일시",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldComment: "��� �Ͻ�");

            migrationBuilder.CreateIndex(
                name: "IX_MemberInventory_MemberID_DeletedAt",
                table: "MemberInventory",
                columns: new[] { "MemberID", "DeletedAt" });
        }

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

            migrationBuilder.DropColumn(
                name: "DeletedAt",
                table: "MemberInventory");

            migrationBuilder.AlterTable(
                name: "MemberApprove",
                comment: "ȸ�� ���� �� ���� ����",
                oldComment: "회원 알림 및 수신 동의");

            migrationBuilder.AlterTable(
                name: "Channel",
                comment: "� ����",
                oldComment: "채널 정보");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveSMSConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "SMS ���� ���� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "SMS 수신 동의 일시");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveNoteConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "���� ���� ���� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "쪽지 수신 동의 일시");

            migrationBuilder.AlterColumn<DateTime>(
                name: "ReceiveEmailConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "E-MAIL ���� ���� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "E-MAIL 수신 동의 일시");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveSMS",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "SMS ���� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "SMS 수신 여부");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveNote",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "���� ���� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "쪽지 수신 여부");

            migrationBuilder.AlterColumn<bool>(
                name: "IsReceiveEmail",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "E-MAIL ���� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "E-MAIL 수신 여부");

            migrationBuilder.AlterColumn<bool>(
                name: "IsDisclosureInvest",
                table: "MemberApprove",
                type: "bit",
                nullable: false,
                comment: "���� ��Ȳ ���� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "투자 현황 공개 여부");

            migrationBuilder.AlterColumn<DateTime>(
                name: "DisclosureInvestConsentAt",
                table: "MemberApprove",
                type: "datetime2",
                nullable: true,
                comment: "���� ��Ȳ ���� ���� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "투자 현황 공개 동의 일시");

            migrationBuilder.AlterColumn<int>(
                name: "MemberID",
                table: "MemberApprove",
                type: "int",
                nullable: false,
                comment: "ȸ�� ID",
                oldClrType: typeof(int),
                oldType: "int",
                oldComment: "회원 ID");

            migrationBuilder.AlterColumn<string>(
                name: "YouTubeUrl",
                table: "Channel",
                type: "nvarchar(255)",
                maxLength: 255,
                nullable: false,
                comment: "YouTube � URL",
                oldClrType: typeof(string),
                oldType: "nvarchar(255)",
                oldMaxLength: 255,
                oldComment: "YouTube 채널 URL");

            migrationBuilder.AlterColumn<DateTime>(
                name: "UpdatedAt",
                table: "Channel",
                type: "datetime2",
                nullable: true,
                comment: "���� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldNullable: true,
                oldComment: "수정 일시");

            migrationBuilder.AlterColumn<string>(
                name: "SID",
                table: "Channel",
                type: "nvarchar(24)",
                maxLength: 24,
                nullable: false,
                comment: "� ID",
                oldClrType: typeof(string),
                oldType: "nvarchar(24)",
                oldMaxLength: 24,
                oldComment: "채널 ID");

            migrationBuilder.AlterColumn<string>(
                name: "Name",
                table: "Channel",
                type: "nvarchar(200)",
                maxLength: 200,
                nullable: false,
                comment: "ä�� �̸�",
                oldClrType: typeof(string),
                oldType: "nvarchar(200)",
                oldMaxLength: 200,
                oldComment: "채널 이름");

            migrationBuilder.AlterColumn<int>(
                name: "MemberID",
                table: "Channel",
                type: "int",
                nullable: false,
                comment: "ȸ�� ID",
                oldClrType: typeof(int),
                oldType: "int",
                oldComment: "회원 ID");

            migrationBuilder.AlterColumn<bool>(
                name: "IsVerified",
                table: "Channel",
                type: "bit",
                nullable: false,
                comment: "���� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "인증 여부");

            migrationBuilder.AlterColumn<bool>(
                name: "IsActive",
                table: "Channel",
                type: "bit",
                nullable: false,
                comment: "Ȱ�� ����",
                oldClrType: typeof(bool),
                oldType: "bit",
                oldComment: "활성 여부");

            migrationBuilder.AlterColumn<string>(
                name: "Handle",
                table: "Channel",
                type: "nvarchar(30)",
                maxLength: 30,
                nullable: true,
                comment: "�ڵ�",
                oldClrType: typeof(string),
                oldType: "nvarchar(30)",
                oldMaxLength: 30,
                oldNullable: true,
                oldComment: "핸들");

            migrationBuilder.AlterColumn<DateTime>(
                name: "CreatedAt",
                table: "Channel",
                type: "datetime2",
                nullable: false,
                comment: "��� �Ͻ�",
                oldClrType: typeof(DateTime),
                oldType: "datetime2",
                oldComment: "등록 일시");
        }
    }
}