using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable #pragma warning disable CA1814 // Prefer jagged arrays over multidimensional namespace MTWorkHR.Infrastructure.Migrations { /// public partial class initial : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "AspNetRoles", columns: table => new { Id = table.Column(type: "nvarchar(450)", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: true), UpdateUser = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), IsDeleted = table.Column(type: "bit", nullable: false), DeleteUserId = table.Column(type: "nvarchar(max)", nullable: true), IsAdmin = table.Column(type: "bit", nullable: true), Name = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), NormalizedName = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), ConcurrencyStamp = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AspNetRoles", x => x.Id); }); migrationBuilder.CreateTable( name: "AspNetUsers", columns: table => new { Id = table.Column(type: "nvarchar(450)", nullable: false), FirstName = table.Column(type: "nvarchar(max)", nullable: false), LastName = table.Column(type: "nvarchar(max)", nullable: false), UserType = table.Column(type: "int", nullable: false), FavoriteName = table.Column(type: "nvarchar(max)", nullable: true), PassportNumber = table.Column(type: "nvarchar(max)", nullable: false), QualificationId = table.Column(type: "int", nullable: true), University = table.Column(type: "nvarchar(max)", nullable: true), JobTitle = table.Column(type: "nvarchar(max)", nullable: true), ManagerId = table.Column(type: "nvarchar(450)", nullable: true), TaxNumber = table.Column(type: "decimal(18,2)", nullable: true), IncomeTaxValue = table.Column(type: "decimal(18,2)", nullable: true), CreateUser = table.Column(type: "nvarchar(max)", nullable: true), UpdateUser = table.Column(type: "nvarchar(max)", nullable: true), IsStopped = table.Column(type: "bit", nullable: false), IsDeleted = table.Column(type: "bit", nullable: false), DeleteUserId = table.Column(type: "nvarchar(max)", nullable: true), UserName = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), NormalizedUserName = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), Email = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), NormalizedEmail = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), EmailConfirmed = table.Column(type: "bit", nullable: false), PasswordHash = table.Column(type: "nvarchar(max)", nullable: true), SecurityStamp = table.Column(type: "nvarchar(max)", nullable: true), ConcurrencyStamp = table.Column(type: "nvarchar(max)", nullable: true), PhoneNumber = table.Column(type: "nvarchar(max)", nullable: true), PhoneNumberConfirmed = table.Column(type: "bit", nullable: false), TwoFactorEnabled = table.Column(type: "bit", nullable: false), LockoutEnd = table.Column(type: "datetimeoffset", nullable: true), LockoutEnabled = table.Column(type: "bit", nullable: false), AccessFailedCount = table.Column(type: "int", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AspNetUsers", x => x.Id); table.ForeignKey( name: "FK_AspNetUsers_AspNetUsers_ManagerId", column: x => x.ManagerId, principalTable: "AspNetUsers", principalColumn: "Id"); }); migrationBuilder.CreateTable( name: "AttachmentTypes", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), NameAr = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), NameEn = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), IsRequired = table.Column(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AttachmentTypes", x => x.Id); }); migrationBuilder.CreateTable( name: "AuthLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AuthLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "Companies", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), UserId = table.Column(type: "bigint", nullable: false), CompanyName = table.Column(type: "nvarchar(max)", nullable: false), CRNumber = table.Column(type: "nvarchar(max)", nullable: false), TaxNumber = table.Column(type: "int", nullable: false), IsDeleted = table.Column(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Companies", x => x.Id); }); migrationBuilder.CreateTable( name: "FileLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_FileLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "Permissions", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Name = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), CategoryName = table.Column(type: "nvarchar(150)", maxLength: 150, nullable: false), Desc = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), Show = table.Column(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Permissions", x => x.Id); }); migrationBuilder.CreateTable( name: "Projects", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), NameAr = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), NameEn = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false) }, constraints: table => { table.PrimaryKey("PK_Projects", x => x.Id); }); migrationBuilder.CreateTable( name: "RoleLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_RoleLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "SettingLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_SettingLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "UserLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_UserLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "UserTaskStatuses", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), NameAr = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), NameEn = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserTaskStatuses", x => x.Id); }); migrationBuilder.CreateTable( name: "AspNetRoleClaims", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), RoleId = table.Column(type: "nvarchar(450)", nullable: false), ClaimType = table.Column(type: "nvarchar(max)", nullable: true), ClaimValue = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id); table.ForeignKey( name: "FK_AspNetRoleClaims_AspNetRoles_RoleId", column: x => x.RoleId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "ApplicationRoleApplicationUser", columns: table => new { UserRolesId = table.Column(type: "nvarchar(450)", nullable: false), UsersId = table.Column(type: "nvarchar(450)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_ApplicationRoleApplicationUser", x => new { x.UserRolesId, x.UsersId }); table.ForeignKey( name: "FK_ApplicationRoleApplicationUser_AspNetRoles_UserRolesId", column: x => x.UserRolesId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_ApplicationRoleApplicationUser_AspNetUsers_UsersId", column: x => x.UsersId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserClaims", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), UserId = table.Column(type: "nvarchar(450)", nullable: false), ClaimType = table.Column(type: "nvarchar(max)", nullable: true), ClaimValue = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AspNetUserClaims", x => x.Id); table.ForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserLogins", columns: table => new { LoginProvider = table.Column(type: "nvarchar(450)", nullable: false), ProviderKey = table.Column(type: "nvarchar(450)", nullable: false), ProviderDisplayName = table.Column(type: "nvarchar(max)", nullable: true), UserId = table.Column(type: "nvarchar(450)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey }); table.ForeignKey( name: "FK_AspNetUserLogins_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserRoles", columns: table => new { UserId = table.Column(type: "nvarchar(450)", nullable: false), RoleId = table.Column(type: "nvarchar(450)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId }); table.ForeignKey( name: "FK_AspNetUserRoles_AspNetRoles_RoleId", column: x => x.RoleId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserTokens", columns: table => new { UserId = table.Column(type: "nvarchar(450)", nullable: false), LoginProvider = table.Column(type: "nvarchar(450)", nullable: false), Name = table.Column(type: "nvarchar(450)", nullable: false), Value = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name }); table.ForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "UserAddress", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), UserId = table.Column(type: "nvarchar(450)", nullable: false), CountryId = table.Column(type: "int", nullable: false), City = table.Column(type: "nvarchar(max)", nullable: false), PostalCode = table.Column(type: "nvarchar(max)", nullable: false), AddressDesc = table.Column(type: "nvarchar(max)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserAddress", x => x.Id); table.ForeignKey( name: "FK_UserAddress_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "UserAttachments", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), UserId = table.Column(type: "nvarchar(450)", nullable: false), AttachmentTypeId = table.Column(type: "bigint", nullable: false), FileName = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), OriginalName = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserAttachments", x => x.Id); table.ForeignKey( name: "FK_UserAttachments_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserAttachments_AttachmentTypes_AttachmentTypeId", column: x => x.AttachmentTypeId, principalTable: "AttachmentTypes", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "RolePermissions", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), RoleId = table.Column(type: "nvarchar(450)", nullable: false), PermissionId = table.Column(type: "bigint", nullable: false), PermissionName = table.Column(type: "nvarchar(max)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_RolePermissions", x => x.Id); table.ForeignKey( name: "FK_RolePermissions_AspNetRoles_RoleId", column: x => x.RoleId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_RolePermissions_Permissions_PermissionId", column: x => x.PermissionId, principalTable: "Permissions", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "UserTasks", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), IsDeleted = table.Column(type: "bit", nullable: false), DeleteUserId = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), AssignedUserId = table.Column(type: "bigint", nullable: false), Title = table.Column(type: "nvarchar(max)", nullable: false), Description = table.Column(type: "nvarchar(max)", nullable: false), DueDate = table.Column(type: "datetime2", nullable: false), Priority = table.Column(type: "int", nullable: false), ProjectId = table.Column(type: "bigint", nullable: false), StatusId = table.Column(type: "bigint", nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserTasks", x => x.Id); table.ForeignKey( name: "FK_UserTasks_Projects_ProjectId", column: x => x.ProjectId, principalTable: "Projects", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserTasks_UserTaskStatuses_StatusId", column: x => x.StatusId, principalTable: "UserTaskStatuses", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "UserTaskAttachments", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), TaskId = table.Column(type: "bigint", nullable: false), AttachmentTypeId = table.Column(type: "bigint", nullable: false), FileName = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false), OriginalName = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserTaskAttachments", x => x.Id); table.ForeignKey( name: "FK_UserTaskAttachments_AttachmentTypes_AttachmentTypeId", column: x => x.AttachmentTypeId, principalTable: "AttachmentTypes", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserTaskAttachments_UserTasks_TaskId", column: x => x.TaskId, principalTable: "UserTasks", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "UserTaskHistories", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), CreateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), UpdateUser = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), UpdateDate = table.Column(type: "datetime2", nullable: true), AssignedToUserId = table.Column(type: "bigint", nullable: false), Comment = table.Column(type: "nvarchar(500)", maxLength: 500, nullable: false), CurrentStatusId = table.Column(type: "bigint", nullable: false), IsDeleted = table.Column(type: "bit", nullable: false), UserTaskId = table.Column(type: "bigint", nullable: true) }, constraints: table => { table.PrimaryKey("PK_UserTaskHistories", x => x.Id); table.ForeignKey( name: "FK_UserTaskHistories_UserTaskStatuses_CurrentStatusId", column: x => x.CurrentStatusId, principalTable: "UserTaskStatuses", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserTaskHistories_UserTasks_UserTaskId", column: x => x.UserTaskId, principalTable: "UserTasks", principalColumn: "Id"); }); migrationBuilder.InsertData( table: "AspNetRoles", columns: new[] { "Id", "ConcurrencyStamp", "CreateDate", "CreateUser", "DeleteUserId", "IsAdmin", "IsDeleted", "Name", "NormalizedName", "UpdateDate", "UpdateUser" }, values: new object[,] { { "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A", null, new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), null, null, true, false, "Admin", "ADMIN", null, null }, { "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E", null, new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), null, null, false, false, "Employee", "EMPLOYEE", null, null } }); migrationBuilder.InsertData( table: "AspNetUsers", columns: new[] { "Id", "AccessFailedCount", "ConcurrencyStamp", "CreateUser", "DeleteUserId", "Email", "EmailConfirmed", "FavoriteName", "FirstName", "IncomeTaxValue", "IsDeleted", "IsStopped", "JobTitle", "LastName", "LockoutEnabled", "LockoutEnd", "ManagerId", "NormalizedEmail", "NormalizedUserName", "PassportNumber", "PasswordHash", "PhoneNumber", "PhoneNumberConfirmed", "QualificationId", "SecurityStamp", "TaxNumber", "TwoFactorEnabled", "University", "UpdateUser", "UserName", "UserType" }, values: new object[,] { { "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA", 0, "7cc87689-9eab-4280-b8e3-1834080783a5", null, null, "a@b.com", true, null, "Zinab", 1m, false, false, null, "Elgendy", false, null, null, "A@B.COM", "ADMIN", "1234567", "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==", "1234567890", true, 1, "49bb16c3-4704-4c60-908d-dc8506950acc", 111m, false, null, null, "Admin", 1 }, { "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB", 0, "4af7b4cf-802a-455b-b598-997e167745b3", null, null, "ali@b.com", true, null, "Ali", 100m, false, false, null, "Farok", false, null, null, "ALI@B.COM", "ALI", "7654321001010", "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==", "1234567890", true, 1, "62549056-1b9d-46d4-84f8-adea3e4d8b68", 222m, false, null, null, "ali", 1 } }); migrationBuilder.InsertData( table: "AttachmentTypes", columns: new[] { "Id", "IsRequired", "NameAr", "NameEn" }, values: new object[,] { { 1L, false, "السيرة الذاتية", "CV" }, { 2L, false, "الهوية", "Identification" } }); migrationBuilder.InsertData( table: "AspNetUserRoles", columns: new[] { "RoleId", "UserId" }, values: new object[,] { { "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A", "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA" }, { "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E", "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB" } }); migrationBuilder.CreateIndex( name: "IX_ApplicationRoleApplicationUser_UsersId", table: "ApplicationRoleApplicationUser", column: "UsersId"); migrationBuilder.CreateIndex( name: "IX_AspNetRoleClaims_RoleId", table: "AspNetRoleClaims", column: "RoleId"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "AspNetRoles", column: "NormalizedName", unique: true, filter: "[NormalizedName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_AspNetUserClaims_UserId", table: "AspNetUserClaims", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_AspNetUserLogins_UserId", table: "AspNetUserLogins", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_AspNetUserRoles_RoleId", table: "AspNetUserRoles", column: "RoleId"); migrationBuilder.CreateIndex( name: "EmailIndex", table: "AspNetUsers", column: "NormalizedEmail"); migrationBuilder.CreateIndex( name: "IX_AspNetUsers_ManagerId", table: "AspNetUsers", column: "ManagerId"); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "AspNetUsers", column: "NormalizedUserName", unique: true, filter: "[NormalizedUserName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_RolePermissions_PermissionId", table: "RolePermissions", column: "PermissionId"); migrationBuilder.CreateIndex( name: "IX_RolePermissions_RoleId", table: "RolePermissions", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_UserAddress_UserId", table: "UserAddress", column: "UserId", unique: true); migrationBuilder.CreateIndex( name: "IX_UserAttachments_AttachmentTypeId", table: "UserAttachments", column: "AttachmentTypeId"); migrationBuilder.CreateIndex( name: "IX_UserAttachments_UserId", table: "UserAttachments", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_UserTaskAttachments_AttachmentTypeId", table: "UserTaskAttachments", column: "AttachmentTypeId"); migrationBuilder.CreateIndex( name: "IX_UserTaskAttachments_TaskId", table: "UserTaskAttachments", column: "TaskId"); migrationBuilder.CreateIndex( name: "IX_UserTaskHistories_CurrentStatusId", table: "UserTaskHistories", column: "CurrentStatusId"); migrationBuilder.CreateIndex( name: "IX_UserTaskHistories_UserTaskId", table: "UserTaskHistories", column: "UserTaskId"); migrationBuilder.CreateIndex( name: "IX_UserTasks_ProjectId", table: "UserTasks", column: "ProjectId"); migrationBuilder.CreateIndex( name: "IX_UserTasks_StatusId", table: "UserTasks", column: "StatusId"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "ApplicationRoleApplicationUser"); migrationBuilder.DropTable( name: "AspNetRoleClaims"); migrationBuilder.DropTable( name: "AspNetUserClaims"); migrationBuilder.DropTable( name: "AspNetUserLogins"); migrationBuilder.DropTable( name: "AspNetUserRoles"); migrationBuilder.DropTable( name: "AspNetUserTokens"); migrationBuilder.DropTable( name: "AuthLogs"); migrationBuilder.DropTable( name: "Companies"); migrationBuilder.DropTable( name: "FileLogs"); migrationBuilder.DropTable( name: "RoleLogs"); migrationBuilder.DropTable( name: "RolePermissions"); migrationBuilder.DropTable( name: "SettingLogs"); migrationBuilder.DropTable( name: "UserAddress"); migrationBuilder.DropTable( name: "UserAttachments"); migrationBuilder.DropTable( name: "UserLogs"); migrationBuilder.DropTable( name: "UserTaskAttachments"); migrationBuilder.DropTable( name: "UserTaskHistories"); migrationBuilder.DropTable( name: "AspNetRoles"); migrationBuilder.DropTable( name: "Permissions"); migrationBuilder.DropTable( name: "AspNetUsers"); migrationBuilder.DropTable( name: "AttachmentTypes"); migrationBuilder.DropTable( name: "UserTasks"); migrationBuilder.DropTable( name: "Projects"); migrationBuilder.DropTable( name: "UserTaskStatuses"); } } }