20260416222857_AddRankingPublicToMemberApprove.cs 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. using System;
  2. using Microsoft.EntityFrameworkCore.Migrations;
  3. #nullable disable
  4. namespace Infrastructure.Migrations.AppDb;
  5. /// <inheritdoc />
  6. public partial class AddRankingPublicToMemberApprove : Migration
  7. {
  8. /// <inheritdoc />
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.AlterTable(
  12. name: "MemberApprove",
  13. comment: "ȸ�� ���� �� ���� ����",
  14. oldComment: "회원 동의 및 수신 여부");
  15. migrationBuilder.AlterColumn<DateTime>(
  16. name: "ReceiveSMSConsentAt",
  17. table: "MemberApprove",
  18. type: "datetime2",
  19. nullable: true,
  20. comment: "SMS ���� ���� �Ͻ�",
  21. oldClrType: typeof(DateTime),
  22. oldType: "datetime2",
  23. oldNullable: true,
  24. oldComment: "SMS 수신 동의 일시");
  25. migrationBuilder.AlterColumn<DateTime>(
  26. name: "ReceiveNoteConsentAt",
  27. table: "MemberApprove",
  28. type: "datetime2",
  29. nullable: true,
  30. comment: "���� ���� ���� �Ͻ�",
  31. oldClrType: typeof(DateTime),
  32. oldType: "datetime2",
  33. oldNullable: true,
  34. oldComment: "쪽지 수신 동의 일시");
  35. migrationBuilder.AlterColumn<DateTime>(
  36. name: "ReceiveEmailConsentAt",
  37. table: "MemberApprove",
  38. type: "datetime2",
  39. nullable: true,
  40. comment: "E-MAIL ���� ���� �Ͻ�",
  41. oldClrType: typeof(DateTime),
  42. oldType: "datetime2",
  43. oldNullable: true,
  44. oldComment: "E-MAIL 수신 동의 일시");
  45. migrationBuilder.AlterColumn<bool>(
  46. name: "IsReceiveSMS",
  47. table: "MemberApprove",
  48. type: "bit",
  49. nullable: false,
  50. comment: "SMS ���� ����",
  51. oldClrType: typeof(bool),
  52. oldType: "bit",
  53. oldComment: "SMS 수신 여부");
  54. migrationBuilder.AlterColumn<bool>(
  55. name: "IsReceiveNote",
  56. table: "MemberApprove",
  57. type: "bit",
  58. nullable: false,
  59. comment: "���� ���� ����",
  60. oldClrType: typeof(bool),
  61. oldType: "bit",
  62. oldComment: "쪽지 수신 여부");
  63. migrationBuilder.AlterColumn<bool>(
  64. name: "IsReceiveEmail",
  65. table: "MemberApprove",
  66. type: "bit",
  67. nullable: false,
  68. comment: "E-MAIL ���� ����",
  69. oldClrType: typeof(bool),
  70. oldType: "bit",
  71. oldComment: "E-MAIL 수신 여부");
  72. migrationBuilder.AlterColumn<bool>(
  73. name: "IsDisclosureInvest",
  74. table: "MemberApprove",
  75. type: "bit",
  76. nullable: false,
  77. comment: "���� ��Ȳ ���� ����",
  78. oldClrType: typeof(bool),
  79. oldType: "bit",
  80. oldComment: "투자 현황 공개 여부");
  81. migrationBuilder.AlterColumn<DateTime>(
  82. name: "DisclosureInvestConsentAt",
  83. table: "MemberApprove",
  84. type: "datetime2",
  85. nullable: true,
  86. comment: "���� ��Ȳ ���� ���� �Ͻ�",
  87. oldClrType: typeof(DateTime),
  88. oldType: "datetime2",
  89. oldNullable: true,
  90. oldComment: "투자 현황 공개 동의 일시");
  91. migrationBuilder.AlterColumn<int>(
  92. name: "MemberID",
  93. table: "MemberApprove",
  94. type: "int",
  95. nullable: false,
  96. comment: "ȸ�� ID",
  97. oldClrType: typeof(int),
  98. oldType: "int",
  99. oldComment: "회원 ID");
  100. migrationBuilder.AddColumn<bool>(
  101. name: "IsRankingPublic",
  102. table: "MemberApprove",
  103. type: "bit",
  104. nullable: false,
  105. defaultValue: false,
  106. comment: "랭킹 공개 여부");
  107. migrationBuilder.AddColumn<DateTime>(
  108. name: "RankingPublicConsentAt",
  109. table: "MemberApprove",
  110. type: "datetime2",
  111. nullable: true,
  112. comment: "랭킹 공개 동의 일시");
  113. }
  114. /// <inheritdoc />
  115. protected override void Down(MigrationBuilder migrationBuilder)
  116. {
  117. migrationBuilder.DropColumn(
  118. name: "IsRankingPublic",
  119. table: "MemberApprove");
  120. migrationBuilder.DropColumn(
  121. name: "RankingPublicConsentAt",
  122. table: "MemberApprove");
  123. migrationBuilder.AlterTable(
  124. name: "MemberApprove",
  125. comment: "회원 동의 및 수신 여부",
  126. oldComment: "ȸ�� ���� �� ���� ����");
  127. migrationBuilder.AlterColumn<DateTime>(
  128. name: "ReceiveSMSConsentAt",
  129. table: "MemberApprove",
  130. type: "datetime2",
  131. nullable: true,
  132. comment: "SMS 수신 동의 일시",
  133. oldClrType: typeof(DateTime),
  134. oldType: "datetime2",
  135. oldNullable: true,
  136. oldComment: "SMS ���� ���� �Ͻ�");
  137. migrationBuilder.AlterColumn<DateTime>(
  138. name: "ReceiveNoteConsentAt",
  139. table: "MemberApprove",
  140. type: "datetime2",
  141. nullable: true,
  142. comment: "쪽지 수신 동의 일시",
  143. oldClrType: typeof(DateTime),
  144. oldType: "datetime2",
  145. oldNullable: true,
  146. oldComment: "���� ���� ���� �Ͻ�");
  147. migrationBuilder.AlterColumn<DateTime>(
  148. name: "ReceiveEmailConsentAt",
  149. table: "MemberApprove",
  150. type: "datetime2",
  151. nullable: true,
  152. comment: "E-MAIL 수신 동의 일시",
  153. oldClrType: typeof(DateTime),
  154. oldType: "datetime2",
  155. oldNullable: true,
  156. oldComment: "E-MAIL ���� ���� �Ͻ�");
  157. migrationBuilder.AlterColumn<bool>(
  158. name: "IsReceiveSMS",
  159. table: "MemberApprove",
  160. type: "bit",
  161. nullable: false,
  162. comment: "SMS 수신 여부",
  163. oldClrType: typeof(bool),
  164. oldType: "bit",
  165. oldComment: "SMS ���� ����");
  166. migrationBuilder.AlterColumn<bool>(
  167. name: "IsReceiveNote",
  168. table: "MemberApprove",
  169. type: "bit",
  170. nullable: false,
  171. comment: "쪽지 수신 여부",
  172. oldClrType: typeof(bool),
  173. oldType: "bit",
  174. oldComment: "���� ���� ����");
  175. migrationBuilder.AlterColumn<bool>(
  176. name: "IsReceiveEmail",
  177. table: "MemberApprove",
  178. type: "bit",
  179. nullable: false,
  180. comment: "E-MAIL 수신 여부",
  181. oldClrType: typeof(bool),
  182. oldType: "bit",
  183. oldComment: "E-MAIL ���� ����");
  184. migrationBuilder.AlterColumn<bool>(
  185. name: "IsDisclosureInvest",
  186. table: "MemberApprove",
  187. type: "bit",
  188. nullable: false,
  189. comment: "투자 현황 공개 여부",
  190. oldClrType: typeof(bool),
  191. oldType: "bit",
  192. oldComment: "���� ��Ȳ ���� ����");
  193. migrationBuilder.AlterColumn<DateTime>(
  194. name: "DisclosureInvestConsentAt",
  195. table: "MemberApprove",
  196. type: "datetime2",
  197. nullable: true,
  198. comment: "투자 현황 공개 동의 일시",
  199. oldClrType: typeof(DateTime),
  200. oldType: "datetime2",
  201. oldNullable: true,
  202. oldComment: "���� ��Ȳ ���� ���� �Ͻ�");
  203. migrationBuilder.AlterColumn<int>(
  204. name: "MemberID",
  205. table: "MemberApprove",
  206. type: "int",
  207. nullable: false,
  208. comment: "회원 ID",
  209. oldClrType: typeof(int),
  210. oldType: "int",
  211. oldComment: "ȸ�� ID");
  212. }
  213. }