Last modified: 2010-05-15 16:03:43 UTC
Some of the sql statements (like maintenance/tables.sql or extensins/Oversight/hidden.sql) are using TYPE attribute; this throws a notice on most recent versions of MySQL:
'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
Is there a reason for not using ENGINE instead of TYPE?
Is "ENGINE" available in MySQL 4.0? We currently support back to that version (it is indeed the one running on Wikimedia) and there currently is no reason to upgrade; even though there would be more features, performance would be significantly reduced.
ENGINE is not available in some older versions of MySQL 4.0.
Currently, we use ENGINE for the MySQL 5 schema modes and TYPE for the MySQL 4 schema mode. (You can see this in the installer, where it sets up $wgDBTableOptions.)