Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using Microsoft.EntityFrameworkCore.Metadata;
- using Microsoft.EntityFrameworkCore.Migrations;
- using System;
- using System.Collections.Generic;
- namespace YouMentor.Server.Dal.Migrations
- {
- public partial class AspNetIdentity : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "FK_Likes_Users_UserId",
- table: "Likes");
- migrationBuilder.DropForeignKey(
- name: "FK_MentorSubscriptions_Users_UserId",
- table: "MentorSubscriptions");
- migrationBuilder.DropTable(
- name: "Accounts");
- migrationBuilder.DropPrimaryKey(
- name: "PK_Users",
- table: "Users");
- migrationBuilder.RenameTable(
- name: "Users",
- newName: "Juniors");
- migrationBuilder.AddPrimaryKey(
- name: "PK_Juniors",
- table: "Juniors",
- column: "Id");
- migrationBuilder.CreateTable(
- name: "AspNetRoles",
- columns: table => new
- {
- Id = table.Column<string>(nullable: false),
- ConcurrencyStamp = table.Column<string>(nullable: true),
- Name = table.Column<string>(maxLength: 256, nullable: true),
- NormalizedName = table.Column<string>(maxLength: 256, nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetRoles", x => x.Id);
- });
- migrationBuilder.CreateTable(
- name: "AspNetUsers",
- columns: table => new
- {
- Id = table.Column<string>(nullable: false),
- AccessFailedCount = table.Column<int>(nullable: false),
- ConcurrencyStamp = table.Column<string>(nullable: true),
- Email = table.Column<string>(maxLength: 256, nullable: true),
- EmailConfirmed = table.Column<bool>(nullable: false),
- LastLoginDate = table.Column<DateTimeOffset>(nullable: true),
- LockoutEnabled = table.Column<bool>(nullable: false),
- LockoutEnd = table.Column<DateTimeOffset>(nullable: true),
- MentorForeignKey = table.Column<int>(nullable: true),
- NormalizedEmail = table.Column<string>(maxLength: 256, nullable: true),
- NormalizedUserName = table.Column<string>(maxLength: 256, nullable: true),
- Password = table.Column<string>(maxLength: 200, nullable: false),
- PasswordHash = table.Column<string>(nullable: true),
- PhoneNumber = table.Column<string>(nullable: true),
- PhoneNumberConfirmed = table.Column<bool>(nullable: false),
- Role = table.Column<string>(maxLength: 50, nullable: false),
- SecurityStamp = table.Column<string>(nullable: true),
- TwoFactorEnabled = table.Column<bool>(nullable: false),
- UserForeignKey = table.Column<int>(nullable: true),
- UserName = table.Column<string>(maxLength: 256, nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AspNetUsers", x => x.Id);
- table.ForeignKey(
- name: "FK_AspNetUsers_Mentors_MentorForeignKey",
- column: x => x.MentorForeignKey,
- principalTable: "Mentors",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_AspNetUsers_Juniors_UserForeignKey",
- column: x => x.UserForeignKey,
- principalTable: "Juniors",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
- migrationBuilder.CreateTable(
- name: "AspNetRoleClaims",
- columns: table => new
- {
- Id = table.Column<int>(nullable: false)
- .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
- ClaimType = table.Column<string>(nullable: true),
- ClaimValue = table.Column<string>(nullable: true),
- RoleId = table.Column<string>(nullable: false)
- },
- 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:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
- ClaimType = table.Column<string>(nullable: true),
- ClaimValue = table.Column<string>(nullable: true),
- UserId = table.Column<string>(nullable: false)
- },
- 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>(nullable: false),
- ProviderKey = table.Column<string>(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>(nullable: false),
- Name = table.Column<string>(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.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: "IX_AspNetUsers_Email",
- table: "AspNetUsers",
- column: "Email",
- unique: true,
- filter: "[Email] IS NOT NULL");
- migrationBuilder.CreateIndex(
- name: "IX_AspNetUsers_MentorForeignKey",
- table: "AspNetUsers",
- column: "MentorForeignKey",
- unique: true,
- filter: "[MentorForeignKey] IS NOT NULL");
- 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_AspNetUsers_UserForeignKey",
- table: "AspNetUsers",
- column: "UserForeignKey",
- unique: true,
- filter: "[UserForeignKey] IS NOT NULL");
- migrationBuilder.AddForeignKey(
- name: "FK_Likes_Juniors_UserId",
- table: "Likes",
- column: "UserId",
- principalTable: "Juniors",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_MentorSubscriptions_Juniors_UserId",
- table: "MentorSubscriptions",
- column: "UserId",
- principalTable: "Juniors",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- }
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "FK_Likes_Juniors_UserId",
- table: "Likes");
- migrationBuilder.DropForeignKey(
- name: "FK_MentorSubscriptions_Juniors_UserId",
- table: "MentorSubscriptions");
- migrationBuilder.DropTable(
- name: "AspNetRoleClaims");
- migrationBuilder.DropTable(
- name: "AspNetUserClaims");
- migrationBuilder.DropTable(
- name: "AspNetUserLogins");
- migrationBuilder.DropTable(
- name: "AspNetUserRoles");
- migrationBuilder.DropTable(
- name: "AspNetUserTokens");
- migrationBuilder.DropTable(
- name: "AspNetRoles");
- migrationBuilder.DropTable(
- name: "AspNetUsers");
- migrationBuilder.DropPrimaryKey(
- name: "PK_Juniors",
- table: "Juniors");
- migrationBuilder.RenameTable(
- name: "Juniors",
- newName: "Users");
- migrationBuilder.AddPrimaryKey(
- name: "PK_Users",
- table: "Users",
- column: "Id");
- migrationBuilder.CreateTable(
- name: "Accounts",
- columns: table => new
- {
- Id = table.Column<int>(nullable: false)
- .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
- Email = table.Column<string>(maxLength: 200, nullable: false),
- LastLoginDate = table.Column<DateTimeOffset>(nullable: true),
- MentorForeignKey = table.Column<int>(nullable: true),
- Password = table.Column<string>(maxLength: 200, nullable: false),
- Role = table.Column<string>(maxLength: 50, nullable: false),
- UserForeignKey = table.Column<int>(nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Accounts", x => x.Id);
- table.ForeignKey(
- name: "FK_Accounts_Mentors_MentorForeignKey",
- column: x => x.MentorForeignKey,
- principalTable: "Mentors",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- table.ForeignKey(
- name: "FK_Accounts_Users_UserForeignKey",
- column: x => x.UserForeignKey,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- });
- migrationBuilder.CreateIndex(
- name: "IX_Accounts_Email",
- table: "Accounts",
- column: "Email",
- unique: true);
- migrationBuilder.CreateIndex(
- name: "IX_Accounts_MentorForeignKey",
- table: "Accounts",
- column: "MentorForeignKey",
- unique: true,
- filter: "[MentorForeignKey] IS NOT NULL");
- migrationBuilder.CreateIndex(
- name: "IX_Accounts_UserForeignKey",
- table: "Accounts",
- column: "UserForeignKey",
- unique: true,
- filter: "[UserForeignKey] IS NOT NULL");
- migrationBuilder.AddForeignKey(
- name: "FK_Likes_Users_UserId",
- table: "Likes",
- column: "UserId",
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_MentorSubscriptions_Users_UserId",
- table: "MentorSubscriptions",
- column: "UserId",
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement