diff options
author | HombreLaser <sebastian-440@live.com> | 2022-11-20 18:04:13 -0600 |
---|---|---|
committer | HombreLaser <sebastian-440@live.com> | 2022-11-20 18:04:13 -0600 |
commit | 45c2616816d62e347cd443a83b184ce5096f3061 (patch) | |
tree | 364a02ff7afc1a5fd94cc6fcee99fc5b127d18ac /Migrations | |
parent | 0eb1eacf11f8c713478c08633f92d7579da91992 (diff) |
Limpiado esquema de base de datos
Diffstat (limited to 'Migrations')
-rw-r--r-- | Migrations/20221118214838_AddTokenExpiryTimeToUser.Designer.cs | 318 | ||||
-rw-r--r-- | Migrations/20221118214838_AddTokenExpiryTimeToUser.cs | 89 | ||||
-rw-r--r-- | Migrations/20221121000226_InitialMigration.Designer.cs (renamed from Migrations/20221118044105_InitialMigration.Designer.cs) | 39 | ||||
-rw-r--r-- | Migrations/20221121000226_InitialMigration.cs (renamed from Migrations/20221118044105_InitialMigration.cs) | 16 |
4 files changed, 5 insertions, 457 deletions
diff --git a/Migrations/20221118214838_AddTokenExpiryTimeToUser.Designer.cs b/Migrations/20221118214838_AddTokenExpiryTimeToUser.Designer.cs deleted file mode 100644 index 3bda0df..0000000 --- a/Migrations/20221118214838_AddTokenExpiryTimeToUser.Designer.cs +++ /dev/null @@ -1,318 +0,0 @@ -// <auto-generated /> -using System; -using BackendPIA.Models; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Migrations; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace BackendPIA.Migrations -{ - [DbContext(typeof(ApplicationDbContext))] - [Migration("20221118214838_AddTokenExpiryTimeToUser")] - partial class AddTokenExpiryTimeToUser - { - /// <inheritdoc /> - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "7.0.0") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("BackendPIA.Models.UserAccount", b => - { - b.Property<string>("Id") - .HasColumnType("text"); - - b.Property<int>("AccessFailedCount") - .HasColumnType("integer"); - - b.Property<string>("ConcurrencyStamp") - .IsConcurrencyToken() - .HasColumnType("text"); - - b.Property<string>("Email") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<bool>("EmailConfirmed") - .HasColumnType("boolean"); - - b.Property<bool>("LockoutEnabled") - .HasColumnType("boolean"); - - b.Property<DateTimeOffset?>("LockoutEnd") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("NormalizedEmail") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("NormalizedUserName") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("PasswordHash") - .HasColumnType("text"); - - b.Property<string>("PhoneNumber") - .HasColumnType("text"); - - b.Property<bool>("PhoneNumberConfirmed") - .HasColumnType("boolean"); - - b.Property<string>("SecurityStamp") - .HasColumnType("text"); - - b.Property<string>("SessionToken") - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<DateTime?>("SessionTokenExpiryTime") - .HasColumnType("timestamp with time zone"); - - b.Property<bool>("TwoFactorEnabled") - .HasColumnType("boolean"); - - b.Property<string>("UserName") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.HasKey("Id"); - - b.HasIndex("NormalizedEmail") - .HasDatabaseName("EmailIndex"); - - b.HasIndex("NormalizedUserName") - .IsUnique() - .HasDatabaseName("UserNameIndex"); - - b.ToTable("AspNetUsers", (string)null); - - b.HasData( - new - { - Id = "24edc3d6-bf9c-41a1-9371-224e4419ccb0", - AccessFailedCount = 0, - ConcurrencyStamp = "bd624bcb-3f06-4bce-b924-2666f82e5f23", - Email = "admin@example.com", - EmailConfirmed = false, - LockoutEnabled = false, - NormalizedEmail = "ADMIN@EXAMPLE.COM", - NormalizedUserName = "ADMIN", - PasswordHash = "AQAAAAIAAYagAAAAEL19rXYOEkR3ftL+T5E5vlsLGPu3HSnJuTSLNp/nyffvQvaXlNJFqU1UO3VKB+K6yg==", - PhoneNumberConfirmed = false, - SecurityStamp = "282566ca-8a3b-4310-8e61-8380d16fa07e", - TwoFactorEnabled = false, - UserName = "admin" - }); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b => - { - b.Property<string>("Id") - .HasColumnType("text"); - - b.Property<string>("ConcurrencyStamp") - .IsConcurrencyToken() - .HasColumnType("text"); - - b.Property<string>("Name") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("NormalizedName") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.HasKey("Id"); - - b.HasIndex("NormalizedName") - .IsUnique() - .HasDatabaseName("RoleNameIndex"); - - b.ToTable("AspNetRoles", (string)null); - - b.HasData( - new - { - Id = "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", - ConcurrencyStamp = "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", - Name = "Administrator", - NormalizedName = "ADMINISTRATOR" - }); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("ClaimType") - .HasColumnType("text"); - - b.Property<string>("ClaimValue") - .HasColumnType("text"); - - b.Property<string>("RoleId") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("Id"); - - b.HasIndex("RoleId"); - - b.ToTable("AspNetRoleClaims", (string)null); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("ClaimType") - .HasColumnType("text"); - - b.Property<string>("ClaimValue") - .HasColumnType("text"); - - b.Property<string>("UserId") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("AspNetUserClaims", (string)null); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b => - { - b.Property<string>("LoginProvider") - .HasColumnType("text"); - - b.Property<string>("ProviderKey") - .HasColumnType("text"); - - b.Property<string>("ProviderDisplayName") - .HasColumnType("text"); - - b.Property<string>("UserId") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("LoginProvider", "ProviderKey"); - - b.HasIndex("UserId"); - - b.ToTable("AspNetUserLogins", (string)null); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b => - { - b.Property<string>("UserId") - .HasColumnType("text"); - - b.Property<string>("RoleId") - .HasColumnType("text"); - - b.HasKey("UserId", "RoleId"); - - b.HasIndex("RoleId"); - - b.ToTable("AspNetUserRoles", (string)null); - - b.HasData( - new - { - UserId = "24edc3d6-bf9c-41a1-9371-224e4419ccb0", - RoleId = "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec" - }); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b => - { - b.Property<string>("UserId") - .HasColumnType("text"); - - b.Property<string>("LoginProvider") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<string>("Value") - .HasColumnType("text"); - - b.HasKey("UserId", "LoginProvider", "Name"); - - b.ToTable("AspNetUserTokens", (string)null); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b => - { - b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null) - .WithMany() - .HasForeignKey("RoleId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b => - { - b.HasOne("BackendPIA.Models.UserAccount", null) - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b => - { - b.HasOne("BackendPIA.Models.UserAccount", null) - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b => - { - b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null) - .WithMany() - .HasForeignKey("RoleId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("BackendPIA.Models.UserAccount", null) - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); - - modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b => - { - b.HasOne("BackendPIA.Models.UserAccount", null) - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - }); -#pragma warning restore 612, 618 - } - } -} diff --git a/Migrations/20221118214838_AddTokenExpiryTimeToUser.cs b/Migrations/20221118214838_AddTokenExpiryTimeToUser.cs deleted file mode 100644 index 065483a..0000000 --- a/Migrations/20221118214838_AddTokenExpiryTimeToUser.cs +++ /dev/null @@ -1,89 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; - -#nullable disable - -namespace BackendPIA.Migrations -{ - /// <inheritdoc /> - public partial class AddTokenExpiryTimeToUser : Migration - { - /// <inheritdoc /> - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.DeleteData( - table: "AspNetUserRoles", - keyColumns: new[] { "RoleId", "UserId" }, - keyValues: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec" }); - - migrationBuilder.DeleteData( - table: "AspNetRoles", - keyColumn: "Id", - keyValue: "24edc3d6-bf9c-41a1-9371-224e4419ccb0"); - - migrationBuilder.DeleteData( - table: "AspNetUsers", - keyColumn: "Id", - keyValue: "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec"); - - migrationBuilder.AddColumn<DateTime>( - name: "SessionTokenExpiryTime", - table: "AspNetUsers", - type: "timestamp with time zone", - nullable: true); - - migrationBuilder.InsertData( - table: "AspNetRoles", - columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" }, - values: new object[] { "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", "Administrator", "ADMINISTRATOR" }); - - migrationBuilder.InsertData( - table: "AspNetUsers", - columns: new[] { "Id", "AccessFailedCount", "ConcurrencyStamp", "Email", "EmailConfirmed", "LockoutEnabled", "LockoutEnd", "NormalizedEmail", "NormalizedUserName", "PasswordHash", "PhoneNumber", "PhoneNumberConfirmed", "SecurityStamp", "SessionToken", "SessionTokenExpiryTime", "TwoFactorEnabled", "UserName" }, - values: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", 0, "bd624bcb-3f06-4bce-b924-2666f82e5f23", "admin@example.com", false, false, null, "ADMIN@EXAMPLE.COM", "ADMIN", "AQAAAAIAAYagAAAAEL19rXYOEkR3ftL+T5E5vlsLGPu3HSnJuTSLNp/nyffvQvaXlNJFqU1UO3VKB+K6yg==", null, false, "282566ca-8a3b-4310-8e61-8380d16fa07e", null, null, false, "admin" }); - - migrationBuilder.InsertData( - table: "AspNetUserRoles", - columns: new[] { "RoleId", "UserId" }, - values: new object[] { "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", "24edc3d6-bf9c-41a1-9371-224e4419ccb0" }); - } - - /// <inheritdoc /> - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DeleteData( - table: "AspNetUserRoles", - keyColumns: new[] { "RoleId", "UserId" }, - keyValues: new object[] { "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", "24edc3d6-bf9c-41a1-9371-224e4419ccb0" }); - - migrationBuilder.DeleteData( - table: "AspNetRoles", - keyColumn: "Id", - keyValue: "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec"); - - migrationBuilder.DeleteData( - table: "AspNetUsers", - keyColumn: "Id", - keyValue: "24edc3d6-bf9c-41a1-9371-224e4419ccb0"); - - migrationBuilder.DropColumn( - name: "SessionTokenExpiryTime", - table: "AspNetUsers"); - - migrationBuilder.InsertData( - table: "AspNetRoles", - columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" }, - values: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "Administrator", "ADMINISTRATOR" }); - - migrationBuilder.InsertData( - table: "AspNetUsers", - columns: new[] { "Id", "AccessFailedCount", "ConcurrencyStamp", "Email", "EmailConfirmed", "LockoutEnabled", "LockoutEnd", "NormalizedEmail", "NormalizedUserName", "PasswordHash", "PhoneNumber", "PhoneNumberConfirmed", "SecurityStamp", "SessionToken", "TwoFactorEnabled", "UserName" }, - values: new object[] { "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", 0, "8bbb8fce-308b-4822-97e1-5741fc955a90", "admin@example.com", false, false, null, "ADMIN@EXAMPLE.COM", "ADMIN", "AQAAAAIAAYagAAAAEENVY01/0BOrBai8zaioq9GOr+ftYIZhUBtulPtda1tTREUCOeVst9cnrB7Ogz4Bsg==", null, false, "5a1e1053-690e-4610-ab66-7a86fe2e04c8", null, false, "admin" }); - - migrationBuilder.InsertData( - table: "AspNetUserRoles", - columns: new[] { "RoleId", "UserId" }, - values: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec" }); - } - } -} diff --git a/Migrations/20221118044105_InitialMigration.Designer.cs b/Migrations/20221121000226_InitialMigration.Designer.cs index cd7ec30..6e28404 100644 --- a/Migrations/20221118044105_InitialMigration.Designer.cs +++ b/Migrations/20221121000226_InitialMigration.Designer.cs @@ -12,7 +12,7 @@ using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; namespace BackendPIA.Migrations { [DbContext(typeof(ApplicationDbContext))] - [Migration("20221118044105_InitialMigration")] + [Migration("20221121000226_InitialMigration")] partial class InitialMigration { /// <inheritdoc /> @@ -74,6 +74,9 @@ namespace BackendPIA.Migrations .HasMaxLength(64) .HasColumnType("character varying(64)"); + b.Property<DateTime?>("SessionTokenExpiryTime") + .HasColumnType("timestamp with time zone"); + b.Property<bool>("TwoFactorEnabled") .HasColumnType("boolean"); @@ -91,24 +94,6 @@ namespace BackendPIA.Migrations .HasDatabaseName("UserNameIndex"); b.ToTable("AspNetUsers", (string)null); - - b.HasData( - new - { - Id = "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", - AccessFailedCount = 0, - ConcurrencyStamp = "8bbb8fce-308b-4822-97e1-5741fc955a90", - Email = "admin@example.com", - EmailConfirmed = false, - LockoutEnabled = false, - NormalizedEmail = "ADMIN@EXAMPLE.COM", - NormalizedUserName = "ADMIN", - PasswordHash = "AQAAAAIAAYagAAAAEENVY01/0BOrBai8zaioq9GOr+ftYIZhUBtulPtda1tTREUCOeVst9cnrB7Ogz4Bsg==", - PhoneNumberConfirmed = false, - SecurityStamp = "5a1e1053-690e-4610-ab66-7a86fe2e04c8", - TwoFactorEnabled = false, - UserName = "admin" - }); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b => @@ -135,15 +120,6 @@ namespace BackendPIA.Migrations .HasDatabaseName("RoleNameIndex"); b.ToTable("AspNetRoles", (string)null); - - b.HasData( - new - { - Id = "24edc3d6-bf9c-41a1-9371-224e4419ccb0", - ConcurrencyStamp = "24edc3d6-bf9c-41a1-9371-224e4419ccb0", - Name = "Administrator", - NormalizedName = "ADMINISTRATOR" - }); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b => @@ -231,13 +207,6 @@ namespace BackendPIA.Migrations b.HasIndex("RoleId"); b.ToTable("AspNetUserRoles", (string)null); - - b.HasData( - new - { - UserId = "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", - RoleId = "24edc3d6-bf9c-41a1-9371-224e4419ccb0" - }); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b => diff --git a/Migrations/20221118044105_InitialMigration.cs b/Migrations/20221121000226_InitialMigration.cs index 44452b9..3b23faa 100644 --- a/Migrations/20221118044105_InitialMigration.cs +++ b/Migrations/20221121000226_InitialMigration.cs @@ -32,6 +32,7 @@ namespace BackendPIA.Migrations { Id = table.Column<string>(type: "text", nullable: false), SessionToken = table.Column<string>(type: "character varying(64)", maxLength: 64, nullable: true), + SessionTokenExpiryTime = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), UserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true), NormalizedUserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true), Email = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true), @@ -158,21 +159,6 @@ namespace BackendPIA.Migrations onDelete: ReferentialAction.Cascade); }); - migrationBuilder.InsertData( - table: "AspNetRoles", - columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" }, - values: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "Administrator", "ADMINISTRATOR" }); - - migrationBuilder.InsertData( - table: "AspNetUsers", - columns: new[] { "Id", "AccessFailedCount", "ConcurrencyStamp", "Email", "EmailConfirmed", "LockoutEnabled", "LockoutEnd", "NormalizedEmail", "NormalizedUserName", "PasswordHash", "PhoneNumber", "PhoneNumberConfirmed", "SecurityStamp", "SessionToken", "TwoFactorEnabled", "UserName" }, - values: new object[] { "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec", 0, "8bbb8fce-308b-4822-97e1-5741fc955a90", "admin@example.com", false, false, null, "ADMIN@EXAMPLE.COM", "ADMIN", "AQAAAAIAAYagAAAAEENVY01/0BOrBai8zaioq9GOr+ftYIZhUBtulPtda1tTREUCOeVst9cnrB7Ogz4Bsg==", null, false, "5a1e1053-690e-4610-ab66-7a86fe2e04c8", null, false, "admin" }); - - migrationBuilder.InsertData( - table: "AspNetUserRoles", - columns: new[] { "RoleId", "UserId" }, - values: new object[] { "24edc3d6-bf9c-41a1-9371-224e4419ccb0", "d42006bc-7f69-4aa4-b247-eb9e2abfe0ec" }); - migrationBuilder.CreateIndex( name: "IX_AspNetRoleClaims_RoleId", table: "AspNetRoleClaims", |