using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace MTWorkHR.Infrastructure.Migrations { /// public partial class jobInterview : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_Invoice", table: "Invoice"); migrationBuilder.RenameTable( name: "Invoice", newName: "Invoices"); migrationBuilder.AddPrimaryKey( name: "PK_Invoices", table: "Invoices", column: "Id"); migrationBuilder.CreateTable( name: "JobInterviews", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), IsDeleted = table.Column(type: "bit", nullable: false), DeleteUserId = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CompanyId = table.Column(type: "bigint", nullable: false), UserId = table.Column(type: "nvarchar(max)", nullable: false), Email = table.Column(type: "nvarchar(max)", nullable: false), InterviewDate = table.Column(type: "datetime2", nullable: false), InterviewTime = table.Column(type: "nvarchar(max)", nullable: true), InterviewLink = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: true), SendByMail = table.Column(type: "bit", nullable: true) }, constraints: table => { table.PrimaryKey("PK_JobInterviews", x => x.Id); }); migrationBuilder.CreateIndex( name: "IX_JobInterviews_CompanyId", table: "JobInterviews", column: "CompanyId"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "JobInterviews"); migrationBuilder.DropPrimaryKey( name: "PK_Invoices", table: "Invoices"); migrationBuilder.RenameTable( name: "Invoices", newName: "Invoice"); migrationBuilder.AddPrimaryKey( name: "PK_Invoice", table: "Invoice", column: "Id"); } } }