Error creating tables on mysql 15.1

[fluffy-critter]

Attempting a new install on a server running PHP 8.3.6 and mysql 15.1 results in this error:

table fof_item_tag [CREATE TABLE IF NOT EXISTS fof_item_tag ( user_id INT(11) NOT NULL DEFAULT '0' REFERENCES fof_user ( user_id ) ON UPDATE CASCADE ON DELETE CASCADE, item_id INT(11) NOT NULL DEFAULT '0' REFERENCES fof_item ( item_id ) ON UPDATE CASCADE ON DELETE CASCADE, tag_id INT(11) NOT NULL DEFAULT '0' REFERENCES fof_tag ( tag_id ) ON UPDATE CASCADE ON DELETE CASCADE, PRIMARY KEY ( user_id, item_id, tag_id ), FOREIGN KEY (user_id) REFERENCES fof_user (user_id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (item_id) REFERENCES fof_item (item_id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (tag_id) REFERENCES fof_tag (tag_id) ON UPDATE CASCADE ON DELETE CASCADE, KEY tag_id ( tag_id ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;]

SQLSTATE[HY000]: General error: 1005 Can't create table `fof`.`fof_item_tag` (errno: 150 "Foreign key constraint is incorrectly formed")

It looks like the table fof_user doesn't exist so I think the table creation order has gotten messed up.