Sorry for the jargon response. The schema is described here: http://dbmail.org/dokuwiki/doku.php?id=er-model
users -> mailboxes -> messages -> physmessages -> messageblks. The physmessages and messgaeblks tables holds the raw bytes of the message. They doesn't know what mailbox it is in or which user owns the message. It is the messages and mailboxes tables that contain those mappings. When a message is deleted in IMAP, it is flagged \Delete in messages. When you expunge the mailbox, the message is internally marked with a status = 'deleted' in DBMail. When you run dbmail-util, messages with status 'purged' are destroyed, while messages with status 'deleted' are marked to be 'purged'. If you simply don't purge the messages, that's one approach to having a forever record of the message. Once a physmessages is no longer references by any messages, it is deleted, and its messageblks are deleted, too. When a mailbox is deleted, however, those steps are not followed; the messages rows are removed from the database directly; so in that respect, it is not a good forever record of the message. Aaron On Thu, 2008-04-17 at 14:28 +1000, Naz Gassiep wrote: > I don't know enough about DBMail's internals to interpret the > implications of the second part of your reponse. > > When you say "message table entries", what data is that? And > "physmessage blocks"? Are they the actual messages themselves? If so, > retaining those is fine for papertrailing, and I'd assume the path/name > of the mailbox they were in is there as well, so if need be, that can be > reconstructed? > > - Naz. > > Aaron Stone wrote: > > This is already the case for normal message deletion. The dbmail-util > > tool is used to actually purge messages from the database. > > > > The exception is if a user removes a mailbox -- in that case, all > > messages table entries are removed (the physmessage blocks, however, > > continue to remain in the database until dbmail-util is used to clear > > them out). > > > > Aaron > > > > > > On Apr 16, 2008, at 9:01 PM, Naz Gassiep wrote: > >> Is it possible to configure DBMail to not delete messages that a user > >> marks as deleted, but only mark them as deleted so they are deleted > >> as far as the user is concerned? We need to retain messages even > >> after a user deletes/expunges them from their client. > >> Thanks, > >> - Naz. > >> _______________________________________________ > >> DBmail mailing list > >> DBmail@dbmail.org > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > _______________________________________________ > > DBmail mailing list > > DBmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
