On Sat, 21 Oct 2006 22:55:31 +0200 Paul J Stevens <[EMAIL PROTECTED]> wrote:
> Jason Chu wrote: > > I believe my other two concerns about keeping emails and extra > > data/fields associated with emails still stand though. > > Jason, > > What you want is to associate meta-data with a physmessage and a user, > not with a message in folder. That way you'd avoid the problems posed > by copy. > > consider this: > > create table dbmail_annotation ( > id bigint not null autoincrement, > user_idnr bigint not null, > physmessage_id bigint not null, > message_part char(16) not null default '', > annotation text not null, > primary key (id), > unique (physmessage_id, id), > foreign_key (physmessage_id) > references dbmail_physmesssage(id) > on update cascade on delete cascade > ); > > this could be expanded with a ACL setup that would allow people to > share access to an annotation with other users, like dbmail_acl does > for mailboxes. Thanks Paul! That's exactly what I needed. I've spent a couple days thinking about this and playing around with it and I'm pretty sure we can pull it off. This will work way better than using a filesystem based mail store! Jason
signature.asc
Description: PGP signature