Hello,
First of all, kudos to IC&S. I've long felt that this was a project
that needed to happen, but never had the time nor the wherewithal to do
it myself.
As background, I obtained dbmail through Debian via dbmail-pgsql, in
the sid branch. This is currently 1.2.5. I used the script in
/usr/share/doc/dbmail-pgsql/examples/create_tables.pgsql to create my
tables, and I had some questions about the fields that are created by
this script (which also appears in the source archive at
sql/postgresql/create_tables.pgsql) in the "messages" table. I apologize
if this is the wrong place to ask, but I can't seem to get to the
developers mailing list (the URL on dbmail.org returns a malformed URL,
and my attempts to guess the correct URL resulted only in 404 errors).
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)?
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.
Thanks offered in advance for any help anyone may be able to provide.
