using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateUser0812002 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_TaskInfoUser_User_UserId", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "ContractUrl", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "EnterpriseSignContractStatus", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "EnterpriseSignContractTime", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "HireStatus", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "HireTime", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "UserSignContractStatus", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "UserSignContractTime", table: "TaskInfoUser"); migrationBuilder.AlterColumn( name: "UserId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: true, oldClrType: typeof(Guid), oldType: "uniqueidentifier"); migrationBuilder.AddColumn( name: "EnterpriseEmployeeId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.CreateTable( name: "EnterpriseEmployee", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false), EnterpriseId = table.Column(type: "uniqueidentifier", nullable: false), UserId = table.Column(type: "uniqueidentifier", nullable: true), Name = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: true), Identity = table.Column(type: "nvarchar(max)", nullable: true), PhoneNumber = table.Column(type: "nvarchar(11)", maxLength: 11, nullable: true), Gender = table.Column(type: "int", nullable: true), Age = table.Column(type: "int", nullable: true), IdentityImg = table.Column(type: "nvarchar(max)", nullable: true), IdentityBackImg = table.Column(type: "nvarchar(max)", nullable: true), HireStatus = table.Column(type: "int", nullable: false), HireTime = table.Column(type: "datetime2", nullable: true), UserSignContractStatus = table.Column(type: "int", nullable: true), UserSignContractTime = table.Column(type: "datetime2", nullable: true), EnterpriseSignContractStatus = table.Column(type: "int", nullable: true), EnterpriseSignContractTime = table.Column(type: "datetime2", nullable: true), ContractUrl = table.Column(type: "nvarchar(max)", nullable: true), CreatedTime = table.Column(type: "datetimeoffset", nullable: false), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true), Sort = table.Column(type: "int", nullable: false), TraceId = table.Column(type: "nvarchar(max)", nullable: true), CreatedUserId = table.Column(type: "uniqueidentifier", nullable: true), CreatedEnterpriseId = table.Column(type: "uniqueidentifier", nullable: true), UpdatedUserId = table.Column(type: "uniqueidentifier", nullable: true), IsDeleted = table.Column(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_EnterpriseEmployee", x => x.Id); table.ForeignKey( name: "FK_EnterpriseEmployee_Enterprise_EnterpriseId", column: x => x.EnterpriseId, principalTable: "Enterprise", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_EnterpriseEmployee_User_UserId", column: x => x.UserId, principalTable: "User", principalColumn: "Id"); }); migrationBuilder.CreateIndex( name: "IX_TaskInfoUser_EnterpriseEmployeeId", table: "TaskInfoUser", column: "EnterpriseEmployeeId"); migrationBuilder.CreateIndex( name: "IX_EnterpriseEmployee_EnterpriseId", table: "EnterpriseEmployee", column: "EnterpriseId"); migrationBuilder.CreateIndex( name: "IX_EnterpriseEmployee_UserId", table: "EnterpriseEmployee", column: "UserId"); migrationBuilder.AddForeignKey( name: "FK_TaskInfoUser_EnterpriseEmployee_EnterpriseEmployeeId", table: "TaskInfoUser", column: "EnterpriseEmployeeId", principalTable: "EnterpriseEmployee", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_TaskInfoUser_User_UserId", table: "TaskInfoUser", column: "UserId", principalTable: "User", principalColumn: "Id"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_TaskInfoUser_EnterpriseEmployee_EnterpriseEmployeeId", table: "TaskInfoUser"); migrationBuilder.DropForeignKey( name: "FK_TaskInfoUser_User_UserId", table: "TaskInfoUser"); migrationBuilder.DropTable( name: "EnterpriseEmployee"); migrationBuilder.DropIndex( name: "IX_TaskInfoUser_EnterpriseEmployeeId", table: "TaskInfoUser"); migrationBuilder.DropColumn( name: "EnterpriseEmployeeId", table: "TaskInfoUser"); migrationBuilder.AlterColumn( name: "UserId", table: "TaskInfoUser", type: "uniqueidentifier", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000"), oldClrType: typeof(Guid), oldType: "uniqueidentifier", oldNullable: true); migrationBuilder.AddColumn( name: "ContractUrl", table: "TaskInfoUser", type: "nvarchar(max)", nullable: true); migrationBuilder.AddColumn( name: "EnterpriseSignContractStatus", table: "TaskInfoUser", type: "int", nullable: true); migrationBuilder.AddColumn( name: "EnterpriseSignContractTime", table: "TaskInfoUser", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "HireStatus", table: "TaskInfoUser", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn( name: "HireTime", table: "TaskInfoUser", type: "datetime2", nullable: true); migrationBuilder.AddColumn( name: "UserSignContractStatus", table: "TaskInfoUser", type: "int", nullable: true); migrationBuilder.AddColumn( name: "UserSignContractTime", table: "TaskInfoUser", type: "datetime2", nullable: true); migrationBuilder.AddForeignKey( name: "FK_TaskInfoUser_User_UserId", table: "TaskInfoUser", column: "UserId", principalTable: "User", principalColumn: "Id", onDelete: ReferentialAction.Cascade); } } }