// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using Syski.Data; namespace Syski.Data.Migrations { [DbContext(typeof(SyskiDBContext))] [Migration("20190428102026_Initial")] partial class Initial { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "2.1.8-servicing-32085") .HasAnnotation("Relational:MaxIdentifierLength", 128) .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ConcurrencyStamp") .IsConcurrencyToken(); b.Property("Name") .HasMaxLength(256); b.Property("NormalizedName") .HasMaxLength(256); b.HasKey("Id"); b.HasIndex("NormalizedName") .IsUnique() .HasName("RoleNameIndex") .HasFilter("[NormalizedName] IS NOT NULL"); b.ToTable("AspNetRoles"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ClaimType"); b.Property("ClaimValue"); b.Property("RoleId") .IsRequired(); b.HasKey("Id"); b.HasIndex("RoleId"); b.ToTable("AspNetRoleClaims"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ClaimType"); b.Property("ClaimValue"); b.Property("UserId") .IsRequired(); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("AspNetUserClaims"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.Property("LoginProvider") .HasMaxLength(128); b.Property("ProviderKey") .HasMaxLength(128); b.Property("ProviderDisplayName"); b.Property("UserId") .IsRequired(); b.HasKey("LoginProvider", "ProviderKey"); b.HasIndex("UserId"); b.ToTable("AspNetUserLogins"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.Property("UserId"); b.Property("RoleId"); b.HasKey("UserId", "RoleId"); b.HasIndex("RoleId"); b.ToTable("AspNetUserRoles"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.Property("UserId"); b.Property("LoginProvider") .HasMaxLength(128); b.Property("Name") .HasMaxLength(128); b.Property("Value"); b.HasKey("UserId", "LoginProvider", "Name"); b.ToTable("AspNetUserTokens"); }); modelBuilder.Entity("Syski.Data.ApplicationUser", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("AccessFailedCount"); b.Property("ConcurrencyStamp") .IsConcurrencyToken(); b.Property("Email") .HasMaxLength(256); b.Property("EmailConfirmed"); b.Property("LockoutEnabled"); b.Property("LockoutEnd"); b.Property("NormalizedEmail") .HasMaxLength(256); b.Property("NormalizedUserName") .HasMaxLength(256); b.Property("PasswordHash"); b.Property("PhoneNumber"); b.Property("PhoneNumberConfirmed"); b.Property("SecurityStamp"); b.Property("TwoFactorEnabled"); b.Property("UserName") .HasMaxLength(256); b.HasKey("Id"); b.HasIndex("NormalizedEmail") .HasName("EmailIndex"); b.HasIndex("NormalizedUserName") .IsUnique() .HasName("UserNameIndex") .HasFilter("[NormalizedUserName] IS NOT NULL"); b.ToTable("AspNetUsers"); }); modelBuilder.Entity("Syski.Data.ApplicationUserSystemCategory", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("ApplicationUserSystemCategory"); }); modelBuilder.Entity("Syski.Data.ApplicationUserSystems", b => { b.Property("UserId"); b.Property("SystemId"); b.Property("CategoryId"); b.HasKey("UserId", "SystemId"); b.HasIndex("CategoryId"); b.HasIndex("SystemId"); b.ToTable("ApplicationUserSystems"); }); modelBuilder.Entity("Syski.Data.Architecture", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("Architectures"); }); modelBuilder.Entity("Syski.Data.AuthenticationToken", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Active"); b.Property("Audience"); b.Property("Expires"); b.Property("Issuer"); b.Property("NextTokenId"); b.Property("NotBefore"); b.Property("PreviousTokenId"); b.Property("RefreshToken"); b.Property("Subject"); b.Property("TokenType"); b.Property("UserId") .IsRequired(); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("AuthenticationTokens"); }); modelBuilder.Entity("Syski.Data.BIOSModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ManufacturerId"); b.HasKey("Id"); b.HasIndex("ManufacturerId"); b.ToTable("BIOSModels"); }); modelBuilder.Entity("Syski.Data.CPUModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ArchitectureId"); b.Property("ModelId"); b.HasKey("Id"); b.HasIndex("ArchitectureId"); b.HasIndex("ModelId") .IsUnique() .HasFilter("[ModelId] IS NOT NULL"); b.ToTable("CPUModels"); }); modelBuilder.Entity("Syski.Data.GPUModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ModelId"); b.HasKey("Id"); b.HasIndex("ModelId") .IsUnique() .HasFilter("[ModelId] IS NOT NULL"); b.ToTable("GPUModels"); }); modelBuilder.Entity("Syski.Data.Manufacturer", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("Manufacturers"); }); modelBuilder.Entity("Syski.Data.Model", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ManufacturerId"); b.Property("Name"); b.HasKey("Id"); b.HasIndex("ManufacturerId"); b.ToTable("Models"); }); modelBuilder.Entity("Syski.Data.MotherboardModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ModelId"); b.Property("Version"); b.HasKey("Id"); b.HasIndex("ModelId") .IsUnique() .HasFilter("[ModelId] IS NOT NULL"); b.ToTable("MotherboardModels"); }); modelBuilder.Entity("Syski.Data.OperatingSystemModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("OperatingSystemModels"); }); modelBuilder.Entity("Syski.Data.RAMModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ModelId"); b.Property("Size"); b.HasKey("Id"); b.HasIndex("ModelId") .IsUnique() .HasFilter("[ModelId] IS NOT NULL"); b.ToTable("RAMModels"); }); modelBuilder.Entity("Syski.Data.StorageInterfaceType", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("StorageInterfaceTypes"); }); modelBuilder.Entity("Syski.Data.StorageModel", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("ModelId"); b.Property("Size"); b.HasKey("Id"); b.HasIndex("ModelId") .IsUnique() .HasFilter("[ModelId] IS NOT NULL"); b.ToTable("StorageModels"); }); modelBuilder.Entity("Syski.Data.System", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("HostName"); b.Property("LastUpdated"); b.Property("ModelId"); b.Property("Secret"); b.HasKey("Id"); b.HasIndex("ModelId"); b.ToTable("Systems"); }); modelBuilder.Entity("Syski.Data.SystemBIOS", b => { b.Property("SystemId"); b.Property("BIOSModelId"); b.Property("Caption"); b.Property("Date"); b.Property("LastUpdated"); b.Property("Version"); b.HasKey("SystemId"); b.HasIndex("BIOSModelId"); b.ToTable("SystemBIOSs"); }); modelBuilder.Entity("Syski.Data.SystemCommand", b => { b.Property("SystemId"); b.Property("QueuedTime"); b.Property("Action"); b.Property("ExecutedTime"); b.Property("Properties"); b.HasKey("SystemId", "QueuedTime"); b.ToTable("SystemCommands"); }); modelBuilder.Entity("Syski.Data.SystemCPU", b => { b.Property("SystemId"); b.Property("CPUModelID"); b.Property("Slot"); b.Property("ClockSpeed"); b.Property("CoreCount"); b.Property("LastUpdated"); b.Property("ThreadCount"); b.HasKey("SystemId", "CPUModelID", "Slot"); b.HasIndex("CPUModelID"); b.ToTable("SystemCPUs"); }); modelBuilder.Entity("Syski.Data.SystemCPUData", b => { b.Property("SystemId"); b.Property("CollectionDateTime"); b.Property("Load"); b.Property("Processes"); b.HasKey("SystemId", "CollectionDateTime"); b.ToTable("SystemCPUsData"); }); modelBuilder.Entity("Syski.Data.SystemGPU", b => { b.Property("SystemId"); b.Property("GPUModelId"); b.Property("Slot"); b.Property("LastUpdated"); b.HasKey("SystemId", "GPUModelId", "Slot"); b.HasIndex("GPUModelId"); b.ToTable("SystemGPUs"); }); modelBuilder.Entity("Syski.Data.SystemMotherboard", b => { b.Property("SystemId"); b.Property("LastUpdated"); b.Property("MotherboardModelId"); b.HasKey("SystemId"); b.HasIndex("MotherboardModelId"); b.ToTable("SystemMotherboards"); }); modelBuilder.Entity("Syski.Data.SystemOS", b => { b.Property("SystemId"); b.Property("OperatingSystemId"); b.Property("ArchitectureId"); b.Property("LastUpdated"); b.Property("Version"); b.HasKey("SystemId", "OperatingSystemId"); b.HasIndex("ArchitectureId"); b.HasIndex("OperatingSystemId"); b.ToTable("SystemOSs"); }); modelBuilder.Entity("Syski.Data.SystemPingData", b => { b.Property("SystemId"); b.Property("SendPingTime"); b.Property("CollectionDateTime"); b.HasKey("SystemId", "SendPingTime"); b.ToTable("SystemPingData"); }); modelBuilder.Entity("Syski.Data.SystemRAM", b => { b.Property("SystemId"); b.Property("RAMModelId"); b.Property("Slot"); b.Property("LastUpdated"); b.Property("Speed"); b.HasKey("SystemId", "RAMModelId", "Slot"); b.HasIndex("RAMModelId"); b.ToTable("SystemRAMs"); }); modelBuilder.Entity("Syski.Data.SystemRAMData", b => { b.Property("SystemId"); b.Property("CollectionDateTime"); b.Property("Free"); b.HasKey("SystemId", "CollectionDateTime"); b.ToTable("SystemRAMData"); }); modelBuilder.Entity("Syski.Data.SystemRunningProcesses", b => { b.Property("SystemId"); b.Property("Id"); b.Property("CollectionDateTime"); b.Property("KernelTime"); b.Property("MemSize"); b.Property("Name"); b.Property("ParentId"); b.Property("Path"); b.Property("Threads"); b.Property("UpTime"); b.HasKey("SystemId", "Id", "CollectionDateTime"); b.ToTable("SystemRunningProcesses"); }); modelBuilder.Entity("Syski.Data.SystemStorage", b => { b.Property("SystemId"); b.Property("StorageModelId"); b.Property("Slot"); b.Property("LastUpdated"); b.Property("StorageInterfaceId"); b.HasKey("SystemId", "StorageModelId", "Slot"); b.HasIndex("StorageInterfaceId"); b.HasIndex("StorageModelId"); b.ToTable("SystemStorages"); }); modelBuilder.Entity("Syski.Data.SystemStorageData", b => { b.Property("SystemId"); b.Property("CollectionDateTime"); b.Property("ByteReads"); b.Property("ByteWrites"); b.Property("Reads"); b.Property("Time"); b.Property("Transfers"); b.Property("Writes"); b.HasKey("SystemId", "CollectionDateTime"); b.ToTable("SystemStorageData"); }); modelBuilder.Entity("Syski.Data.SystemType", b => { b.Property("SystemId"); b.Property("TypeId"); b.HasKey("SystemId", "TypeId"); b.HasIndex("TypeId"); b.ToTable("SystemTypes"); }); modelBuilder.Entity("Syski.Data.SystemTypeName", b => { b.Property("Id") .ValueGeneratedOnAdd(); b.Property("Name"); b.HasKey("Id"); b.ToTable("SystemTypeNames"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole") .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.HasOne("Syski.Data.ApplicationUser") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.HasOne("Syski.Data.ApplicationUser") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole") .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade); b.HasOne("Syski.Data.ApplicationUser") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b => { b.HasOne("Syski.Data.ApplicationUser") .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("Syski.Data.ApplicationUserSystems", b => { b.HasOne("Syski.Data.ApplicationUserSystemCategory", "Category") .WithMany("Systems") .HasForeignKey("CategoryId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("Users") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.ApplicationUser", "User") .WithMany("Systems") .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.AuthenticationToken", b => { b.HasOne("Syski.Data.ApplicationUser", "User") .WithMany("AuthenticationTokens") .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.BIOSModel", b => { b.HasOne("Syski.Data.Manufacturer", "Manufacturer") .WithMany("BIOSManufacturer") .HasForeignKey("ManufacturerId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.CPUModel", b => { b.HasOne("Syski.Data.Architecture", "Architecture") .WithMany("CPUModels") .HasForeignKey("ArchitectureId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.Model", "Model") .WithOne("CPUModel") .HasForeignKey("Syski.Data.CPUModel", "ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.GPUModel", b => { b.HasOne("Syski.Data.Model", "Model") .WithOne("GPUModel") .HasForeignKey("Syski.Data.GPUModel", "ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.Model", b => { b.HasOne("Syski.Data.Manufacturer", "Manufacturer") .WithMany("Models") .HasForeignKey("ManufacturerId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.MotherboardModel", b => { b.HasOne("Syski.Data.Model", "Model") .WithOne("MotherboardModel") .HasForeignKey("Syski.Data.MotherboardModel", "ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.RAMModel", b => { b.HasOne("Syski.Data.Model", "Model") .WithOne("RAMModel") .HasForeignKey("Syski.Data.RAMModel", "ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.StorageModel", b => { b.HasOne("Syski.Data.Model", "Model") .WithOne("StorageModel") .HasForeignKey("Syski.Data.StorageModel", "ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.System", b => { b.HasOne("Syski.Data.Model", "Model") .WithMany("Systems") .HasForeignKey("ModelId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemBIOS", b => { b.HasOne("Syski.Data.BIOSModel", "BIOSModel") .WithMany("SystemBIOSs") .HasForeignKey("BIOSModelId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithOne("SystemBIOS") .HasForeignKey("Syski.Data.SystemBIOS", "SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemCommand", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemCommands") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemCPU", b => { b.HasOne("Syski.Data.CPUModel", "CPUModel") .WithMany("SystemCPUs") .HasForeignKey("CPUModelID") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("SystemCPUs") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemCPUData", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemCPUData") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemGPU", b => { b.HasOne("Syski.Data.GPUModel", "GPUModel") .WithMany("SystemGPUs") .HasForeignKey("GPUModelId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("SystemGPUs") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemMotherboard", b => { b.HasOne("Syski.Data.MotherboardModel", "MotherboardModel") .WithMany("SystemMotherboards") .HasForeignKey("MotherboardModelId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithOne("SystemMotherboard") .HasForeignKey("Syski.Data.SystemMotherboard", "SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemOS", b => { b.HasOne("Syski.Data.Architecture", "Architecture") .WithMany("SystemOSs") .HasForeignKey("ArchitectureId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.OperatingSystemModel", "OperatingSystem") .WithMany("SystemOSs") .HasForeignKey("OperatingSystemId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("SystemOSs") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemPingData", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemPingData") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemRAM", b => { b.HasOne("Syski.Data.RAMModel", "RAMModel") .WithMany("SystemRAMs") .HasForeignKey("RAMModelId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("SystemRAMs") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemRAMData", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemRAMData") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemRunningProcesses", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemRunningProcesses") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemStorage", b => { b.HasOne("Syski.Data.StorageInterfaceType", "StorageInterface") .WithMany("SystemStorages") .HasForeignKey("StorageInterfaceId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.StorageModel", "StorageModel") .WithMany("SystemStorages") .HasForeignKey("StorageModelId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.System", "System") .WithMany("SystemStorages") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemStorageData", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemStorageData") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); }); modelBuilder.Entity("Syski.Data.SystemType", b => { b.HasOne("Syski.Data.System", "System") .WithMany("SystemTypes") .HasForeignKey("SystemId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("Syski.Data.SystemTypeName", "Type") .WithMany("SystemTypes") .HasForeignKey("TypeId") .OnDelete(DeleteBehavior.Restrict); }); #pragma warning restore 612, 618 } } }