Failing migrations on clean install

[sarahmccuan]

Describe the bug
See failed migrations below.

To Reproduce
Steps to reproduce the behavior:

1. follow quickstart instructions
2. Go to User > Server Data
3. (note: have not added any dictionaries / texts / etc. yet. Trying to do leads to lots of other failures of various other sorts b/c of the missing fks.)

Server (please complete)

Web Server	Apache/2.4.68 (Debian)
Server Software	Apache/2.4.68
Server Location	http://localhost:8010
PHP Version	8.4.24
Database
Database name	learning-with-texts
Database Size	0.8 MB
MySQL Version	12.1.2-MariaDB-ubu2404
Failed migrations

Some database migrations did not run through. The schema is incomplete, so features relying on the missing tables or columns will fail. Please report this with the details below.

20251130_120000_myisam_to_innodb.sql (1 attempts)
Query failed: Got error 41 "Unknown error 41" from storage engine InnoDB
20251221_120000_add_inter_table_foreign_keys.sql (1 attempts)
Query failed: Cannot change column 'LgID': used in a foreign key constraint 'fk_news_feeds_language' of table 'learning-with-texts.news_feeds'
20251223_173100_add_local_dictionaries.sql (1 attempts)
Query failed: Can't create table `learning-with-texts`.`local_dictionaries` (errno: 150 "Foreign key constraint is incorrectly formed")
20260107_150000_settings_composite_pk.sql (1 attempts)
Query failed: Error on rename of './learning@002dwith@002dtexts/settings' to './learning@002dwith@002dtexts/#sql-backup-1-3' (errno: 194 "Tablespace is missing for a table")
20260107_160000_convert_utf8_to_utf8mb4.sql (1 attempts)
Query failed: Error on rename of './learning@002dwith@002dtexts/sentences' to './learning@002dwith@002dtexts/#sql-backup-1-3' (errno: 194 "Tablespace is missing for a table")
20260109_195419_add_books_table.sql (1 attempts)
Query failed: Can't create table `learning-with-texts`.`books` (errno: 150 "Foreign key constraint is incorrectly formed")
20260314_201500_fix_books_table.sql (1 attempts)
Query failed: Can't create table `learning-with-texts`.`books` (errno: 150 "Foreign key constraint is incorrectly formed")
20260805_200000_add_fsrs_scheduling.sql (1 attempts)
Query failed: Can't create table `learning-with-texts`.`term_schedule` (errno: 150 "Foreign key constraint is incorrectly formed")
20260810_120000_repair_missing_tables.sql (1 attempts)
Query failed: Can't create table `learning-with-texts`.`books` (errno: 150 "Foreign key constraint is incorrectly formed")

• OS: Windows
• Browser: Vivaldi (Chromium)

Additional context
I'm guessing this is either something Windows related or related to the other recent migration bugs. I'll try to submit a fix shortly.