using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace ManagerService.Migrations { /// public partial class UpdateGuidedStepQuizQuestionAndMisc : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "ExpectedAnswer", table: "GuidedSteps"); migrationBuilder.DropColumn( name: "MultipleChoiceOptions", table: "GuidedSteps"); migrationBuilder.DropColumn( name: "ValidationQuestion", table: "GuidedSteps"); migrationBuilder.DropColumn( name: "ValidationQuestionType", table: "GuidedSteps"); migrationBuilder.AddColumn( name: "GuidedStepId", table: "QuizQuestions", type: "text", nullable: true); migrationBuilder.AddColumn( name: "IsSlidingPuzzle", table: "QuizQuestions", type: "boolean", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "PuzzleCols", table: "QuizQuestions", type: "integer", nullable: true); migrationBuilder.AddColumn( name: "PuzzleImageId", table: "QuizQuestions", type: "text", nullable: true); migrationBuilder.AddColumn( name: "PuzzleRows", table: "QuizQuestions", type: "integer", nullable: true); migrationBuilder.AddColumn( name: "ValidationQuestionType", table: "QuizQuestions", type: "integer", nullable: false, defaultValue: 0); migrationBuilder.AddColumn( name: "IsSearchNumber", table: "Configurations", type: "boolean", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "IsSearchText", table: "Configurations", type: "boolean", nullable: false, defaultValue: false); migrationBuilder.CreateIndex( name: "IX_QuizQuestions_GuidedStepId", table: "QuizQuestions", column: "GuidedStepId"); migrationBuilder.CreateIndex( name: "IX_QuizQuestions_PuzzleImageId", table: "QuizQuestions", column: "PuzzleImageId"); migrationBuilder.AddForeignKey( name: "FK_QuizQuestions_GuidedSteps_GuidedStepId", table: "QuizQuestions", column: "GuidedStepId", principalTable: "GuidedSteps", principalColumn: "Id"); migrationBuilder.AddForeignKey( name: "FK_QuizQuestions_Resources_PuzzleImageId", table: "QuizQuestions", column: "PuzzleImageId", principalTable: "Resources", principalColumn: "Id"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_QuizQuestions_GuidedSteps_GuidedStepId", table: "QuizQuestions"); migrationBuilder.DropForeignKey( name: "FK_QuizQuestions_Resources_PuzzleImageId", table: "QuizQuestions"); migrationBuilder.DropIndex( name: "IX_QuizQuestions_GuidedStepId", table: "QuizQuestions"); migrationBuilder.DropIndex( name: "IX_QuizQuestions_PuzzleImageId", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "GuidedStepId", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "IsSlidingPuzzle", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "PuzzleCols", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "PuzzleImageId", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "PuzzleRows", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "ValidationQuestionType", table: "QuizQuestions"); migrationBuilder.DropColumn( name: "IsSearchNumber", table: "Configurations"); migrationBuilder.DropColumn( name: "IsSearchText", table: "Configurations"); migrationBuilder.AddColumn( name: "ExpectedAnswer", table: "GuidedSteps", type: "jsonb", nullable: true); migrationBuilder.AddColumn( name: "MultipleChoiceOptions", table: "GuidedSteps", type: "jsonb", nullable: true); migrationBuilder.AddColumn( name: "ValidationQuestion", table: "GuidedSteps", type: "jsonb", nullable: true); migrationBuilder.AddColumn( name: "ValidationQuestionType", table: "GuidedSteps", type: "integer", nullable: false, defaultValue: 0); } } }