Create> customized fields

Hi,

It will be great to add customized fields,
example :

[Name] - [Type] - [Default] - [Index]
Deleted - ENUM('YES', 'NO') - 'NO' - INDEXED


Thanks ;-)

your example does not explain what you want. what exactly is a "customized field" and how does it differ from a normal field definition ?

I guess you did not yet see HeidiSQL's table editor for adding new columns? Just doubleclick a table and see the green "Add" button.

I suspect laurent_h might be referring to some kind of type templates or domain editor. For instance, every time you code a file upload feature you'll possibly need a column for the MIME type and having the column definition stored would save you some time (looking up the maximum size, providing a default value...) and would help you to keep coherence (every time you use such column it would have the same exact definition).

While I think it could be a nice feature, I tend to think of HeidiSQL as an administration tool (rather than a design tool) so I'm not sure it'd really fit.

BTW, I can think of a workaround: maintain an ad-hoc database with templates. Then, when you need a table or column you can leverage HeidiSQL "Create new table copy" and "Copy selected columns / Paste columns" features.

(If that's not what the OP meant, please clarify!)

I think you are right about fitting - if you are a developer who wants code reuse / snippets, do use an appropriate IDE - that´s where such a feature would belong.

Hi,

In the table editor, this feature would be great,
to add automatically customized field throw a popup under "+ Add buton",
it will be a kind of macro to add customized field.

Thanks