[Phpmyadmin-devel] Advanced index creation

[Marc Delisle]

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)