Erik Osterman wrote: > Hrm... Well, since the first solution was satisfied without modifying > any code, I'll probably just use a trigger to insert the deleted folders > into a separate table.
That might work if you break the constraint on the messages table against the mailboxes table. But you might be better off by re-assigning the mailbox to a special __archive__ user, keeping the original owner_idnr in a special field of the mailboxes table. That way you can keep the foreign key restraint on the messages tables, and you can easily recover archived mailboxes without having to worry about colliding mailbox_idnr values. If you figure this out, please post a mini-howto on the wiki if you don't mind. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev