public override void Up()
{
AddColumn("dbo.AspNetUsers", "CurrentGamingGroupId", c => c.Int(nullable: true));
Sql("UPDATE dbo.AspNetUsers SET CurrentGamingGroupId = (SELECT TOP 1 GamingGroupId FROM UserGamingGroup WHERE UserGamingGroup.ApplicationUserId = AspNetUsers.Id)");
}