Hello, > The first thing I noticed about the various fields in the "messages" > table that are named with "_flag" is that they are defined as integer > fields, rather than boolean. My experience in the past is that variables > named with "_flag" are usually booleans, so I'm wondering if this is the > right datatype? If int is the right datatype, what are the possible > values of these fields, and what do they indicate? The field > "flagged_flag" seems to be a great example of this...what other state > can it have besides on (true) or off (false)?
AFAIK, those are only used for boolean values, and changing the schema there could probably save a small bit of space. You would have to have different sql syntax for mysql and postgres doing that, though, so perhaps that's why they're not. (postgres requires "where *_flag = B'1' ...") > Also, I'm curious what purpose the "client_idnr" field serves? It > appears to be intended as a foreign key between "aliases" and "users", > but I don' t see the reference itself. Is there another table that's > missing where client_idnr is the primary key, perhaps? Or am I just > missing something obvious. That field is completely for local use, dbmail makes no use of it at all. Eg. we use it to track the reseller id of users so we can easily pull a list of all users for them (although we don't do that ... but we could :). Later, Jesse -- Jesse Norell [EMAIL PROTECTED] is not my email address; change "administrator" to my first name. --
