Recent changes to 1681: combine create / alter table statements

#1681 combine create / alter table statements

2015-07-13T05:52:15.549000Z

status: open --> pending
Group: 4.4.10 --> Needs_decision

#1681 combine create / alter table statements

2015-06-26T10:59:26.984000Z

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

#4968 combine create / alter table statements

2015-06-26T06:52:42.558000Z

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

#4968 combine create / alter table statements

2015-06-26T06:33:09.304000Z

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

Create table statement without auto increment, indexes and foreign keys
Insert statement for data
Alter table statement to create indexes
Alter table statement to add auto increment
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.

#4968 combine create / alter table statements

2015-06-26T06:23:26.136000Z

This is more of a feature request IMO

#4968 combine create / alter table statements

2015-06-26T05:59:30.117000Z

assigned_to: Madhura Jayaratne

combine create / alter table statements

2015-06-25T14:22:58.090000Z

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

combine create / alter table statements

2015-06-25T14:22:58.090000Z

Ticket 4968 has been modified: combine create / alter table statements
Edited By: Madhura Jayaratne (madhuracj)
Owner updated: None => u'madhuracj'

combine create / alter table statements

2015-06-25T14:22:58.090000Z

Ticket 1681 has been modified: combine create / alter table statements
Edited By: Madhura Jayaratne (madhuracj)
Status updated: u'open' => u'pending'
_milestone updated: u'4.4.10' => u'Needs_decision'