using System;
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
#nullable disable
|
|
namespace FlexJobApi.Database.Migrations.Migrations
|
{
|
/// <inheritdoc />
|
public partial class UpdateEnterpriseWallet0904 : Migration
|
{
|
/// <inheritdoc />
|
protected override void Up(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.DropTable(
|
name: "AlipayFundExpandindirectOrder");
|
|
migrationBuilder.AlterColumn<string>(
|
name: "Status",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true,
|
oldClrType: typeof(int),
|
oldType: "int");
|
|
migrationBuilder.AddColumn<string>(
|
name: "BizScene",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<string>(
|
name: "Link",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<string>(
|
name: "PayFundOrderId",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<string>(
|
name: "ProductCode",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<string>(
|
name: "SettleSerialNo",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<string>(
|
name: "SubStatus",
|
table: "EnterpriseWalletTransaction",
|
type: "nvarchar(max)",
|
nullable: true);
|
|
migrationBuilder.AddColumn<DateTime>(
|
name: "TransDate",
|
table: "EnterpriseWalletTransaction",
|
type: "datetime2",
|
nullable: true);
|
|
migrationBuilder.AddColumn<int>(
|
name: "TransactionStatus",
|
table: "EnterpriseWalletTransaction",
|
type: "int",
|
nullable: false,
|
defaultValue: 0);
|
|
migrationBuilder.CreateTable(
|
name: "EnterpriseWalletExpandindirectOrder",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
WalletId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
ProductCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
BizScene = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OutBizNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Identity = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IdentityType = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
BizType = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OriginalOrderId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Scene = table.Column<int>(type: "int", nullable: false),
|
SceneDirections = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneImage = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneQualificationImage = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sites = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OrderId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Status = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OrderStatus = table.Column<int>(type: "int", nullable: false),
|
TaskFinishTime = table.Column<DateTime>(type: "datetime2", nullable: true),
|
RiskReviewRemark = 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),
|
CreatedEnterpriseId = 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_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<Guid>(type: "uniqueidentifier", nullable: false),
|
OrderId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Type = table.Column<int>(type: "int", nullable: false),
|
File = 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),
|
CreatedEnterpriseId = 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_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");
|
}
|
|
/// <inheritdoc />
|
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<int>(
|
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<Guid>(type: "uniqueidentifier", nullable: false),
|
BizScene = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
BizType = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedEnterpriseId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
Identity = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IdentityType = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false),
|
Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OrderId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OriginalOrderId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
OutBizNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ProductCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RiskReviewRemark = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneCode = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneDirections = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneImage = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
SceneQualificationImage = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sites = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
Status = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TaskFinishTime = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_AlipayFundExpandindirectOrder", x => x.Id);
|
});
|
}
|
}
|
}
|
