using System;
using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace FlexJobApi.Database.Migrations.Migrations
{
///
public partial class UpdateEnterpriseWallet0904 : Migration
{
///
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "AlipayFundExpandindirectOrder");
migrationBuilder.AlterColumn(
name: "Status",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true,
oldClrType: typeof(int),
oldType: "int");
migrationBuilder.AddColumn(
name: "BizScene",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "Link",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "PayFundOrderId",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "ProductCode",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "SettleSerialNo",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "SubStatus",
table: "EnterpriseWalletTransaction",
type: "nvarchar(max)",
nullable: true);
migrationBuilder.AddColumn(
name: "TransDate",
table: "EnterpriseWalletTransaction",
type: "datetime2",
nullable: true);
migrationBuilder.AddColumn(
name: "TransactionStatus",
table: "EnterpriseWalletTransaction",
type: "int",
nullable: false,
defaultValue: 0);
migrationBuilder.CreateTable(
name: "EnterpriseWalletExpandindirectOrder",
columns: table => new
{
Id = table.Column(type: "uniqueidentifier", nullable: false),
WalletId = table.Column(type: "uniqueidentifier", nullable: false),
ProductCode = table.Column(type: "nvarchar(max)", nullable: true),
BizScene = table.Column(type: "nvarchar(max)", nullable: true),
OutBizNo = table.Column(type: "nvarchar(max)", nullable: true),
Identity = table.Column(type: "nvarchar(max)", nullable: true),
IdentityType = table.Column(type: "nvarchar(max)", nullable: true),
Name = table.Column(type: "nvarchar(max)", nullable: true),
BizType = table.Column(type: "nvarchar(max)", nullable: true),
OriginalOrderId = table.Column(type: "nvarchar(max)", nullable: true),
SceneCode = table.Column(type: "nvarchar(max)", nullable: true),
Scene = table.Column(type: "int", nullable: false),
SceneDirections = table.Column(type: "nvarchar(max)", nullable: true),
SceneImage = table.Column(type: "nvarchar(max)", nullable: true),
SceneQualificationImage = table.Column(type: "nvarchar(max)", nullable: true),
Sites = table.Column(type: "nvarchar(max)", nullable: true),
OrderId = table.Column(type: "nvarchar(max)", nullable: true),
Status = table.Column(type: "nvarchar(max)", nullable: true),
OrderStatus = table.Column(type: "int", nullable: false),
TaskFinishTime = table.Column(type: "datetime2", nullable: true),
RiskReviewRemark = table.Column(type: "nvarchar(max)", nullable: true),
Sort = table.Column(type: "int", nullable: false),
TraceId = table.Column(type: "nvarchar(max)", nullable: true),
CreatedTime = table.Column(type: "datetimeoffset", nullable: false),
CreatedUserId = table.Column(type: "uniqueidentifier", nullable: true),
CreatedEnterpriseId = table.Column(type: "uniqueidentifier", nullable: true),
UpdatedTime = table.Column(type: "datetimeoffset", nullable: true),
UpdatedUserId = table.Column(type: "uniqueidentifier", nullable: true),
IsDeleted = table.Column(type: "bit", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_EnterpriseWalletExpandindirectOrder", x => x.Id);
table.ForeignKey(
name: "FK_EnterpriseWalletExpandindirectOrder_EnterpriseWallet_WalletId",
column: x => x.WalletId,
principalTable: "EnterpriseWallet",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
});
migrationBuilder.CreateTable(
name: "EnterpriseWalletExpandindirectOrderFile",
columns: table => new
{
Id = table.Column(type: "uniqueidentifier", nullable: false),
OrderId = table.Column(type: "uniqueidentifier", nullable: false),
Type = table.Column(type: "int", nullable: false),
File = table.Column(type: "nvarchar(max)", nullable: true),
Sort = table.Column(type: "int", nullable: false),
TraceId = table.Column(type: "nvarchar(max)", nullable: true),
CreatedTime = table.Column(type: "datetimeoffset", nullable: false),
CreatedUserId = table.Column(type: "uniqueidentifier", nullable: true),
CreatedEnterpriseId = table.Column(type: "uniqueidentifier", nullable: true),
UpdatedTime = table.Column(type: "datetimeoffset", nullable: true),
UpdatedUserId = table.Column(type: "uniqueidentifier", nullable: true),
IsDeleted = table.Column(type: "bit", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_EnterpriseWalletExpandindirectOrderFile", x => x.Id);
table.ForeignKey(
name: "FK_EnterpriseWalletExpandindirectOrderFile_EnterpriseWalletExpandindirectOrder_OrderId",
column: x => x.OrderId,
principalTable: "EnterpriseWalletExpandindirectOrder",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
});
migrationBuilder.CreateIndex(
name: "IX_EnterpriseWalletExpandindirectOrder_WalletId",
table: "EnterpriseWalletExpandindirectOrder",
column: "WalletId");
migrationBuilder.CreateIndex(
name: "IX_EnterpriseWalletExpandindirectOrderFile_OrderId",
table: "EnterpriseWalletExpandindirectOrderFile",
column: "OrderId");
}
///
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "EnterpriseWalletExpandindirectOrderFile");
migrationBuilder.DropTable(
name: "EnterpriseWalletExpandindirectOrder");
migrationBuilder.DropColumn(
name: "BizScene",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "Link",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "PayFundOrderId",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "ProductCode",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "SettleSerialNo",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "SubStatus",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "TransDate",
table: "EnterpriseWalletTransaction");
migrationBuilder.DropColumn(
name: "TransactionStatus",
table: "EnterpriseWalletTransaction");
migrationBuilder.AlterColumn(
name: "Status",
table: "EnterpriseWalletTransaction",
type: "int",
nullable: false,
defaultValue: 0,
oldClrType: typeof(string),
oldType: "nvarchar(max)",
oldNullable: true);
migrationBuilder.CreateTable(
name: "AlipayFundExpandindirectOrder",
columns: table => new
{
Id = table.Column(type: "uniqueidentifier", nullable: false),
BizScene = table.Column(type: "nvarchar(max)", nullable: true),
BizType = table.Column(type: "nvarchar(max)", nullable: true),
CreatedEnterpriseId = table.Column(type: "uniqueidentifier", nullable: true),
CreatedTime = table.Column(type: "datetimeoffset", nullable: false),
CreatedUserId = table.Column(type: "uniqueidentifier", nullable: true),
Identity = table.Column(type: "nvarchar(max)", nullable: true),
IdentityType = table.Column(type: "nvarchar(max)", nullable: true),
IsDeleted = table.Column(type: "bit", nullable: false),
Name = table.Column(type: "nvarchar(max)", nullable: true),
OrderId = table.Column(type: "nvarchar(max)", nullable: true),
OriginalOrderId = table.Column(type: "nvarchar(max)", nullable: true),
OutBizNo = table.Column(type: "nvarchar(max)", nullable: true),
ProductCode = table.Column(type: "nvarchar(max)", nullable: true),
RiskReviewRemark = table.Column(type: "nvarchar(max)", nullable: true),
SceneCode = table.Column(type: "nvarchar(max)", nullable: true),
SceneDirections = table.Column(type: "nvarchar(max)", nullable: true),
SceneImage = table.Column(type: "nvarchar(max)", nullable: true),
SceneQualificationImage = table.Column(type: "nvarchar(max)", nullable: true),
Sites = table.Column(type: "nvarchar(max)", nullable: true),
Sort = table.Column(type: "int", nullable: false),
Status = table.Column(type: "nvarchar(max)", nullable: true),
TaskFinishTime = table.Column(type: "nvarchar(max)", nullable: true),
TraceId = table.Column(type: "nvarchar(max)", nullable: true),
UpdatedTime = table.Column(type: "datetimeoffset", nullable: true),
UpdatedUserId = table.Column(type: "uniqueidentifier", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_AlipayFundExpandindirectOrder", x => x.Id);
});
}
}
}