what tables are used for email

[customnames]

does any one know the tables sequency for emails
to work around the issues with pop3. I need to change the delete field to 1
and then use a script to pull the emails off the pop3 server with a cronjob
it would also be handy to remove the button that try to delete or move the emails as
my broswers keep hanging and need to restart and login again which is so un cool

why can't we have phpmailer or sendmail which just use one smtp account
and allow all emails come in in one
why do I ahve myinbox and when I put in my email account details I get a new inbox not related
to myinbox

also not all browsers are able to handle sugar
FF can't move emails or import into sugar
safari the same but takes 3-4 mins to not do anything accept hang
opera can't handle most functions even adding settings so avoid
IE can transfer files but not import to sugar or move to another folder

havent tried chrome yet

Tested on linux centos 5.2 php 5.2.6
windows web server 2008 php 5.2.8

[kinshibuya]

Tables are on the image attached:

[lucianamssouza]

Hi,

We have a similar problem. By accident in one user account there are now more than 100.000 e-mails and we don't want to remove them manually as it will take too much time.
The idea is to make an SQL query that will clean up the email from this user.
So my question is: Does the attachment files also stay in the database or are they put in the file system somewhere?

Thank you and best regards,
Luciana Moreira

[datasponge]

Tables are on the image attached:

Don't forget the inbound / outbound tables for your server account settings. Here is a list of the tables I am aware of trimmed from show tables in MySQL:

| email_addr_bean_rel            |
| email_addresses                |
| email_addresses_audit          |
| email_cache                    |
| email_marketing                |
| email_marketing_prospect_lists |
| email_templates                |
| emailman                       |
| emails                         |
| emails_beans                   |
| emails_email_addr_rel          |
| emails_text                    |
| inbound_email                  |
| inbound_email_autoreply        |
| inbound_email_cache_ts         |
| outbound_email                 |

Phil