Where does Roundtube build SQL queries to insert records to DB?

[[email protected]]

I'm trying to set up an archive system whereby the "messages" table in the Roundcube database is duplicated, with every insert into the table being  mirrored by an insert into a "message_archive" table that is the exact same as the "messages" table.

Where do I find the commands that build the SQL that roundcube uses to insert a new message into the DB, delete a message when deleted from trash, etc.?

tx,

Chris

[rosali]

What is your goal? The messages table is part of RoundCube cache. It holds only a selection of headers and the structure of the message. The message itself is still on the imap server. So, if you plan to mirror messages RoundCube may be the wrong approach.