Looking at the mysql-myisam schema from 2.0:
some questions:
config table:
no index on configid? shouldn't this be primary?
why is there both a Primary and Unique index on the primary key field on
these tables?
aliases
mailboxes
messageblks
messages
and the users table indexes are all over the place.
regards,
Brian
some questions:
config table:
no index on configid? shouldn't this be primary?
why is there both a Primary and Unique index on the primary key field on
these tables?
aliases
mailboxes
messageblks
messages
and the users table indexes are all over the place.
regards,
Brian