Tables in SQL files

[jscholtysik]

Hi,


only a general question:

In setup/default_sql/phpwcms_init_410.sql the SQL-statements always end with a

Code: Select all

) ENGINE=MyISAM ;

In the upgrade files in setup\update_sql\ the SQL statements in all files end with a

Code: Select all

) TYPE=MyISAM ;

What is the difference between these two commands and does it have any effect to the phpwcms installation or upgrade?

Thanks in advance.


Joachim

[Cipolla]

This is both the same.

i think Oliver made this because older Sql versions uses TYPE instead of ENGINE. This is to make it downwardly compatible.