#1681 combine create / alter table statements

[freeman]

when i make table structure export, the result is not efficent

for ex
it makes alter table statement and after it makes another alter just to set auto increment
there should be single alter table where possible
thanks

[Madhura Jayaratne]

This is more of a feature request IMO

[Madhura Jayaratne]

An export of table(s) from phpMyAdmin has the following order.

1. Create table statement without auto increment, indexes and foreign keys
2. Insert statement for data
3. Alter table statement to create indexes
4. Alter table statement to add auto increment
5. Alter table statement to add foreign key constraints

AFAIK, creating index and foreign keys only after inserting data makes inserting much efficient.
Indexes of the foreign table needs to be in place to add foreign key constraints. So we have to separate index creation and foreign key constraint adding with indexes being added first.

[Madhura Jayaratne]

See https://sourceforge.net/p/phpmyadmin/feature-requests/1004/

[Marc Delisle]

Ticket moved from /p/phpmyadmin/bugs/4968/