| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239 |
- using System;
- using Microsoft.EntityFrameworkCore.Migrations;
- #nullable disable
- namespace Infrastructure.Migrations.AppDb;
- /// <inheritdoc />
- public partial class AddRankingPublicToMemberApprove : Migration
- {
- /// <inheritdoc />
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.AlterTable(
- name: "MemberApprove",
- 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.AddColumn<bool>(
- name: "IsRankingPublic",
- table: "MemberApprove",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "랭킹 공개 여부");
- migrationBuilder.AddColumn<DateTime>(
- name: "RankingPublicConsentAt",
- table: "MemberApprove",
- type: "datetime2",
- nullable: true,
- comment: "랭킹 공개 동의 일시");
- }
- /// <inheritdoc />
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropColumn(
- name: "IsRankingPublic",
- table: "MemberApprove");
- migrationBuilder.DropColumn(
- name: "RankingPublicConsentAt",
- table: "MemberApprove");
- migrationBuilder.AlterTable(
- name: "MemberApprove",
- 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");
- }
- }
|