// using System; using IOL.GreatOffice.Api.Models; using IOL.GreatOffice.Api.Models.Database; 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(MainAppDatabase))] [Migration("20210517202115_InitialMigration")] partial class InitialMigration { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("Relational:MaxIdentifierLength", 63) .HasAnnotation("ProductVersion", "5.0.6") .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn); modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uuid") .HasColumnName("id"); b.Property("Created") .HasColumnType("timestamp with time zone") .HasColumnName("created"); b.Property("UserId") .HasColumnType("uuid") .HasColumnName("user_id"); b.HasKey("Id") .HasName("pk_forgot_password_requests"); b.HasIndex("UserId") .HasDatabaseName("ix_forgot_password_requests_user_id"); b.ToTable("forgot_password_requests"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeCategory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uuid") .HasColumnName("id"); b.Property("Color") .HasColumnType("text") .HasColumnName("color"); b.Property("Created") .HasColumnType("timestamp with time zone") .HasColumnName("created"); b.Property("Name") .HasColumnType("text") .HasColumnName("name"); b.Property("UserId") .HasColumnType("uuid") .HasColumnName("user_id"); b.HasKey("Id") .HasName("pk_time_categories"); b.ToTable("time_categories"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uuid") .HasColumnName("id"); b.Property("CategoryId") .HasColumnType("uuid") .HasColumnName("category_id"); b.Property("Created") .HasColumnType("timestamp with time zone") .HasColumnName("created"); b.Property("Description") .HasColumnType("text") .HasColumnName("note"); b.Property("Start") .HasColumnType("timestamp with time zone") .HasColumnName("start"); b.Property("Stop") .HasColumnType("timestamp with time zone") .HasColumnName("stop"); b.Property("UserId") .HasColumnType("uuid") .HasColumnName("user_id"); b.HasKey("Id") .HasName("pk_time_entries"); b.HasIndex("CategoryId") .HasDatabaseName("ix_time_entries_category_id"); b.ToTable("time_entries"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeLabel", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uuid") .HasColumnName("id"); b.Property("Color") .HasColumnType("text") .HasColumnName("color"); b.Property("Created") .HasColumnType("timestamp with time zone") .HasColumnName("created"); b.Property("Name") .HasColumnType("text") .HasColumnName("name"); b.Property("UserId") .HasColumnType("uuid") .HasColumnName("user_id"); b.HasKey("Id") .HasName("pk_time_labels"); b.ToTable("time_labels"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.User", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uuid") .HasColumnName("id"); b.Property("Created") .HasColumnType("timestamp with time zone") .HasColumnName("created"); b.Property("Password") .HasColumnType("text") .HasColumnName("password"); b.Property("Username") .HasColumnType("text") .HasColumnName("username"); b.HasKey("Id") .HasName("pk_users"); b.ToTable("users"); b.HasData( new { Id = new Guid("784938f0-cc0e-46ec-afa6-fc60b47b28db"), Created = new DateTime(2021, 5, 17, 20, 21, 14, 827, DateTimeKind.Utc).AddTicks(4868), Password = "AAAAAAEAACcQAAAAEJdtrX3pEeIbcgY+BDAr56gvfbc420ag1TllA0cK6Q6Gw3+gGDIQtYIZnisW3dmqaQ==", Username = "admin@ivarlovlie.no" }); }); modelBuilder.Entity("TimeEntryTimeLabel", b => { b.Property("EntriesId") .HasColumnType("uuid") .HasColumnName("entries_id"); b.Property("LabelsId") .HasColumnType("uuid") .HasColumnName("labels_id"); b.HasKey("EntriesId", "LabelsId") .HasName("pk_time_entry_time_label"); b.HasIndex("LabelsId") .HasDatabaseName("ix_time_entry_time_label_labels_id"); b.ToTable("time_entry_time_label"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.ForgotPasswordRequest", b => { b.HasOne("IOL.GreatOffice.Data.Database.User", "User") .WithMany() .HasForeignKey("UserId") .HasConstraintName("fk_forgot_password_requests_users_user_id"); b.Navigation("User"); }); modelBuilder.Entity("IOL.GreatOffice.Data.Database.TimeEntry", b => { b.HasOne("IOL.GreatOffice.Data.Database.TimeCategory", "Category") .WithMany() .HasForeignKey("CategoryId") .HasConstraintName("fk_time_entries_time_categories_category_id"); b.Navigation("Category"); }); modelBuilder.Entity("TimeEntryTimeLabel", b => { b.HasOne("IOL.GreatOffice.Data.Database.TimeEntry", null) .WithMany() .HasForeignKey("EntriesId") .HasConstraintName("fk_time_entry_time_label_time_entries_entries_id") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("IOL.GreatOffice.Data.Database.TimeLabel", null) .WithMany() .HasForeignKey("LabelsId") .HasConstraintName("fk_time_entry_time_label_time_labels_labels_id") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); #pragma warning restore 612, 618 } } }