Hi all, Hope you are doing well. I'm working on this feature https://github.com/phpmyadmin/phpmyadmin/issues/13235 and I need some suggestions. As of now, Isaac and I have decided to not show any add index popup and automatically add index.

My idea is to create an index named A_I_columnName if it doesn't exist and leave it if user removes A_I on that column, If user chooses to add the A_I on that column again, we'll use that index if it exists and create it if it doesn't.

Any suggestions would be appreciated, thanks.