Mailing List Archive: mysql schema questions

mysql schema questions

Nov 27, 2003, 8:56 AM

Post #1 of 2 (790 views)

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

Re: mysql schema questions [ In reply to ]

brian at macserve

Nov 27, 2003, 9:06 AM

Post #2 of 2 (778 views)

Permalink

On 11/27/03 9:56 AM, "Brian Blood" <brian@macserve.net> wrote:

> Looking at the mysql-myisam schema from 2.0:
> some questions:

more questions:

mailboxes table:

owner_idnr - should this be: user_idnr for consistency or is the wording
that way to ensure that this really means ownership?

the flags that are on this table: is this used to quickly determine if there
are any messages of that type contained within?

regards,
Brian