Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using Microsoft.EntityFrameworkCore.Migrations;
- namespace Project.Models.Migrations
- {
- public partial class Models : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "Answers",
- columns: table => new
- {
- Id = table.Column<Guid>(nullable: false),
- Answer = table.Column<string>(nullable: true),
- Explination = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Answers", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "AspNetRoles",
- columns: table => new
- {
- Id = table.Column<string>(nullable: false),
- Name = table.Column<string>(maxLength: 256, nullable: true),
- NormalizedName = table.Column<string>(maxLength: 256, nullable: true),
- ConcurrencyStamp = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetRoles", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUsers",
- columns: table => new
- {
- Id = table.Column<string>(nullable: false),
- UserName = table.Column<string>(maxLength: 256, nullable: true),
- NormalizedUserName = table.Column<string>(maxLength: 256, nullable: true),
- Email = table.Column<string>(maxLength: 256, nullable: true),
- NormalizedEmail = table.Column<string>(maxLength: 256, nullable: true),
- EmailConfirmed = table.Column<bool>(nullable: false),
- PasswordHash = table.Column<string>(nullable: true),
- SecurityStamp = table.Column<string>(nullable: true),
- ConcurrencyStamp = table.Column<string>(nullable: true),
- PhoneNumber = table.Column<string>(nullable: true),
- PhoneNumberConfirmed = table.Column<bool>(nullable: false),
- TwoFactorEnabled = table.Column<bool>(nullable: false),
- LockoutEnd = table.Column<DateTimeOffset>(nullable: true),
- LockoutEnabled = table.Column<bool>(nullable: false),
- AccessFailedCount = table.Column<int>(nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUsers", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "Questions",
- columns: table => new
- {
- Id = table.Column<Guid>(nullable: false),
- Question = table.Column<string>(nullable: true),
- Score = table.Column<int>(nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Questions", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "Quizzes",
- columns: table => new
- {
- Id = table.Column<Guid>(nullable: false),
- QuizName = table.Column<string>(nullable: true),
- Difficulty = table.Column<int>(nullable: false),
- ThemeColor = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Quizzes", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "Subjects",
- columns: table => new
- {
- Id = table.Column<Guid>(nullable: false),
- SubjectName = table.Column<string>(nullable: true),
- Description = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Subjects", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "AspNetRoleClaims",
- columns: table => new
- {
- Id = table.Column<int>(nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- RoleId = table.Column<string>(nullable: false),
- ClaimType = table.Column<string>(nullable: true),
- ClaimValue = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
- table.ForeignKey(
- name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
- column: x => x.RoleId,
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUserClaims",
- columns: table => new
- {
- Id = table.Column<int>(nullable: false)
- .Annotation("SqlServer:Identity", "1, 1"),
- UserId = table.Column<string>(nullable: false),
- ClaimType = table.Column<string>(nullable: true),
- ClaimValue = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
- table.ForeignKey(
- name: "FK_AspNetUserClaims_AspNetUsers_UserId",
- column: x => x.UserId,
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUserLogins",
- columns: table => new
- {
- LoginProvider = table.Column<string>(maxLength: 128, nullable: false),
- ProviderKey = table.Column<string>(maxLength: 128, nullable: false),
- ProviderDisplayName = table.Column<string>(nullable: true),
- UserId = table.Column<string>(nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey });
- table.ForeignKey(
- name: "FK_AspNetUserLogins_AspNetUsers_UserId",
- column: x => x.UserId,
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUserRoles",
- columns: table => new
- {
- UserId = table.Column<string>(nullable: false),
- RoleId = table.Column<string>(nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
- table.ForeignKey(
- name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
- column: x => x.RoleId,
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_AspNetUserRoles_AspNetUsers_UserId",
- column: x => x.UserId,
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUserTokens",
- columns: table => new
- {
- UserId = table.Column<string>(nullable: false),
- LoginProvider = table.Column<string>(maxLength: 128, nullable: false),
- Name = table.Column<string>(maxLength: 128, nullable: false),
- Value = table.Column<string>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
- table.ForeignKey(
- name: "FK_AspNetUserTokens_AspNetUsers_UserId",
- column: x => x.UserId,
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "QuestionAnswers",
- columns: table => new
- {
- QuestionId = table.Column<Guid>(nullable: false),
- AnswerId = table.Column<Guid>(nullable: false),
- IsCorrect = table.Column<bool>(nullable: false),
- QuestionsId = table.Column<Guid>(nullable: true),
- AnswersId = table.Column<Guid>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_QuestionAnswers", x => new { x.AnswerId, x.QuestionId });
- table.ForeignKey(
- name: "FK_QuestionAnswers_Answers_AnswersId",
- column: x => x.AnswersId,
- principalTable: "Answers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuestionAnswers_Questions_QuestionsId",
- column: x => x.QuestionsId,
- principalTable: "Questions",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateTable(
- name: "QuizQuestions",
- columns: table => new
- {
- QuizId = table.Column<Guid>(nullable: false),
- QuestionId = table.Column<Guid>(nullable: false),
- QuizzesId = table.Column<Guid>(nullable: true),
- QuestionsId = table.Column<Guid>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_QuizQuestions", x => new { x.QuestionId, x.QuizId });
- table.ForeignKey(
- name: "FK_QuizQuestions_Questions_QuestionsId",
- column: x => x.QuestionsId,
- principalTable: "Questions",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuizQuestions_Quizzes_QuizzesId",
- column: x => x.QuizzesId,
- principalTable: "Quizzes",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateTable(
- name: "UserQuizzes",
- columns: table => new
- {
- Id = table.Column<Guid>(nullable: false),
- UserId = table.Column<string>(nullable: true),
- QuizId = table.Column<Guid>(nullable: false),
- Score = table.Column<int>(nullable: false),
- UsersId = table.Column<string>(nullable: true),
- QuizzesId = table.Column<Guid>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_UserQuizzes", x => x.Id);
- table.ForeignKey(
- name: "FK_UserQuizzes_Quizzes_QuizzesId",
- column: x => x.QuizzesId,
- principalTable: "Quizzes",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_UserQuizzes_AspNetUsers_UsersId",
- column: x => x.UsersId,
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateTable(
- name: "QuizSubjects",
- columns: table => new
- {
- QuizId = table.Column<Guid>(nullable: false),
- SubjectId = table.Column<Guid>(nullable: false),
- SubjectsId = table.Column<Guid>(nullable: true),
- QuizzesId = table.Column<Guid>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_QuizSubjects", x => new { x.QuizId, x.SubjectId });
- table.ForeignKey(
- name: "FK_QuizSubjects_Quizzes_QuizzesId",
- column: x => x.QuizzesId,
- principalTable: "Quizzes",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuizSubjects_Subjects_SubjectsId",
- column: x => x.SubjectsId,
- principalTable: "Subjects",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateTable(
- name: "QuizAwnsers",
- columns: table => new
- {
- QuestionAnswerId = table.Column<Guid>(nullable: false),
- UserQuizId = table.Column<Guid>(nullable: false),
- QuestionAnswerAnswerId = table.Column<Guid>(nullable: true),
- QuestionAnswerQuestionId = table.Column<Guid>(nullable: true),
- AnswersId = table.Column<Guid>(nullable: true),
- QuestionsId = table.Column<Guid>(nullable: true),
- QuizzesId = table.Column<Guid>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_QuizAwnsers", x => new { x.QuestionAnswerId, x.UserQuizId });
- table.ForeignKey(
- name: "FK_QuizAwnsers_Answers_AnswersId",
- column: x => x.AnswersId,
- principalTable: "Answers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuizAwnsers_Questions_QuestionsId",
- column: x => x.QuestionsId,
- principalTable: "Questions",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuizAwnsers_Quizzes_QuizzesId",
- column: x => x.QuizzesId,
- principalTable: "Quizzes",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_QuizAwnsers_UserQuizzes_UserQuizId",
- column: x => x.UserQuizId,
- principalTable: "UserQuizzes",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_QuizAwnsers_QuestionAnswers_QuestionAnswerAnswerId_QuestionAnswerQuestionId",
- columns: x => new { x.QuestionAnswerAnswerId, x.QuestionAnswerQuestionId },
- principalTable: "QuestionAnswers",
- principalColumns: new[] { "AnswerId", "QuestionId" },
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateIndex(
- name: "IX_AspNetRoleClaims_RoleId",
- table: "AspNetRoleClaims",
- column: "RoleId");
- migrationBuilder.CreateIndex(
- name: "RoleNameIndex",
- table: "AspNetRoles",
- column: "NormalizedName",
- unique: true,
- filter: "[NormalizedName] IS NOT NULL");
- migrationBuilder.CreateIndex(
- name: "IX_AspNetUserClaims_UserId",
- table: "AspNetUserClaims",
- column: "UserId");
- migrationBuilder.CreateIndex(
- name: "IX_AspNetUserLogins_UserId",
- table: "AspNetUserLogins",
- column: "UserId");
- migrationBuilder.CreateIndex(
- name: "IX_AspNetUserRoles_RoleId",
- table: "AspNetUserRoles",
- column: "RoleId");
- migrationBuilder.CreateIndex(
- name: "EmailIndex",
- table: "AspNetUsers",
- column: "NormalizedEmail");
- migrationBuilder.CreateIndex(
- name: "UserNameIndex",
- table: "AspNetUsers",
- column: "NormalizedUserName",
- unique: true,
- filter: "[NormalizedUserName] IS NOT NULL");
- migrationBuilder.CreateIndex(
- name: "IX_QuestionAnswers_AnswersId",
- table: "QuestionAnswers",
- column: "AnswersId");
- migrationBuilder.CreateIndex(
- name: "IX_QuestionAnswers_QuestionsId",
- table: "QuestionAnswers",
- column: "QuestionsId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizAwnsers_AnswersId",
- table: "QuizAwnsers",
- column: "AnswersId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizAwnsers_QuestionsId",
- table: "QuizAwnsers",
- column: "QuestionsId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizAwnsers_QuizzesId",
- table: "QuizAwnsers",
- column: "QuizzesId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizAwnsers_UserQuizId",
- table: "QuizAwnsers",
- column: "UserQuizId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizAwnsers_QuestionAnswerAnswerId_QuestionAnswerQuestionId",
- table: "QuizAwnsers",
- columns: new[] { "QuestionAnswerAnswerId", "QuestionAnswerQuestionId" });
- migrationBuilder.CreateIndex(
- name: "IX_QuizQuestions_QuestionsId",
- table: "QuizQuestions",
- column: "QuestionsId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizQuestions_QuizzesId",
- table: "QuizQuestions",
- column: "QuizzesId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizSubjects_QuizzesId",
- table: "QuizSubjects",
- column: "QuizzesId");
- migrationBuilder.CreateIndex(
- name: "IX_QuizSubjects_SubjectsId",
- table: "QuizSubjects",
- column: "SubjectsId");
- migrationBuilder.CreateIndex(
- name: "IX_UserQuizzes_QuizzesId",
- table: "UserQuizzes",
- column: "QuizzesId");
- migrationBuilder.CreateIndex(
- name: "IX_UserQuizzes_UsersId",
- table: "UserQuizzes",
- column: "UsersId");
- }
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "AspNetRoleClaims");
- migrationBuilder.DropTable(
- name: "AspNetUserClaims");
- migrationBuilder.DropTable(
- name: "AspNetUserLogins");
- migrationBuilder.DropTable(
- name: "AspNetUserRoles");
- migrationBuilder.DropTable(
- name: "AspNetUserTokens");
- migrationBuilder.DropTable(
- name: "QuizAwnsers");
- migrationBuilder.DropTable(
- name: "QuizQuestions");
- migrationBuilder.DropTable(
- name: "QuizSubjects");
- migrationBuilder.DropTable(
- name: "AspNetRoles");
- migrationBuilder.DropTable(
- name: "UserQuizzes");
- migrationBuilder.DropTable(
- name: "QuestionAnswers");
- migrationBuilder.DropTable(
- name: "Subjects");
- migrationBuilder.DropTable(
- name: "Quizzes");
- migrationBuilder.DropTable(
- name: "AspNetUsers");
- migrationBuilder.DropTable(
- name: "Answers");
- migrationBuilder.DropTable(
- name: "Questions");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement