[Phpmyadmin-devel] Advanced index creation

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Mon May 7 14:20:40 CEST 2001

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)

More information about the Developers mailing list