using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateUser0801 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "DictionaryCategory", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), Code = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "编号"), Name = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称"), FieldNames = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段名（逗号隔开）"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_DictionaryCategory", x => x.Id); }, comment: "字典类别"); migrationBuilder.CreateTable( name: "FileStore", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), Access = table.Column(type: "int", nullable: false, comment: "通道"), AbsolutePath = table.Column(type: "nvarchar(max)", nullable: false, comment: "绝对路径"), RelativePath = table.Column(type: "nvarchar(max)", nullable: true, comment: "相对路径"), Name = table.Column(type: "nvarchar(max)", nullable: false, comment: "名称"), Extension = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "扩展名"), ContentType = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "内容类型"), FileType = table.Column(type: "int", nullable: false, comment: "文件类型"), Length = table.Column(type: "bigint", nullable: false, comment: "文件大小（字节）"), Hash = table.Column(type: "nvarchar(max)", nullable: false, comment: "哈希"), ImageWidth = table.Column(type: "int", nullable: true, comment: "宽度（像素）"), ImageHeight = table.Column(type: "int", nullable: true, comment: "高度（像素）"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_FileStore", x => x.Id); }, comment: "文件存储"); migrationBuilder.CreateTable( name: "Menu", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), ParentId = table.Column(type: "uniqueidentifier", nullable: true, comment: "上级Id"), Path = table.Column(type: "nvarchar(max)", nullable: true, comment: "菜单路径"), Code = table.Column(type: "nvarchar(max)", nullable: false, comment: "编号"), Name = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称"), Type = table.Column(type: "int", nullable: false, comment: "类型"), VisitLevel = table.Column(type: "int", nullable: false, comment: "访问级别"), Icon = table.Column(type: "nvarchar(max)", nullable: true, comment: "图标"), Url = table.Column(type: "nvarchar(max)", nullable: true, comment: "链接地址"), Group = table.Column(type: "nvarchar(max)", nullable: true, comment: "分组名称（用于按钮/字段）"), Location = table.Column(type: "nvarchar(max)", nullable: true, comment: "位置（用于按钮）"), Width = table.Column(type: "nvarchar(max)", nullable: true, comment: "列宽（用于按钮/列/元素）"), IsDisabled = table.Column(type: "bit", nullable: false, comment: "是否禁用"), IsHidden = table.Column(type: "bit", nullable: false, comment: "是否隐藏"), IsCache = table.Column(type: "bit", nullable: false, comment: "是否缓存"), Remark = table.Column(type: "nvarchar(max)", nullable: true, comment: "备注"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_Menu", x => x.Id); table.ForeignKey( name: "FK_Menu_Menu_ParentId", column: x => x.ParentId, principalTable: "Menu", principalColumn: "Id"); }, comment: "菜单"); migrationBuilder.CreateTable( name: "Resource", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), Service = table.Column(type: "nvarchar(max)", nullable: false), Code = table.Column(type: "nvarchar(max)", nullable: false), Name = table.Column(type: "nvarchar(max)", nullable: false), Method = table.Column(type: "int", nullable: false), Route = table.Column(type: "nvarchar(max)", nullable: false), RequestTypeName = table.Column(type: "nvarchar(max)", nullable: false), ResponseTypeName = table.Column(type: "nvarchar(max)", nullable: false), IsExpired = table.Column(type: "bit", nullable: false), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_Resource", x => x.Id); }); migrationBuilder.CreateTable( name: "Role", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), Name = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "名称"), UserType = table.Column(type: "int", nullable: false, comment: "用户类型"), ClientType = table.Column(type: "int", nullable: false, comment: "客户端类型"), MinLevel = table.Column(type: "int", nullable: false, comment: "最低级别"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_Role", x => x.Id); }, comment: "角色"); migrationBuilder.CreateTable( name: "DictionaryData", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), CategoryId = table.Column(type: "uniqueidentifier", nullable: false, comment: "类别Id"), ParentId = table.Column(type: "uniqueidentifier", nullable: true, comment: "上级Id"), Path = table.Column(type: "nvarchar(max)", nullable: true, comment: "字典路径"), Code = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: true, comment: "编号"), Content = table.Column(type: "nvarchar(max)", nullable: false, comment: "显示内容"), Field1 = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段1"), Field2 = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段2"), Field3 = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段3"), Field4 = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段4"), Field5 = table.Column(type: "nvarchar(max)", nullable: true, comment: "字段5"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_DictionaryData", x => x.Id); table.ForeignKey( name: "FK_DictionaryData_DictionaryCategory_CategoryId", column: x => x.CategoryId, principalTable: "DictionaryCategory", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_DictionaryData_DictionaryData_ParentId", column: x => x.ParentId, principalTable: "DictionaryData", principalColumn: "Id"); }, comment: "字典数据"); migrationBuilder.CreateTable( name: "FileVirtualPath", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), StoreId = table.Column(type: "uniqueidentifier", nullable: false, comment: "文件存储Id"), Name = table.Column(type: "nvarchar(max)", nullable: false, comment: "名称"), VirtualPath = table.Column(type: "nvarchar(max)", nullable: false, comment: "虚拟路径"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_FileVirtualPath", x => x.Id); table.ForeignKey( name: "FK_FileVirtualPath_FileStore_StoreId", column: x => x.StoreId, principalTable: "FileStore", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "文件虚拟路径"); migrationBuilder.CreateTable( name: "RoleMenu", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), RoleId = table.Column(type: "uniqueidentifier", nullable: false, comment: "角色Id"), MenuId = table.Column(type: "uniqueidentifier", nullable: false, comment: "菜单Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_RoleMenu", x => x.Id); table.ForeignKey( name: "FK_RoleMenu_Menu_MenuId", column: x => x.MenuId, principalTable: "Menu", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_RoleMenu_Role_RoleId", column: x => x.RoleId, principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "角色菜单"); migrationBuilder.CreateTable( name: "RoleResource", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), RoleId = table.Column(type: "uniqueidentifier", nullable: false), MenuId = table.Column(type: "uniqueidentifier", nullable: false), DataPower = table.Column(type: "int", nullable: true), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_RoleResource", x => x.Id); table.ForeignKey( name: "FK_RoleResource_Menu_MenuId", column: x => x.MenuId, principalTable: "Menu", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_RoleResource_Role_RoleId", column: x => x.RoleId, principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Enterprise", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), EnterpriseRealMethod = table.Column(type: "int", nullable: true, comment: "企业认证方式"), EnterpriseName = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "企业全称"), SocietyCreditCode = table.Column(type: "nvarchar(18)", maxLength: 18, nullable: false, comment: "统一社会信用代码"), LicenseImageId = table.Column(type: "uniqueidentifier", nullable: true, comment: "营业执照照片Id"), LegalPerson = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人姓名"), PersonalRealMethod = table.Column(type: "int", nullable: true, comment: "法人或经办人实名方式"), Name = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人或经办人姓名"), Identity = table.Column(type: "nvarchar(18)", maxLength: 18, nullable: true, comment: "法人或经办人身份证号"), IdentityImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "法人或经办人身份证人像面Id"), IdentityBackImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "法人或经办人身份证国徽面Id"), BankCard = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "法人或经办人银行卡号"), BankCardImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "法人或经办人银行卡照片Id"), PhoneNumber = table.Column(type: "nvarchar(11)", maxLength: 11, nullable: true, comment: "法人或经办人手机号"), Proxy = table.Column(type: "bit", nullable: true, comment: "是否委托经办人"), ProxyPowerAttorneyUrl = table.Column(type: "nvarchar(max)", nullable: true, comment: "企业授权书"), RealAccess = table.Column(type: "int", nullable: true, comment: "实名通道"), IsReal = table.Column(type: "bit", nullable: false, comment: "是否实名"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_Enterprise", x => x.Id); table.ForeignKey( name: "FK_Enterprise_FileVirtualPath_IdentityBackImgId", column: x => x.IdentityBackImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_Enterprise_FileVirtualPath_IdentityImgId", column: x => x.IdentityImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_Enterprise_FileVirtualPath_LicenseImageId", column: x => x.LicenseImageId, principalTable: "FileVirtualPath", principalColumn: "Id"); }, comment: "企业"); migrationBuilder.CreateTable( name: "UserAuth", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), AvatarId = table.Column(type: "uniqueidentifier", nullable: true, comment: "头像Id"), Name = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "姓名"), UserName = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "用户名"), PhoneNumber = table.Column(type: "nvarchar(11)", maxLength: 11, nullable: true, comment: "手机号"), IsCheckPhoneNumber = table.Column(type: "bit", nullable: false, comment: "是否已校验手机号"), Password = table.Column(type: "nvarchar(max)", nullable: true, comment: "密码"), Identity = table.Column(type: "nvarchar(max)", nullable: true, comment: "身份证号"), IdentityImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "身份证人像面Id"), IdentityBackImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "身份证国徽面Id"), BankCard = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "银行卡号"), BankCardImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "银行卡照片Id"), RealAccess = table.Column(type: "int", nullable: true, comment: "实名通道"), IsReal = table.Column(type: "bit", nullable: false, comment: "是否实名"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserAuth", x => x.Id); table.ForeignKey( name: "FK_UserAuth_FileVirtualPath_AvatarId", column: x => x.AvatarId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_UserAuth_FileVirtualPath_BankCardImgId", column: x => x.BankCardImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_UserAuth_FileVirtualPath_IdentityBackImgId", column: x => x.IdentityBackImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_UserAuth_FileVirtualPath_IdentityImgId", column: x => x.IdentityImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); }, comment: "用户"); migrationBuilder.CreateTable( name: "Department", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), ParentId = table.Column(type: "uniqueidentifier", nullable: true, comment: "上级Id"), Path = table.Column(type: "nvarchar(max)", nullable: true, comment: "部门路径"), EnterpriseId = table.Column(type: "uniqueidentifier", nullable: false, comment: "企业Id"), Name = table.Column(type: "nvarchar(max)", nullable: false, comment: "名称"), Remark = table.Column(type: "nvarchar(max)", nullable: true, comment: "备注"), IsDisabled = table.Column(type: "bit", nullable: false, comment: "是否禁用"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_Department", x => x.Id); table.ForeignKey( name: "FK_Department_Department_ParentId", column: x => x.ParentId, principalTable: "Department", principalColumn: "Id"); table.ForeignKey( name: "FK_Department_Enterprise_EnterpriseId", column: x => x.EnterpriseId, principalTable: "Enterprise", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "部门"); migrationBuilder.CreateTable( name: "TaskInfo", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), EnterpriseId = table.Column(type: "uniqueidentifier", nullable: false, comment: "企业Id"), Name = table.Column(type: "nvarchar(max)", nullable: false, comment: "任务名称"), BillingMethod = table.Column(type: "int", nullable: false, comment: "计费方式"), ServiceFee = table.Column(type: "decimal(18,2)", nullable: false, comment: "服务费"), SettlementCycle = table.Column(type: "int", nullable: false, comment: "结算方式"), AgeMinLimit = table.Column(type: "int", nullable: false, comment: "年龄范围最小"), AgeMaxLimit = table.Column(type: "int", nullable: false, comment: "年龄范围大"), GenderLimit = table.Column(type: "int", nullable: false, comment: "性别要求"), CityId = table.Column(type: "uniqueidentifier", nullable: false, comment: "任务地点所属区域Id"), Address = table.Column(type: "nvarchar(max)", nullable: true, comment: "任务地点详细地址"), BeginTime = table.Column(type: "datetime2", nullable: false, comment: "任务开始时间"), EndTime = table.Column(type: "datetime2", nullable: false, comment: "任务结束时间"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_TaskInfo", x => x.Id); table.ForeignKey( name: "FK_TaskInfo_DictionaryData_CityId", column: x => x.CityId, principalTable: "DictionaryData", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_TaskInfo_Enterprise_EnterpriseId", column: x => x.EnterpriseId, principalTable: "Enterprise", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "任务信息"); migrationBuilder.CreateTable( name: "UserInfo", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserAuthId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户Id"), Type = table.Column(type: "int", nullable: false, comment: "用户类型"), EnterpriseId = table.Column(type: "uniqueidentifier", nullable: true, comment: "企业Id"), WxmpOpenId = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "微信开放Id"), Level = table.Column(type: "int", nullable: false, comment: "级别"), PersonalIdentityId = table.Column(type: "uniqueidentifier", nullable: true, comment: "身份Id"), EducationalBackgroundId = table.Column(type: "uniqueidentifier", nullable: true, comment: "学历Id"), CityId = table.Column(type: "uniqueidentifier", nullable: true, comment: "常驻城市Id"), FreeTime = table.Column(type: "int", nullable: true, comment: "空闲时间"), JobSeekingStatus = table.Column(type: "int", nullable: true, comment: "求职状态"), WorkSeniority = table.Column(type: "nvarchar(max)", nullable: true, comment: "工作资历"), WorkExperience = table.Column(type: "nvarchar(max)", nullable: true, comment: "工作经验"), Height = table.Column(type: "int", nullable: true, comment: "身高"), Weight = table.Column(type: "int", nullable: true, comment: "体重"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfo", x => x.Id); table.ForeignKey( name: "FK_UserInfo_DictionaryData_CityId", column: x => x.CityId, principalTable: "DictionaryData", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfo_DictionaryData_EducationalBackgroundId", column: x => x.EducationalBackgroundId, principalTable: "DictionaryData", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfo_DictionaryData_PersonalIdentityId", column: x => x.PersonalIdentityId, principalTable: "DictionaryData", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfo_Enterprise_EnterpriseId", column: x => x.EnterpriseId, principalTable: "Enterprise", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfo_UserAuth_UserAuthId", column: x => x.UserAuthId, principalTable: "UserAuth", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息"); migrationBuilder.CreateTable( name: "TaskInfoBenefit", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), TaskInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "任务Id"), BenefitId = table.Column(type: "uniqueidentifier", nullable: false, comment: "福利Id"), BenefitId1 = table.Column(type: "uniqueidentifier", nullable: false), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_TaskInfoBenefit", x => x.Id); table.ForeignKey( name: "FK_TaskInfoBenefit_DictionaryData_BenefitId1", column: x => x.BenefitId1, principalTable: "DictionaryData", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_TaskInfoBenefit_TaskInfo_BenefitId", column: x => x.BenefitId, principalTable: "TaskInfo", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }, comment: "任务福利"); migrationBuilder.CreateTable( name: "TaskInfoCredentialLimit", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), TaskInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "任务Id"), TypeId = table.Column(type: "uniqueidentifier", nullable: true, comment: "证书类型Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_TaskInfoCredentialLimit", x => x.Id); table.ForeignKey( name: "FK_TaskInfoCredentialLimit_DictionaryData_TypeId", column: x => x.TypeId, principalTable: "DictionaryData", principalColumn: "Id"); table.ForeignKey( name: "FK_TaskInfoCredentialLimit_TaskInfo_TaskInfoId", column: x => x.TaskInfoId, principalTable: "TaskInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "TaskInfoUser", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), TaskInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "任务Id"), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), HireStatus = table.Column(type: "int", nullable: false, comment: "录用状态"), HireTime = table.Column(type: "datetime2", nullable: true, comment: "录用时间"), SignContractStatus = table.Column(type: "int", nullable: true, comment: "签约状态"), SignContractTime = table.Column(type: "datetime2", nullable: true, comment: "签约时间"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_TaskInfoUser", x => x.Id); table.ForeignKey( name: "FK_TaskInfoUser_TaskInfo_TaskInfoId", column: x => x.TaskInfoId, principalTable: "TaskInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_TaskInfoUser_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "任务用户信息"); migrationBuilder.CreateTable( name: "UserInfoBankCard", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), Code = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "银行卡号"), Bank = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "开户行"), PhoneNumber = table.Column(type: "nvarchar(11)", maxLength: 11, nullable: false, comment: "银行预留手机号"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoBankCard", x => x.Id); table.ForeignKey( name: "FK_UserInfoBankCard_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户银行卡信息"); migrationBuilder.CreateTable( name: "UserInfoCredential", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), TypeId = table.Column(type: "uniqueidentifier", nullable: true, comment: "证书类型Id"), Code = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "证书编号"), IsForever = table.Column(type: "bit", nullable: false, comment: "永久证书"), StartDate = table.Column(type: "datetime2", nullable: false, comment: "开始日期"), EndDate = table.Column(type: "datetime2", nullable: false, comment: "结束日期"), IssueUnit = table.Column(type: "nvarchar(max)", nullable: true, comment: "发证单位"), ImgId = table.Column(type: "uniqueidentifier", nullable: false, comment: "证书正面照片Id"), BackImgId = table.Column(type: "uniqueidentifier", nullable: true, comment: "证书反面照片Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoCredential", x => x.Id); table.ForeignKey( name: "FK_UserInfoCredential_DictionaryData_TypeId", column: x => x.TypeId, principalTable: "DictionaryData", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfoCredential_FileVirtualPath_BackImgId", column: x => x.BackImgId, principalTable: "FileVirtualPath", principalColumn: "Id"); table.ForeignKey( name: "FK_UserInfoCredential_FileVirtualPath_ImgId", column: x => x.ImgId, principalTable: "FileVirtualPath", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserInfoCredential_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息资格证书"); migrationBuilder.CreateTable( name: "UserInfoDepartment", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), DepartmentId = table.Column(type: "uniqueidentifier", nullable: false, comment: "部门Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoDepartment", x => x.Id); table.ForeignKey( name: "FK_UserInfoDepartment_Department_DepartmentId", column: x => x.DepartmentId, principalTable: "Department", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserInfoDepartment_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息部门"); migrationBuilder.CreateTable( name: "UserInfoExpectJob", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), PersonalIdentityId = table.Column(type: "uniqueidentifier", nullable: false, comment: "期望岗位Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoExpectJob", x => x.Id); table.ForeignKey( name: "FK_UserInfoExpectJob_DictionaryData_PersonalIdentityId", column: x => x.PersonalIdentityId, principalTable: "DictionaryData", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserInfoExpectJob_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息期望岗位"); migrationBuilder.CreateTable( name: "UserInfoPhoto", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), ImgId = table.Column(type: "uniqueidentifier", nullable: false, comment: "照片Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoPhoto", x => x.Id); table.ForeignKey( name: "FK_UserInfoPhoto_FileVirtualPath_ImgId", column: x => x.ImgId, principalTable: "FileVirtualPath", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserInfoPhoto_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息生活照"); migrationBuilder.CreateTable( name: "UserInfoRole", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), UserInfoId = table.Column(type: "uniqueidentifier", nullable: false, comment: "用户信息Id"), RoleId = table.Column(type: "uniqueidentifier", nullable: false, comment: "角色Id"), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false, comment: "排序"), TraceId = table.Column(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"), CreatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "创建操作人"), UpdatedUserInfoId = table.Column(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "是否删除") }, constraints: table => { table.PrimaryKey("PK_UserInfoRole", x => x.Id); table.ForeignKey( name: "FK_UserInfoRole_Role_RoleId", column: x => x.RoleId, principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserInfoRole_UserInfo_UserInfoId", column: x => x.UserInfoId, principalTable: "UserInfo", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "用户信息角色"); migrationBuilder.InsertData( table: "UserAuth", columns: new[] { "Id", "AvatarId", "BankCard", "BankCardImgId", "CreatedTime", "CreatedUserInfoId", "Identity", "IdentityBackImgId", "IdentityImgId", "IsCheckPhoneNumber", "IsDeleted", "IsReal", "Name", "Password", "PhoneNumber", "RealAccess", "Sort", "TraceId", "UpdatedTime", "UpdatedUserInfoId", "UserName" }, values: new object[] { new Guid("11111111-1111-1111-1111-111111111111"), null, null, null, new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, false, false, "管理员", null, null, null, 0, null, null, null, "admin" }); migrationBuilder.InsertData( table: "UserInfo", columns: new[] { "Id", "CityId", "CreatedTime", "CreatedUserInfoId", "EducationalBackgroundId", "EnterpriseId", "FreeTime", "Height", "IsDeleted", "JobSeekingStatus", "Level", "PersonalIdentityId", "Sort", "TraceId", "Type", "UpdatedTime", "UpdatedUserInfoId", "UserAuthId", "Weight", "WorkExperience", "WorkSeniority", "WxmpOpenId" }, values: new object[] { new Guid("11111111-1111-1111-1111-111111111112"), null, new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, null, false, null, 999, null, 0, null, 100, null, null, new Guid("11111111-1111-1111-1111-111111111111"), null, null, null, null }); migrationBuilder.CreateIndex( name: "IX_Department_EnterpriseId", table: "Department", column: "EnterpriseId"); migrationBuilder.CreateIndex( name: "IX_Department_ParentId", table: "Department", column: "ParentId"); migrationBuilder.CreateIndex( name: "IX_DictionaryData_CategoryId", table: "DictionaryData", column: "CategoryId"); migrationBuilder.CreateIndex( name: "IX_DictionaryData_ParentId", table: "DictionaryData", column: "ParentId"); migrationBuilder.CreateIndex( name: "IX_Enterprise_IdentityBackImgId", table: "Enterprise", column: "IdentityBackImgId"); migrationBuilder.CreateIndex( name: "IX_Enterprise_IdentityImgId", table: "Enterprise", column: "IdentityImgId"); migrationBuilder.CreateIndex( name: "IX_Enterprise_LicenseImageId", table: "Enterprise", column: "LicenseImageId"); migrationBuilder.CreateIndex( name: "IX_FileVirtualPath_StoreId", table: "FileVirtualPath", column: "StoreId"); migrationBuilder.CreateIndex( name: "IX_Menu_ParentId", table: "Menu", column: "ParentId"); migrationBuilder.CreateIndex( name: "IX_RoleMenu_MenuId", table: "RoleMenu", column: "MenuId"); migrationBuilder.CreateIndex( name: "IX_RoleMenu_RoleId", table: "RoleMenu", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_RoleResource_MenuId", table: "RoleResource", column: "MenuId"); migrationBuilder.CreateIndex( name: "IX_RoleResource_RoleId", table: "RoleResource", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_TaskInfo_CityId", table: "TaskInfo", column: "CityId"); migrationBuilder.CreateIndex( name: "IX_TaskInfo_EnterpriseId", table: "TaskInfo", column: "EnterpriseId"); migrationBuilder.CreateIndex( name: "IX_TaskInfoBenefit_BenefitId", table: "TaskInfoBenefit", column: "BenefitId"); migrationBuilder.CreateIndex( name: "IX_TaskInfoBenefit_BenefitId1", table: "TaskInfoBenefit", column: "BenefitId1"); migrationBuilder.CreateIndex( name: "IX_TaskInfoCredentialLimit_TaskInfoId", table: "TaskInfoCredentialLimit", column: "TaskInfoId"); migrationBuilder.CreateIndex( name: "IX_TaskInfoCredentialLimit_TypeId", table: "TaskInfoCredentialLimit", column: "TypeId"); migrationBuilder.CreateIndex( name: "IX_TaskInfoUser_TaskInfoId", table: "TaskInfoUser", column: "TaskInfoId"); migrationBuilder.CreateIndex( name: "IX_TaskInfoUser_UserInfoId", table: "TaskInfoUser", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserAuth_AvatarId", table: "UserAuth", column: "AvatarId"); migrationBuilder.CreateIndex( name: "IX_UserAuth_BankCardImgId", table: "UserAuth", column: "BankCardImgId"); migrationBuilder.CreateIndex( name: "IX_UserAuth_IdentityBackImgId", table: "UserAuth", column: "IdentityBackImgId"); migrationBuilder.CreateIndex( name: "IX_UserAuth_IdentityImgId", table: "UserAuth", column: "IdentityImgId"); migrationBuilder.CreateIndex( name: "IX_UserInfo_CityId", table: "UserInfo", column: "CityId"); migrationBuilder.CreateIndex( name: "IX_UserInfo_EducationalBackgroundId", table: "UserInfo", column: "EducationalBackgroundId"); migrationBuilder.CreateIndex( name: "IX_UserInfo_EnterpriseId", table: "UserInfo", column: "EnterpriseId"); migrationBuilder.CreateIndex( name: "IX_UserInfo_PersonalIdentityId", table: "UserInfo", column: "PersonalIdentityId"); migrationBuilder.CreateIndex( name: "IX_UserInfo_UserAuthId", table: "UserInfo", column: "UserAuthId"); migrationBuilder.CreateIndex( name: "IX_UserInfoBankCard_UserInfoId", table: "UserInfoBankCard", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserInfoCredential_BackImgId", table: "UserInfoCredential", column: "BackImgId"); migrationBuilder.CreateIndex( name: "IX_UserInfoCredential_ImgId", table: "UserInfoCredential", column: "ImgId"); migrationBuilder.CreateIndex( name: "IX_UserInfoCredential_TypeId", table: "UserInfoCredential", column: "TypeId"); migrationBuilder.CreateIndex( name: "IX_UserInfoCredential_UserInfoId", table: "UserInfoCredential", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserInfoDepartment_DepartmentId", table: "UserInfoDepartment", column: "DepartmentId"); migrationBuilder.CreateIndex( name: "IX_UserInfoDepartment_UserInfoId", table: "UserInfoDepartment", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserInfoExpectJob_PersonalIdentityId", table: "UserInfoExpectJob", column: "PersonalIdentityId"); migrationBuilder.CreateIndex( name: "IX_UserInfoExpectJob_UserInfoId", table: "UserInfoExpectJob", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserInfoPhoto_ImgId", table: "UserInfoPhoto", column: "ImgId"); migrationBuilder.CreateIndex( name: "IX_UserInfoPhoto_UserInfoId", table: "UserInfoPhoto", column: "UserInfoId"); migrationBuilder.CreateIndex( name: "IX_UserInfoRole_RoleId", table: "UserInfoRole", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_UserInfoRole_UserInfoId", table: "UserInfoRole", column: "UserInfoId"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "Resource"); migrationBuilder.DropTable( name: "RoleMenu"); migrationBuilder.DropTable( name: "RoleResource"); migrationBuilder.DropTable( name: "TaskInfoBenefit"); migrationBuilder.DropTable( name: "TaskInfoCredentialLimit"); migrationBuilder.DropTable( name: "TaskInfoUser"); migrationBuilder.DropTable( name: "UserInfoBankCard"); migrationBuilder.DropTable( name: "UserInfoCredential"); migrationBuilder.DropTable( name: "UserInfoDepartment"); migrationBuilder.DropTable( name: "UserInfoExpectJob"); migrationBuilder.DropTable( name: "UserInfoPhoto"); migrationBuilder.DropTable( name: "UserInfoRole"); migrationBuilder.DropTable( name: "Menu"); migrationBuilder.DropTable( name: "TaskInfo"); migrationBuilder.DropTable( name: "Department"); migrationBuilder.DropTable( name: "Role"); migrationBuilder.DropTable( name: "UserInfo"); migrationBuilder.DropTable( name: "DictionaryData"); migrationBuilder.DropTable( name: "Enterprise"); migrationBuilder.DropTable( name: "UserAuth"); migrationBuilder.DropTable( name: "DictionaryCategory"); migrationBuilder.DropTable( name: "FileVirtualPath"); migrationBuilder.DropTable( name: "FileStore"); } } }