From b7e39b59fd0fc7b5610ebff29035bf622079e0d8 Mon Sep 17 00:00:00 2001 From: ivarlovlie Date: Wed, 5 Oct 2022 20:45:21 +0800 Subject: refactor: Change file structure --- .../20210517202115_InitialMigration.Designer.cs | 238 ------- .../Migrations/20210517202115_InitialMigration.cs | 162 ----- ...10522165932_RenameNoteToDescription.Designer.cs | 229 ------- .../20210522165932_RenameNoteToDescription.cs | 34 - .../20211002113037_V6Migration.Designer.cs | 233 ------- .../src/Migrations/20211002113037_V6Migration.cs | 130 ---- .../20220225143559_GithubUserMappings.Designer.cs | 270 -------- .../20220225143559_GithubUserMappings.cs | 43 -- .../20220319135910_RenameCreated.Designer.cs | 270 -------- .../src/Migrations/20220319135910_RenameCreated.cs | 65 -- .../20220319144958_ModifiedAt.Designer.cs | 290 --------- server/src/Migrations/20220319144958_ModifiedAt.cs | 66 -- .../Migrations/20220319203018_UserBase.Designer.cs | 322 ---------- server/src/Migrations/20220319203018_UserBase.cs | 140 ---- .../Migrations/20220320115601_Update1.Designer.cs | 342 ---------- server/src/Migrations/20220320115601_Update1.cs | 139 ---- ...32220_UpdatedForgotPasswordRequests.Designer.cs | 344 ---------- ...20220320132220_UpdatedForgotPasswordRequests.cs | 57 -- .../20220529190359_ApiAccessTokens.Designer.cs | 401 ------------ .../Migrations/20220529190359_ApiAccessTokens.cs | 48 -- .../Migrations/20220530174741_Tenants.Designer.cs | 710 --------------------- server/src/Migrations/20220530174741_Tenants.cs | 481 -------------- .../20220530175322_RemoveUnusedNavs.Designer.cs | 686 -------------------- .../Migrations/20220530175322_RemoveUnusedNavs.cs | 78 --- ...02214238_NullableOptionalBaseFields.Designer.cs | 656 ------------------- .../20220602214238_NullableOptionalBaseFields.cs | 649 ------------------- .../20220606232346_FleshOutNewModules.Designer.cs | 510 --------------- .../20220606232346_FleshOutNewModules.cs | 630 ------------------ .../20220616170311_DataProtectionKeys.Designer.cs | 533 ---------------- .../20220616170311_DataProtectionKeys.cs | 33 - .../20220819203816_RemoveGithubUsers.Designer.cs | 496 -------------- .../Migrations/20220819203816_RemoveGithubUsers.cs | 43 -- server/src/Migrations/AppDbContextModelSnapshot.cs | 494 -------------- 33 files changed, 9822 deletions(-) delete mode 100644 server/src/Migrations/20210517202115_InitialMigration.Designer.cs delete mode 100644 server/src/Migrations/20210517202115_InitialMigration.cs delete mode 100644 server/src/Migrations/20210522165932_RenameNoteToDescription.Designer.cs delete mode 100644 server/src/Migrations/20210522165932_RenameNoteToDescription.cs delete mode 100644 server/src/Migrations/20211002113037_V6Migration.Designer.cs delete mode 100644 server/src/Migrations/20211002113037_V6Migration.cs delete mode 100644 server/src/Migrations/20220225143559_GithubUserMappings.Designer.cs delete mode 100644 server/src/Migrations/20220225143559_GithubUserMappings.cs delete mode 100644 server/src/Migrations/20220319135910_RenameCreated.Designer.cs delete mode 100644 server/src/Migrations/20220319135910_RenameCreated.cs delete mode 100644 server/src/Migrations/20220319144958_ModifiedAt.Designer.cs delete mode 100644 server/src/Migrations/20220319144958_ModifiedAt.cs delete mode 100644 server/src/Migrations/20220319203018_UserBase.Designer.cs delete mode 100644 server/src/Migrations/20220319203018_UserBase.cs delete mode 100644 server/src/Migrations/20220320115601_Update1.Designer.cs delete mode 100644 server/src/Migrations/20220320115601_Update1.cs delete mode 100644 server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.Designer.cs delete mode 100644 server/src/Migrations/20220320132220_UpdatedForgotPasswordRequests.cs delete mode 100644 server/src/Migrations/20220529190359_ApiAccessTokens.Designer.cs delete mode 100644 server/src/Migrations/20220529190359_ApiAccessTokens.cs delete mode 100644 server/src/Migrations/20220530174741_Tenants.Designer.cs delete mode 100644 server/src/Migrations/20220530174741_Tenants.cs delete mode 100644 server/src/Migrations/20220530175322_RemoveUnusedNavs.Designer.cs delete mode 100644 server/src/Migrations/20220530175322_RemoveUnusedNavs.cs delete mode 100644 server/src/Migrations/20220602214238_NullableOptionalBaseFields.Designer.cs delete mode 100644 server/src/Migrations/20220602214238_NullableOptionalBaseFields.cs delete mode 100644 server/src/Migrations/20220606232346_FleshOutNewModules.Designer.cs delete mode 100644 server/src/Migrations/20220606232346_FleshOutNewModules.cs delete mode 100644 server/src/Migrations/20220616170311_DataProtectionKeys.Designer.cs delete mode 100644 server/src/Migrations/20220616170311_DataProtectionKeys.cs delete mode 100644 server/src/Migrations/20220819203816_RemoveGithubUsers.Designer.cs delete mode 100644 server/src/Migrations/20220819203816_RemoveGithubUsers.cs delete mode 100644 server/src/Migrations/AppDbContextModelSnapshot.cs (limited to 'server/src/Migrations') 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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("note"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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(type: "uuid", nullable: false), - name = table.Column(type: "text", nullable: true), - color = table.Column(type: "text", nullable: true), - user_id = table.Column(type: "uuid", nullable: false), - created = table.Column(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(type: "uuid", nullable: false), - name = table.Column(type: "text", nullable: true), - color = table.Column(type: "text", nullable: true), - user_id = table.Column(type: "uuid", nullable: false), - created = table.Column(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(type: "uuid", nullable: false), - username = table.Column(type: "text", nullable: true), - password = table.Column(type: "text", nullable: true), - created = table.Column(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(type: "uuid", nullable: false), - start = table.Column(type: "timestamp with time zone", nullable: false), - stop = table.Column(type: "timestamp with time zone", nullable: false), - note = table.Column(type: "text", nullable: true), - user_id = table.Column(type: "uuid", nullable: false), - category_id = table.Column(type: "uuid", nullable: true), - created = table.Column(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(type: "uuid", nullable: false), - user_id = table.Column(type: "uuid", nullable: true), - created = table.Column(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(type: "uuid", nullable: false), - labels_id = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp without time zone") - .HasColumnName("created"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp without time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("Created") - .HasColumnType("timestamp without time zone") - .HasColumnName("created"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("Start") - .HasColumnType("timestamp without time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp without time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp without time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp without time zone") - .HasColumnName("created"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users"); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - name: "created", - table: "users", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_labels", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - name: "stop", - table: "time_entries", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - name: "start", - table: "time_entries", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_entries", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_categories", - type: "timestamp with time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp without time zone"); - - migrationBuilder.AlterColumn( - 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( - name: "created", - table: "users", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_labels", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - name: "stop", - table: "time_entries", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - name: "start", - table: "time_entries", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_entries", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - name: "created", - table: "time_categories", - type: "timestamp without time zone", - nullable: false, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn( - 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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Created") - .HasColumnType("timestamp with time zone") - .HasColumnName("created"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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(type: "text", nullable: false), - user_id = table.Column(type: "uuid", nullable: true), - email = table.Column(type: "text", nullable: true), - refresh_token = table.Column(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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - name: "modified_at", - table: "users", - type: "timestamp with time zone", - nullable: true); - - migrationBuilder.AddColumn( - name: "modified_at", - table: "time_labels", - type: "timestamp with time zone", - nullable: true); - - migrationBuilder.AddColumn( - name: "modified_at", - table: "time_entries", - type: "timestamp with time zone", - nullable: true); - - migrationBuilder.AddColumn( - name: "modified_at", - table: "time_categories", - type: "timestamp with time zone", - nullable: true); - - migrationBuilder.AddColumn( - 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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.Property("password") - .HasColumnType("text") - .HasColumnName("password"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - name: "user_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - 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( - 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( - 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( - 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( - 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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.Property("password") - .HasColumnType("text") - .HasColumnName("password"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - 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( - 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( - 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( - name: "user_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - 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 @@ -// - - -#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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - 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( - 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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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(type: "uuid", nullable: false), - user_id = table.Column(type: "uuid", nullable: true), - expiry_date = table.Column(type: "timestamp with time zone", nullable: false), - allow_read = table.Column(type: "boolean", nullable: false), - allow_create = table.Column(type: "boolean", nullable: false), - allow_update = table.Column(type: "boolean", nullable: false), - allow_delete = table.Column(type: "boolean", nullable: false), - created_at = table.Column(type: "timestamp with time zone", nullable: false), - modified_at = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TenantId1") - .HasColumnType("uuid") - .HasColumnName("tenant_id1"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TimeEntryTimeLabel", b => - { - b.Property("EntriesId") - .HasColumnType("uuid") - .HasColumnName("entries_id"); - - b.Property("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( - name: "created_by_id", - table: "time_labels", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "deleted_by_id", - table: "time_labels", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "modified_by_id", - table: "time_labels", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "tenant_id", - table: "time_labels", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "created_by_id", - table: "time_entries", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "deleted_by_id", - table: "time_entries", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "modified_by_id", - table: "time_entries", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "tenant_id", - table: "time_entries", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "created_by_id", - table: "time_categories", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "deleted_by_id", - table: "time_categories", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - name: "modified_by_id", - table: "time_categories", - type: "uuid", - nullable: false, - defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); - - migrationBuilder.AddColumn( - 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(type: "uuid", nullable: false), - name = table.Column(type: "text", nullable: true), - description = table.Column(type: "text", nullable: true), - contact_email = table.Column(type: "text", nullable: true), - master_user_id = table.Column(type: "uuid", nullable: false), - master_user_password = table.Column(type: "text", nullable: true), - created_at = table.Column(type: "timestamp with time zone", nullable: false), - modified_at = table.Column(type: "timestamp with time zone", nullable: true), - user_id = table.Column(type: "uuid", nullable: false), - tenant_id = table.Column(type: "uuid", nullable: false), - tenant_id1 = table.Column(type: "uuid", nullable: true), - modified_by_id = table.Column(type: "uuid", nullable: false), - created_by_id = table.Column(type: "uuid", nullable: false), - deleted_by_id = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TenantId1") - .HasColumnType("uuid") - .HasColumnName("tenant_id1"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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( - 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(type: "uuid", nullable: false), - labels_id = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TenantId1") - .HasColumnType("uuid") - .HasColumnName("tenant_id1"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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( - name: "tenant_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "modified_by_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "deleted_by_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "created_by_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "tenant_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "modified_by_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "deleted_by_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "created_by_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "tenant_id", - table: "time_categories", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "modified_by_id", - table: "time_categories", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "deleted_by_id", - table: "time_categories", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "created_by_id", - table: "time_categories", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "tenant_id", - table: "tenants", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "modified_by_id", - table: "tenants", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - name: "deleted_by_id", - table: "tenants", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AlterColumn( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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( - 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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("FirstName") - .HasColumnType("text") - .HasColumnName("first_name"); - - b.Property("LastName") - .HasColumnType("text") - .HasColumnName("last_name"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("Username") - .HasColumnType("text") - .HasColumnName("username"); - - b.HasKey("Id") - .HasName("pk_users"); - - b.ToTable("users", (string)null); - }); - - modelBuilder.Entity("TenantUser", b => - { - b.Property("TenantsId") - .HasColumnType("uuid") - .HasColumnName("tenants_id"); - - b.Property("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( - name: "deleted", - table: "users", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.AddColumn( - name: "email", - table: "users", - type: "text", - nullable: true); - - migrationBuilder.AddColumn( - name: "first_name", - table: "users", - type: "text", - nullable: true); - - migrationBuilder.AddColumn( - name: "last_name", - table: "users", - type: "text", - nullable: true); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "time_labels", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AddColumn( - name: "deleted", - table: "time_labels", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "time_entries", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AddColumn( - name: "deleted", - table: "time_entries", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "time_categories", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AddColumn( - name: "deleted", - table: "time_categories", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.AlterColumn( - name: "user_id", - table: "tenants", - type: "uuid", - nullable: true, - oldClrType: typeof(Guid), - oldType: "uuid"); - - migrationBuilder.AddColumn( - name: "deleted", - table: "tenants", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.AddColumn( - name: "deleted", - table: "api_access_tokens", - type: "boolean", - nullable: false, - defaultValue: false); - - migrationBuilder.CreateTable( - name: "tenant_user", - columns: table => new - { - tenants_id = table.Column(type: "uuid", nullable: false), - users_id = table.Column(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( - 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( - 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( - 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( - 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( - 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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("GithubId") - .HasColumnType("text") - .HasColumnName("github_id"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("RefreshToken") - .HasColumnType("text") - .HasColumnName("refresh_token"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("FirstName") - .HasColumnType("text") - .HasColumnName("first_name"); - - b.Property("LastName") - .HasColumnType("text") - .HasColumnName("last_name"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasColumnName("id"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); - - b.Property("FriendlyName") - .HasColumnType("text") - .HasColumnName("friendly_name"); - - b.Property("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("TenantsId") - .HasColumnType("uuid") - .HasColumnName("tenants_id"); - - b.Property("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(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - friendly_name = table.Column(type: "text", nullable: true), - xml = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("FirstName") - .HasColumnType("text") - .HasColumnName("first_name"); - - b.Property("LastName") - .HasColumnType("text") - .HasColumnName("last_name"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasColumnName("id"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); - - b.Property("FriendlyName") - .HasColumnType("text") - .HasColumnName("friendly_name"); - - b.Property("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("TenantsId") - .HasColumnType("uuid") - .HasColumnName("tenants_id"); - - b.Property("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(type: "text", nullable: false), - user_id = table.Column(type: "uuid", nullable: true), - email = table.Column(type: "text", nullable: true), - refresh_token = table.Column(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 @@ -// -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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("AllowCreate") - .HasColumnType("boolean") - .HasColumnName("allow_create"); - - b.Property("AllowDelete") - .HasColumnType("boolean") - .HasColumnName("allow_delete"); - - b.Property("AllowRead") - .HasColumnType("boolean") - .HasColumnName("allow_read"); - - b.Property("AllowUpdate") - .HasColumnType("boolean") - .HasColumnName("allow_update"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("ExpiryDate") - .HasColumnType("timestamp with time zone") - .HasColumnName("expiry_date"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("ContactEmail") - .HasColumnType("text") - .HasColumnName("contact_email"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("MasterUserId") - .HasColumnType("uuid") - .HasColumnName("master_user_id"); - - b.Property("MasterUserPassword") - .HasColumnType("text") - .HasColumnName("master_user_password"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CategoryId") - .HasColumnType("uuid") - .HasColumnName("category_id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("Description") - .HasColumnType("text") - .HasColumnName("description"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Start") - .HasColumnType("timestamp with time zone") - .HasColumnName("start"); - - b.Property("Stop") - .HasColumnType("timestamp with time zone") - .HasColumnName("stop"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("Color") - .HasColumnType("text") - .HasColumnName("color"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("CreatedById") - .HasColumnType("uuid") - .HasColumnName("created_by_id"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("DeletedById") - .HasColumnType("uuid") - .HasColumnName("deleted_by_id"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("ModifiedById") - .HasColumnType("uuid") - .HasColumnName("modified_by_id"); - - b.Property("Name") - .HasColumnType("text") - .HasColumnName("name"); - - b.Property("TenantId") - .HasColumnType("uuid") - .HasColumnName("tenant_id"); - - b.Property("TimeEntryId") - .HasColumnType("uuid") - .HasColumnName("time_entry_id"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid") - .HasColumnName("id"); - - b.Property("CreatedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("created_at"); - - b.Property("Deleted") - .HasColumnType("boolean") - .HasColumnName("deleted"); - - b.Property("Email") - .HasColumnType("text") - .HasColumnName("email"); - - b.Property("FirstName") - .HasColumnType("text") - .HasColumnName("first_name"); - - b.Property("LastName") - .HasColumnType("text") - .HasColumnName("last_name"); - - b.Property("ModifiedAt") - .HasColumnType("timestamp with time zone") - .HasColumnName("modified_at"); - - b.Property("Password") - .HasColumnType("text") - .HasColumnName("password"); - - b.Property("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("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer") - .HasColumnName("id"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); - - b.Property("FriendlyName") - .HasColumnType("text") - .HasColumnName("friendly_name"); - - b.Property("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("TenantsId") - .HasColumnType("uuid") - .HasColumnName("tenants_id"); - - b.Property("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 - } - } -} -- cgit v1.3