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); }); } } }