summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--Migrations/20221118214838_AddTokenExpiryTimeToUser.Designer.cs318
-rw-r--r--Migrations/20221118214838_AddTokenExpiryTimeToUser.cs89
-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",
generated by cgit v1.2.3 (git 2.39.1) at 2024-10-18 12:24:32 +0000