123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534 |
- // <auto-generated />
- using System;
- using MTWorkHR.Identity.DBContext;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Metadata;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- #nullable disable
- namespace MTWorkHR.Identity.Migrations
- {
- [DbContext(typeof(HRIdentityDBContext))]
- [Migration("20240128145047_InitialCreate")]
- partial class InitialCreate
- {
- /// <inheritdoc />
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "8.0.1")
- .HasAnnotation("Relational:MaxIdentifierLength", 128);
- SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
- modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
- {
- b.Property<string>("UserRolesId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("UsersId")
- .HasColumnType("nvarchar(450)");
- b.HasKey("UserRolesId", "UsersId");
- b.HasIndex("UsersId");
- b.ToTable("ApplicationRoleApplicationUser");
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.ApplicationRole", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("nvarchar(max)");
- b.Property<DateTime>("CreateDate")
- .HasColumnType("datetime2");
- b.Property<string>("CreateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("DeleteUserId")
- .HasColumnType("nvarchar(max)");
- b.Property<bool?>("IsAdmin")
- .HasColumnType("bit");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
- b.Property<string>("Name")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("NormalizedName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<DateTime?>("UpdateDate")
- .HasColumnType("datetime2");
- b.Property<string>("UpdateUser")
- .HasColumnType("nvarchar(max)");
- b.HasKey("Id");
- b.HasIndex("NormalizedName")
- .IsUnique()
- .HasDatabaseName("RoleNameIndex")
- .HasFilter("[NormalizedName] IS NOT NULL");
- b.ToTable("AspNetRoles", (string)null);
- b.HasData(
- new
- {
- Id = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A",
- CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
- IsAdmin = true,
- IsDeleted = false,
- Name = "Admin",
- NormalizedName = "ADMIN"
- },
- new
- {
- Id = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E",
- CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
- IsAdmin = false,
- IsDeleted = false,
- Name = "Employee",
- NormalizedName = "EMPLOYEE"
- });
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.ApplicationUser", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("nvarchar(450)");
- b.Property<int>("AccessFailedCount")
- .HasColumnType("int");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("CreateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("DeleteUserId")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("Email")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<bool>("EmailConfirmed")
- .HasColumnType("bit");
- b.Property<string>("FirstName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
- b.Property<bool>("IsStopped")
- .HasColumnType("bit");
- b.Property<string>("LastName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("LockoutEnabled")
- .HasColumnType("bit");
- b.Property<DateTimeOffset?>("LockoutEnd")
- .HasColumnType("datetimeoffset");
- b.Property<string>("ManagerId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("NormalizedEmail")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("NormalizedUserName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<string>("PasswordHash")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("PhoneNumber")
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("PhoneNumberConfirmed")
- .HasColumnType("bit");
- b.Property<string>("SecurityStamp")
- .HasColumnType("nvarchar(max)");
- b.Property<bool>("TwoFactorEnabled")
- .HasColumnType("bit");
- b.Property<string>("UpdateUser")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserName")
- .HasMaxLength(256)
- .HasColumnType("nvarchar(256)");
- b.Property<int>("UserType")
- .HasColumnType("int");
- b.HasKey("Id");
- b.HasIndex("ManagerId");
- b.HasIndex("NormalizedEmail")
- .HasDatabaseName("EmailIndex");
- b.HasIndex("NormalizedUserName")
- .IsUnique()
- .HasDatabaseName("UserNameIndex")
- .HasFilter("[NormalizedUserName] IS NOT NULL");
- b.ToTable("AspNetUsers", (string)null);
- b.HasData(
- new
- {
- Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
- AccessFailedCount = 0,
- ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5",
- Email = "a@b.com",
- EmailConfirmed = true,
- FirstName = "Zinab",
- IsDeleted = false,
- IsStopped = false,
- LastName = "Elgendy",
- LockoutEnabled = false,
- NormalizedEmail = "A@B.COM",
- NormalizedUserName = "ADMIN",
- PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==",
- PhoneNumber = "1234567890",
- PhoneNumberConfirmed = true,
- SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc",
- TwoFactorEnabled = false,
- UserName = "Admin",
- UserType = 1
- },
- new
- {
- Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
- AccessFailedCount = 0,
- ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3",
- Email = "ali@b.com",
- EmailConfirmed = true,
- FirstName = "Ali",
- IsDeleted = false,
- IsStopped = false,
- LastName = "Farok",
- LockoutEnabled = false,
- NormalizedEmail = "ALI@B.COM",
- NormalizedUserName = "ALI",
- PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==",
- PhoneNumber = "1234567890",
- PhoneNumberConfirmed = true,
- SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68",
- TwoFactorEnabled = false,
- UserName = "ali",
- UserType = 1
- });
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.Permission", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("CategoryName")
- .IsRequired()
- .HasMaxLength(150)
- .HasColumnType("nvarchar(150)");
- b.Property<string>("Desc")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<string>("Name")
- .IsRequired()
- .HasMaxLength(250)
- .HasColumnType("nvarchar(250)");
- b.Property<bool>("Show")
- .HasColumnType("bit");
- b.HasKey("Id");
- b.ToTable("Permissions");
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.RolePermission", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<long>("PermissionId")
- .HasColumnType("bigint");
- b.Property<string>("PermissionName")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("RoleId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("PermissionId");
- b.HasIndex("RoleId");
- b.ToTable("RolePermissions");
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("int");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ClaimValue")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("RoleId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- 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("int");
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
- b.Property<string>("ClaimType")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("ClaimValue")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- b.HasKey("Id");
- b.HasIndex("UserId");
- b.ToTable("AspNetUserClaims", (string)null);
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.Property<string>("LoginProvider")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ProviderKey")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("ProviderDisplayName")
- .HasColumnType("nvarchar(max)");
- b.Property<string>("UserId")
- .IsRequired()
- .HasColumnType("nvarchar(450)");
- 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("nvarchar(450)");
- b.Property<string>("RoleId")
- .HasColumnType("nvarchar(450)");
- b.HasKey("UserId", "RoleId");
- b.HasIndex("RoleId");
- b.ToTable("AspNetUserRoles", (string)null);
- b.HasData(
- new
- {
- UserId = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
- RoleId = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A"
- },
- new
- {
- UserId = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
- RoleId = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E"
- });
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
- {
- b.Property<string>("UserId")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("LoginProvider")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("Name")
- .HasColumnType("nvarchar(450)");
- b.Property<string>("Value")
- .HasColumnType("nvarchar(max)");
- b.HasKey("UserId", "LoginProvider", "Name");
- b.ToTable("AspNetUserTokens", (string)null);
- });
- modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationRole", null)
- .WithMany()
- .HasForeignKey("UserRolesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UsersId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.ApplicationUser", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", "Manager")
- .WithMany()
- .HasForeignKey("ManagerId");
- b.Navigation("Manager");
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.RolePermission", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.Permission", "Permission")
- .WithMany()
- .HasForeignKey("PermissionId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.HasOne("MTWorkHR.Identity.Models.ApplicationRole", "Role")
- .WithMany("RolePermissions")
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.Navigation("Permission");
- b.Navigation("Role");
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationRole", null)
- .WithMany()
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationRole", null)
- .WithMany()
- .HasForeignKey("RoleId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
- {
- b.HasOne("MTWorkHR.Identity.Models.ApplicationUser", null)
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
- modelBuilder.Entity("MTWorkHR.Identity.Models.ApplicationRole", b =>
- {
- b.Navigation("RolePermissions");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|