phpbb/phpbb3 — pull request #421 by bantu (2011-10-14 02:43:16+00:00)
Title: [ticket/10327] Change CREATE INDEX to ALTER TABLE table ADD INDEX for MyS

[ticket/10327] Change CREATE INDEX to ALTER TABLE table ADD INDEX for MySQL.

* CREATE INDEX is internally mapped to an ALTER INDEX statement.
* CREATE INDEX requires the INDEX permission.
* ALTER TABLE requires the (more powerful) ALTER permission.
* We require the ALTER permission anyway for operation.
* Changing CREATE INDEX to ALTER TABLE thus removes dependency on the INDEX
permission which is good because some management software does not give
out the INDEX permission by default.

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

PHPBB3-10327

http://tracker.phpbb.com/browse/PHPBB3-10327