Custom Mailet or Repository

2005-07-06 Thread Mark Gulbrandsen
Hi all, I want to store emails in a database. But, I want to index the inbox emails in a different way than the regular inbox table. For example (MySQL): create table webmail_inbox ( id bigint not null auto_increment, client_id bigint, subject varchar(1), sender varchar(255) not n

Re: db schema question

2005-06-22 Thread Mark Gulbrandsen
ables, which effectively means that you might use one single table > for inboxes _and_ other functions. Don't ask me why, the point is that > it isn't a rule you could be 100% confident of . > > d. > > On 22/06/05, Jason Webb <[EMAIL PROTECTED]> wrote: > > &

db schema question

2005-06-21 Thread Mark Gulbrandsen
Greetings, james creates a table named 'inbox' (or whatever one configures it to be). This table has a composite id on inbox.message_name and inbox.repository_name. It seems to me that inbox.repository_name is always the users.username for the owner of the email in the inbox table. Is this supposi