Author Topic: Where does Roundtube build SQL queries to insert records to DB?  (Read 4763 times)

Offline chris.shiplett@gmail.com

  • Newbie
  • *
  • Posts: 5
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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Where does Roundtube build SQL queries to insert records to DB?
« Reply #1 on: May 21, 2009, 12:52:57 AM »
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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)