123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561 |
- // <auto-generated />
- using System;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
- using OnlineMetodist.API.Data;
- #nullable disable
- namespace OnlineMetodist.API.Migrations
- {
- [DbContext(typeof(OnlineMetodistDbContext))]
- [Migration("20240416232405_AddRolesData")]
- partial class AddRolesData
- {
- /// <inheritdoc />
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "8.0.3")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("text");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("text");
- b.Property<string>("Name")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.Property<string>("NormalizedName")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.HasKey("Id");
- b.HasIndex("NormalizedName")
- .IsUnique()
- .HasDatabaseName("RoleNameIndex");
- b.ToTable("AspNetRoles", (string)null);
- b.HasData(
- new
- {
- Id = "b9e3a61d-7719-4a28-9e72-3e01e486d6ad",
- Name = "Администратор",
- NormalizedName = "ADMIN"
- },
- new
- {
- Id = "5db04fea-d3fe-4560-b3d2-af89fc81f885",
- Name = "Заведующий корпусом",
- NormalizedName = "ZAVED"
- },
- new
- {
- Id = "3e6a19fe-742c-413a-914d-c3c77c5f7862",
- Name = "Представитель НМЦ",
- NormalizedName = "PREDSTAV"
- },
- new
- {
- Id = "c99b7c50-641e-4c83-a868-2020dd042634",
- Name = "Председатель МК",
- NormalizedName = "PREDSED"
- },
- new
- {
- Id = "15b46e43-900d-4b7b-87aa-a3fbf9d1baa6",
- Name = "Преподаватель",
- NormalizedName = "PREPOD"
- });
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("text");
- b.Property<string>("ClaimValue")
- .HasColumnType("text");
- b.Property<string>("RoleId")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.HasIndex("RoleId");
- b.ToTable("AspNetRoleClaims", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("text");
- b.Property<string>("ClaimValue")
- .HasColumnType("text");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.HasIndex("UserId");
- b.ToTable("AspNetUserClaims", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.Property<string>("LoginProvider")
- .HasColumnType("text");
- b.Property<string>("ProviderKey")
- .HasColumnType("text");
- b.Property<string>("ProviderDisplayName")
- .HasColumnType("text");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("LoginProvider", "ProviderKey");
- b.HasIndex("UserId");
- b.ToTable("AspNetUserLogins", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
- {
- b.Property<string>("UserId")
- .HasColumnType("text");
- b.Property<string>("RoleId")
- .HasColumnType("text");
- b.HasKey("UserId", "RoleId");
- b.HasIndex("RoleId");
- b.ToTable("AspNetUserRoles", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
- {
- b.Property<string>("UserId")
- .HasColumnType("text");
- b.Property<string>("LoginProvider")
- .HasColumnType("text");
- b.Property<string>("Name")
- .HasColumnType("text");
- b.Property<string>("Value")
- .HasColumnType("text");
- b.HasKey("UserId", "LoginProvider", "Name");
- b.ToTable("AspNetUserTokens", (string)null);
- });
- modelBuilder.Entity("OnlineMetodist.API.Models.ApplicationUser", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("text");
- b.Property<int>("AccessFailedCount")
- .HasColumnType("integer");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("text");
- b.Property<string>("Email")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.Property<bool>("EmailConfirmed")
- .HasColumnType("boolean");
- b.Property<bool>("LockoutEnabled")
- .HasColumnType("boolean");
- b.Property<DateTimeOffset?>("LockoutEnd")
- .HasColumnType("timestamp with time zone");
- b.Property<string>("NormalizedEmail")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.Property<string>("NormalizedUserName")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.Property<string>("PasswordHash")
- .HasColumnType("text");
- b.Property<string>("PhoneNumber")
- .HasColumnType("text");
- b.Property<bool>("PhoneNumberConfirmed")
- .HasColumnType("boolean");
- b.Property<string>("SecurityStamp")
- .HasColumnType("text");
- b.Property<bool>("TwoFactorEnabled")
- .HasColumnType("boolean");
- b.Property<string>("UserName")
- .HasMaxLength(256)
- .HasColumnType("character varying(256)");
- b.HasKey("Id");
- b.HasIndex("NormalizedEmail")
- .HasDatabaseName("EmailIndex");
- b.HasIndex("NormalizedUserName")
- .IsUnique()
- .HasDatabaseName("UserNameIndex");
- b.ToTable("AspNetUsers", (string)null);
- });
- modelBuilder.Entity("OnlineMetodist.Models.Employee", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid");
- b.Property<Guid?>("IdMC")
- .HasColumnType("uuid");
- b.Property<string>("Name")
- .IsRequired()
- .HasColumnType("text");
- b.Property<string>("Patronymic")
- .HasColumnType("text");
- b.Property<string>("Surname")
- .IsRequired()
- .HasColumnType("text");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.HasIndex("IdMC");
- b.HasIndex("UserId")
- .IsUnique();
- b.ToTable("Employees");
- });
- modelBuilder.Entity("OnlineMetodist.Models.Activity", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid");
- b.Property<DateOnly>("DateOfEvent")
- .HasColumnType("date");
- b.Property<Guid?>("EmployeeId")
- .HasColumnType("uuid");
- b.Property<DateOnly?>("EndDateOfEvent")
- .HasColumnType("date");
- b.Property<Guid>("FormOfWorkFKId")
- .HasColumnType("uuid");
- b.Property<Guid>("IdFormOfWork")
- .HasColumnType("uuid");
- b.Property<string>("Specifications")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.HasIndex("EmployeeId");
- b.HasIndex("FormOfWorkFKId");
- b.ToTable("Events");
- });
- modelBuilder.Entity("OnlineMetodist.Models.FormOfWork", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid");
- b.Property<string>("Name")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.ToTable("FormsOfWorks");
- b.HasData(
- new
- {
- Id = new Guid("2ef2618d-4a30-4f18-9d27-258eefdf55af"),
- Name = "Проведение"
- },
- new
- {
- Id = new Guid("d278705a-287b-465c-9129-e3e7e85690eb"),
- Name = "Участие"
- },
- new
- {
- Id = new Guid("f27967b1-13a8-4bf5-b286-8569094fc3ba"),
- Name = "Публикация"
- },
- new
- {
- Id = new Guid("39384f27-75d7-4a52-8c6c-6442a9dbb3c3"),
- Name = "Стажировка"
- });
- });
- modelBuilder.Entity("OnlineMetodist.Models.MethodicalCommission", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("uuid");
- b.Property<Guid?>("IdHead")
- .HasColumnType("uuid");
- b.Property<string>("Name")
- .IsRequired()
- .HasColumnType("text");
- b.HasKey("Id");
- b.HasIndex("IdHead")
- .IsUnique();
- b.ToTable("MethodicaCommissions");
- b.HasData(
- new
- {
- Id = new Guid("c9606bfb-8be6-45bd-8758-f4baf87ce6cb"),
- Name = "Математических и естественно - научных дисциплин"
- },
- new
- {
- Id = new Guid("5579d667-8e33-4e31-92be-0af1898604f2"),
- Name = "Гуманитарных дисциплин"
- },
- new
- {
- Id = new Guid("cedc1e44-cd5a-4e49-814c-9926b0030659"),
- Name = "Иностранного языка"
- },
- new
- {
- Id = new Guid("b59b9413-5813-474b-abfe-0de5dfdb5564"),
- Name = "Дисциплин физической культуры и БЖД"
- },
- new
- {
- Id = new Guid("d223366a-7a6b-485c-91b7-de734619f4c8"),
- Name = "Общественных и правовых дисциплин"
- },
- new
- {
- Id = new Guid("e1e858a7-8185-473a-8eee-644546322a46"),
- Name = "Информатика и вычислительная техника"
- },
- new
- {
- Id = new Guid("45c8cde9-92cb-4973-8312-5e62768bef9f"),
- Name = "Экономика и управление, логистика"
- },
- new
- {
- Id = new Guid("97ed3094-f321-4258-81ef-46337a0e86ed"),
- Name = "Специальностей Товароведение, Коммерция"
- },
- new
- {
- Id = new Guid("c93cf688-be01-499f-8885-48e17a9bea0f"),
- Name = "Специальностей Банковское дело, ДОУ"
- },
- new
- {
- Id = new Guid("7b32336b-6e2b-4548-b571-79511fcc70ab"),
- Name = "Инструментальных дисциплин"
- },
- new
- {
- Id = new Guid("48b40e88-6948-44f8-a46b-41963f156697"),
- Name = "Музыкальных дисциплин"
- },
- new
- {
- Id = new Guid("68722d0f-aa91-4ef9-a40f-80b69d6ef3d0"),
- Name = "Специальности Дошкольное образование"
- },
- new
- {
- Id = new Guid("8c5ad7ae-31ff-41d5-9352-11e5af466c46"),
- Name = "Специальности Преподавание в начальных классах"
- });
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
- {
- b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
- .WithMany()
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
- {
- b.HasOne("OnlineMetodist.API.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.HasOne("OnlineMetodist.API.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
- {
- b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
- .WithMany()
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.HasOne("OnlineMetodist.API.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
- {
- b.HasOne("OnlineMetodist.API.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("OnlineMetodist.Models.Employee", b =>
- {
- b.HasOne("OnlineMetodist.Models.MethodicalCommission", "MethodicalCommission")
- .WithMany("Employees")
- .HasForeignKey("IdMC");
- b.HasOne("OnlineMetodist.API.Models.ApplicationUser", "User")
- .WithOne("Employee")
- .HasForeignKey("OnlineMetodist.Models.Employee", "UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("MethodicalCommission");
- b.Navigation("User");
- });
- modelBuilder.Entity("OnlineMetodist.Models.Activity", b =>
- {
- b.HasOne("OnlineMetodist.Models.Employee", null)
- .WithMany("Events")
- .HasForeignKey("EmployeeId");
- b.HasOne("OnlineMetodist.Models.FormOfWork", "FormOfWorkFK")
- .WithMany()
- .HasForeignKey("FormOfWorkFKId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("FormOfWorkFK");
- });
- modelBuilder.Entity("OnlineMetodist.Models.MethodicalCommission", b =>
- {
- b.HasOne("OnlineMetodist.Models.Employee", "HeadMC")
- .WithOne("HeadMC")
- .HasForeignKey("OnlineMetodist.Models.MethodicalCommission", "IdHead");
- b.Navigation("HeadMC");
- });
- modelBuilder.Entity("OnlineMetodist.API.Models.ApplicationUser", b =>
- {
- b.Navigation("Employee")
- .IsRequired();
- });
- modelBuilder.Entity("OnlineMetodist.Models.Employee", b =>
- {
- b.Navigation("Events");
- b.Navigation("HeadMC");
- });
- modelBuilder.Entity("OnlineMetodist.Models.MethodicalCommission", b =>
- {
- b.Navigation("Employees");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|