public override void Down()
{
DropForeignKey("dbo.UserRoles", "RoleID", "dbo.Roles");
DropForeignKey("dbo.UserRoles", "UserID", "dbo.Users");
DropForeignKey("dbo.Comments", "UserID", "dbo.Users");
DropForeignKey("dbo.Comments", "BookID", "dbo.Books");
DropForeignKey("dbo.Books", "CategoriesID", "dbo.Categories");
DropIndex("dbo.UserRoles", new[] { "RoleID" });
DropIndex("dbo.UserRoles", new[] { "UserID" });
DropIndex("dbo.Comments", new[] { "UserID" });
DropIndex("dbo.Comments", new[] { "BookID" });
DropIndex("dbo.Books", new[] { "CategoriesID" });
DropTable("dbo.UserRoles");
DropTable("dbo.Roles");
DropTable("dbo.Users");
DropTable("dbo.Comments");
DropTable("dbo.Categories");
DropTable("dbo.Books");
}