using System;
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
#nullable disable
|
|
namespace ApiTools.Database.Migrations.Migrations
|
{
|
/// <inheritdoc />
|
public partial class UpdateChannelWallet1119 : Migration
|
{
|
/// <inheritdoc />
|
protected override void Up(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.CreateTable(
|
name: "ChannelWallet",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
ChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
OutWalletId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Access = table.Column<int>(type: "int", nullable: false),
|
Code = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Bank = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
BankBranch = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Identity = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Balance = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
|
SignStatus = table.Column<int>(type: "int", nullable: false),
|
ErrorCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
FailReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ChannelWallet", x => x.Id);
|
table.ForeignKey(
|
name: "FK_ChannelWallet_Channel_ChannelId",
|
column: x => x.ChannelId,
|
principalTable: "Channel",
|
principalColumn: "Id");
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ChannelWalletTransaction",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
WalletId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Type = table.Column<int>(type: "int", nullable: false),
|
Code = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OutCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ConcurrencyLock = table.Column<string>(type: "nvarchar(450)", nullable: true),
|
Amount = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
|
Balance = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
|
AfterBalance = table.Column<decimal>(type: "decimal(18,2)", nullable: false),
|
OutOperatorId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OperatorTime = table.Column<DateTime>(type: "datetime2", nullable: true),
|
PayerAccount = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
PayerName = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
PayerBank = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
PayerBankBranch = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OutReceiveId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ReceiveName = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ReceiveIdentity = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ReceiveAccount = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ReceiveBank = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ReceiveBankBranch = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Currency = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Purpose = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ErrorCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
FailReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TransDate = table.Column<DateTime>(type: "datetime2", nullable: true),
|
OrderFee = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
|
EreceiptFileId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
EreceiptDownloadUrl = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
EreceiptDownloadOssUrl = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
EreceiptStatus = table.Column<int>(type: "int", nullable: true),
|
EreceiptErrorMessage = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TransactionStatus = table.Column<int>(type: "int", nullable: false),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ChannelWalletTransaction", x => x.Id);
|
table.ForeignKey(
|
name: "FK_ChannelWalletTransaction_ChannelWallet_WalletId",
|
column: x => x.WalletId,
|
principalTable: "ChannelWallet",
|
principalColumn: "Id",
|
onDelete: ReferentialAction.Cascade);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ChannelWalletTransactionPingAnPay",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
FreezeNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
StopStt = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
StopFailReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RemoveStopStt = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RemoveStopFailReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ThirdVoucher = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
FrontLogNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CstInnerFlowNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IsBack = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
BackRem = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Yhcljg = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SysFlag = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Fee = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TransBsn = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SubmitTime = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
AccountDate = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
HostFlowNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
HostErrorCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ProxyPayName = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ProxyPayAcc = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ProxyPayBankName = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ChannelWalletTransactionPingAnPay", x => x.Id);
|
table.ForeignKey(
|
name: "FK_ChannelWalletTransactionPingAnPay_ChannelWalletTransaction_Id",
|
column: x => x.Id,
|
principalTable: "ChannelWalletTransaction",
|
principalColumn: "Id",
|
onDelete: ReferentialAction.Cascade);
|
});
|
|
migrationBuilder.CreateIndex(
|
name: "IX_ChannelWallet_ChannelId",
|
table: "ChannelWallet",
|
column: "ChannelId");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_ChannelWalletTransaction_ConcurrencyLock",
|
table: "ChannelWalletTransaction",
|
column: "ConcurrencyLock",
|
unique: true,
|
filter: "[ConcurrencyLock] IS NOT NULL");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_ChannelWalletTransaction_WalletId",
|
table: "ChannelWalletTransaction",
|
column: "WalletId");
|
}
|
|
/// <inheritdoc />
|
protected override void Down(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.DropTable(
|
name: "ChannelWalletTransactionPingAnPay");
|
|
migrationBuilder.DropTable(
|
name: "ChannelWalletTransaction");
|
|
migrationBuilder.DropTable(
|
name: "ChannelWallet");
|
}
|
}
|
}
|
