Alternative way of creating indexes

[patrickc]

Hello,

after trying to install S9Y, there was an error message saying that the indexes in the MySQL database could not be created because of a permission problem.

After looking at phpMyAdmin, I noticed that it was possible to create indexes using the ALTER TABLE command. Would that be an option for future versions of S9Y to use this command?

Regards
Patrick

[garvinhicking]

Hi!

That ALTER TABLE is really a strange workaround. Since the MYSQL files are used for pgsql in most cases (which does not support that syntaX) it would mean some trouble to alter all files and introduce new ones just for pgsql.

IMHO the better way is to fix the permission setup on the database.

Regards,
Garvin