#25 3 check boxes for indexes

[Christophe Gesché]

try to translate in english below.

Pour la création d'une table ou l'ajout d'un champs.

on a 3 check box.

PRIMARY UNIQUE et INDEX.

Mais sauf si je me trompe.

UNIQUE -> toujours un index
et
PRIMARY -> Toujours un INDEX UNIQUE

alors pour koi un check box et pas radio ?
------------------------------------------------

When adding a fields we have 3 check box for
PRIMARY UNIQUE et INDEX.

but if I'n not in wrong

UNIQUE is always an index
and
PRIMARY is always an INDEX UNIQUE

so why a check box and not a radio with 4 choice ?

[Marc Delisle]

Logged In: YES
user_id=210714

Christophe,

I agree with your point,however, I think that with
checkboxes, some user could be confused:
"Hmmm, I just checked "primary" then "unique" got
unchecked"....

Also, we must not forget that we can have a unique index
that is not the primary.

Maybe offer a choice of checkboxes:

( ) No index
( ) non-unique index
( ) unique index
( ) PRIMARY unique index

[Christophe Gesché]

Logged In: YES
user_id=220614

Yes I think that 4 case in radio is better
and must is a javascript to control there is only one
primary.

[Robin Johnson]

Logged In: YES
user_id=30201

Actually, we would need to have a set of radios for the
table, as only one field can be primary, (and it must be
both of index/unique as well), and other than that, index
and unique can be on any field

[Loïc Chapeaux]

Logged In: YES
user_id=144058

Hi!

This feature is "on the air": see patch #458014 - Advanced
index generation/editing.

Loc

[Marc Delisle]

Logged In: YES
user_id=210714

Loic,

when creating a table, the 3 checkboxes are still there and
are still a bit confusing for newbies.

[Marc Delisle]

Logged In: YES
user_id=210714

Changes committed to cvs.