7 May
2001
7 May
'01
3:20 p.m.
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)