20260526200341_ExpandChannelRatePrecision.cs 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. #nullable disable
  3. namespace Infrastructure.Migrations.AppDb
  4. {
  5. /// <inheritdoc />
  6. public partial class ExpandChannelRatePrecision : Migration
  7. {
  8. /// <inheritdoc />
  9. protected override void Up(MigrationBuilder migrationBuilder)
  10. {
  11. migrationBuilder.AlterColumn<decimal>(
  12. name: "StoreCommissionRate",
  13. table: "Channel",
  14. type: "decimal(10,7)",
  15. precision: 10,
  16. scale: 7,
  17. nullable: false,
  18. defaultValue: 0m,
  19. comment: "상점 매출 보상률(%) — 채널 몫, 0~100, 소수점 7자리",
  20. oldClrType: typeof(decimal),
  21. oldType: "decimal(5,2)",
  22. oldPrecision: 5,
  23. oldScale: 2,
  24. oldDefaultValue: 0m,
  25. oldComment: "상점 매출 보상률(%) — 채널 몫");
  26. migrationBuilder.AlterColumn<decimal>(
  27. name: "PlatformFeeRate",
  28. table: "Channel",
  29. type: "decimal(10,7)",
  30. precision: 10,
  31. scale: 7,
  32. nullable: false,
  33. comment: "후원 수수료(%) — dpot 몫, 0~100, 소수점 7자리",
  34. oldClrType: typeof(decimal),
  35. oldType: "decimal(5,2)",
  36. oldPrecision: 5,
  37. oldScale: 2,
  38. oldComment: "후원 수수료(%) — dpot 몫");
  39. }
  40. /// <inheritdoc />
  41. protected override void Down(MigrationBuilder migrationBuilder)
  42. {
  43. migrationBuilder.AlterColumn<decimal>(
  44. name: "StoreCommissionRate",
  45. table: "Channel",
  46. type: "decimal(5,2)",
  47. precision: 5,
  48. scale: 2,
  49. nullable: false,
  50. defaultValue: 0m,
  51. comment: "상점 매출 보상률(%) — 채널 몫",
  52. oldClrType: typeof(decimal),
  53. oldType: "decimal(10,7)",
  54. oldPrecision: 10,
  55. oldScale: 7,
  56. oldDefaultValue: 0m,
  57. oldComment: "상점 매출 보상률(%) — 채널 몫, 0~100, 소수점 7자리");
  58. migrationBuilder.AlterColumn<decimal>(
  59. name: "PlatformFeeRate",
  60. table: "Channel",
  61. type: "decimal(5,2)",
  62. precision: 5,
  63. scale: 2,
  64. nullable: false,
  65. comment: "후원 수수료(%) — dpot 몫",
  66. oldClrType: typeof(decimal),
  67. oldType: "decimal(10,7)",
  68. oldPrecision: 10,
  69. oldScale: 7,
  70. oldComment: "후원 수수료(%) — dpot 몫, 0~100, 소수점 7자리");
  71. }
  72. }
  73. }