[BioSQL-l] MySQL schema, CREATE TABLE and TYPE verus ENGINE

[Peter]

Hello all,

I've just been running the Biopython BioSQL unit tests on a "new"
Linux machine with MySQL 5.0,

$ mysql --version
mysql  Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0

Part of the unit test creats a new empty database and loads the schema
file biosqldb-mysql.sql into it.  This triggers a warning:

Warning: 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead

My guess is the commands "CREATE TABLE ... TYPE=INNODB;" be updated to
"CREATE TABLE ... ENGINE=INNODB;" in biosqldb-mysql.sql to get rid of
the warning.

According to the following documents, MySQL 4.1 and 5.0 will accept
either TYPE or ENGINE, but it looks like MySQL 6.0 insists on using
ENGINE.

http://dev.mysql.com/doc/refman/4.1/en/create-table.html
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
http://dev.mysql.com/doc/refman/6.0/en/create-table.html

Is this something which should be fixed in BioSQL?

Thanks

Peter