using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateUser0806 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterTable( name: "EnterpriseAuth", comment: "企业认证"); migrationBuilder.AlterColumn( name: "ProvinceId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "常驻省份Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Avatar", table: "UserInfo", type: "nvarchar(max)", nullable: true, comment: "头像", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "SocietyCreditCode", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: false, comment: "统一社会信用代码", oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18); migrationBuilder.AlterColumn( name: "ProxyPowerAttorneyUrl", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "企业授权书", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Proxy", table: "EnterpriseAuth", type: "bit", nullable: true, comment: "是否委托经办人", oldClrType: typeof(bool), oldType: "bit", oldNullable: true); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "EnterpriseAuth", type: "nvarchar(11)", maxLength: 11, nullable: true, comment: "法人或经办人手机号", oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true); migrationBuilder.AlterColumn( name: "PersonalRealMethod", table: "EnterpriseAuth", type: "int", nullable: true, comment: "法人或经办人实名方式", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人或经办人姓名", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "LicenseImage", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "营业执照照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "LegalPerson", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人姓名", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "LegalIdentity", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: true, comment: "法人身份证号", oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18, oldNullable: true); migrationBuilder.AlterColumn( name: "IsReal", table: "EnterpriseAuth", type: "bit", nullable: false, comment: "是否实名", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IdentityImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "法人或经办人身份证人像面", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "IdentityBackImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "法人或经办人身份证国徽面", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Identity", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: true, comment: "法人或经办人身份证号", oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18, oldNullable: true); migrationBuilder.AlterColumn( name: "EnterpriseRealMethod", table: "EnterpriseAuth", type: "int", nullable: true, comment: "企业认证方式", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "EnterpriseName", table: "EnterpriseAuth", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "企业全称", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "BankCardImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "法人或经办人银行卡照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "BankCard", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人或经办人银行卡号", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "SmsCost", table: "Enterprise", type: "decimal(18,2)", nullable: false, comment: "短信费用", oldClrType: typeof(decimal), oldType: "decimal(18,2)"); migrationBuilder.AlterColumn( name: "SmsAccess", table: "Enterprise", type: "int", nullable: true, comment: "短信通道", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "SignCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, comment: "签约费用", oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true); migrationBuilder.AlterColumn( name: "RealVerifyCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, comment: "实名费用", oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true); migrationBuilder.AlterColumn( name: "ProvinceId", table: "Enterprise", type: "uniqueidentifier", nullable: true, comment: "所在省份Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "PayAccess", table: "Enterprise", type: "int", nullable: true, comment: "支付通道", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "MergeSignCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, comment: "一口价", oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true); migrationBuilder.AlterColumn( name: "MainBusiness", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "主营业务", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "IsCheckedBankCard", table: "Enterprise", type: "bit", nullable: false, comment: "是否已校验银行账户", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IndustryTypeId", table: "Enterprise", type: "uniqueidentifier", nullable: true, comment: "所属行业Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "EnterpriseAuthId", table: "Enterprise", type: "uniqueidentifier", nullable: false, comment: "企业认证Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "ContactPhoneNumber", table: "Enterprise", type: "nvarchar(11)", maxLength: 11, nullable: true, comment: "联系电话", oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true); migrationBuilder.AlterColumn( name: "ContactEmail", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "联系邮箱", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CityId", table: "Enterprise", type: "uniqueidentifier", nullable: true, comment: "所在城市Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "BankName", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "开户总行", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "BankCard", table: "Enterprise", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "银行账户", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "法人或经办人银行卡号"); migrationBuilder.AlterColumn( name: "BankBranchName", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "开户支行", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.AlterTable( name: "EnterpriseAuth", oldComment: "企业认证"); migrationBuilder.AlterColumn( name: "ProvinceId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "常驻省份Id"); migrationBuilder.AlterColumn( name: "Avatar", table: "UserInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "头像"); migrationBuilder.AlterColumn( name: "SocietyCreditCode", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18, oldComment: "统一社会信用代码"); migrationBuilder.AlterColumn( name: "ProxyPowerAttorneyUrl", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "企业授权书"); migrationBuilder.AlterColumn( name: "Proxy", table: "EnterpriseAuth", type: "bit", nullable: true, oldClrType: typeof(bool), oldType: "bit", oldNullable: true, oldComment: "是否委托经办人"); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "EnterpriseAuth", type: "nvarchar(11)", maxLength: 11, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true, oldComment: "法人或经办人手机号"); migrationBuilder.AlterColumn( name: "PersonalRealMethod", table: "EnterpriseAuth", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "法人或经办人实名方式"); migrationBuilder.AlterColumn( name: "Name", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "法人或经办人姓名"); migrationBuilder.AlterColumn( name: "LicenseImage", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "营业执照照片"); migrationBuilder.AlterColumn( name: "LegalPerson", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "法人姓名"); migrationBuilder.AlterColumn( name: "LegalIdentity", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18, oldNullable: true, oldComment: "法人身份证号"); migrationBuilder.AlterColumn( name: "IsReal", table: "EnterpriseAuth", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否实名"); migrationBuilder.AlterColumn( name: "IdentityImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "法人或经办人身份证人像面"); migrationBuilder.AlterColumn( name: "IdentityBackImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "法人或经办人身份证国徽面"); migrationBuilder.AlterColumn( name: "Identity", table: "EnterpriseAuth", type: "nvarchar(18)", maxLength: 18, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(18)", oldMaxLength: 18, oldNullable: true, oldComment: "法人或经办人身份证号"); migrationBuilder.AlterColumn( name: "EnterpriseRealMethod", table: "EnterpriseAuth", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "企业认证方式"); migrationBuilder.AlterColumn( name: "EnterpriseName", table: "EnterpriseAuth", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "企业全称"); migrationBuilder.AlterColumn( name: "BankCardImg", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "法人或经办人银行卡照片"); migrationBuilder.AlterColumn( name: "BankCard", table: "EnterpriseAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "法人或经办人银行卡号"); migrationBuilder.AlterColumn( name: "SmsCost", table: "Enterprise", type: "decimal(18,2)", nullable: false, oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldComment: "短信费用"); migrationBuilder.AlterColumn( name: "SmsAccess", table: "Enterprise", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "短信通道"); migrationBuilder.AlterColumn( name: "SignCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true, oldComment: "签约费用"); migrationBuilder.AlterColumn( name: "RealVerifyCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true, oldComment: "实名费用"); migrationBuilder.AlterColumn( name: "ProvinceId", table: "Enterprise", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "所在省份Id"); migrationBuilder.AlterColumn( name: "PayAccess", table: "Enterprise", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "支付通道"); migrationBuilder.AlterColumn( name: "MergeSignCost", table: "Enterprise", type: "decimal(18,2)", nullable: true, oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldNullable: true, oldComment: "一口价"); migrationBuilder.AlterColumn( name: "MainBusiness", table: "Enterprise", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "主营业务"); migrationBuilder.AlterColumn( name: "IsCheckedBankCard", table: "Enterprise", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否已校验银行账户"); migrationBuilder.AlterColumn( name: "IndustryTypeId", table: "Enterprise", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "所属行业Id"); migrationBuilder.AlterColumn( name: "EnterpriseAuthId", table: "Enterprise", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "企业认证Id"); migrationBuilder.AlterColumn( name: "ContactPhoneNumber", table: "Enterprise", type: "nvarchar(11)", maxLength: 11, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true, oldComment: "联系电话"); migrationBuilder.AlterColumn( name: "ContactEmail", table: "Enterprise", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "联系邮箱"); migrationBuilder.AlterColumn( name: "CityId", table: "Enterprise", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "所在城市Id"); migrationBuilder.AlterColumn( name: "BankName", table: "Enterprise", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "开户总行"); migrationBuilder.AlterColumn( name: "BankCard", table: "Enterprise", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人或经办人银行卡号", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "银行账户"); migrationBuilder.AlterColumn( name: "BankBranchName", table: "Enterprise", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "开户支行"); } } }