I upgrade from 6.3.2 and the index still exist in 6.4. The altertable 6.4 to 6.4 script show the following:
Adding a new table to save database queries that are used frequently from the admin section
Adding a new field to the Groups table to allow for disabling of groups.
Grabbing all old poll data for conversion.
Dropping old poll tables and creating new ones for the updated poll system.
importing old poll data...
Adding a table for calendar events...
Altering the user's table to add a few new fields/preferences...
SQL ERROR: Mon, Dec 08 2003 12:13:09 +0100 Unable to do_query: ALTER TABLE w3t_Users ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0', ADD U_ShowBday INT(1) NOT NULL DEFAULT '0', ADD U_TimeFormat VARCHAR(6), ADD U_Ignored TEXT, ADD U_OC_Userid VARCHAR(64), ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)
Duplicate column name 'U_Birthday'Altering the online table to store info a bit differently...
Altering the board's table to allow admin's to associate an image with a forum...
Altering the posts table so posts can be linked to a calendar event...
Reworking some indexes for speed, this may take awhile. You will get a few errors about indexes not being able to be dropped. This is ok, index names might be a bit different depending on when you installed but they will be dropped properly...
SQL ERROR: Mon, Dec 08 2003 12:13:30 +0100 Unable to do_query: ALTER TABLE w3t_Last DROP INDEX Luid_ndx
Can't DROP 'Luid_ndx'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:13 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex10
Can't DROP 'w3t_Postsindex10'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:13 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX topic_index
Can't DROP 'topic_index'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:13 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX topic_ndx
Can't DROP 'topic_ndx'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:13 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex9
Can't DROP 'w3t_Postsindex9'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:13 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex9
Can't DROP 'w3t_Postsindex9'. Check that column/key existsSQL ERROR: Mon, Dec 08 2003 12:14:31 +0100 Unable to do_query: ALTER TABLE w3t_Posts DROP INDEX w3t_Postsindex6
Can't DROP 'w3t_Postsindex6'. Check that column/key existsCreating a cache table for some things that don't change to often...
Creating a table to store version info to make future upgrades easier...
Done
The Birthday SQL is forced by an old birthday hack and dosn't matter.
