protected override void Down(MigrationBuilder migrationBuilder) { //Drop Index on Site table var siteEntityBuilder = new SiteEntityBuilder(migrationBuilder, ActiveDatabase); siteEntityBuilder.DropIndex("IX_Site"); //Drop Index on Role table var roleEntityBuilder = new RoleEntityBuilder(migrationBuilder, ActiveDatabase); roleEntityBuilder.DropIndex("IX_Role"); //Drop Index on Profile table var profileEntityBuilder = new ProfileEntityBuilder(migrationBuilder, ActiveDatabase); profileEntityBuilder.DropIndex("IX_Profile"); //Drop Index on File table var fileEntityBuilder = new FileEntityBuilder(migrationBuilder, ActiveDatabase); fileEntityBuilder.DropIndex("IX_File"); //Drop Columns from Notification table var notificationEntityBuilder = new NotificationEntityBuilder(migrationBuilder, ActiveDatabase); notificationEntityBuilder.DropColumn("FromDisplayName"); notificationEntityBuilder.DropColumn("FromEmail"); notificationEntityBuilder.DropColumn("ToDisplayName"); }
protected override void Down(MigrationBuilder migrationBuilder) { if (ActiveDatabase.Name != "Sqlite") { var fileEntityBuilder = new FileEntityBuilder(migrationBuilder, ActiveDatabase); fileEntityBuilder.DropIndex("IX_File"); fileEntityBuilder.AlterStringColumn("Name", 50); fileEntityBuilder.AddIndex("IX_File", new[] { "FolderId", "Name" }, true); } }
protected override void Up(MigrationBuilder migrationBuilder) { if (ActiveDatabase.Name != "Sqlite") { var fileEntityBuilder = new FileEntityBuilder(migrationBuilder, ActiveDatabase); // Drop the index is needed because the Name is already associated with IX_File fileEntityBuilder.DropForeignKey("FK_File_Folder"); fileEntityBuilder.DropIndex("IX_File"); fileEntityBuilder.AlterStringColumn("Name", 256); fileEntityBuilder.AddIndex("IX_File", new[] { "FolderId", "Name" }, true); fileEntityBuilder.AddForeignKey("FK_File_Folder"); } }