Results 1 to 2 of 2

Thread: Zimbra mysql strcuture , anyone know where is the message id of email located in DB?

Hybrid View

  1. #1
    Join Date
    Jul 2012
    Posts
    67
    Rep Power
    3

    Default Zimbra mysql strcuture , anyone know where is the message id of email located in DB?

    Zimbra my sql strcuture , anyone know where is the message id of email located in DB?

  2. #2
    Join Date
    Jul 2007
    Location
    Baltimore
    Posts
    1,649
    Rep Power
    11

    Default

    I'm not sure it is. it would probably be in mail_item if anywhere but I don't see any field for message id

    Code:
    mysql> describe mail_item;
    +--------------+---------------------+------+-----+---------+-------+
    | Field        | Type                | Null | Key | Default | Extra |
    +--------------+---------------------+------+-----+---------+-------+
    | mailbox_id   | int(10) unsigned    | NO   | PRI | NULL    |       |
    | id           | int(10) unsigned    | NO   | PRI | NULL    |       |
    | type         | tinyint(4)          | NO   |     | NULL    |       |
    | parent_id    | int(10) unsigned    | YES  |     | NULL    |       |
    | folder_id    | int(10) unsigned    | YES  |     | NULL    |       |
    | index_id     | int(10) unsigned    | YES  |     | NULL    |       |
    | imap_id      | int(10) unsigned    | YES  |     | NULL    |       |
    | date         | int(10) unsigned    | NO   |     | NULL    |       |
    | size         | bigint(20) unsigned | NO   |     | NULL    |       |
    | volume_id    | tinyint(3) unsigned | YES  | MUL | NULL    |       |
    | blob_digest  | varchar(28)         | YES  |     | NULL    |       |
    | unread       | int(10) unsigned    | YES  |     | NULL    |       |
    | flags        | int(11)             | NO   |     | 0       |       |
    | tags         | bigint(20)          | NO   |     | 0       |       |
    | sender       | varchar(128)        | YES  |     | NULL    |       |
    | subject      | text                | YES  |     | NULL    |       |
    | name         | varchar(128)        | YES  |     | NULL    |       |
    | metadata     | mediumtext          | YES  |     | NULL    |       |
    | mod_metadata | int(10) unsigned    | NO   |     | NULL    |       |
    | change_date  | int(10) unsigned    | YES  |     | NULL    |       |
    | mod_content  | int(10) unsigned    | NO   |     | NULL    |       |
    +--------------+---------------------+------+-----+---------+-------+

Similar Threads

  1. Where is my spam located?
    By mfehr in forum Administrators
    Replies: 3
    Last Post: 08-04-2011, 12:59 PM
  2. Replies: 1
    Last Post: 05-27-2011, 05:21 AM
  3. Where is the Zimbra source code located?
    By sasepp in forum Developers
    Replies: 4
    Last Post: 08-25-2008, 06:19 PM
  4. Where are the mailboxes located
    By PatrickIPM in forum Administrators
    Replies: 1
    Last Post: 02-25-2008, 12:37 AM
  5. Sizing of Mysql vs Message store
    By hillman in forum Administrators
    Replies: 8
    Last Post: 11-12-2007, 11:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •