Adding indexes, fk and async fk validation for deployments

This code change is part of a database migration process to convert certain ID columns from smaller integer types to larger "bigint" types to handle more data as the system grows.

The main changes include:

1. Converted two existing migration files into no-op placeholders - These files now do nothing and reference new "real" versions that were created later due to an incident: #584816 (comment 2973390014)
2. Added new migration files that handle the bigint conversion process for deployment-related database tables:
   • One file ensures the conversion process completes properly
   • Another creates new database indexes using the larger integer columns
   • Two files handle foreign key relationships between tables using the new larger columns
   • One file prepares validation of these relationships
3. Added tracking files that help the database system know which migrations have been applied.

Essentially, this is infrastructure work to future-proof the database by allowing it to store much larger ID numbers, preventing potential overflow issues as the application scales. The duplication of some migration files was necessary to work around a specific technical problem encountered during the migration process.