using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateResource0806002 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_TaskInfoBenefit_DictionaryData_BenefitId1", table: "TaskInfoBenefit"); migrationBuilder.DropForeignKey( name: "FK_TaskInfoBenefit_TaskInfo_BenefitId", table: "TaskInfoBenefit"); migrationBuilder.DropIndex( name: "IX_TaskInfoBenefit_BenefitId1", table: "TaskInfoBenefit"); migrationBuilder.DropColumn( name: "BenefitId1", table: "TaskInfoBenefit"); migrationBuilder.AlterTable( name: "UserInfoRole", oldComment: "用户信息角色"); migrationBuilder.AlterTable( name: "UserInfoPhoto", oldComment: "用户信息生活照"); migrationBuilder.AlterTable( name: "UserInfoExpectJob", oldComment: "用户信息期望岗位"); migrationBuilder.AlterTable( name: "UserInfoDepartment", oldComment: "用户信息部门"); migrationBuilder.AlterTable( name: "UserInfoCredential", oldComment: "用户信息资格证书"); migrationBuilder.AlterTable( name: "UserInfoBankCard", oldComment: "用户银行卡信息"); migrationBuilder.AlterTable( name: "UserInfo", oldComment: "用户信息"); migrationBuilder.AlterTable( name: "UserAuth", oldComment: "用户"); migrationBuilder.AlterTable( name: "TaskInfoUser", oldComment: "任务用户信息"); migrationBuilder.AlterTable( name: "TaskInfoBenefit", oldComment: "任务福利"); migrationBuilder.AlterTable( name: "TaskInfo", oldComment: "任务信息"); migrationBuilder.AlterTable( name: "RoleResource", oldComment: "角色资源"); migrationBuilder.AlterTable( name: "RoleMenu", oldComment: "角色菜单"); migrationBuilder.AlterTable( name: "Role", oldComment: "角色"); migrationBuilder.AlterTable( name: "Resource", oldComment: "资源"); migrationBuilder.AlterTable( name: "Menu", oldComment: "菜单"); migrationBuilder.AlterTable( name: "EnterpriseAuth", oldComment: "企业认证"); migrationBuilder.AlterTable( name: "Enterprise", oldComment: "企业"); migrationBuilder.AlterTable( name: "DictionaryData", oldComment: "字典数据"); migrationBuilder.AlterTable( name: "DictionaryCategory", oldComment: "字典类别"); migrationBuilder.AlterTable( name: "Department", oldComment: "部门"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoRole", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoRole", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "RoleId", table: "UserInfoRole", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "角色Id"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoRole", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoPhoto", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoPhoto", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoPhoto", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "Img", table: "UserInfoPhoto", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "照片"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoExpectJob", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoExpectJob", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "PersonalIdentityId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "期望岗位Id"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoExpectJob", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoDepartment", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoDepartment", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoDepartment", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "DepartmentId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "部门Id"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TypeId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "证书类型Id"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "StartDate", table: "UserInfoCredential", type: "datetime2", nullable: false, oldClrType: typeof(DateTime), oldType: "datetime2", oldComment: "开始日期"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoCredential", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "IssueUnit", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "发证单位"); migrationBuilder.AlterColumn( name: "IsForever", table: "UserInfoCredential", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "永久证书"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoCredential", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "Img", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "证书正面照片"); migrationBuilder.AlterColumn( name: "EndDate", table: "UserInfoCredential", type: "datetime2", nullable: false, oldClrType: typeof(DateTime), oldType: "datetime2", oldComment: "结束日期"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Code", table: "UserInfoCredential", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "证书编号"); migrationBuilder.AlterColumn( name: "BackImg", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "证书反面照片"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoBankCard", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoBankCard", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserInfoBankCard", type: "nvarchar(11)", maxLength: 11, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldComment: "银行预留手机号"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoBankCard", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Code", table: "UserInfoBankCard", type: "nvarchar(32)", maxLength: 32, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldComment: "银行卡号"); migrationBuilder.AlterColumn( name: "Bank", table: "UserInfoBankCard", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "开户行"); migrationBuilder.AlterColumn( name: "WxmpOpenId", table: "UserInfo", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "微信开放Id"); migrationBuilder.AlterColumn( name: "WorkSeniority", table: "UserInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "工作资历"); migrationBuilder.AlterColumn( name: "WorkExperience", table: "UserInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "工作经验"); migrationBuilder.AlterColumn( name: "Weight", table: "UserInfo", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "体重"); migrationBuilder.AlterColumn( name: "UserAuthId", table: "UserInfo", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "Type", table: "UserInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "用户类型"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Status", table: "UserInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "状态"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Remark", table: "UserInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "备注"); migrationBuilder.AlterColumn( name: "ProvinceId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "常驻省份Id"); migrationBuilder.AlterColumn( name: "PersonalIdentityId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "身份Id"); migrationBuilder.AlterColumn( name: "Level", table: "UserInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "级别"); migrationBuilder.AlterColumn( name: "JobSeekingStatus", table: "UserInfo", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "求职状态"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfo", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "Height", table: "UserInfo", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "身高"); migrationBuilder.AlterColumn( name: "FreeTime", table: "UserInfo", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "空闲时间"); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "企业Id"); migrationBuilder.AlterColumn( name: "EducationalBackgroundId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "学历Id"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "CityId", 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: "UserName", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldComment: "用户名"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserAuth", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "UserAuth", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "RealAccess", table: "UserAuth", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "实名通道"); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserAuth", type: "nvarchar(11)", maxLength: 11, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true, oldComment: "手机号"); migrationBuilder.AlterColumn( name: "Password", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "密码"); migrationBuilder.AlterColumn( name: "Name", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldComment: "姓名"); migrationBuilder.AlterColumn( name: "IsReal", table: "UserAuth", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否实名"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserAuth", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "IsCheckPhoneNumber", table: "UserAuth", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否已校验手机号"); migrationBuilder.AlterColumn( name: "IdentityImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "身份证人像面"); migrationBuilder.AlterColumn( name: "IdentityBackImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "身份证国徽面"); migrationBuilder.AlterColumn( name: "Identity", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "身份证号"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserAuth", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "BankCardImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "银行卡照片"); migrationBuilder.AlterColumn( name: "BankCard", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "银行卡号"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "用户信息Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "任务Id"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoUser", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "SignContractTime", table: "TaskInfoUser", type: "datetime2", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2", oldNullable: true, oldComment: "签约时间"); migrationBuilder.AlterColumn( name: "SignContractStatus", table: "TaskInfoUser", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "签约状态"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoUser", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "HireTime", table: "TaskInfoUser", type: "datetime2", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2", oldNullable: true, oldComment: "录用时间"); migrationBuilder.AlterColumn( name: "HireStatus", table: "TaskInfoUser", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "录用状态"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TypeId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "证书类型Id"); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoCredentialLimit", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "任务Id"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoCredentialLimit", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoCredentialLimit", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoBenefit", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "任务Id"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoBenefit", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoBenefit", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "BenefitId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "福利Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "SettlementCycle", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "结算方式"); migrationBuilder.AlterColumn( name: "ServiceFee", table: "TaskInfo", type: "decimal(18,2)", nullable: false, oldClrType: typeof(decimal), oldType: "decimal(18,2)", oldComment: "服务费"); migrationBuilder.AlterColumn( name: "Name", table: "TaskInfo", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "任务名称"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfo", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "GenderLimit", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "性别要求"); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "TaskInfo", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "企业Id"); migrationBuilder.AlterColumn( name: "EndTime", table: "TaskInfo", type: "datetime2", nullable: false, oldClrType: typeof(DateTime), oldType: "datetime2", oldComment: "任务结束时间"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfo", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "CityId", table: "TaskInfo", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "任务地点所属区域Id"); migrationBuilder.AlterColumn( name: "BillingMethod", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "计费方式"); migrationBuilder.AlterColumn( name: "BeginTime", table: "TaskInfo", type: "datetime2", nullable: false, oldClrType: typeof(DateTime), oldType: "datetime2", oldComment: "任务开始时间"); migrationBuilder.AlterColumn( name: "AgeMinLimit", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "年龄范围最小"); migrationBuilder.AlterColumn( name: "AgeMaxLimit", table: "TaskInfo", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "年龄范围大"); migrationBuilder.AlterColumn( name: "Address", table: "TaskInfo", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "任务地点详细地址"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "RoleResource", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "RoleResource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "RoleResource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "RoleId", table: "RoleResource", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "角色Id"); migrationBuilder.AlterColumn( name: "ResourceId", table: "RoleResource", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "资源Id"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "RoleResource", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "DataPower", table: "RoleResource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "数据权限"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "RoleResource", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "RoleMenu", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "RoleMenu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "RoleMenu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "RoleId", table: "RoleMenu", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "角色Id"); migrationBuilder.AlterColumn( name: "MenuId", table: "RoleMenu", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "菜单Id"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "RoleMenu", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "RoleMenu", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "UserType", table: "Role", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "用户类型"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Role", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "Role", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "Role", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Remark", table: "Role", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "备注"); migrationBuilder.AlterColumn( name: "Name", table: "Role", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "名称"); migrationBuilder.AlterColumn( name: "MinLevel", table: "Role", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "最低级别"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Role", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否禁用"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Role", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "DataPower", table: "Role", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "数据权限"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Role", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "ClientType", table: "Role", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "客户端类型"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Resource", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "Resource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "ServiceName", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "服务名称"); migrationBuilder.AlterColumn( name: "Service", table: "Resource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "服务"); migrationBuilder.AlterColumn( name: "RouteArea", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "路由区域"); migrationBuilder.AlterColumn( name: "Route", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "路由"); migrationBuilder.AlterColumn( name: "ResponseTypeName", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "响应类型名称"); migrationBuilder.AlterColumn( name: "ResponseTypeFullName", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "响应类型全名"); migrationBuilder.AlterColumn( name: "RequestTypeName", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "请求类型名称"); migrationBuilder.AlterColumn( name: "RequestTypeFullName", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "请求类型全名"); migrationBuilder.AlterColumn( name: "Name", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "名称"); migrationBuilder.AlterColumn( name: "Method", table: "Resource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "请求方式"); migrationBuilder.AlterColumn( name: "IsExpired", table: "Resource", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否已过期"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Resource", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "DynamicAssemblyName", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "动态程序集名称"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Resource", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "ControllerSummary", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "控制器摘要"); migrationBuilder.AlterColumn( name: "Controller", table: "Resource", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "控制器"); migrationBuilder.AlterColumn( name: "Code", table: "Resource", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "编号"); migrationBuilder.AlterColumn( name: "ApplicationName", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "应用名称"); migrationBuilder.AlterColumn( name: "AllowAnonymous", table: "Resource", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "忽略权限"); migrationBuilder.AlterColumn( name: "ActionSummary", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "委托摘要"); migrationBuilder.AlterColumn( name: "ActionName", table: "Resource", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "委托名称"); migrationBuilder.AlterColumn( name: "Width", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "列宽(用于按钮/列/元素)"); migrationBuilder.AlterColumn( name: "VisitLevel", table: "Menu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "访问级别"); migrationBuilder.AlterColumn( name: "UserType", table: "Menu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "用户类型"); migrationBuilder.AlterColumn( name: "Url", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "链接地址"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Menu", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "Type", table: "Menu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "类型"); migrationBuilder.AlterColumn( name: "TraceId", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "Menu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Remark", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "备注"); migrationBuilder.AlterColumn( name: "Path", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "菜单路径"); migrationBuilder.AlterColumn( name: "ParentId", table: "Menu", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "上级Id"); migrationBuilder.AlterColumn( name: "Name", table: "Menu", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "名称"); migrationBuilder.AlterColumn( name: "Location", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "位置(用于按钮)"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Menu", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否禁用"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Menu", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "IsCache", table: "Menu", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否缓存"); migrationBuilder.AlterColumn( name: "Icon", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "图标"); migrationBuilder.AlterColumn( name: "Group", table: "Menu", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "分组名称(用于按钮/字段)"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Menu", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Code", table: "Menu", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "编号"); migrationBuilder.AlterColumn( name: "ClientType", table: "Menu", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "客户端类型"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "EnterpriseAuth", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "EnterpriseAuth", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", 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: "IsDeleted", 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: "CreatedUserInfoId", table: "EnterpriseAuth", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, 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: "UpdatedUserInfoId", table: "Enterprise", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "Enterprise", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "Enterprise", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", 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: "RealAccess", table: "Enterprise", type: "int", nullable: true, oldClrType: typeof(int), oldType: "int", 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: "IsDeleted", table: "Enterprise", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", 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: "CreatedUserInfoId", table: "Enterprise", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Contacts", table: "Enterprise", type: "nvarchar(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true, oldComment: "联系人"); 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, 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: "开户支行"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "DictionaryData", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Path", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字典路径"); migrationBuilder.AlterColumn( name: "ParentId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "上级Id"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "DictionaryData", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否禁用"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "DictionaryData", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "Field5", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段5"); migrationBuilder.AlterColumn( name: "Field4", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段4"); migrationBuilder.AlterColumn( name: "Field3", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段3"); migrationBuilder.AlterColumn( name: "Field2", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段2"); migrationBuilder.AlterColumn( name: "Field1", table: "DictionaryData", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段1"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Content", table: "DictionaryData", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "显示内容"); migrationBuilder.AlterColumn( name: "Code", table: "DictionaryData", type: "nvarchar(128)", maxLength: 128, nullable: true, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldNullable: true, oldComment: "编号"); migrationBuilder.AlterColumn( name: "CategoryId", table: "DictionaryData", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "类别Id"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "DictionaryCategory", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "DictionaryCategory", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Remark", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "备注"); migrationBuilder.AlterColumn( name: "Name", table: "DictionaryCategory", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "名称"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "DictionaryCategory", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "FieldNames", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "字段名(逗号隔开)"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "DictionaryCategory", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.AlterColumn( name: "Code", table: "DictionaryCategory", type: "nvarchar(128)", maxLength: 128, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldComment: "编号"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Department", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "最后更新操作人"); migrationBuilder.AlterColumn( name: "TraceId", table: "Department", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "跟踪Id"); migrationBuilder.AlterColumn( name: "Sort", table: "Department", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldComment: "排序"); migrationBuilder.AlterColumn( name: "Remark", table: "Department", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "备注"); migrationBuilder.AlterColumn( name: "Path", table: "Department", type: "nvarchar(max)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true, oldComment: "部门路径"); migrationBuilder.AlterColumn( name: "ParentId", table: "Department", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "上级Id"); migrationBuilder.AlterColumn( name: "Name", table: "Department", type: "nvarchar(max)", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)", oldComment: "名称"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Department", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否禁用"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Department", type: "bit", nullable: false, oldClrType: typeof(bool), oldType: "bit", oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "Department", type: "uniqueidentifier", nullable: false, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldComment: "企业Id"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Department", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true, oldComment: "创建操作人"); migrationBuilder.CreateIndex( name: "IX_TaskInfoBenefit_TaskInfoId", table: "TaskInfoBenefit", column: "TaskInfoId"); migrationBuilder.AddForeignKey( name: "FK_TaskInfoBenefit_DictionaryData_BenefitId", table: "TaskInfoBenefit", column: "BenefitId", principalTable: "DictionaryData", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_TaskInfoBenefit_TaskInfo_TaskInfoId", table: "TaskInfoBenefit", column: "TaskInfoId", principalTable: "TaskInfo", principalColumn: "Id", onDelete: ReferentialAction.Restrict); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_TaskInfoBenefit_DictionaryData_BenefitId", table: "TaskInfoBenefit"); migrationBuilder.DropForeignKey( name: "FK_TaskInfoBenefit_TaskInfo_TaskInfoId", table: "TaskInfoBenefit"); migrationBuilder.DropIndex( name: "IX_TaskInfoBenefit_TaskInfoId", table: "TaskInfoBenefit"); migrationBuilder.AlterTable( name: "UserInfoRole", comment: "用户信息角色"); migrationBuilder.AlterTable( name: "UserInfoPhoto", comment: "用户信息生活照"); migrationBuilder.AlterTable( name: "UserInfoExpectJob", comment: "用户信息期望岗位"); migrationBuilder.AlterTable( name: "UserInfoDepartment", comment: "用户信息部门"); migrationBuilder.AlterTable( name: "UserInfoCredential", comment: "用户信息资格证书"); migrationBuilder.AlterTable( name: "UserInfoBankCard", comment: "用户银行卡信息"); migrationBuilder.AlterTable( name: "UserInfo", comment: "用户信息"); migrationBuilder.AlterTable( name: "UserAuth", comment: "用户"); migrationBuilder.AlterTable( name: "TaskInfoUser", comment: "任务用户信息"); migrationBuilder.AlterTable( name: "TaskInfoBenefit", comment: "任务福利"); migrationBuilder.AlterTable( name: "TaskInfo", comment: "任务信息"); migrationBuilder.AlterTable( name: "RoleResource", comment: "角色资源"); migrationBuilder.AlterTable( name: "RoleMenu", comment: "角色菜单"); migrationBuilder.AlterTable( name: "Role", comment: "角色"); migrationBuilder.AlterTable( name: "Resource", comment: "资源"); migrationBuilder.AlterTable( name: "Menu", comment: "菜单"); migrationBuilder.AlterTable( name: "EnterpriseAuth", comment: "企业认证"); migrationBuilder.AlterTable( name: "Enterprise", comment: "企业"); migrationBuilder.AlterTable( name: "DictionaryData", comment: "字典数据"); migrationBuilder.AlterTable( name: "DictionaryCategory", comment: "字典类别"); migrationBuilder.AlterTable( name: "Department", comment: "部门"); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoRole", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoRole", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "RoleId", table: "UserInfoRole", type: "uniqueidentifier", nullable: false, comment: "角色Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoRole", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoRole", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoPhoto", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoPhoto", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoPhoto", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "Img", table: "UserInfoPhoto", type: "nvarchar(max)", nullable: true, comment: "照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoPhoto", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoExpectJob", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoExpectJob", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "PersonalIdentityId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: false, comment: "期望岗位Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoExpectJob", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoExpectJob", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoDepartment", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoDepartment", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoDepartment", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "DepartmentId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: false, comment: "部门Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoDepartment", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TypeId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, comment: "证书类型Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "StartDate", table: "UserInfoCredential", type: "datetime2", nullable: false, comment: "开始日期", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoCredential", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IssueUnit", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, comment: "发证单位", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "IsForever", table: "UserInfoCredential", type: "bit", nullable: false, comment: "永久证书", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoCredential", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "Img", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, comment: "证书正面照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "EndDate", table: "UserInfoCredential", type: "datetime2", nullable: false, comment: "结束日期", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoCredential", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Code", table: "UserInfoCredential", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "证书编号", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "BackImg", table: "UserInfoCredential", type: "nvarchar(max)", nullable: true, comment: "证书反面照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfoBankCard", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfoBankCard", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserInfoBankCard", type: "nvarchar(11)", maxLength: 11, nullable: false, comment: "银行预留手机号", oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfoBankCard", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfoBankCard", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Code", table: "UserInfoBankCard", type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "银行卡号", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32); migrationBuilder.AlterColumn( name: "Bank", table: "UserInfoBankCard", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "开户行", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "WxmpOpenId", table: "UserInfo", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "微信开放Id", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "WorkSeniority", table: "UserInfo", type: "nvarchar(max)", nullable: true, comment: "工作资历", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "WorkExperience", table: "UserInfo", type: "nvarchar(max)", nullable: true, comment: "工作经验", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Weight", table: "UserInfo", type: "int", nullable: true, comment: "体重", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "UserAuthId", table: "UserInfo", type: "uniqueidentifier", nullable: false, comment: "用户Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Type", table: "UserInfo", type: "int", nullable: false, comment: "用户类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "TraceId", table: "UserInfo", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Status", table: "UserInfo", type: "int", nullable: false, comment: "状态", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Sort", table: "UserInfo", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Remark", table: "UserInfo", type: "nvarchar(max)", nullable: true, comment: "备注", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "ProvinceId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "常驻省份Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "PersonalIdentityId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "身份Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Level", table: "UserInfo", type: "int", nullable: false, comment: "级别", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "JobSeekingStatus", table: "UserInfo", type: "int", nullable: true, comment: "求职状态", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserInfo", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "Height", table: "UserInfo", type: "int", nullable: true, comment: "身高", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "FreeTime", table: "UserInfo", type: "int", nullable: true, comment: "空闲时间", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "企业Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "EducationalBackgroundId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "学历Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserInfo", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "CityId", 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: "UserName", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "用户名", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "UserAuth", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "UserAuth", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "RealAccess", table: "UserAuth", type: "int", nullable: true, comment: "实名通道", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "PhoneNumber", table: "UserAuth", type: "nvarchar(11)", maxLength: 11, nullable: true, comment: "手机号", oldClrType: typeof(string), oldType: "nvarchar(11)", oldMaxLength: 11, oldNullable: true); migrationBuilder.AlterColumn( name: "Password", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "密码", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "姓名", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32); migrationBuilder.AlterColumn( name: "IsReal", table: "UserAuth", type: "bit", nullable: false, comment: "是否实名", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "UserAuth", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsCheckPhoneNumber", table: "UserAuth", type: "bit", nullable: false, comment: "是否已校验手机号", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IdentityImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "身份证人像面", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "IdentityBackImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "身份证国徽面", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Identity", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "身份证号", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "UserAuth", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "BankCardImg", table: "UserAuth", type: "nvarchar(max)", nullable: true, comment: "银行卡照片", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "BankCard", table: "UserAuth", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "银行卡号", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "UserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, comment: "用户信息Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, comment: "任务Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoUser", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "SignContractTime", table: "TaskInfoUser", type: "datetime2", nullable: true, comment: "签约时间", oldClrType: typeof(DateTime), oldType: "datetime2", oldNullable: true); migrationBuilder.AlterColumn( name: "SignContractStatus", table: "TaskInfoUser", type: "int", nullable: true, comment: "签约状态", oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoUser", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "HireTime", table: "TaskInfoUser", type: "datetime2", nullable: true, comment: "录用时间", oldClrType: typeof(DateTime), oldType: "datetime2", oldNullable: true); migrationBuilder.AlterColumn( name: "HireStatus", table: "TaskInfoUser", type: "int", nullable: false, comment: "录用状态", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TypeId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, comment: "证书类型Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoCredentialLimit", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: false, comment: "任务Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoCredentialLimit", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoCredentialLimit", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoCredentialLimit", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfoBenefit", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "TaskInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: false, comment: "任务Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfoBenefit", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfoBenefit", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "BenefitId", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: false, comment: "福利Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AddColumn( name: "BenefitId1", table: "TaskInfoBenefit", type: "uniqueidentifier", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "TaskInfo", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "TaskInfo", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "TaskInfo", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "SettlementCycle", table: "TaskInfo", type: "int", nullable: false, comment: "结算方式", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "ServiceFee", table: "TaskInfo", type: "decimal(18,2)", nullable: false, comment: "服务费", oldClrType: typeof(decimal), oldType: "decimal(18,2)"); migrationBuilder.AlterColumn( name: "Name", table: "TaskInfo", type: "nvarchar(max)", nullable: false, comment: "任务名称", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "TaskInfo", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "GenderLimit", table: "TaskInfo", type: "int", nullable: false, comment: "性别要求", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "TaskInfo", type: "uniqueidentifier", nullable: false, comment: "企业Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "EndTime", table: "TaskInfo", type: "datetime2", nullable: false, comment: "任务结束时间", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "TaskInfo", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "CityId", table: "TaskInfo", type: "uniqueidentifier", nullable: false, comment: "任务地点所属区域Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "BillingMethod", table: "TaskInfo", type: "int", nullable: false, comment: "计费方式", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "BeginTime", table: "TaskInfo", type: "datetime2", nullable: false, comment: "任务开始时间", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn( name: "AgeMinLimit", table: "TaskInfo", type: "int", nullable: false, comment: "年龄范围最小", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "AgeMaxLimit", table: "TaskInfo", type: "int", nullable: false, comment: "年龄范围大", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Address", table: "TaskInfo", type: "nvarchar(max)", nullable: true, comment: "任务地点详细地址", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "RoleResource", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "RoleResource", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "RoleResource", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "RoleId", table: "RoleResource", type: "uniqueidentifier", nullable: false, comment: "角色Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "ResourceId", table: "RoleResource", type: "uniqueidentifier", nullable: false, comment: "资源Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "RoleResource", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "DataPower", table: "RoleResource", type: "int", nullable: false, comment: "数据权限", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "RoleResource", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "RoleMenu", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "RoleMenu", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "RoleMenu", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "RoleId", table: "RoleMenu", type: "uniqueidentifier", nullable: false, comment: "角色Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "MenuId", table: "RoleMenu", type: "uniqueidentifier", nullable: false, comment: "菜单Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "RoleMenu", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "RoleMenu", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "UserType", table: "Role", type: "int", nullable: false, comment: "用户类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Role", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "Role", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "Role", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Remark", table: "Role", type: "nvarchar(max)", nullable: true, comment: "备注", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "Role", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "MinLevel", table: "Role", type: "int", nullable: false, comment: "最低级别", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Role", type: "bit", nullable: false, comment: "是否禁用", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Role", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "DataPower", table: "Role", type: "int", nullable: false, comment: "数据权限", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Role", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "ClientType", table: "Role", type: "int", nullable: false, comment: "客户端类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Resource", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "Resource", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "ServiceName", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "服务名称", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Service", table: "Resource", type: "int", nullable: false, comment: "服务", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "RouteArea", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "路由区域", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Route", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "路由", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "ResponseTypeName", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "响应类型名称", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "ResponseTypeFullName", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "响应类型全名", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "RequestTypeName", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "请求类型名称", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "RequestTypeFullName", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "请求类型全名", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "Name", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "名称", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "Method", table: "Resource", type: "int", nullable: false, comment: "请求方式", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "IsExpired", table: "Resource", type: "bit", nullable: false, comment: "是否已过期", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Resource", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "DynamicAssemblyName", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "动态程序集名称", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Resource", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "ControllerSummary", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "控制器摘要", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Controller", table: "Resource", type: "int", nullable: false, comment: "控制器", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Code", table: "Resource", type: "nvarchar(max)", nullable: false, comment: "编号", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "ApplicationName", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "应用名称", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "AllowAnonymous", table: "Resource", type: "bit", nullable: false, comment: "忽略权限", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "ActionSummary", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "委托摘要", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "ActionName", table: "Resource", type: "nvarchar(max)", nullable: true, comment: "委托名称", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Width", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "列宽(用于按钮/列/元素)", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "VisitLevel", table: "Menu", type: "int", nullable: false, comment: "访问级别", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "UserType", table: "Menu", type: "int", nullable: false, comment: "用户类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Url", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "链接地址", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Menu", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Type", table: "Menu", type: "int", nullable: false, comment: "类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "TraceId", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "Menu", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Remark", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "备注", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Path", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "菜单路径", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "ParentId", table: "Menu", type: "uniqueidentifier", nullable: true, comment: "上级Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "Menu", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "Location", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "位置(用于按钮)", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Menu", type: "bit", nullable: false, comment: "是否禁用", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Menu", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsCache", table: "Menu", type: "bit", nullable: false, comment: "是否缓存", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "Icon", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "图标", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Group", table: "Menu", type: "nvarchar(max)", nullable: true, comment: "分组名称(用于按钮/字段)", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Menu", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Code", table: "Menu", type: "nvarchar(max)", nullable: false, comment: "编号", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "ClientType", table: "Menu", type: "int", nullable: false, comment: "客户端类型", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "EnterpriseAuth", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "EnterpriseAuth", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "EnterpriseAuth", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); 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: "IsDeleted", 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: "CreatedUserInfoId", table: "EnterpriseAuth", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); 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: "UpdatedUserInfoId", table: "Enterprise", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "Enterprise", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); 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: "RealAccess", table: "Enterprise", type: "int", nullable: true, comment: "实名通道", oldClrType: typeof(int), oldType: "int", 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: "IsDeleted", table: "Enterprise", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); 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: "CreatedUserInfoId", table: "Enterprise", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Contacts", table: "Enterprise", type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "联系人", oldClrType: typeof(string), oldType: "nvarchar(32)", oldMaxLength: 32, oldNullable: true); 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); migrationBuilder.AlterColumn( name: "BankBranchName", table: "Enterprise", type: "nvarchar(max)", nullable: true, comment: "开户支行", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "DictionaryData", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Path", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字典路径", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "ParentId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, comment: "上级Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDisabled", table: "DictionaryData", type: "bit", nullable: false, comment: "是否禁用", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "DictionaryData", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "Field5", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字段5", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Field4", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字段4", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Field3", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字段3", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Field2", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字段2", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Field1", table: "DictionaryData", type: "nvarchar(max)", nullable: true, comment: "字段1", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "DictionaryData", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Content", table: "DictionaryData", type: "nvarchar(max)", nullable: false, comment: "显示内容", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "Code", table: "DictionaryData", type: "nvarchar(128)", maxLength: 128, nullable: true, comment: "编号", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128, oldNullable: true); migrationBuilder.AlterColumn( name: "CategoryId", table: "DictionaryData", type: "uniqueidentifier", nullable: false, comment: "类别Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "DictionaryCategory", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "DictionaryCategory", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Remark", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, comment: "备注", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "DictionaryCategory", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "IsDeleted", table: "DictionaryCategory", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "FieldNames", table: "DictionaryCategory", type: "nvarchar(max)", nullable: true, comment: "字段名(逗号隔开)", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "DictionaryCategory", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Code", table: "DictionaryCategory", type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "编号", oldClrType: typeof(string), oldType: "nvarchar(128)", oldMaxLength: 128); migrationBuilder.AlterColumn( name: "UpdatedUserInfoId", table: "Department", type: "uniqueidentifier", nullable: true, comment: "最后更新操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "TraceId", table: "Department", type: "nvarchar(max)", nullable: true, comment: "跟踪Id", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Sort", table: "Department", type: "int", nullable: false, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "Remark", table: "Department", type: "nvarchar(max)", nullable: true, comment: "备注", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "Path", table: "Department", type: "nvarchar(max)", nullable: true, comment: "部门路径", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn( name: "ParentId", table: "Department", type: "uniqueidentifier", nullable: true, comment: "上级Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AlterColumn( name: "Name", table: "Department", type: "nvarchar(max)", nullable: false, comment: "名称", oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "Department", type: "bit", nullable: false, comment: "是否禁用", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "Department", type: "bit", nullable: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn( name: "EnterpriseId", table: "Department", type: "uniqueidentifier", nullable: false, comment: "企业Id", oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AlterColumn( name: "CreatedUserInfoId", table: "Department", type: "uniqueidentifier", nullable: true, comment: "创建操作人", oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.CreateIndex( name: "IX_TaskInfoBenefit_BenefitId1", table: "TaskInfoBenefit", column: "BenefitId1"); migrationBuilder.AddForeignKey( name: "FK_TaskInfoBenefit_DictionaryData_BenefitId1", table: "TaskInfoBenefit", column: "BenefitId1", principalTable: "DictionaryData", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_TaskInfoBenefit_TaskInfo_BenefitId", table: "TaskInfoBenefit", column: "BenefitId", principalTable: "TaskInfo", principalColumn: "Id", onDelete: ReferentialAction.Restrict); } } }