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: "开户支行");
}
}
}