using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateUserWalletTransaction0909 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn( name: "ActualAmount", table: "TaskInfoUser", type: "decimal(18,2)", nullable: false, defaultValue: 0m); migrationBuilder.AddColumn( name: "SettlementOperatorUserId", table: "TaskInfo", type: "uniqueidentifier", nullable: true); migrationBuilder.AddColumn( name: "AfterBalance", table: "EnterpriseWalletTransaction", type: "decimal(18,2)", nullable: false, defaultValue: 0m); migrationBuilder.AddColumn( name: "OperatorTime", table: "EnterpriseWalletTransaction", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "OperatorUserId", table: "EnterpriseWalletTransaction", type: "uniqueidentifier", nullable: true); migrationBuilder.AddColumn( name: "ReceiveUserId", table: "EnterpriseWalletTransaction", type: "uniqueidentifier", nullable: true); migrationBuilder.AddColumn( name: "FreezeBalance", table: "EnterpriseWallet", type: "decimal(18,2)", nullable: false, defaultValue: 0m); migrationBuilder.CreateIndex( name: "IX_TaskInfo_SettlementOperatorUserId", table: "TaskInfo", column: "SettlementOperatorUserId"); migrationBuilder.CreateIndex( name: "IX_EnterpriseWalletTransaction_OperatorUserId", table: "EnterpriseWalletTransaction", column: "OperatorUserId"); migrationBuilder.CreateIndex( name: "IX_EnterpriseWalletTransaction_ReceiveUserId", table: "EnterpriseWalletTransaction", column: "ReceiveUserId"); migrationBuilder.AddForeignKey( name: "FK_EnterpriseWalletTransaction_User_OperatorUserId", table: "EnterpriseWalletTransaction", column: "OperatorUserId", principalTable: "User", principalColumn: "Id"); migrationBuilder.AddForeignKey( name: "FK_EnterpriseWalletTransaction_User_ReceiveUserId", table: "EnterpriseWalletTransaction", column: "ReceiveUserId", principalTable: "User", principalColumn: "Id"); migrationBuilder.AddForeignKey( name: "FK_TaskInfo_User_SettlementOperatorUserId", table: "TaskInfo", column: "SettlementOperatorUserId", principalTable: "User", principalColumn: "Id"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_EnterpriseWalletTransaction_User_OperatorUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropForeignKey( name: "FK_EnterpriseWalletTransaction_User_ReceiveUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropForeignKey( name: "FK_TaskInfo_User_SettlementOperatorUserId", table: "TaskInfo"); migrationBuilder.DropIndex( name: "IX_TaskInfo_SettlementOperatorUserId", table: "TaskInfo"); migrationBuilder.DropIndex( name: "IX_EnterpriseWalletTransaction_OperatorUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropIndex( name: "IX_EnterpriseWalletTransaction_ReceiveUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropColumn( name: "ActualAmount", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "SettlementOperatorUserId", table: "TaskInfo"); migrationBuilder.DropColumn( name: "AfterBalance", table: "EnterpriseWalletTransaction"); migrationBuilder.DropColumn( name: "OperatorTime", table: "EnterpriseWalletTransaction"); migrationBuilder.DropColumn( name: "OperatorUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropColumn( name: "ReceiveUserId", table: "EnterpriseWalletTransaction"); migrationBuilder.DropColumn( name: "FreezeBalance", table: "EnterpriseWallet"); } } }