Mail server database structure...

[anuj_web]

Hi...


I need the basic database structure used in email servers to handle emails, if available ... please post the link.....



thnks

[freecrm]

Sorry - probably being thick here - can you clarify?

Do you mean a basic db to store information, including e-mail addresses.

Or headers?

Are you using php to handle e-mails? - If not, I can't help!

[sunils]

senders id, receivers id, message, subject, ipaddress from which the sender has sent it, the timestamp when the mail was sent, when it reached the server and when it was forwarded to the client. I thinks this is the basic structure/ data collected.. There are more than this..

[anuj_web]

thnks for replying.....

actually what i want is the designs of all the tables involved in the database of an email server.....

Otherwise i would like to know how an email is related to attachments...the table design again would help....

How more than one attachment is indexed in a table and how are they stored on the servers....

thanks

[rima123]

hey try this ... i dont know i'ven't tried... better to have a look here... one by one,...

http://atmail.com/support_doc.php?do...-customization

or this one??

http://www.hypexr.org/linux_mail_server.php

enjoy
bgb

[anuj_web]

thnx bro for replying....

but i could find the structure newere on those pages :|



thanks again

[anuj_web]

i am actually in doubt about the contacts table...consider this 2 field table
(ID,Contact)

(User1,User2)
(User2,User1)

See....there is unnecessary repetition....i cant figure out another structure...so that this does not happen..

please help...

[anuj_web]

stuck again....sorry for bumping...

i am actually in doubt about the contacts table...consider this 2 field table
(ID,Contact)

(User1,User2)
(User2,User1)

See....there is unnecessary repetition....i cant figure out another structure...so that this does not happen..

please help...

[jassie3]

HI all, I'm very new to mysql . does anyone here can tell me what am I missing because I got the error message - Los emails no coinciden
Thanks in advandce.