20260527055422_ReplaceStoreAdminWithIdentityUser.cs 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. #nullable disable
  3. namespace Infrastructure.Migrations.AppDb
  4. {
  5. /// <inheritdoc />
  6. public partial class ReplaceStoreAdminWithIdentityUser : Migration
  7. {
  8. /// <inheritdoc />
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.DropForeignKey(
  12. name: "FK_GameSettlement_Member_SettledByAdminID",
  13. table: "GameSettlement");
  14. migrationBuilder.DropForeignKey(
  15. name: "FK_OrderRefund_Member_AdminID",
  16. table: "OrderRefund");
  17. migrationBuilder.DropIndex(
  18. name: "IX_OrderRefund_AdminID",
  19. table: "OrderRefund");
  20. migrationBuilder.DropIndex(
  21. name: "IX_GameSettlement_SettledByAdminID",
  22. table: "GameSettlement");
  23. migrationBuilder.DropColumn(
  24. name: "AdminID",
  25. table: "OrderRefund");
  26. migrationBuilder.DropColumn(
  27. name: "SettledByAdminID",
  28. table: "GameSettlement");
  29. migrationBuilder.AddColumn<string>(
  30. name: "AdminEmail",
  31. table: "OrderRefund",
  32. type: "nvarchar(256)",
  33. maxLength: 256,
  34. nullable: true);
  35. migrationBuilder.AddColumn<string>(
  36. name: "AdminUserId",
  37. table: "OrderRefund",
  38. type: "nvarchar(450)",
  39. maxLength: 450,
  40. nullable: true);
  41. migrationBuilder.AddColumn<string>(
  42. name: "SettledByAdminEmail",
  43. table: "GameSettlement",
  44. type: "nvarchar(256)",
  45. maxLength: 256,
  46. nullable: true);
  47. migrationBuilder.AddColumn<string>(
  48. name: "SettledByAdminUserId",
  49. table: "GameSettlement",
  50. type: "nvarchar(450)",
  51. maxLength: 450,
  52. nullable: true);
  53. }
  54. /// <inheritdoc />
  55. protected override void Down(MigrationBuilder migrationBuilder)
  56. {
  57. migrationBuilder.DropColumn(
  58. name: "AdminEmail",
  59. table: "OrderRefund");
  60. migrationBuilder.DropColumn(
  61. name: "AdminUserId",
  62. table: "OrderRefund");
  63. migrationBuilder.DropColumn(
  64. name: "SettledByAdminEmail",
  65. table: "GameSettlement");
  66. migrationBuilder.DropColumn(
  67. name: "SettledByAdminUserId",
  68. table: "GameSettlement");
  69. migrationBuilder.AddColumn<int>(
  70. name: "AdminID",
  71. table: "OrderRefund",
  72. type: "int",
  73. nullable: true);
  74. migrationBuilder.AddColumn<int>(
  75. name: "SettledByAdminID",
  76. table: "GameSettlement",
  77. type: "int",
  78. nullable: true);
  79. migrationBuilder.CreateIndex(
  80. name: "IX_OrderRefund_AdminID",
  81. table: "OrderRefund",
  82. column: "AdminID");
  83. migrationBuilder.CreateIndex(
  84. name: "IX_GameSettlement_SettledByAdminID",
  85. table: "GameSettlement",
  86. column: "SettledByAdminID");
  87. migrationBuilder.AddForeignKey(
  88. name: "FK_GameSettlement_Member_SettledByAdminID",
  89. table: "GameSettlement",
  90. column: "SettledByAdminID",
  91. principalTable: "Member",
  92. principalColumn: "ID");
  93. migrationBuilder.AddForeignKey(
  94. name: "FK_OrderRefund_Member_AdminID",
  95. table: "OrderRefund",
  96. column: "AdminID",
  97. principalTable: "Member",
  98. principalColumn: "ID");
  99. }
  100. }
  101. }