Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1525 Generate keys one per line, like foreign key constraints

Needs_decision
open
nobody
None
7
2014-05-27
2014-05-27
Artem K.
No

Since the completion of #1004 a few days ago, all the indices are generated using a separate ALTER TABLE statement. This statement is generated on one line for all the indices of the table.

Is it possible to generate each "ADD KEY ..." segment on a separate line just like with foreign key constraints? This is really important to be able to easily compare structural differences between two dumps using a file compare tool. When the indices were embedded in CREATE TABLE statements, they were generated one index per line.

Discussion