Page 1 of 1

Tables in SQL files

Posted: Mon 19. May 2008, 10:21
by 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

Re: Tables in SQL files

Posted: Mon 19. May 2008, 12:18
by 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.