I've been reading through the pgsql schema, and submitted a few bugs regarding it.
Several data fields in the database are not marked as 'NOT NULL'. Either this has been forgotten or it is intentional (if so, I cant see why). The ones I mean are these: mailboxes->permission INT2 DEFAULT '2' auto_notifications->notify_address VARCHAR(100) auto_replies->reply_body TEXT There is also a mixed practice of using 'NOT NULL' on primary key fields, as I recollect pk requires the field to be 'NOT NULL'. So either it should be added to all pk fields for readability or removed from the pk fields for "correctness". Partly off topic: is the id_header field used in 2.0? If not I suggest removing it in favor of future separation of headers into separate table. -HK
