Manually review migrations for 4.57.0

[georgekarrv]

Before Releasing 4.57.0 review the migrations introduced and flag any potentially time intensive migrations.

[iansltx]

This won't show up in DB migrations, but as part of this release we have a cron to go through all installers and pull them out of DB or object storage to confirm bundle IDs for uninstallers. This is not part of migrations but is a backfill job that we'll want to watch for cloud customers with installers, and mention in release notes (/cc @spokanemac) in general.

[iansltx]

Here are the DB migrations new to this release, which I'll be reviewing: 4.56-to-4.57-migrations.txt

[iansltx]

Actually, that diff provides false positives due to cherry-picks. Going to take a different approach: migrating from scratch to v4.56.0, then migrating to 4.57.0, and getting the list that way.

[iansltx]

Here are the actual migrations:

Policy Automatic Install Software Add Auto Increment Column To Profiles Add URL To Software Installers Uninstall Packages Add Policies To No Team

AKA

• [x] 20240829170044 - adds some columns and fkeys to policies and software_installers, both of which will be small tables, so good to go
• [x] 20240905105135 - adds auto-increment keys to mdm_windows_configuration_profiles and mdm_apple_declarations; these should be small tables; confirming now that we tested with existing data in the DB as I don't see a test for this migration
• [x] 20240905140514 - adds a URL column to software installers; good to go
• [x] 20240905200000 - various alters/updates to software installers and host_software_installs, including a new stored generated column; small risk if there are lots of software install atempts, but should be fine
• [x] 20240905200001 - drops a fkey from policies to teams, drops unique index on policy_stats; since the size of the table should be comparable to the size of the policies table (plus additional rows for cross-team policies), we should be fine here

Erring on the side of caution, we heed largest-record counts for the following tables:

• policies
• software_installers
• mdm_windows_configuration_profiles
• mdm_apple_declarations
• host_software_installs
• policy_stats

If none of those numbers are abnormally large, should be good to go.