hello
I would like to ask for option making possible to generate index into DDL by using ALTER TABLE ADD INDEX syntax.
Current one (CREATE INDEX) requires INDEX privilege and often fails on shared hosting machines. Adding index using alter syntax requires only ALTER privilege which is usually available.
In any way, such option would be useful at least to me