aboutsummaryrefslogtreecommitdiffstats
path: root/server/src/Migrations
diff options
context:
space:
mode:
authorivarlovlie <git@ivarlovlie.no>2022-10-05 14:45:21 +0200
committerivarlovlie <git@ivarlovlie.no>2022-10-05 14:45:21 +0200
commitb7e39b59fd0fc7b5610ebff29035bf622079e0d8 (patch)
tree64be84ebbdac9f7ceced983390c53b10d575af5c /server/src/Migrations
parent2001c035fbb417ab0a3d42cfb04d17420bde4086 (diff)
downloadgreatoffice-b7e39b59fd0fc7b5610ebff29035bf622079e0d8.tar.xz
greatoffice-b7e39b59fd0fc7b5610ebff29035bf622079e0d8.zip
refactor: Change file structure
Diffstat (limited to 'server/src/Migrations')
-rw-r--r--server/src/Migrations/20210517202115_InitialMigration.Designer.cs238
-rw-r--r--server/src/Migrations/20210517202115_InitialMigration.cs162
-rw-r--r--server/src/Migrations/20210522165932_RenameNoteToDescription.Designer.cs229
-rw-r--r--server/src/Migrations/20210522165932_RenameNoteToDescription.cs34
-rw-r--r--server/src/Migrations/20211002113037_V6Migration.Designer.cs233
-rw-r--r--server/src/Migrations/20211002113037_V6Migration.cs130
-rw-r--r--server/src/Migrations/20220225143559_GithubUserMappings.Designer.cs270
-rw-r--r--server/src/Migrations/20220225143559_GithubUserMappings.cs43
-rw-r--r--server/src/Migrations/20220319135910_RenameCreated.Designer.cs270
-rw-r--r--server/src/Migrations/20220319135910_RenameCreated.cs65
-rw-r--r--server/src/Migrations/20220319144958_ModifiedAt.Designer.cs290
-rw-r--r--server/src/Migrations/20220319144958_ModifiedAt.cs66
-rw-r--r--server/src/Migrations/20220319203018_UserBase.Designer.cs322
-rw-r--r--server/src/Migrations/20220319203018_UserBase.cs140
-rw-r--r--server/src/Migrations/20220320115601_Update1.Designer.cs342
-rw-r--r--server/src/Migrations/20220320115601_Update1.cs139
-rw-r--r--server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.Designer.cs344
-rw-r--r--server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.cs57
-rw-r--r--server/src/Migrations/20220529190359_ApiAccessTokens.Designer.cs401
-rw-r--r--server/src/Migrations/20220529190359_ApiAccessTokens.cs48
-rw-r--r--server/src/Migrations/20220530174741_Tenants.Designer.cs710
-rw-r--r--server/src/Migrations/20220530174741_Tenants.cs481
-rw-r--r--server/src/Migrations/20220530175322_RemoveUnusedNavs.Designer.cs686
-rw-r--r--server/src/Migrations/20220530175322_RemoveUnusedNavs.cs78
-rw-r--r--server/src/Migrations/20220602214238_NullableOptionalBaseFields.Designer.cs656
-rw-r--r--server/src/Migrations/20220602214238_NullableOptionalBaseFields.cs649
-rw-r--r--server/src/Migrations/20220606232346_FleshOutNewModules.Designer.cs510
-rw-r--r--server/src/Migrations/20220606232346_FleshOutNewModules.cs630
-rw-r--r--server/src/Migrations/20220616170311_DataProtectionKeys.Designer.cs533
-rw-r--r--server/src/Migrations/20220616170311_DataProtectionKeys.cs33
-rw-r--r--server/src/Migrations/20220819203816_RemoveGithubUsers.Designer.cs496
-rw-r--r--server/src/Migrations/20220819203816_RemoveGithubUsers.cs43
-rw-r--r--server/src/Migrations/AppDbContextModelSnapshot.cs494
33 files changed, 0 insertions, 9822 deletions
diff --git a/server/src/Migrations/20210517202115_InitialMigration.Designer.cs b/server/src/Migrations/20210517202115_InitialMigration.Designer.cs
deleted file mode 100644
index b6a01ff..0000000
--- a/server/src/Migrations/20210517202115_InitialMigration.Designer.cs
+++ /dev/null
@@ -1,238 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20210517202115_InitialMigration")]
- partial class InitialMigration
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("Relational:MaxIdentifierLength", 63)
- .HasAnnotation("ProductVersion", "5.0.6")
- .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("note");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users");
-
- b.HasData(
- new
- {
- Id = new Guid("784938f0-cc0e-46ec-afa6-fc60b47b28db"),
- Created = new DateTime(2021, 5, 17, 20, 21, 14, 827, DateTimeKind.Utc).AddTicks(4868),
- Password = "AAAAAAEAACcQAAAAEJdtrX3pEeIbcgY+BDAr56gvfbc420ag1TllA0cK6Q6Gw3+gGDIQtYIZnisW3dmqaQ==",
- Username = "admin@ivarlovlie.no"
- });
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20210517202115_InitialMigration.cs b/server/src/Migrations/20210517202115_InitialMigration.cs
deleted file mode 100644
index 8bfaf61..0000000
--- a/server/src/Migrations/20210517202115_InitialMigration.cs
+++ /dev/null
@@ -1,162 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class InitialMigration : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "time_categories",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- name = table.Column<string>(type: "text", nullable: true),
- color = table.Column<string>(type: "text", nullable: true),
- user_id = table.Column<Guid>(type: "uuid", nullable: false),
- created = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_time_categories", x => x.id);
- });
-
- migrationBuilder.CreateTable(
- name: "time_labels",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- name = table.Column<string>(type: "text", nullable: true),
- color = table.Column<string>(type: "text", nullable: true),
- user_id = table.Column<Guid>(type: "uuid", nullable: false),
- created = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_time_labels", x => x.id);
- });
-
- migrationBuilder.CreateTable(
- name: "users",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- username = table.Column<string>(type: "text", nullable: true),
- password = table.Column<string>(type: "text", nullable: true),
- created = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_users", x => x.id);
- });
-
- migrationBuilder.CreateTable(
- name: "time_entries",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- start = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
- stop = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
- note = table.Column<string>(type: "text", nullable: true),
- user_id = table.Column<Guid>(type: "uuid", nullable: false),
- category_id = table.Column<Guid>(type: "uuid", nullable: true),
- created = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_time_entries", x => x.id);
- table.ForeignKey(
- name: "fk_time_entries_time_categories_category_id",
- column: x => x.category_id,
- principalTable: "time_categories",
- principalColumn: "id",
- onDelete: ReferentialAction.Restrict);
- });
-
- migrationBuilder.CreateTable(
- name: "forgot_password_requests",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- user_id = table.Column<Guid>(type: "uuid", nullable: true),
- created = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_forgot_password_requests", x => x.id);
- table.ForeignKey(
- name: "fk_forgot_password_requests_users_user_id",
- column: x => x.user_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Restrict);
- });
-
- migrationBuilder.CreateTable(
- name: "time_entry_time_label",
- columns: table => new
- {
- entries_id = table.Column<Guid>(type: "uuid", nullable: false),
- labels_id = table.Column<Guid>(type: "uuid", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_time_entry_time_label", x => new { x.entries_id, x.labels_id });
- table.ForeignKey(
- name: "fk_time_entry_time_label_time_entries_entries_id",
- column: x => x.entries_id,
- principalTable: "time_entries",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_time_entry_time_label_time_labels_labels_id",
- column: x => x.labels_id,
- principalTable: "time_labels",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.InsertData(
- table: "users",
- columns: new[] { "id", "created", "password", "username" },
- values: new object[] { new Guid("784938f0-cc0e-46ec-afa6-fc60b47b28db"), new DateTime(2021, 5, 17, 20, 21, 14, 827, DateTimeKind.Utc).AddTicks(4868), "AAAAAAEAACcQAAAAEJdtrX3pEeIbcgY+BDAr56gvfbc420ag1TllA0cK6Q6Gw3+gGDIQtYIZnisW3dmqaQ==", "admin@ivarlovlie.no" });
-
- migrationBuilder.CreateIndex(
- name: "ix_forgot_password_requests_user_id",
- table: "forgot_password_requests",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_category_id",
- table: "time_entries",
- column: "category_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entry_time_label_labels_id",
- table: "time_entry_time_label",
- column: "labels_id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "forgot_password_requests");
-
- migrationBuilder.DropTable(
- name: "time_entry_time_label");
-
- migrationBuilder.DropTable(
- name: "users");
-
- migrationBuilder.DropTable(
- name: "time_entries");
-
- migrationBuilder.DropTable(
- name: "time_labels");
-
- migrationBuilder.DropTable(
- name: "time_categories");
- }
- }
-}
diff --git a/server/src/Migrations/20210522165932_RenameNoteToDescription.Designer.cs b/server/src/Migrations/20210522165932_RenameNoteToDescription.Designer.cs
deleted file mode 100644
index 368e6b3..0000000
--- a/server/src/Migrations/20210522165932_RenameNoteToDescription.Designer.cs
+++ /dev/null
@@ -1,229 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20210522165932_RenameNoteToDescription")]
- partial class RenameNoteToDescription
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("Relational:MaxIdentifierLength", 63)
- .HasAnnotation("ProductVersion", "5.0.6")
- .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("created");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("created");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp without time zone")
- .HasColumnName("created");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20210522165932_RenameNoteToDescription.cs b/server/src/Migrations/20210522165932_RenameNoteToDescription.cs
deleted file mode 100644
index e5bae54..0000000
--- a/server/src/Migrations/20210522165932_RenameNoteToDescription.cs
+++ /dev/null
@@ -1,34 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class RenameNoteToDescription : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DeleteData(
- table: "users",
- keyColumn: "id",
- keyValue: new Guid("784938f0-cc0e-46ec-afa6-fc60b47b28db"));
-
- migrationBuilder.RenameColumn(
- name: "note",
- table: "time_entries",
- newName: "description");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.RenameColumn(
- name: "description",
- table: "time_entries",
- newName: "note");
-
- migrationBuilder.InsertData(
- table: "users",
- columns: new[] { "id", "created", "password", "username" },
- values: new object[] { new Guid("784938f0-cc0e-46ec-afa6-fc60b47b28db"), new DateTime(2021, 5, 17, 20, 21, 14, 827, DateTimeKind.Utc).AddTicks(4868), "AAAAAAEAACcQAAAAEJdtrX3pEeIbcgY+BDAr56gvfbc420ag1TllA0cK6Q6Gw3+gGDIQtYIZnisW3dmqaQ==", "admin@ivarlovlie.no" });
- }
- }
-}
diff --git a/server/src/Migrations/20211002113037_V6Migration.Designer.cs b/server/src/Migrations/20211002113037_V6Migration.Designer.cs
deleted file mode 100644
index 59e6112..0000000
--- a/server/src/Migrations/20211002113037_V6Migration.Designer.cs
+++ /dev/null
@@ -1,233 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20211002113037_V6Migration")]
- partial class V6Migration
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.0-rc.1.21452.10")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20211002113037_V6Migration.cs b/server/src/Migrations/20211002113037_V6Migration.cs
deleted file mode 100644
index c7ac971..0000000
--- a/server/src/Migrations/20211002113037_V6Migration.cs
+++ /dev/null
@@ -1,130 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class V6Migration : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.Sql("SET TimeZone='UTC'");
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "users",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_labels",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "stop",
- table: "time_entries",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "start",
- table: "time_entries",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_entries",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_categories",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "forgot_password_requests",
- type: "timestamp with time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp without time zone");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.Sql("SET TimeZone='UTC'");
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "users",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_labels",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "stop",
- table: "time_entries",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "start",
- table: "time_entries",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_entries",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "time_categories",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
-
- migrationBuilder.AlterColumn<DateTime>(
- name: "created",
- table: "forgot_password_requests",
- type: "timestamp without time zone",
- nullable: false,
- oldClrType: typeof(DateTime),
- oldType: "timestamp with time zone");
- }
- }
-}
diff --git a/server/src/Migrations/20220225143559_GithubUserMappings.Designer.cs b/server/src/Migrations/20220225143559_GithubUserMappings.Designer.cs
deleted file mode 100644
index 2b95f9d..0000000
--- a/server/src/Migrations/20220225143559_GithubUserMappings.Designer.cs
+++ /dev/null
@@ -1,270 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220225143559_GithubUserMappings")]
- partial class GithubUserMappings
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.2")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("Created")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220225143559_GithubUserMappings.cs b/server/src/Migrations/20220225143559_GithubUserMappings.cs
deleted file mode 100644
index fc30c7a..0000000
--- a/server/src/Migrations/20220225143559_GithubUserMappings.cs
+++ /dev/null
@@ -1,43 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class GithubUserMappings : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "github_user_mappings",
- columns: table => new
- {
- github_id = table.Column<string>(type: "text", nullable: false),
- user_id = table.Column<Guid>(type: "uuid", nullable: true),
- email = table.Column<string>(type: "text", nullable: true),
- refresh_token = table.Column<string>(type: "text", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_github_user_mappings", x => x.github_id);
- table.ForeignKey(
- name: "fk_github_user_mappings_users_user_id",
- column: x => x.user_id,
- principalTable: "users",
- principalColumn: "id");
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_github_user_mappings_user_id",
- table: "github_user_mappings",
- column: "user_id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "github_user_mappings");
- }
- }
-}
diff --git a/server/src/Migrations/20220319135910_RenameCreated.Designer.cs b/server/src/Migrations/20220319135910_RenameCreated.Designer.cs
deleted file mode 100644
index 3d57f1a..0000000
--- a/server/src/Migrations/20220319135910_RenameCreated.Designer.cs
+++ /dev/null
@@ -1,270 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220319135910_RenameCreated")]
- partial class RenameCreated
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220319135910_RenameCreated.cs b/server/src/Migrations/20220319135910_RenameCreated.cs
deleted file mode 100644
index 6571e50..0000000
--- a/server/src/Migrations/20220319135910_RenameCreated.cs
+++ /dev/null
@@ -1,65 +0,0 @@
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class RenameCreated : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.RenameColumn(
- name: "created",
- table: "users",
- newName: "created_at");
-
- migrationBuilder.RenameColumn(
- name: "created",
- table: "time_labels",
- newName: "created_at");
-
- migrationBuilder.RenameColumn(
- name: "created",
- table: "time_entries",
- newName: "created_at");
-
- migrationBuilder.RenameColumn(
- name: "created",
- table: "time_categories",
- newName: "created_at");
-
- migrationBuilder.RenameColumn(
- name: "created",
- table: "forgot_password_requests",
- newName: "created_at");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.RenameColumn(
- name: "created_at",
- table: "users",
- newName: "created");
-
- migrationBuilder.RenameColumn(
- name: "created_at",
- table: "time_labels",
- newName: "created");
-
- migrationBuilder.RenameColumn(
- name: "created_at",
- table: "time_entries",
- newName: "created");
-
- migrationBuilder.RenameColumn(
- name: "created_at",
- table: "time_categories",
- newName: "created");
-
- migrationBuilder.RenameColumn(
- name: "created_at",
- table: "forgot_password_requests",
- newName: "created");
- }
- }
-}
diff --git a/server/src/Migrations/20220319144958_ModifiedAt.Designer.cs b/server/src/Migrations/20220319144958_ModifiedAt.Designer.cs
deleted file mode 100644
index f75400e..0000000
--- a/server/src/Migrations/20220319144958_ModifiedAt.Designer.cs
+++ /dev/null
@@ -1,290 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220319144958_ModifiedAt")]
- partial class ModifiedAt
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220319144958_ModifiedAt.cs b/server/src/Migrations/20220319144958_ModifiedAt.cs
deleted file mode 100644
index 028473d..0000000
--- a/server/src/Migrations/20220319144958_ModifiedAt.cs
+++ /dev/null
@@ -1,66 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class ModifiedAt : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "users",
- type: "timestamp with time zone",
- nullable: true);
-
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "time_labels",
- type: "timestamp with time zone",
- nullable: true);
-
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "time_entries",
- type: "timestamp with time zone",
- nullable: true);
-
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "time_categories",
- type: "timestamp with time zone",
- nullable: true);
-
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "forgot_password_requests",
- type: "timestamp with time zone",
- nullable: true);
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "users");
-
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "forgot_password_requests");
- }
- }
-}
diff --git a/server/src/Migrations/20220319203018_UserBase.Designer.cs b/server/src/Migrations/20220319203018_UserBase.Designer.cs
deleted file mode 100644
index 6c7a76f..0000000
--- a/server/src/Migrations/20220319203018_UserBase.Designer.cs
+++ /dev/null
@@ -1,322 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220319203018_UserBase")]
- partial class UserBase
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.Property<string>("password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220319203018_UserBase.cs b/server/src/Migrations/20220319203018_UserBase.cs
deleted file mode 100644
index 14d3f4b..0000000
--- a/server/src/Migrations/20220319203018_UserBase.cs
+++ /dev/null
@@ -1,140 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class UserBase : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropColumn(
- name: "modified_at",
- table: "forgot_password_requests");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_user_id",
- table: "time_labels",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_user_id",
- table: "time_entries",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_user_id",
- table: "time_categories",
- column: "user_id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_user_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_user_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_user_id",
- table: "time_categories");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AddColumn<DateTime>(
- name: "modified_at",
- table: "forgot_password_requests",
- type: "timestamp with time zone",
- nullable: true);
- }
- }
-}
diff --git a/server/src/Migrations/20220320115601_Update1.Designer.cs b/server/src/Migrations/20220320115601_Update1.Designer.cs
deleted file mode 100644
index c7463fb..0000000
--- a/server/src/Migrations/20220320115601_Update1.Designer.cs
+++ /dev/null
@@ -1,342 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220320115601_Update1")]
- partial class Update1
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.Property<string>("password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Categories")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany("Entries")
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Entries")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Labels")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Navigation("Entries");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Navigation("Categories");
-
- b.Navigation("Entries");
-
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220320115601_Update1.cs b/server/src/Migrations/20220320115601_Update1.cs
deleted file mode 100644
index 8b06fb7..0000000
--- a/server/src/Migrations/20220320115601_Update1.cs
+++ /dev/null
@@ -1,139 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class Update1 : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
- }
- }
-}
diff --git a/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.Designer.cs b/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.Designer.cs
deleted file mode 100644
index 3a18463..0000000
--- a/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.Designer.cs
+++ /dev/null
@@ -1,344 +0,0 @@
-// <auto-generated />
-
-
-#nullable disable
-
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220320132220_UpdatedForgotPasswordRequests")]
- partial class UpdatedForgotPasswordRequests
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Categories")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category")
- .WithMany("Entries")
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Entries")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.User", "User")
- .WithMany("Labels")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b =>
- {
- b.Navigation("Entries");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b =>
- {
- b.Navigation("Categories");
-
- b.Navigation("Entries");
-
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.cs b/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.cs
deleted file mode 100644
index df7a195..0000000
--- a/server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.cs
+++ /dev/null
@@ -1,57 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class UpdatedForgotPasswordRequests : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_forgot_password_requests_users_user_id",
- table: "forgot_password_requests");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "forgot_password_requests",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AddForeignKey(
- name: "fk_forgot_password_requests_users_user_id",
- table: "forgot_password_requests",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_forgot_password_requests_users_user_id",
- table: "forgot_password_requests");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "forgot_password_requests",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddForeignKey(
- name: "fk_forgot_password_requests_users_user_id",
- table: "forgot_password_requests",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id");
- }
- }
-}
diff --git a/server/src/Migrations/20220529190359_ApiAccessTokens.Designer.cs b/server/src/Migrations/20220529190359_ApiAccessTokens.Designer.cs
deleted file mode 100644
index 74f9b40..0000000
--- a/server/src/Migrations/20220529190359_ApiAccessTokens.Designer.cs
+++ /dev/null
@@ -1,401 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220529190359_ApiAccessTokens")]
- partial class ApiAccessTokens
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany("Categories")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany("Entries")
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany("Entries")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany("Labels")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Navigation("Entries");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Navigation("Categories");
-
- b.Navigation("Entries");
-
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220529190359_ApiAccessTokens.cs b/server/src/Migrations/20220529190359_ApiAccessTokens.cs
deleted file mode 100644
index dc44bee..0000000
--- a/server/src/Migrations/20220529190359_ApiAccessTokens.cs
+++ /dev/null
@@ -1,48 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class ApiAccessTokens : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "api_access_tokens",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- user_id = table.Column<Guid>(type: "uuid", nullable: true),
- expiry_date = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
- allow_read = table.Column<bool>(type: "boolean", nullable: false),
- allow_create = table.Column<bool>(type: "boolean", nullable: false),
- allow_update = table.Column<bool>(type: "boolean", nullable: false),
- allow_delete = table.Column<bool>(type: "boolean", nullable: false),
- created_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
- modified_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_api_access_tokens", x => x.id);
- table.ForeignKey(
- name: "fk_api_access_tokens_users_user_id",
- column: x => x.user_id,
- principalTable: "users",
- principalColumn: "id");
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_api_access_tokens_user_id",
- table: "api_access_tokens",
- column: "user_id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "api_access_tokens");
- }
- }
-}
diff --git a/server/src/Migrations/20220530174741_Tenants.Designer.cs b/server/src/Migrations/20220530174741_Tenants.Designer.cs
deleted file mode 100644
index 678c52d..0000000
--- a/server/src/Migrations/20220530174741_Tenants.Designer.cs
+++ /dev/null
@@ -1,710 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220530174741_Tenants")]
- partial class Tenants
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TenantId1")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id1");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_tenants_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_tenants_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_tenants_modified_by_id");
-
- b.HasIndex("TenantId1")
- .HasDatabaseName("ix_tenants_tenant_id1");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_tenants_user_id");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_categories_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_categories_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_categories_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_categories_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_entries_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_entries_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_entries_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_entries_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_labels_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_labels_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_labels_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_labels_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.Property<Guid>("EntriesId")
- .HasColumnType("uuid")
- .HasColumnName("entries_id");
-
- b.Property<Guid>("LabelsId")
- .HasColumnType("uuid")
- .HasColumnName("labels_id");
-
- b.HasKey("EntriesId", "LabelsId")
- .HasName("pk_time_entry_time_label");
-
- b.HasIndex("LabelsId")
- .HasDatabaseName("ix_time_entry_time_label_labels_id");
-
- b.ToTable("time_entry_time_label", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId1")
- .HasConstraintName("fk_tenants_tenants_tenant_id1");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany("Entries")
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("TimeEntryTimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany()
- .HasForeignKey("EntriesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeLabel", null)
- .WithMany()
- .HasForeignKey("LabelsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Navigation("Entries");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220530174741_Tenants.cs b/server/src/Migrations/20220530174741_Tenants.cs
deleted file mode 100644
index ea02ddd..0000000
--- a/server/src/Migrations/20220530174741_Tenants.cs
+++ /dev/null
@@ -1,481 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class Tenants : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.AddColumn<Guid>(
- name: "created_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "deleted_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "modified_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "tenant_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "created_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "deleted_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "modified_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "tenant_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "created_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "deleted_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "modified_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.AddColumn<Guid>(
- name: "tenant_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"));
-
- migrationBuilder.CreateTable(
- name: "tenants",
- columns: table => new
- {
- id = table.Column<Guid>(type: "uuid", nullable: false),
- name = table.Column<string>(type: "text", nullable: true),
- description = table.Column<string>(type: "text", nullable: true),
- contact_email = table.Column<string>(type: "text", nullable: true),
- master_user_id = table.Column<Guid>(type: "uuid", nullable: false),
- master_user_password = table.Column<string>(type: "text", nullable: true),
- created_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
- modified_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
- user_id = table.Column<Guid>(type: "uuid", nullable: false),
- tenant_id = table.Column<Guid>(type: "uuid", nullable: false),
- tenant_id1 = table.Column<Guid>(type: "uuid", nullable: true),
- modified_by_id = table.Column<Guid>(type: "uuid", nullable: false),
- created_by_id = table.Column<Guid>(type: "uuid", nullable: false),
- deleted_by_id = table.Column<Guid>(type: "uuid", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_tenants", x => x.id);
- table.ForeignKey(
- name: "fk_tenants_tenants_tenant_id1",
- column: x => x.tenant_id1,
- principalTable: "tenants",
- principalColumn: "id");
- table.ForeignKey(
- name: "fk_tenants_users_created_by_id",
- column: x => x.created_by_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- column: x => x.deleted_by_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_tenants_users_modified_by_id",
- column: x => x.modified_by_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_tenants_users_user_id",
- column: x => x.user_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_created_by_id",
- table: "time_labels",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_modified_by_id",
- table: "time_labels",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_tenant_id",
- table: "time_labels",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_created_by_id",
- table: "time_entries",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_modified_by_id",
- table: "time_entries",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_tenant_id",
- table: "time_entries",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_created_by_id",
- table: "time_categories",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_modified_by_id",
- table: "time_categories",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_tenant_id",
- table: "time_categories",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_created_by_id",
- table: "tenants",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_deleted_by_id",
- table: "tenants",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_modified_by_id",
- table: "tenants",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_tenant_id1",
- table: "tenants",
- column: "tenant_id1");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_user_id",
- table: "tenants",
- column: "user_id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.DropTable(
- name: "tenants");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "modified_by_id",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "tenant_id",
- table: "time_categories");
- }
- }
-}
diff --git a/server/src/Migrations/20220530175322_RemoveUnusedNavs.Designer.cs b/server/src/Migrations/20220530175322_RemoveUnusedNavs.Designer.cs
deleted file mode 100644
index 8fd6b40..0000000
--- a/server/src/Migrations/20220530175322_RemoveUnusedNavs.Designer.cs
+++ /dev/null
@@ -1,686 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220530175322_RemoveUnusedNavs")]
- partial class RemoveUnusedNavs
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TenantId1")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id1");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_tenants_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_tenants_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_tenants_modified_by_id");
-
- b.HasIndex("TenantId1")
- .HasDatabaseName("ix_tenants_tenant_id1");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_tenants_user_id");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_categories_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_categories_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_categories_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_categories_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_entries_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_entries_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_entries_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_entries_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_labels_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_labels_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_labels_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_labels_tenant_id");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId1")
- .HasConstraintName("fk_tenants_tenants_tenant_id1");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220530175322_RemoveUnusedNavs.cs b/server/src/Migrations/20220530175322_RemoveUnusedNavs.cs
deleted file mode 100644
index 36b3cf1..0000000
--- a/server/src/Migrations/20220530175322_RemoveUnusedNavs.cs
+++ /dev/null
@@ -1,78 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class RemoveUnusedNavs : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "time_entry_time_label");
-
- migrationBuilder.AddColumn<Guid>(
- name: "time_entry_id",
- table: "time_labels",
- type: "uuid",
- nullable: true);
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_time_entry_id",
- table: "time_labels",
- column: "time_entry_id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_time_entries_time_entry_id",
- table: "time_labels",
- column: "time_entry_id",
- principalTable: "time_entries",
- principalColumn: "id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_time_entries_time_entry_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_time_entry_id",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "time_entry_id",
- table: "time_labels");
-
- migrationBuilder.CreateTable(
- name: "time_entry_time_label",
- columns: table => new
- {
- entries_id = table.Column<Guid>(type: "uuid", nullable: false),
- labels_id = table.Column<Guid>(type: "uuid", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_time_entry_time_label", x => new { x.entries_id, x.labels_id });
- table.ForeignKey(
- name: "fk_time_entry_time_label_time_entries_entries_id",
- column: x => x.entries_id,
- principalTable: "time_entries",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_time_entry_time_label_time_labels_labels_id",
- column: x => x.labels_id,
- principalTable: "time_labels",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entry_time_label_labels_id",
- table: "time_entry_time_label",
- column: "labels_id");
- }
- }
-}
diff --git a/server/src/Migrations/20220602214238_NullableOptionalBaseFields.Designer.cs b/server/src/Migrations/20220602214238_NullableOptionalBaseFields.Designer.cs
deleted file mode 100644
index a05b0e4..0000000
--- a/server/src/Migrations/20220602214238_NullableOptionalBaseFields.Designer.cs
+++ /dev/null
@@ -1,656 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220602214238_NullableOptionalBaseFields")]
- partial class NullableOptionalBaseFields
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TenantId1")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id1");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_tenants_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_tenants_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_tenants_modified_by_id");
-
- b.HasIndex("TenantId1")
- .HasDatabaseName("ix_tenants_tenant_id1");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_tenants_user_id");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_categories_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_categories_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_categories_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_categories_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_categories_user_id");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_entries_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_entries_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_entries_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_entries_tenant_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_entries_user_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("CreatedById")
- .HasDatabaseName("ix_time_labels_created_by_id");
-
- b.HasIndex("DeletedById")
- .HasDatabaseName("ix_time_labels_deleted_by_id");
-
- b.HasIndex("ModifiedById")
- .HasDatabaseName("ix_time_labels_modified_by_id");
-
- b.HasIndex("TenantId")
- .HasDatabaseName("ix_time_labels_tenant_id");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_time_labels_user_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .HasConstraintName("fk_tenants_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .HasConstraintName("fk_tenants_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .HasConstraintName("fk_tenants_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId1")
- .HasConstraintName("fk_tenants_tenants_tenant_id1");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenants_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .HasConstraintName("fk_time_categories_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .HasConstraintName("fk_time_categories_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .HasConstraintName("fk_time_categories_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .HasConstraintName("fk_time_categories_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_categories_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .HasConstraintName("fk_time_entries_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .HasConstraintName("fk_time_entries_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .HasConstraintName("fk_time_entries_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .HasConstraintName("fk_time_entries_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_entries_users_user_id");
-
- b.Navigation("Category");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "CreatedBy")
- .WithMany()
- .HasForeignKey("CreatedById")
- .HasConstraintName("fk_time_labels_users_created_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "DeletedBy")
- .WithMany()
- .HasForeignKey("DeletedById")
- .HasConstraintName("fk_time_labels_users_deleted_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "ModifiedBy")
- .WithMany()
- .HasForeignKey("ModifiedById")
- .HasConstraintName("fk_time_labels_users_modified_by_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "Tenant")
- .WithMany()
- .HasForeignKey("TenantId")
- .HasConstraintName("fk_time_labels_tenants_tenant_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_time_labels_users_user_id");
-
- b.Navigation("CreatedBy");
-
- b.Navigation("DeletedBy");
-
- b.Navigation("ModifiedBy");
-
- b.Navigation("Tenant");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220602214238_NullableOptionalBaseFields.cs b/server/src/Migrations/20220602214238_NullableOptionalBaseFields.cs
deleted file mode 100644
index eebab5c..0000000
--- a/server/src/Migrations/20220602214238_NullableOptionalBaseFields.cs
+++ /dev/null
@@ -1,649 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class NullableOptionalBaseFields : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "tenants",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "tenants",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "tenants",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "tenants",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "tenant_id",
- table: "tenants",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "modified_by_id",
- table: "tenants",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "deleted_by_id",
- table: "tenants",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "created_by_id",
- table: "tenants",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- }
- }
-}
diff --git a/server/src/Migrations/20220606232346_FleshOutNewModules.Designer.cs b/server/src/Migrations/20220606232346_FleshOutNewModules.Designer.cs
deleted file mode 100644
index 69d4f7e..0000000
--- a/server/src/Migrations/20220606232346_FleshOutNewModules.Designer.cs
+++ /dev/null
@@ -1,510 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220606232346_FleshOutNewModules")]
- partial class FleshOutNewModules
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("FirstName")
- .HasColumnType("text")
- .HasColumnName("first_name");
-
- b.Property<string>("LastName")
- .HasColumnType("text")
- .HasColumnName("last_name");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.Property<Guid>("TenantsId")
- .HasColumnType("uuid")
- .HasColumnName("tenants_id");
-
- b.Property<Guid>("UsersId")
- .HasColumnType("uuid")
- .HasColumnName("users_id");
-
- b.HasKey("TenantsId", "UsersId")
- .HasName("pk_tenant_user");
-
- b.HasIndex("UsersId")
- .HasDatabaseName("ix_tenant_user_users_id");
-
- b.ToTable("tenant_user", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", null)
- .WithMany()
- .HasForeignKey("TenantsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_tenants_tenants_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", null)
- .WithMany()
- .HasForeignKey("UsersId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_users_users_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220606232346_FleshOutNewModules.cs b/server/src/Migrations/20220606232346_FleshOutNewModules.cs
deleted file mode 100644
index 49a36b8..0000000
--- a/server/src/Migrations/20220606232346_FleshOutNewModules.cs
+++ /dev/null
@@ -1,630 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class FleshOutNewModules : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_tenants_tenant_id1",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_tenants_users_user_id",
- table: "tenants");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.DropForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_created_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_deleted_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_modified_by_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_tenant_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_labels_user_id",
- table: "time_labels");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_created_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_deleted_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_modified_by_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_tenant_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_entries_user_id",
- table: "time_entries");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_created_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_deleted_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_modified_by_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_tenant_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_time_categories_user_id",
- table: "time_categories");
-
- migrationBuilder.DropIndex(
- name: "ix_tenants_created_by_id",
- table: "tenants");
-
- migrationBuilder.DropIndex(
- name: "ix_tenants_deleted_by_id",
- table: "tenants");
-
- migrationBuilder.DropIndex(
- name: "ix_tenants_modified_by_id",
- table: "tenants");
-
- migrationBuilder.DropIndex(
- name: "ix_tenants_tenant_id1",
- table: "tenants");
-
- migrationBuilder.DropIndex(
- name: "ix_tenants_user_id",
- table: "tenants");
-
- migrationBuilder.DropColumn(
- name: "tenant_id1",
- table: "tenants");
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "users",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.AddColumn<string>(
- name: "email",
- table: "users",
- type: "text",
- nullable: true);
-
- migrationBuilder.AddColumn<string>(
- name: "first_name",
- table: "users",
- type: "text",
- nullable: true);
-
- migrationBuilder.AddColumn<string>(
- name: "last_name",
- table: "users",
- type: "text",
- nullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "time_labels",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "time_entries",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "time_categories",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "tenants",
- type: "uuid",
- nullable: true,
- oldClrType: typeof(Guid),
- oldType: "uuid");
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "tenants",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.AddColumn<bool>(
- name: "deleted",
- table: "api_access_tokens",
- type: "boolean",
- nullable: false,
- defaultValue: false);
-
- migrationBuilder.CreateTable(
- name: "tenant_user",
- columns: table => new
- {
- tenants_id = table.Column<Guid>(type: "uuid", nullable: false),
- users_id = table.Column<Guid>(type: "uuid", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_tenant_user", x => new { x.tenants_id, x.users_id });
- table.ForeignKey(
- name: "fk_tenant_user_tenants_tenants_id",
- column: x => x.tenants_id,
- principalTable: "tenants",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "fk_tenant_user_users_users_id",
- column: x => x.users_id,
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_tenant_user_users_id",
- table: "tenant_user",
- column: "users_id");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "tenant_user");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "users");
-
- migrationBuilder.DropColumn(
- name: "email",
- table: "users");
-
- migrationBuilder.DropColumn(
- name: "first_name",
- table: "users");
-
- migrationBuilder.DropColumn(
- name: "last_name",
- table: "users");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "time_labels");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "time_entries");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "time_categories");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "tenants");
-
- migrationBuilder.DropColumn(
- name: "deleted",
- table: "api_access_tokens");
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_labels",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_entries",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "time_categories",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AlterColumn<Guid>(
- name: "user_id",
- table: "tenants",
- type: "uuid",
- nullable: false,
- defaultValue: new Guid("00000000-0000-0000-0000-000000000000"),
- oldClrType: typeof(Guid),
- oldType: "uuid",
- oldNullable: true);
-
- migrationBuilder.AddColumn<Guid>(
- name: "tenant_id1",
- table: "tenants",
- type: "uuid",
- nullable: true);
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_created_by_id",
- table: "time_labels",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_modified_by_id",
- table: "time_labels",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_tenant_id",
- table: "time_labels",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_labels_user_id",
- table: "time_labels",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_created_by_id",
- table: "time_entries",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_modified_by_id",
- table: "time_entries",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_tenant_id",
- table: "time_entries",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_entries_user_id",
- table: "time_entries",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_created_by_id",
- table: "time_categories",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_modified_by_id",
- table: "time_categories",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_tenant_id",
- table: "time_categories",
- column: "tenant_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_time_categories_user_id",
- table: "time_categories",
- column: "user_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_created_by_id",
- table: "tenants",
- column: "created_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_deleted_by_id",
- table: "tenants",
- column: "deleted_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_modified_by_id",
- table: "tenants",
- column: "modified_by_id");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_tenant_id1",
- table: "tenants",
- column: "tenant_id1");
-
- migrationBuilder.CreateIndex(
- name: "ix_tenants_user_id",
- table: "tenants",
- column: "user_id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_tenants_tenant_id1",
- table: "tenants",
- column: "tenant_id1",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_created_by_id",
- table: "tenants",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_deleted_by_id",
- table: "tenants",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_modified_by_id",
- table: "tenants",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_tenants_users_user_id",
- table: "tenants",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_tenants_tenant_id",
- table: "time_categories",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_created_by_id",
- table: "time_categories",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_deleted_by_id",
- table: "time_categories",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_modified_by_id",
- table: "time_categories",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_categories_users_user_id",
- table: "time_categories",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_tenants_tenant_id",
- table: "time_entries",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_created_by_id",
- table: "time_entries",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_deleted_by_id",
- table: "time_entries",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_modified_by_id",
- table: "time_entries",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_entries_users_user_id",
- table: "time_entries",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_tenants_tenant_id",
- table: "time_labels",
- column: "tenant_id",
- principalTable: "tenants",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_created_by_id",
- table: "time_labels",
- column: "created_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_deleted_by_id",
- table: "time_labels",
- column: "deleted_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_modified_by_id",
- table: "time_labels",
- column: "modified_by_id",
- principalTable: "users",
- principalColumn: "id");
-
- migrationBuilder.AddForeignKey(
- name: "fk_time_labels_users_user_id",
- table: "time_labels",
- column: "user_id",
- principalTable: "users",
- principalColumn: "id",
- onDelete: ReferentialAction.Cascade);
- }
- }
-}
diff --git a/server/src/Migrations/20220616170311_DataProtectionKeys.Designer.cs b/server/src/Migrations/20220616170311_DataProtectionKeys.Designer.cs
deleted file mode 100644
index b333f23..0000000
--- a/server/src/Migrations/20220616170311_DataProtectionKeys.Designer.cs
+++ /dev/null
@@ -1,533 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220616170311_DataProtectionKeys")]
- partial class DataProtectionKeys
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.6")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.Property<string>("GithubId")
- .HasColumnType("text")
- .HasColumnName("github_id");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("RefreshToken")
- .HasColumnType("text")
- .HasColumnName("refresh_token");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("GithubId")
- .HasName("pk_github_user_mappings");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_github_user_mappings_user_id");
-
- b.ToTable("github_user_mappings", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("FirstName")
- .HasColumnType("text")
- .HasColumnName("first_name");
-
- b.Property<string>("LastName")
- .HasColumnType("text")
- .HasColumnName("last_name");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer")
- .HasColumnName("id");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
-
- b.Property<string>("FriendlyName")
- .HasColumnType("text")
- .HasColumnName("friendly_name");
-
- b.Property<string>("Xml")
- .HasColumnType("text")
- .HasColumnName("xml");
-
- b.HasKey("Id")
- .HasName("pk_data_protection_keys");
-
- b.ToTable("data_protection_keys", (string)null);
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.Property<Guid>("TenantsId")
- .HasColumnType("uuid")
- .HasColumnName("tenants_id");
-
- b.Property<Guid>("UsersId")
- .HasColumnType("uuid")
- .HasColumnName("users_id");
-
- b.HasKey("TenantsId", "UsersId")
- .HasName("pk_tenant_user");
-
- b.HasIndex("UsersId")
- .HasDatabaseName("ix_tenant_user_users_id");
-
- b.ToTable("tenant_user", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.GithubUserMapping", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_github_user_mappings_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", null)
- .WithMany()
- .HasForeignKey("TenantsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_tenants_tenants_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", null)
- .WithMany()
- .HasForeignKey("UsersId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_users_users_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220616170311_DataProtectionKeys.cs b/server/src/Migrations/20220616170311_DataProtectionKeys.cs
deleted file mode 100644
index bc3c673..0000000
--- a/server/src/Migrations/20220616170311_DataProtectionKeys.cs
+++ /dev/null
@@ -1,33 +0,0 @@
-using Microsoft.EntityFrameworkCore.Migrations;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class DataProtectionKeys : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "data_protection_keys",
- columns: table => new
- {
- id = table.Column<int>(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- friendly_name = table.Column<string>(type: "text", nullable: true),
- xml = table.Column<string>(type: "text", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_data_protection_keys", x => x.id);
- });
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "data_protection_keys");
- }
- }
-}
diff --git a/server/src/Migrations/20220819203816_RemoveGithubUsers.Designer.cs b/server/src/Migrations/20220819203816_RemoveGithubUsers.Designer.cs
deleted file mode 100644
index 33b5cfd..0000000
--- a/server/src/Migrations/20220819203816_RemoveGithubUsers.Designer.cs
+++ /dev/null
@@ -1,496 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- [Migration("20220819203816_RemoveGithubUsers")]
- partial class RemoveGithubUsers
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.7")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("FirstName")
- .HasColumnType("text")
- .HasColumnName("first_name");
-
- b.Property<string>("LastName")
- .HasColumnType("text")
- .HasColumnName("last_name");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer")
- .HasColumnName("id");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
-
- b.Property<string>("FriendlyName")
- .HasColumnType("text")
- .HasColumnName("friendly_name");
-
- b.Property<string>("Xml")
- .HasColumnType("text")
- .HasColumnName("xml");
-
- b.HasKey("Id")
- .HasName("pk_data_protection_keys");
-
- b.ToTable("data_protection_keys", (string)null);
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.Property<Guid>("TenantsId")
- .HasColumnType("uuid")
- .HasColumnName("tenants_id");
-
- b.Property<Guid>("UsersId")
- .HasColumnType("uuid")
- .HasColumnName("users_id");
-
- b.HasKey("TenantsId", "UsersId")
- .HasName("pk_tenant_user");
-
- b.HasIndex("UsersId")
- .HasDatabaseName("ix_tenant_user_users_id");
-
- b.ToTable("tenant_user", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", null)
- .WithMany()
- .HasForeignKey("TenantsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_tenants_tenants_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", null)
- .WithMany()
- .HasForeignKey("UsersId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_users_users_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/server/src/Migrations/20220819203816_RemoveGithubUsers.cs b/server/src/Migrations/20220819203816_RemoveGithubUsers.cs
deleted file mode 100644
index d301f67..0000000
--- a/server/src/Migrations/20220819203816_RemoveGithubUsers.cs
+++ /dev/null
@@ -1,43 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- public partial class RemoveGithubUsers : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "github_user_mappings");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "github_user_mappings",
- columns: table => new
- {
- github_id = table.Column<string>(type: "text", nullable: false),
- user_id = table.Column<Guid>(type: "uuid", nullable: true),
- email = table.Column<string>(type: "text", nullable: true),
- refresh_token = table.Column<string>(type: "text", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("pk_github_user_mappings", x => x.github_id);
- table.ForeignKey(
- name: "fk_github_user_mappings_users_user_id",
- column: x => x.user_id,
- principalTable: "users",
- principalColumn: "id");
- });
-
- migrationBuilder.CreateIndex(
- name: "ix_github_user_mappings_user_id",
- table: "github_user_mappings",
- column: "user_id");
- }
- }
-}
diff --git a/server/src/Migrations/AppDbContextModelSnapshot.cs b/server/src/Migrations/AppDbContextModelSnapshot.cs
deleted file mode 100644
index cc4bf72..0000000
--- a/server/src/Migrations/AppDbContextModelSnapshot.cs
+++ /dev/null
@@ -1,494 +0,0 @@
-// <auto-generated />
-using System;
-using IOL.GreatOffice.Api.Data;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace IOL.GreatOffice.Api.Migrations
-{
- [DbContext(typeof(AppDbContext))]
- partial class AppDbContextModelSnapshot : ModelSnapshot
- {
- protected override void BuildModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "6.0.7")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<bool>("AllowCreate")
- .HasColumnType("boolean")
- .HasColumnName("allow_create");
-
- b.Property<bool>("AllowDelete")
- .HasColumnType("boolean")
- .HasColumnName("allow_delete");
-
- b.Property<bool>("AllowRead")
- .HasColumnType("boolean")
- .HasColumnName("allow_read");
-
- b.Property<bool>("AllowUpdate")
- .HasColumnType("boolean")
- .HasColumnName("allow_update");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<DateTime>("ExpiryDate")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("expiry_date");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_api_access_tokens");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_api_access_tokens_user_id");
-
- b.ToTable("api_access_tokens", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_forgot_password_requests");
-
- b.HasIndex("UserId")
- .HasDatabaseName("ix_forgot_password_requests_user_id");
-
- b.ToTable("forgot_password_requests", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Tenant", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("ContactEmail")
- .HasColumnType("text")
- .HasColumnName("contact_email");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<Guid>("MasterUserId")
- .HasColumnType("uuid")
- .HasColumnName("master_user_id");
-
- b.Property<string>("MasterUserPassword")
- .HasColumnType("text")
- .HasColumnName("master_user_password");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_tenants");
-
- b.ToTable("tenants", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_categories");
-
- b.ToTable("time_categories", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<Guid?>("CategoryId")
- .HasColumnType("uuid")
- .HasColumnName("category_id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<string>("Description")
- .HasColumnType("text")
- .HasColumnName("description");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<DateTime>("Start")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("start");
-
- b.Property<DateTime>("Stop")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("stop");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_entries");
-
- b.HasIndex("CategoryId")
- .HasDatabaseName("ix_time_entries_category_id");
-
- b.ToTable("time_entries", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<string>("Color")
- .HasColumnType("text")
- .HasColumnName("color");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<Guid?>("CreatedById")
- .HasColumnType("uuid")
- .HasColumnName("created_by_id");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<Guid?>("DeletedById")
- .HasColumnType("uuid")
- .HasColumnName("deleted_by_id");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<Guid?>("ModifiedById")
- .HasColumnType("uuid")
- .HasColumnName("modified_by_id");
-
- b.Property<string>("Name")
- .HasColumnType("text")
- .HasColumnName("name");
-
- b.Property<Guid?>("TenantId")
- .HasColumnType("uuid")
- .HasColumnName("tenant_id");
-
- b.Property<Guid?>("TimeEntryId")
- .HasColumnType("uuid")
- .HasColumnName("time_entry_id");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("uuid")
- .HasColumnName("user_id");
-
- b.HasKey("Id")
- .HasName("pk_time_labels");
-
- b.HasIndex("TimeEntryId")
- .HasDatabaseName("ix_time_labels_time_entry_id");
-
- b.ToTable("time_labels", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid")
- .HasColumnName("id");
-
- b.Property<DateTime>("CreatedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("created_at");
-
- b.Property<bool>("Deleted")
- .HasColumnType("boolean")
- .HasColumnName("deleted");
-
- b.Property<string>("Email")
- .HasColumnType("text")
- .HasColumnName("email");
-
- b.Property<string>("FirstName")
- .HasColumnType("text")
- .HasColumnName("first_name");
-
- b.Property<string>("LastName")
- .HasColumnType("text")
- .HasColumnName("last_name");
-
- b.Property<DateTime?>("ModifiedAt")
- .HasColumnType("timestamp with time zone")
- .HasColumnName("modified_at");
-
- b.Property<string>("Password")
- .HasColumnType("text")
- .HasColumnName("password");
-
- b.Property<string>("Username")
- .HasColumnType("text")
- .HasColumnName("username");
-
- b.HasKey("Id")
- .HasName("pk_users");
-
- b.ToTable("users", (string)null);
- });
-
- modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer")
- .HasColumnName("id");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
-
- b.Property<string>("FriendlyName")
- .HasColumnType("text")
- .HasColumnName("friendly_name");
-
- b.Property<string>("Xml")
- .HasColumnType("text")
- .HasColumnName("xml");
-
- b.HasKey("Id")
- .HasName("pk_data_protection_keys");
-
- b.ToTable("data_protection_keys", (string)null);
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.Property<Guid>("TenantsId")
- .HasColumnType("uuid")
- .HasColumnName("tenants_id");
-
- b.Property<Guid>("UsersId")
- .HasColumnType("uuid")
- .HasColumnName("users_id");
-
- b.HasKey("TenantsId", "UsersId")
- .HasName("pk_tenant_user");
-
- b.HasIndex("UsersId")
- .HasDatabaseName("ix_tenant_user_users_id");
-
- b.ToTable("tenant_user", (string)null);
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ApiAccessToken", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .HasConstraintName("fk_api_access_tokens_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_forgot_password_requests_users_user_id");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
- .WithMany()
- .HasForeignKey("CategoryId")
- .HasConstraintName("fk_time_entries_time_categories_category_id");
-
- b.Navigation("Category");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
- .WithMany("Labels")
- .HasForeignKey("TimeEntryId")
- .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
- });
-
- modelBuilder.Entity("TenantUser", b =>
- {
- b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", null)
- .WithMany()
- .HasForeignKey("TenantsId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_tenants_tenants_id");
-
- b.HasOne("IOL.GreatOffice.Api.Data.Database.User", null)
- .WithMany()
- .HasForeignKey("UsersId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired()
- .HasConstraintName("fk_tenant_user_users_users_id");
- });
-
- modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
- {
- b.Navigation("Labels");
- });
-#pragma warning restore 612, 618
- }
- }
-}