using System; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace UserManagement.Domain.Migrations { public partial class Inital : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterDatabase() .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "AppSettings", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), Name = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Key = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Value = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_AppSettings", x => x.Id); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "EmailTemplates", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), Name = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Subject = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Body = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_EmailTemplates", x => x.Id); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "LoginAudits", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), UserName = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), LoginTime = table.Column(type: "datetime(6)", nullable: false), RemoteIP = table.Column(type: "varchar(50)", maxLength: 50, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Status = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Provider = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Latitude = table.Column(type: "varchar(50)", maxLength: 50, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Longitude = table.Column(type: "varchar(50)", maxLength: 50, nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_LoginAudits", x => x.Id); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "NLog", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), MachineName = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Logged = table.Column(type: "datetime(6)", nullable: false), Level = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Message = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Logger = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Properties = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Callsite = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Exception = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Source = table.Column(type: "varchar(50)", maxLength: 50, nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_NLog", x => x.Id); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "Users", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), FirstName = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), LastName = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false), IsActive = table.Column(type: "tinyint(1)", nullable: false), ProfilePhoto = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Provider = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Address = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), UserName = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), NormalizedUserName = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Email = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), NormalizedEmail = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), EmailConfirmed = table.Column(type: "tinyint(1)", nullable: false), PasswordHash = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), SecurityStamp = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), ConcurrencyStamp = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), PhoneNumber = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), PhoneNumberConfirmed = table.Column(type: "tinyint(1)", nullable: false), TwoFactorEnabled = table.Column(type: "tinyint(1)", nullable: false), LockoutEnd = table.Column(type: "datetime(6)", nullable: true), LockoutEnabled = table.Column(type: "tinyint(1)", nullable: false), AccessFailedCount = table.Column(type: "int", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Users", x => x.Id); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "Actions", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), Name = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Actions", x => x.Id); table.ForeignKey( name: "FK_Actions_Users_CreatedBy", column: x => x.CreatedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Actions_Users_DeletedBy", column: x => x.DeletedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Actions_Users_ModifiedBy", column: x => x.ModifiedBy, principalTable: "Users", principalColumn: "Id"); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "EmailSMTPSettings", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), Host = table.Column(type: "longtext", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), UserName = table.Column(type: "longtext", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), Password = table.Column(type: "longtext", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), IsEnableSSL = table.Column(type: "tinyint(1)", nullable: false), Port = table.Column(type: "int", nullable: false), IsDefault = table.Column(type: "tinyint(1)", nullable: false), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_EmailSMTPSettings", x => x.Id); table.ForeignKey( name: "FK_EmailSMTPSettings_Users_CreatedBy", column: x => x.CreatedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_EmailSMTPSettings_Users_DeletedBy", column: x => x.DeletedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_EmailSMTPSettings_Users_ModifiedBy", column: x => x.ModifiedBy, principalTable: "Users", principalColumn: "Id"); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "Pages", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), Name = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Url = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Pages", x => x.Id); table.ForeignKey( name: "FK_Pages_Users_CreatedBy", column: x => x.CreatedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Pages_Users_DeletedBy", column: x => x.DeletedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Pages_Users_ModifiedBy", column: x => x.ModifiedBy, principalTable: "Users", principalColumn: "Id"); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "Roles", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), Name = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), NormalizedName = table.Column(type: "varchar(256)", maxLength: 256, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), ConcurrencyStamp = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_Roles", x => x.Id); table.ForeignKey( name: "FK_Roles_Users_CreatedBy", column: x => x.CreatedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Roles_Users_DeletedBy", column: x => x.DeletedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_Roles_Users_ModifiedBy", column: x => x.ModifiedBy, principalTable: "Users", principalColumn: "Id"); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "UserAllowedIPs", columns: table => new { UserId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), IPAddress = table.Column(type: "varchar(255)", nullable: false) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_UserAllowedIPs", x => new { x.UserId, x.IPAddress }); table.ForeignKey( name: "FK_UserAllowedIPs_Users_UserId", column: x => x.UserId, principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "UserLogins", columns: table => new { LoginProvider = table.Column(type: "varchar(255)", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), ProviderKey = table.Column(type: "varchar(255)", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), ProviderDisplayName = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), UserId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci") }, constraints: table => { table.PrimaryKey("PK_UserLogins", x => new { x.LoginProvider, x.ProviderKey }); table.ForeignKey( name: "FK_UserLogins_Users_UserId", column: x => x.UserId, principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "UserTokens", columns: table => new { UserId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), LoginProvider = table.Column(type: "varchar(255)", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), Name = table.Column(type: "varchar(255)", nullable: false) .Annotation("MySql:CharSet", "utf8mb4"), Value = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_UserTokens", x => new { x.UserId, x.LoginProvider, x.Name }); table.ForeignKey( name: "FK_UserTokens_Users_UserId", column: x => x.UserId, principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "PageActions", columns: table => new { Id = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ActionId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), PageId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), CreatedDate = table.Column(type: "datetime", nullable: false), CreatedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ModifiedDate = table.Column(type: "datetime", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP"), ModifiedBy = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), DeletedDate = table.Column(type: "datetime", nullable: true), DeletedBy = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_PageActions", x => x.Id); table.ForeignKey( name: "FK_PageActions_Actions_ActionId", column: x => x.ActionId, principalTable: "Actions", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_PageActions_Pages_PageId", column: x => x.PageId, principalTable: "Pages", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_PageActions_Users_CreatedBy", column: x => x.CreatedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_PageActions_Users_DeletedBy", column: x => x.DeletedBy, principalTable: "Users", principalColumn: "Id"); table.ForeignKey( name: "FK_PageActions_Users_ModifiedBy", column: x => x.ModifiedBy, principalTable: "Users", principalColumn: "Id"); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "UserClaims", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn), ActionId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), PageId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), UserId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ClaimType = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), ClaimValue = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_UserClaims", x => x.Id); table.ForeignKey( name: "FK_UserClaims_Actions_ActionId", column: x => x.ActionId, principalTable: "Actions", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserClaims_Pages_PageId", column: x => x.PageId, principalTable: "Pages", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserClaims_Users_UserId", column: x => x.UserId, principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "RoleClaims", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn), ActionId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), PageId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), RoleId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), ClaimType = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), ClaimValue = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4") }, constraints: table => { table.PrimaryKey("PK_RoleClaims", x => x.Id); table.ForeignKey( name: "FK_RoleClaims_Actions_ActionId", column: x => x.ActionId, principalTable: "Actions", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_RoleClaims_Pages_PageId", column: x => x.PageId, principalTable: "Pages", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_RoleClaims_Roles_RoleId", column: x => x.RoleId, principalTable: "Roles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "UserRoles", columns: table => new { UserId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci"), RoleId = table.Column(type: "char(36)", nullable: false, collation: "ascii_general_ci") }, constraints: table => { table.PrimaryKey("PK_UserRoles", x => new { x.UserId, x.RoleId }); table.ForeignKey( name: "FK_UserRoles_Roles_RoleId", column: x => x.RoleId, principalTable: "Roles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_UserRoles_Users_UserId", column: x => x.UserId, principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateIndex( name: "IX_Actions_CreatedBy", table: "Actions", column: "CreatedBy"); migrationBuilder.CreateIndex( name: "IX_Actions_DeletedBy", table: "Actions", column: "DeletedBy"); migrationBuilder.CreateIndex( name: "IX_Actions_ModifiedBy", table: "Actions", column: "ModifiedBy"); migrationBuilder.CreateIndex( name: "IX_EmailSMTPSettings_CreatedBy", table: "EmailSMTPSettings", column: "CreatedBy"); migrationBuilder.CreateIndex( name: "IX_EmailSMTPSettings_DeletedBy", table: "EmailSMTPSettings", column: "DeletedBy"); migrationBuilder.CreateIndex( name: "IX_EmailSMTPSettings_ModifiedBy", table: "EmailSMTPSettings", column: "ModifiedBy"); migrationBuilder.CreateIndex( name: "IX_PageActions_ActionId", table: "PageActions", column: "ActionId"); migrationBuilder.CreateIndex( name: "IX_PageActions_CreatedBy", table: "PageActions", column: "CreatedBy"); migrationBuilder.CreateIndex( name: "IX_PageActions_DeletedBy", table: "PageActions", column: "DeletedBy"); migrationBuilder.CreateIndex( name: "IX_PageActions_ModifiedBy", table: "PageActions", column: "ModifiedBy"); migrationBuilder.CreateIndex( name: "IX_PageActions_PageId", table: "PageActions", column: "PageId"); migrationBuilder.CreateIndex( name: "IX_Pages_CreatedBy", table: "Pages", column: "CreatedBy"); migrationBuilder.CreateIndex( name: "IX_Pages_DeletedBy", table: "Pages", column: "DeletedBy"); migrationBuilder.CreateIndex( name: "IX_Pages_ModifiedBy", table: "Pages", column: "ModifiedBy"); migrationBuilder.CreateIndex( name: "IX_RoleClaims_ActionId", table: "RoleClaims", column: "ActionId"); migrationBuilder.CreateIndex( name: "IX_RoleClaims_PageId", table: "RoleClaims", column: "PageId"); migrationBuilder.CreateIndex( name: "IX_RoleClaims_RoleId", table: "RoleClaims", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_Roles_CreatedBy", table: "Roles", column: "CreatedBy"); migrationBuilder.CreateIndex( name: "IX_Roles_DeletedBy", table: "Roles", column: "DeletedBy"); migrationBuilder.CreateIndex( name: "IX_Roles_ModifiedBy", table: "Roles", column: "ModifiedBy"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "Roles", column: "NormalizedName", unique: true); migrationBuilder.CreateIndex( name: "IX_UserClaims_ActionId", table: "UserClaims", column: "ActionId"); migrationBuilder.CreateIndex( name: "IX_UserClaims_PageId", table: "UserClaims", column: "PageId"); migrationBuilder.CreateIndex( name: "IX_UserClaims_UserId", table: "UserClaims", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_UserLogins_UserId", table: "UserLogins", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_UserRoles_RoleId", table: "UserRoles", column: "RoleId"); migrationBuilder.CreateIndex( name: "EmailIndex", table: "Users", column: "NormalizedEmail"); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "Users", column: "NormalizedUserName", unique: true); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "AppSettings"); migrationBuilder.DropTable( name: "EmailSMTPSettings"); migrationBuilder.DropTable( name: "EmailTemplates"); migrationBuilder.DropTable( name: "LoginAudits"); migrationBuilder.DropTable( name: "NLog"); migrationBuilder.DropTable( name: "PageActions"); migrationBuilder.DropTable( name: "RoleClaims"); migrationBuilder.DropTable( name: "UserAllowedIPs"); migrationBuilder.DropTable( name: "UserClaims"); migrationBuilder.DropTable( name: "UserLogins"); migrationBuilder.DropTable( name: "UserRoles"); migrationBuilder.DropTable( name: "UserTokens"); migrationBuilder.DropTable( name: "Actions"); migrationBuilder.DropTable( name: "Pages"); migrationBuilder.DropTable( name: "Roles"); migrationBuilder.DropTable( name: "Users"); } } }