using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateEnterpriseWallet0905 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserBankCard", type: "nvarchar(11)", maxLength: 11, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11); migrationBuilder.AlterColumn( name: "Code", table: "UserBankCard", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32); migrationBuilder.AlterColumn( name: "Bank", table: "UserBankCard", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AddColumn( name: "BankBranch", table: "UserBankCard", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "Identity", table: "UserBankCard", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "Name", table: "UserBankCard", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "ActualSettlementAmount", table: "TaskInfoUser", type: "decimal(18,2)", nullable: true); migrationBuilder.AddColumn( name: "Bank", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "BankBranch", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "ReceiveAccount", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "ReceiveName", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "SettlementAmount", table: "TaskInfoUser", type: "decimal(18,2)", nullable: true); migrationBuilder.AddColumn( name: "SettlementRemark", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "SettlementStatus", table: "TaskInfoUser", type: "int", nullable: true); migrationBuilder.AddColumn( name: "SettlementTime", table: "TaskInfoUser", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "ActualSettlementAmount", table: "TaskInfo", type: "decimal(18,2)", nullable: true); migrationBuilder.AddColumn( name: "SettlementAmount", table: "TaskInfo", type: "decimal(18,2)", nullable: true); migrationBuilder.AddColumn( name: "SettlementOrderName", table: "TaskInfo", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "SettlementOrderStatus", table: "TaskInfo", type: "int", nullable: true); migrationBuilder.AddColumn( name: "SettlementOrderTime", table: "TaskInfo", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "SettlementOrderUrl", table: "TaskInfo", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "SettlementRemark", table: "TaskInfo", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "SettlementStartTime", table: "TaskInfo", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "SettlementUserCount", table: "TaskInfo", type: "int", nullable: false, defaultValue: 0); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "BankBranch", table: "UserBankCard"); migrationBuilder.DropColumn( name: "Identity", table: "UserBankCard"); migrationBuilder.DropColumn( name: "Name", table: "UserBankCard"); migrationBuilder.DropColumn( name: "ActualSettlementAmount", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "Bank", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "BankBranch", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "ReceiveAccount", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "ReceiveName", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "SettlementAmount", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "SettlementRemark", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "SettlementStatus", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "SettlementTime", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "ActualSettlementAmount", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementAmount", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementOrderName", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementOrderStatus", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementOrderTime", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementOrderUrl", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementRemark", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementStartTime", table: "TaskInfo"); migrationBuilder.DropColumn( name: "SettlementUserCount", table: "TaskInfo"); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserBankCard", type: "nvarchar(11)", maxLength: 11, nullable: false, defaultValue: "", oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true); migrationBuilder.AlterColumn( name: "Code", table: "UserBankCard", type: "nvarchar(32)", maxLength: 32, nullable: false, defaultValue: "", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "Bank", table: "UserBankCard", type: "nvarchar(128)", maxLength: 128, nullable: false, defaultValue: "", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); } } }