My best guess is that these are the indicies created by the configuration scripts as they look like this:
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">
// The Posts Table ###################
$index1 = "w3t_Posts"."index1";
$index2 = "w3t_Posts"."index2";
$index3 = "w3t_Posts"."index3";
$index4 = "w3t_Posts"."index4";
$index5 = "w3t_Posts"."index5";
$index6 = "w3t_Posts"."index6";
$index7 = "w3t_Posts"."index7";
$index8 = "w3t_Posts"."index8";
$index9 = "w3t_Posts"."index9";
$index10= "w3t_Posts"."index10";
$indexes = "";
if ($config['dbtype'] == "mysql") {
$indexes = ", INDEX $index1 (B_Parent,B_Board),
INDEX $index2 (B_Number, B_Board), INDEX $index3 (B_Main, B_Board),
INDEX $index4 (B_Status,B_Board),
INDEX $index6 (B_Board),
INDEX $index7 (B_Approved,B_Board),
INDEX $index8 (B_Posted, B_Board),
INDEX $index10 (B_Board(10),B_Topic),
INDEX ID_ndx(B_PosterId),
INDEX poster_ndx(B_Username)
";
</font><hr /></blockquote><font size="" face="">So - I presume that MUL is for Multiple columns - if this were version 6.0.2 I suspect that the Key you would see on the B_username column would be called poster_ndx
Does that help? Again, I am not 100% certain and I am dredging MySQL books for the answers.
Regards,
Brett Harris
Infopop Corporation
