// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using OnProfNext.Server.Data; #nullable disable namespace OnProfNext.Server.Migrations { [DbContext(typeof(AppDbContext))] [Migration("20251015131954_AddBookingsConfiguration")] partial class AddBookingsConfiguration { /// protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "9.0.9") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("OnProfNext.Shared.Models.Booking", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("GETUTCDATE()"); b.Property("Date") .HasColumnType("datetime2"); b.Property("Description") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("Hours") .HasColumnType("decimal(5,2)"); b.Property("MandantId") .HasColumnType("int"); b.Property("OrderId") .HasColumnType("int"); b.Property("UpdatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("GETUTCDATE()"); b.Property("UserId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("OrderId"); b.HasIndex("UserId"); b.ToTable("Bookings", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.Order", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Auftragsnummer") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CreatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("GETUTCDATE()"); b.Property("Iststunden") .ValueGeneratedOnAdd() .HasPrecision(10, 2) .HasColumnType("decimal(10,2)") .HasDefaultValue(0m); b.Property("MandantId") .HasColumnType("int"); b.Property("Planstunden") .ValueGeneratedOnAdd() .HasPrecision(10, 2) .HasColumnType("decimal(10,2)") .HasDefaultValue(0m); b.Property("ProjectId") .HasColumnType("int"); b.Property("Projektcode") .HasColumnType("nvarchar(max)"); b.Property("Status") .IsRequired() .ValueGeneratedOnAdd() .HasMaxLength(50) .HasColumnType("nvarchar(50)") .HasDefaultValue("Geplant"); b.Property("Titel") .IsRequired() .HasMaxLength(255) .HasColumnType("nvarchar(255)"); b.Property("UpdatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("GETUTCDATE()"); b.HasKey("Id"); b.HasIndex("ProjectId"); b.ToTable("Orders", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.OrderUser", b => { b.Property("OrderId") .HasColumnType("int"); b.Property("UserId") .HasColumnType("int"); b.HasKey("OrderId", "UserId"); b.HasIndex("UserId"); b.ToTable("OrderUsers", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.Project", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("SYSDATETIME()"); b.Property("Description") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("EndDate") .HasColumnType("datetime2"); b.Property("MandantId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(1); b.Property("ProjectManager") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("ProjectName") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("StartDate") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("SYSDATETIME()"); b.Property("Status") .IsRequired() .ValueGeneratedOnAdd() .HasMaxLength(50) .HasColumnType("nvarchar(50)") .HasDefaultValue("Geplant"); b.Property("UpdatedAt") .ValueGeneratedOnAddOrUpdate() .HasColumnType("datetime2") .HasDefaultValueSql("SYSDATETIME()"); b.HasKey("Id"); b.ToTable("Projects", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.ProjectUser", b => { b.Property("ProjectId") .HasColumnType("int"); b.Property("UserId") .HasColumnType("int"); b.HasKey("ProjectId", "UserId"); b.HasIndex("UserId"); b.ToTable("ProjectUsers", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.User", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreatedAt") .ValueGeneratedOnAdd() .HasColumnType("datetime2") .HasDefaultValueSql("SYSDATETIME()"); b.Property("Email") .IsRequired() .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("FirstName") .IsRequired() .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("IsActive") .ValueGeneratedOnAdd() .HasColumnType("bit") .HasDefaultValue(true); b.Property("LastName") .IsRequired() .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("MandantId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(1); b.Property("PasswordHash") .IsRequired() .HasMaxLength(512) .HasColumnType("nvarchar(512)"); b.Property("UpdatedAt") .ValueGeneratedOnAddOrUpdate() .HasColumnType("datetime2") .HasDefaultValueSql("SYSDATETIME()"); b.Property("Username") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.HasKey("Id"); b.ToTable("Users", (string)null); }); modelBuilder.Entity("OnProfNext.Shared.Models.Booking", b => { b.HasOne("OnProfNext.Shared.Models.Order", "Order") .WithMany() .HasForeignKey("OrderId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("OnProfNext.Shared.Models.User", "User") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Order"); b.Navigation("User"); }); modelBuilder.Entity("OnProfNext.Shared.Models.Order", b => { b.HasOne("OnProfNext.Shared.Models.Project", "Project") .WithMany("Orders") .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); }); modelBuilder.Entity("OnProfNext.Shared.Models.OrderUser", b => { b.HasOne("OnProfNext.Shared.Models.Order", "Order") .WithMany("OrderUsers") .HasForeignKey("OrderId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("OnProfNext.Shared.Models.User", "User") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Order"); b.Navigation("User"); }); modelBuilder.Entity("OnProfNext.Shared.Models.ProjectUser", b => { b.HasOne("OnProfNext.Shared.Models.Project", "Project") .WithMany("ProjectUsers") .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("OnProfNext.Shared.Models.User", "User") .WithMany("ProjectUsers") .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); b.Navigation("User"); }); modelBuilder.Entity("OnProfNext.Shared.Models.Order", b => { b.Navigation("OrderUsers"); }); modelBuilder.Entity("OnProfNext.Shared.Models.Project", b => { b.Navigation("Orders"); b.Navigation("ProjectUsers"); }); modelBuilder.Entity("OnProfNext.Shared.Models.User", b => { b.Navigation("ProjectUsers"); }); #pragma warning restore 612, 618 } } }