Created
June 11, 2022 23:22
-
-
Save milosh-96/037afe7c383895e2a9a4b540be1e0f07 to your computer and use it in GitHub Desktop.
The main purpose of this is that I adjusted lengths so you don't get errors like "specified key is too long".
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using Microsoft.EntityFrameworkCore.Migrations; | |
| using MySql.EntityFrameworkCore.Metadata; | |
| namespace AspNetProject.Data.Migrations | |
| { | |
| public partial class Identity : Migration | |
| { | |
| protected override void Up(MigrationBuilder migrationBuilder) | |
| { | |
| migrationBuilder.CreateTable( | |
| name: "AspNetRoles", | |
| columns: table => new | |
| { | |
| Id = table.Column<int>(nullable: false) | |
| .Annotation("MySQL:ValueGenerationStrategy", MySQLValueGenerationStrategy.IdentityColumn), | |
| 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<int>(nullable: false) | |
| .Annotation("MySQL:ValueGenerationStrategy", MySQLValueGenerationStrategy.IdentityColumn), | |
| 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: "AspNetRoleClaims", | |
| columns: table => new | |
| { | |
| Id = table.Column<int>(nullable: false) | |
| .Annotation("MySQL:ValueGenerationStrategy", MySQLValueGenerationStrategy.IdentityColumn), | |
| RoleId = table.Column<int>(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("MySQL:ValueGenerationStrategy", MySQLValueGenerationStrategy.IdentityColumn), | |
| UserId = table.Column<int>(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<int>(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<int>(nullable: false), | |
| RoleId = table.Column<int>(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<int>(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.CreateIndex( | |
| name: "IX_AspNetRoleClaims_RoleId", | |
| table: "AspNetRoleClaims", | |
| column: "RoleId"); | |
| migrationBuilder.CreateIndex( | |
| name: "RoleNameIndex", | |
| table: "AspNetRoles", | |
| column: "NormalizedName", | |
| unique: true); | |
| 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); | |
| } | |
| 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: "AspNetRoles"); | |
| migrationBuilder.DropTable( | |
| name: "AspNetUsers"); | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment