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