#1319 (ok 4.0.0-beta3) Permit to create index when creating foreign key

[Michal Čihař]

It is required to have index prior to creating foreign key. phpMyAdmin currently offers only fields which do have foreign key. Instead it should offer all fields and automatically create index when necessary.

[Marc Delisle]

You mean create a non-unique index? Because we can't for sure create a unique one.

I believe that we should ask the user to confirm this creation.

[Michal Čihař]

Yes, probably confirmation is needed and maybe should offer choice for index type.

[Marc Delisle]

Good point; however there are options that a user might want (for example setting the size for each column in the index) so we'll have to see how much flexibility we offer to the user.

[Michal Čihař]

I'd keep this just as a convenience shortcut not offering much flexibility.

[Anders Lindén]

I like the idea. A missing feature.

[Mohamed Ashraf]

so do you want to redirect to another page to do the index or do you want to add the option on the current page and execute it in the current page.

[Marc Delisle]

In the current page would be fine.

[Mohamed Ashraf]

I did the feature request and submitted a pull request here https://github.com/phpmyadmin/phpmyadmin/pull/215

[Marc Delisle]

Implemented by https://github.com/phpmyadmin/phpmyadmin/pull/217, thanks.