//
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
}
}
}