#623 confirmation box for re-arranging field positions

[Anonymous]

Originally created by: ypha...@gmail.com

Well i suggested earlier that the confirmation box for re-arranging a
field position in a table be given an option to disable the confirmation,
i believe it was in a bug report, and remember that it was confirmed to
have been added, and just wanted to know where it was added so i can
disable the thing. :) If you could make a re-arrange dialog box so we
could move the fields up and down and then commit, that would be the best,
as it could all be done in one go.

http://www.heidisql.com/forum/viewtopic.php?t=598

[Anonymous]

Originally posted by: a...@anse.de

Found the message you're talking about:

"You are about to move a field's position in the table-structure. While there is no
handy one-query-method in MySQL to do that, this will be done in 4 steps:
1. Adding a temporary field at the specified position
2. Filling the temporary field with the same data as source field
3. Dropping the source-field
4. Renaming the temporary field to it's original name.
Be aware that this method can mess up existing indexes in your table or even can
result in losing data! If you are not sure you should not use this function on
indexed fields.
Continue?"

And it only pops up on a pre 4.0.1 (!) server which doesn't support the
AFTER/LAST/FIRST keywords in ALTER TABLE. I guess you're really still using a 3.x
server?

Pros:
- No more annoyance when moving a field on a 3.x server.

Contra
- This dialog is an important safety reminder for the user. It's risky and there is
a good chance your data gets corrupted using that feature on old servers.
- Much work to implement a customized dialog with a "Don't display this warning in
the future" checkbox for such an anti-annoyance feature

Labels: -Type-Defect -Priority-Medium Type-Enhancement Severity-Default
Status: WontFix

[Anonymous]

Originally posted by: ypha...@gmail.com

Yes unforunately i'm still using 3.x servers. :)

Well if the checkbox on the dialog is difficult, then add it to the preferences. One
way or another, i will be doing it and am aware of the warning, so whats the need
for the warning everytime i do it.

So how about the re-arranging dialog idea? See attachment.

[Anonymous]

Originally posted by: a...@anse.de

Let's not add a new dialog and instead refactor the whole create/modify table/field
dialogs into one single dialog. Like described in issue 436.