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

[Hilmar Lapp]

On May 7, 2008, at 4:04 AM, Peter wrote:
> 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?


Sounds like this would not break compatibility for >= 4.1, but would  
for at least for 3.x. (Not sure about 4.0.x here.)

Is anyone still using MySQL with a version < 4.0?

	-hilmar
-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:-  hlapp at gmx dot net :
===========================================================