using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace MTWorkHR.Infrastructure.Migrations { /// public partial class addSubscription : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "SubscriptionConfiguration", 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), FirstRegisterationCompanyFees = table.Column(type: "decimal(18,2)", nullable: true), MonthlyCompanyFees = table.Column(type: "decimal(18,2)", nullable: true), YearlyCompanyFees = table.Column(type: "decimal(18,2)", nullable: true), MonthlyEmployeeServicesCompanyFees = table.Column(type: "decimal(18,2)", nullable: true), DistinguishedEmployeeCompanyFeesPerc = table.Column(type: "decimal(18,2)", nullable: true), OrdinaryEmployeePerc = table.Column(type: "decimal(18,2)", nullable: true), DistinguishedEmployeePerc = table.Column(type: "decimal(18,2)", nullable: true), DeductedFirstSearchAmount = table.Column(type: "decimal(18,2)", nullable: true), ContractDocumentationFees = table.Column(type: "decimal(18,2)", nullable: true), ExperienceCertificateFees = table.Column(type: "decimal(18,2)", nullable: true), RequestDisputeResolutionFees = table.Column(type: "decimal(18,2)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_SubscriptionConfiguration", x => x.Id); }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "SubscriptionConfiguration"); } } }