Good (morning|afternoon :),
Ok I need your feedback about this.
In the "Create new table" dialog, after "Fields" question, we add this checkbox:
Use special index mode (for key lengths, multi-field keys) _
and an input field:
Total number of indexes: ___
For example, the user activates the checkbox and asks for 2 indexes.
Then on the fields page, instead of the columns "primary, index, unique" we add double-columns for each new index, at the right of the screen.
For example:
Field (other field attributes...) | Relative | Length| Relative | Length | | position | | position | |
first_name 30 2 10 last_name 30 1 15 city 40 phone 15 1 10 ________________________________________________________________________________ index_1 index_2 unique _ unique _ primary _ primary _ fulltext _ fulltext _
========================
We generate the index names, but in an input box, so they can be changed.
I wonder if we should use the same layout in the table properties page...
If the user does not use Special index mode, we show them the normal "Primary Index Unique" columns.
Marc (Lem9)