| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727 |
- using System;
- using Microsoft.EntityFrameworkCore.Migrations;
- #nullable disable
- namespace Infrastructure.Migrations.AppDb
- {
- /// <inheritdoc />
- public partial class ReplaceDanalWithTossPayments : Migration
- {
- /// <inheritdoc />
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "DanalCancel");
- migrationBuilder.DropTable(
- name: "DanalConfirm");
- migrationBuilder.DropTable(
- name: "DanalLog");
- migrationBuilder.DropColumn(
- name: "External_DanalLiveClientKeyEnc",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "External_DanalLiveCpid",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalCardFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalCardFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalKakaoPayFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalKakaoPayFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalMobileFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalMobileFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalNaverPayFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalNaverPayFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalTransferFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalTransferFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalVbankFeeAmount",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_DanalVbankFeeRate",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsCardEnabled",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsKakaoPayEnabled",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsMobileEnabled",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsNaverPayEnabled",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsTransferEnabled",
- table: "Config");
- migrationBuilder.DropColumn(
- name: "Payment_IsVirtualAccountEnabled",
- table: "Config");
- migrationBuilder.RenameColumn(
- name: "External_DanalTestSecretKeyEnc",
- table: "Config",
- newName: "External_TossTestSecretKeyEnc");
- migrationBuilder.RenameColumn(
- name: "External_DanalTestCpid",
- table: "Config",
- newName: "External_TossTestClientKeyEnc");
- migrationBuilder.RenameColumn(
- name: "External_DanalTestClientKeyEnc",
- table: "Config",
- newName: "External_TossPayMode");
- migrationBuilder.RenameColumn(
- name: "External_DanalPayMode",
- table: "Config",
- newName: "External_TossLiveSecretKeyEnc");
- migrationBuilder.RenameColumn(
- name: "External_DanalLiveSecretKeyEnc",
- table: "Config",
- newName: "External_TossLiveClientKeyEnc");
- migrationBuilder.AddColumn<Guid>(
- name: "PaymentCustomerKey",
- table: "Member",
- type: "uniqueidentifier",
- nullable: true);
- migrationBuilder.CreateTable(
- name: "TossCancel",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: false),
- PaymentOrderID = table.Column<int>(type: "int", nullable: false),
- PaymentKey = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: false),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- CancelAmount = table.Column<int>(type: "int", nullable: false),
- CancelReason = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: false),
- CancelRequester = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- ResponseCode = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- TransactionKey = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- Status = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true),
- CanceledAt = table.Column<DateTime>(type: "datetime2", nullable: true),
- RawResponse = table.Column<string>(type: "nvarchar(max)", nullable: true),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
- UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_TossCancel", x => x.ID);
- table.ForeignKey(
- name: "FK_TossCancel_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- table.ForeignKey(
- name: "FK_TossCancel_PaymentOrder_PaymentOrderID",
- column: x => x.PaymentOrderID,
- principalTable: "PaymentOrder",
- principalColumn: "ID");
- },
- comment: "토스페이먼츠 결제 취소 (요청+응답)");
- migrationBuilder.CreateTable(
- name: "TossConfirm",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: false),
- PaymentOrderID = table.Column<int>(type: "int", nullable: false),
- PaymentKey = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: false),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- Amount = table.Column<int>(type: "int", nullable: false),
- ResponseCode = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- Status = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true),
- Method = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true),
- TotalAmount = table.Column<int>(type: "int", nullable: true),
- ApprovedAt = table.Column<DateTime>(type: "datetime2", nullable: true),
- ReceiptUrl = table.Column<string>(type: "nvarchar(300)", maxLength: 300, nullable: true),
- RawResponse = table.Column<string>(type: "nvarchar(max)", nullable: true),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
- UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_TossConfirm", x => x.ID);
- table.ForeignKey(
- name: "FK_TossConfirm_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- table.ForeignKey(
- name: "FK_TossConfirm_PaymentOrder_PaymentOrderID",
- column: x => x.PaymentOrderID,
- principalTable: "PaymentOrder",
- principalColumn: "ID");
- },
- comment: "토스페이먼츠 결제 승인 (요청+응답)");
- migrationBuilder.CreateTable(
- name: "TossLog",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: true),
- LogType = table.Column<int>(type: "int", nullable: false),
- Code = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- Message = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: false),
- PaymentKey = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- ExtraData = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_TossLog", x => x.ID);
- table.ForeignKey(
- name: "FK_TossLog_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- },
- comment: "토스페이먼츠 결제 에러/실패/웹훅/대사 로그");
- migrationBuilder.CreateIndex(
- name: "IX_TossCancel_MemberID",
- table: "TossCancel",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_TossCancel_OrderID",
- table: "TossCancel",
- column: "OrderID");
- migrationBuilder.CreateIndex(
- name: "IX_TossCancel_PaymentKey",
- table: "TossCancel",
- column: "PaymentKey");
- migrationBuilder.CreateIndex(
- name: "IX_TossCancel_PaymentOrderID",
- table: "TossCancel",
- column: "PaymentOrderID");
- migrationBuilder.CreateIndex(
- name: "IX_TossCancel_TransactionKey",
- table: "TossCancel",
- column: "TransactionKey");
- migrationBuilder.CreateIndex(
- name: "IX_TossConfirm_MemberID",
- table: "TossConfirm",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_TossConfirm_OrderID",
- table: "TossConfirm",
- column: "OrderID",
- unique: true);
- migrationBuilder.CreateIndex(
- name: "IX_TossConfirm_PaymentKey",
- table: "TossConfirm",
- column: "PaymentKey",
- unique: true);
- migrationBuilder.CreateIndex(
- name: "IX_TossConfirm_PaymentOrderID",
- table: "TossConfirm",
- column: "PaymentOrderID");
- migrationBuilder.CreateIndex(
- name: "IX_TossConfirm_Status",
- table: "TossConfirm",
- column: "Status");
- migrationBuilder.CreateIndex(
- name: "IX_TossLog_Code",
- table: "TossLog",
- column: "Code");
- migrationBuilder.CreateIndex(
- name: "IX_TossLog_LogType",
- table: "TossLog",
- column: "LogType");
- migrationBuilder.CreateIndex(
- name: "IX_TossLog_MemberID",
- table: "TossLog",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_TossLog_OrderID",
- table: "TossLog",
- column: "OrderID");
- migrationBuilder.CreateIndex(
- name: "IX_TossLog_PaymentKey",
- table: "TossLog",
- column: "PaymentKey");
- }
- /// <inheritdoc />
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "TossCancel");
- migrationBuilder.DropTable(
- name: "TossConfirm");
- migrationBuilder.DropTable(
- name: "TossLog");
- migrationBuilder.DropColumn(
- name: "PaymentCustomerKey",
- table: "Member");
- migrationBuilder.RenameColumn(
- name: "External_TossTestSecretKeyEnc",
- table: "Config",
- newName: "External_DanalTestSecretKeyEnc");
- migrationBuilder.RenameColumn(
- name: "External_TossTestClientKeyEnc",
- table: "Config",
- newName: "External_DanalTestCpid");
- migrationBuilder.RenameColumn(
- name: "External_TossPayMode",
- table: "Config",
- newName: "External_DanalTestClientKeyEnc");
- migrationBuilder.RenameColumn(
- name: "External_TossLiveSecretKeyEnc",
- table: "Config",
- newName: "External_DanalPayMode");
- migrationBuilder.RenameColumn(
- name: "External_TossLiveClientKeyEnc",
- table: "Config",
- newName: "External_DanalLiveSecretKeyEnc");
- migrationBuilder.AddColumn<string>(
- name: "External_DanalLiveClientKeyEnc",
- table: "Config",
- type: "nvarchar(max)",
- nullable: true);
- migrationBuilder.AddColumn<string>(
- name: "External_DanalLiveCpid",
- table: "Config",
- type: "nvarchar(max)",
- nullable: true);
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalCardFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "신용카드 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalCardFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "신용카드 수수료(%)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalKakaoPayFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "카카오페이 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalKakaoPayFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "카카오페이 수수료(%)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalMobileFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "휴대폰 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalMobileFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "휴대폰 수수료(%)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalNaverPayFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "네이버페이 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalNaverPayFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "네이버페이 수수료(%)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalTransferFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "계좌이체 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalTransferFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "계좌이체 수수료(%)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalVbankFeeAmount",
- table: "Config",
- type: "decimal(18,0)",
- precision: 18,
- nullable: true,
- comment: "가상계좌 수수료(원)");
- migrationBuilder.AddColumn<decimal>(
- name: "Payment_DanalVbankFeeRate",
- table: "Config",
- type: "decimal(5,2)",
- precision: 5,
- scale: 2,
- nullable: true,
- comment: "가상계좌 수수료(%)");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsCardEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "신용카드 사용 여부");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsKakaoPayEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "카카오페이 사용 여부");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsMobileEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "휴대폰 사용 여부");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsNaverPayEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "네이버페이 사용 여부");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsTransferEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "계좌이체 사용 여부");
- migrationBuilder.AddColumn<bool>(
- name: "Payment_IsVirtualAccountEnabled",
- table: "Config",
- type: "bit",
- nullable: false,
- defaultValue: false,
- comment: "가상계좌 사용 여부");
- migrationBuilder.CreateTable(
- name: "DanalCancel",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: false),
- PaymentOrderID = table.Column<int>(type: "int", nullable: false),
- Amount = table.Column<int>(type: "int", nullable: false),
- ApprovalDateTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
- Balance = table.Column<int>(type: "int", nullable: true),
- CancelReason = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true),
- CancelRequester = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- CancelType = table.Column<int>(type: "int", nullable: false),
- CancelledAmount = table.Column<int>(type: "int", nullable: true),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
- MerchantID = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
- Method = table.Column<int>(type: "int", nullable: false),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- OriginalTransactionID = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- RemainedAmount = table.Column<int>(type: "int", nullable: true),
- ResponseCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- TransDate = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
- TransTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
- TransactionID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_DanalCancel", x => x.ID);
- table.ForeignKey(
- name: "FK_DanalCancel_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- table.ForeignKey(
- name: "FK_DanalCancel_PaymentOrder_PaymentOrderID",
- column: x => x.PaymentOrderID,
- principalTable: "PaymentOrder",
- principalColumn: "ID");
- },
- comment: "다날 결제 취소 (요청+응답)");
- migrationBuilder.CreateTable(
- name: "DanalConfirm",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: false),
- PaymentOrderID = table.Column<int>(type: "int", nullable: false),
- AccountNumber = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
- Amount = table.Column<int>(type: "int", nullable: false),
- ApprovalDateTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
- ApproveNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
- AuthKey = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
- BankCode = table.Column<string>(type: "nvarchar(3)", maxLength: 3, nullable: true),
- BankName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- CardCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- CardName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
- CardNo = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- CertificateToken = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
- DiscountAmount = table.Column<int>(type: "int", nullable: true),
- ExpireDate = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
- ExpireTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
- InstallmentMonths = table.Column<byte>(type: "tinyint", nullable: true),
- MerchantID = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
- Method = table.Column<int>(type: "int", nullable: false),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- OrderName = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- ResponseCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
- TotalAmount = table.Column<int>(type: "int", nullable: true),
- TransDate = table.Column<string>(type: "nvarchar(8)", maxLength: 8, nullable: true),
- TransTime = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- TransactionID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
- UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true),
- UseCashReceipt = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true),
- UserEmail = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
- UserId = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- UserName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
- VirtualAccountNumber = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_DanalConfirm", x => x.ID);
- table.ForeignKey(
- name: "FK_DanalConfirm_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- table.ForeignKey(
- name: "FK_DanalConfirm_PaymentOrder_PaymentOrderID",
- column: x => x.PaymentOrderID,
- principalTable: "PaymentOrder",
- principalColumn: "ID");
- },
- comment: "다날 결제 승인 (요청+응답)");
- migrationBuilder.CreateTable(
- name: "DanalLog",
- columns: table => new
- {
- ID = table.Column<int>(type: "int", nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- MemberID = table.Column<int>(type: "int", nullable: false),
- Code = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
- CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
- ExtraData = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true),
- LogType = table.Column<int>(type: "int", nullable: false),
- Message = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: false),
- OrderID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
- TransactionID = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_DanalLog", x => x.ID);
- table.ForeignKey(
- name: "FK_DanalLog_Member_MemberID",
- column: x => x.MemberID,
- principalTable: "Member",
- principalColumn: "ID");
- },
- comment: "다날 결제 에러/실패/웹훅 로그");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_CancelType",
- table: "DanalCancel",
- column: "CancelType");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_MemberID",
- table: "DanalCancel",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_Method",
- table: "DanalCancel",
- column: "Method");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_OrderID",
- table: "DanalCancel",
- column: "OrderID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_PaymentOrderID",
- table: "DanalCancel",
- column: "PaymentOrderID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalCancel_TransactionID",
- table: "DanalCancel",
- column: "TransactionID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalConfirm_MemberID",
- table: "DanalConfirm",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalConfirm_Method",
- table: "DanalConfirm",
- column: "Method");
- migrationBuilder.CreateIndex(
- name: "IX_DanalConfirm_OrderID",
- table: "DanalConfirm",
- column: "OrderID",
- unique: true);
- migrationBuilder.CreateIndex(
- name: "IX_DanalConfirm_PaymentOrderID",
- table: "DanalConfirm",
- column: "PaymentOrderID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalConfirm_TransactionID",
- table: "DanalConfirm",
- column: "TransactionID",
- unique: true);
- migrationBuilder.CreateIndex(
- name: "IX_DanalLog_Code",
- table: "DanalLog",
- column: "Code");
- migrationBuilder.CreateIndex(
- name: "IX_DanalLog_LogType",
- table: "DanalLog",
- column: "LogType");
- migrationBuilder.CreateIndex(
- name: "IX_DanalLog_MemberID",
- table: "DanalLog",
- column: "MemberID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalLog_OrderID",
- table: "DanalLog",
- column: "OrderID");
- migrationBuilder.CreateIndex(
- name: "IX_DanalLog_TransactionID",
- table: "DanalLog",
- column: "TransactionID");
- }
- }
- }
|