Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using Microsoft.EntityFrameworkCore.Migrations;
- namespace MyProject.Migrations
- {
- public partial class ChangedPostTableName : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "FK_MyProject.Models.Blog_MyProject.Models.Post_PostPostId",
- table: "MyProject.Models.Blog");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
- table: "AspNetRoleClaims");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserClaims_AspNetUsers_UserId",
- table: "AspNetUserClaims");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserLogins_AspNetUsers_UserId",
- table: "AspNetUserLogins");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
- table: "AspNetUserRoles");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserRoles_AspNetUsers_UserId",
- table: "AspNetUserRoles");
- migrationBuilder.DropPrimaryKey(
- name: "PK_MyProject.Models.Blog",
- table: "MyProject.Models.Blog");
- migrationBuilder.DropIndex(
- name: "IX_MyProject.Models.Blog_PostPostId",
- table: "MyProject.Models.Blog");
- migrationBuilder.DropPrimaryKey(
- name: "PK_MyProject.Models.Post",
- table: "MyProject.Models.Post");
- migrationBuilder.DropColumn(
- name: "PostPostId",
- table: "MyProject.Models.Blog");
- 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 });
- });
- migrationBuilder.AddColumn<int>(
- name: "PostId",
- table: "Blog",
- nullable: false,
- defaultValue: 0);
- migrationBuilder.AddPrimaryKey(
- name: "PK_Blog",
- table: "Blog",
- column: "BlogId");
- migrationBuilder.CreateIndex(
- name: "IX_Blog_PostId",
- table: "Blog",
- column: "PostId");
- migrationBuilder.AddPrimaryKey(
- name: "PK_Posts",
- table: "Posts",
- column: "PostId");
- migrationBuilder.AddForeignKey(
- name: "FK_Blog_Posts_PostId",
- table: "Blog",
- column: "PostId",
- principalTable: "Posts",
- principalColumn: "PostId",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
- table: "AspNetRoleClaims",
- column: "RoleId",
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserClaims_AspNetUsers_UserId",
- table: "AspNetUserClaims",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserLogins_AspNetUsers_UserId",
- table: "AspNetUserLogins",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
- table: "AspNetUserRoles",
- column: "RoleId",
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserRoles_AspNetUsers_UserId",
- table: "AspNetUserRoles",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- migrationBuilder.RenameTable(
- name: "MyProject.Models.Blog",
- newName: "Blog");
- migrationBuilder.RenameTable(
- name: "MyProject.Models.Post",
- newName: "Posts");
- }
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "FK_Blog_Posts_PostId",
- table: "Blog");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
- table: "AspNetRoleClaims");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserClaims_AspNetUsers_UserId",
- table: "AspNetUserClaims");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserLogins_AspNetUsers_UserId",
- table: "AspNetUserLogins");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
- table: "AspNetUserRoles");
- migrationBuilder.DropForeignKey(
- name: "FK_AspNetUserRoles_AspNetUsers_UserId",
- table: "AspNetUserRoles");
- migrationBuilder.DropPrimaryKey(
- name: "PK_Blog",
- table: "Blog");
- migrationBuilder.DropIndex(
- name: "IX_Blog_PostId",
- table: "Blog");
- migrationBuilder.DropPrimaryKey(
- name: "PK_Posts",
- table: "Posts");
- migrationBuilder.DropColumn(
- name: "PostId",
- table: "Blog");
- migrationBuilder.DropTable(
- name: "AspNetUserTokens");
- migrationBuilder.AddColumn<int>(
- name: "PostPostId",
- table: "MyProject.Models.Blog",
- nullable: true);
- migrationBuilder.AddPrimaryKey(
- name: "PK_MyProject.Models.Blog",
- table: "MyProject.Models.Blog",
- column: "BlogId");
- migrationBuilder.CreateIndex(
- name: "IX_MyProject.Models.Blog_PostPostId",
- table: "MyProject.Models.Blog",
- column: "PostPostId");
- migrationBuilder.AddPrimaryKey(
- name: "PK_MyProject.Models.Post",
- table: "MyProject.Models.Post",
- column: "PostId");
- migrationBuilder.AddForeignKey(
- name: "FK_MyProject.Models.Blog_MyProject.Models.Post_PostPostId",
- table: "MyProject.Models.Blog",
- column: "PostPostId",
- principalTable: "MyProject.Models.Post",
- principalColumn: "PostId",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
- table: "AspNetRoleClaims",
- column: "RoleId",
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserClaims_AspNetUsers_UserId",
- table: "AspNetUserClaims",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserLogins_AspNetUsers_UserId",
- table: "AspNetUserLogins",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
- table: "AspNetUserRoles",
- column: "RoleId",
- principalTable: "AspNetRoles",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.AddForeignKey(
- name: "FK_AspNetUserRoles_AspNetUsers_UserId",
- table: "AspNetUserRoles",
- column: "UserId",
- principalTable: "AspNetUsers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Restrict);
- migrationBuilder.RenameTable(
- name: "Blog",
- newName: "MyProject.Models.Blog");
- migrationBuilder.RenameTable(
- name: "Posts",
- newName: "MyProject.Models.Post");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement